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
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
2.Product Master Table:
In the Product Master table we have 3 columns – ProductId, Product Name, and Category.
3.Sales Table:
In this Table, We have 3 columns – Date, ProductId, and Sale Amount
Below is the Data Model diagram for this dashboard:
We have used the below 5 measures for this dashboard using DAX.
