Budget Vs Forecast Analysis
In this dashboard, I have analyzed the performance of a company in terms of its sales performance in 2020.
The dashboard points to the excel-based sources that are linked together using common fields.
-
In this tab actual and forecast number are analyzed over last 12 month across regions, cost elements groups and IT departments.
-
This view helps users to analyze performance of the company over last 12 months and understand which geographies and functional a reas are under performing and take next course of action.
-
Budget vs Forecast charts in this view gives a very good understanding of under performing areas of the company.
-
In this view various regions are analyzed for respective performance
-
This view will help management to understand which regions are performing well, they can investigate more to know what went well in these regions and implement same strategies in under performing regions
- In this view we dig dipper to understand how different categories contribute to either positive or negative Budget vs Forecast numbers
