A dataset was chosen as a case study for this work, which includes information about the sales of KEE'S CHOCOLATES. The final work includes two dashboards: a sales report in the company, which is needed to visualize the main indicators of this process, and a "What if?" model, which is necessary in order to track the impact of various dynamics on the main indicators.
A thematic data set was found and processed. After connecting it to power bi, two dashboards were built.
The first dashboard is a simple collection of graphs forming a sales report for 2020. The composition of the screen includes:
- Pie chart with the distribution of profits by country
- 4 Cards showing profit, costs, revenue and number of customers
- A graph showing the dynamics of revenue by category
The second dashboard was created using the "What if?" function and it consists of:
- Actual cost, revenue and profit cards
- Cards of projected costs, revenue and profit
- Cost, revenue and profit cross-sections that reflect the planned change in indicators as a percentage
The created dashboard is designed for financial forecasting. It is able to help in building a plan, assessing the profitability of changes in indicators with an increase in cost prices.
