07-05-2022 02:41 AM
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:
The second dashboard was created using the "What if?" function and it consists of:
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.