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 … Continue reading Comparative Analysis Dashboard in Excel