Skip to content
Share with your networks
Chocolate Company: Finding sales per team members
Tools we used: PowerBI
Skills we applied:
Power Query, DAS, Data Formatting, Handling Null Values, Creating New Measures, Using different type of visual charts & Creating interactive dashboard.
“Miss M” wants to give an award to best seller team and team members
She is considering the selling amount per box as a priority for the award
Also She wants to know the total amount of sales per country by the team
Lastly She wants to know which category of products “That team” are selling
Data Set Format: Excel
Dataset Download link:
Download from Kaggle
Data Analysis Steps We Followed:
Step 1: Ask the questions to the clients/stakeholders to know what is his/her expectations
Step 2: Plan how we will analyze and what we need to do.
Step 3: Prepare the data for visualization. Like clear dirty data, check formating, and null values...
Step 4: Analyze data and create dashboard.
Step 5: Show the analysis to the Team leader / Project manager before submission
Step 6: Show the report to the Stakeholders
Analysis Process Video:
Project 02 || Call Center Data Analysis with SQL
Follow Me | Contact Me
Text On LinkedIn
Proudely designed by Md. Mahadi Hasan. All copyrights reserved by Md. Mahadi Hasan. Web Designer and Data Analyst
Content is protected !!