Project Details

In this project, I designed a sales report using pivot tables in Excel that will allow businesses to estimate successful customer discounts, facilitate consumer negotiations, and uncover new business expansion chances in promising countries. The created reports will give businesses with actionable insights and recommendations to optimize their sales methods, improve customer satisfaction, and increase income production.

I've discovered the following:

1. The pivot table
2. Power Search
3. DAX (Introduction)
4. conditional formatting
5. Report Enhancement Metrics for the Sales Domain

Overall, the goal of this project is to provide firms with the tools and information they need to monitor, assess, and improve their sales efforts. Businesses may discover new opportunities, accelerate growth, and remain competitive in a volatile market landscape by employing sales data analysis.

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard