This is the Excel version of the Comparative Analysis Dashboard. We have used Power Pivot to create this dashboard.
We have used Current Year Sales Vs Previous Year Same Period Sales using the DAX functions in Power Pivot. We have also created Sales Vs Budget Variance on the dashboard.
Learn how to create Comparative Analysis Dashboard in Microsoft Power BI
![Comparative Analysis Dashboard in Excel](https://www.pk-anexcelexpert.com/wp-content/uploads/2021/06/Comparative-Analysis-Dashboard-in-Excel-1.jpg)
We have used 3 Excel Tables to create this dashboard using Power Pivot
1.Budget Table:
In this table, we have 3 columns – Month, ProductID, and Budgeted Amt
![BudgetTable](https://www.pk-anexcelexpert.com/wp-content/uploads/2021/06/Comparative-Analysis-Dashboard-in-Excel-2.jpg)
2.Product Master Table:
In the Product Master table we have 3 columns – ProductId, Product Name, and Category.
![Product Master Table](https://www.pk-anexcelexpert.com/wp-content/uploads/2021/06/Comparative-Analysis-Dashboard-in-Excel-3.jpg)
3.Sales Table:
In this Table, We have 3 columns – Date, ProductId, and Sale Amount
![Sales Table](https://www.pk-anexcelexpert.com/wp-content/uploads/2021/06/Comparative-Analysis-Dashboard-in-Excel-4.jpg)
Below is the Data Model diagram for this dashboard:
![Data Model diagram](https://www.pk-anexcelexpert.com/wp-content/uploads/2021/06/Comparative-Analysis-Dashboard-in-Excel-5.jpg)
We have used the below 5 measures for this dashboard using DAX.
![DAX measures](https://www.pk-anexcelexpert.com/wp-content/uploads/2021/06/Comparative-Analysis-Dashboard-in-Excel-6.jpg)
Visit our YouTube channel to learn step-by-step video tutorials
Watch the step by step video tutorial: