EBUS3030: Sales Data Analysis Report for BIA Inc. - Semester 2

This report presents a business intelligence analysis of sales data for BIA Inc., focusing on the period covered by the assignment brief. The report details the implementation of a datamart to visualize sales information and includes an executive summary highlighting key findings. The analysis reveals that 2018 saw the highest sales volume. The most sold product was the Cordless Drill Kit, while the Drill Bit 5mm was the least sold item. The report identifies Michele as the top-performing salesperson, generating the highest sales revenue. Based on these findings, the report suggests incentives such as bonuses and rewards to motivate the sales team. The analysis includes the data load process undertaken using PivotTable and PivotChart Report within Excel. The report addresses the assignment outcomes by presenting data modeling, ETL processes, analysis output, and business recommendations, addressing the head Sales Executive's question.

Sales Data
Business Intelligence for Sales
Department

Executive Summary
• Today, maintaining businesses with the assistance of information
is the new standard all around the universe. In case you're not
utilizing information to direct your business into the future, you
will end up being a business of the past. Luckily, the advances in
information preparing and perception make developing your
business with information simpler to do.
• In order to visualize your information and get the experiences
you have to impel your organization into the future, you need a
cutting edge business Intelligence solution, DATA MART is one. In
this paper, we discuss the implementation of datamart for
business intelligence in making an analysis of Sales Data from
Excel for BIA Inc.

Summary
• In order to have a good visual representation
of data for sales, we should create a business
intelligence model.
• The slides preceding describe the total sales
made by BIA Inc.

Output of Analysis
• From the business intel done on the data from
excel, It’s evident that most of the sales by BIA
Inc, were done in the year 2018.
• The most Sold product was the Cordless Drill
Kit as seen in the Pie chart on the next slide.
• On the other hand, the Least bought item was
the Drill Bit 5 mm whose sale was just 3 times
in 2018. Pie chart is in the slide number 6.

Most Sold Item

Least Sold Product

Screenshot

Data Load Process undertaken
• Select a given cell in the database
• Select the Data>PivotTable and PivotChart Report
• Choose 'Microsoft Excel List or Database', click Next.
• For the range, type your range name, e.g. Database
• Click Next
• Click the Layout button
• Drag field buttons to the row, column and data areas
• Click OK, click Finish

Response to business question.
• From the DataMart report, it is evident that
the sales person who made the most sales is
Michele with Staff ID S8, She made a total of
92437.9 in cost.
• In order to motivate her, The company needs
to award her a number of incentives including;

• Throw her a good bonus:
The company needs to buld bonusess tied
to specific results. This way, employees like
Michene can feel rewarded and push on. An
example is giving employees a cash bonus for
every annual upfront sale they make.

Incentives
• Reward the lead sale agent. Put aside a
percentage of new income each quarter
towards a reward that the sales guys gets the
opportunity to vote on, regardless of whether
it be new organization swag, a café outing or
new furnishings. This will Boost the entire
association to pull for and bolster the sales
team.