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.
Clients Expectations:
- “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
- Which pizzas we are selling most & worst
- Lastly She wants to know which category of products “That team” are selling
Data Set Format: Excel
Dataset Download link:
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
Final Outcome:
