Objective - Bloom .INC wants to create an annual sales report. So that, They can understand their Business and grow more sales.
In this Project, we have performed following steps:
- Data importing ( Multiple CSV files).
- Data Cleaning.
- Data analysing
- Dax Measure to add Total Net Revenue.
- Pivot table Charts(Line chart, Bar chart).
- Conditional Formatting for Top 20 Product & Region.
Insights - We can do More Promotion campaign of Product TryFly and Sunbell and give discount.And run a marketing campaign on all products to incease Sales. Bonus to Top 3 Salesrep, so other salesrep can get Motivation to Perform More.