Project Description:
In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.
I have learned the following:
- Pivot table
- Power Query
- DAX measures
- Conditional Formatting
- Report Beautification
- Sales Domain Metrics
Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.
Customer Performance Report: Provides net sales performance of each customer across years
Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.
