To achieve these goals, the model is divided into two blocks and designed with easy navigation to move between blocks. Additionally, the model also allows users to administer the display of data.
All work contained in the model is based on pre-aggregated data. The current model features sales data with a breakdown by sales departments, sales channels and sales figures, and financial data - data for PL and balance sheet figures. Next are reporting slides - dashboards with the ability to view data by specified slice - are generated based on ready-made indicators (for example, the PL items) or according to the calculated data (liquidity, profitability, financial stability).
Within the model, the block on summary presentation is divided into 5 parts:
- Key performance indicators;
- Sales;
- Working capital and business performance;
- Financial ratios;
- Comments.
The first block presents data on the company's overall activity. Therefore, on the slides contained within this block you will observe:
percentage of the implemented budget in the form of pie charts;
factor analysis of net profit formation in the form of waterfall diagrams with percentages underneath;
key cost indicators based on the MDB report;
adjustments to the Balance Sheet items in the form of a combination of pie charts, bar charts and relevant tables.
The second block provides sales analysis using various analytics. Users have the option to analyze basic indices - sales with and without VAT, gross profit and profitability in absolute and relative values for the period and compared to previous respective periods. Next is a graphical analysis by analytics detailing the data that has been loaded. These are regions/sales departments and sales channels. The graphs show the percentage of budget implementation and deviations from the budget, comparisons with previous periods, and the dynamics of distribution by period.
The next block presents a set of indicators with calculations based on the balance sheet data. Visualization is built on the synergy of graphical and tabular representations of data and their complementarity.
The fourth block contains data on different types of profitability also expressed using two representations. Users will observe normative values for the liquidity ratio in addition to actual data and indicators for gross profit margin in key business areas.
The last block contains slides with the option to leave comments on all company activities and recommended specific solutions to eliminate current problems and improve the company’s performance.
An important aspect of the model overall is the option to define corporate colors and style to be used throughout the presentation. You can also enter comments for each month in the administration block so that they are displayed in a uniform standard for all model users.
As mentioned above, in addition to the general presentation, there is a second block of the model. This portion provides personal reports on indicators for the company, configured by roles for each employee, and takes into account the company’s organizational structure.
To set up a personal report, each employee must be assigned a specific role. For each role, a set of required parameters are defined, which may be divided into several folders. Afterwards, you can set the period and version by which it will be tracked for each indicator.
Personal KPIs can be in a yes/no test format as well as in numerical format (absolute or relative values). Users may set the required number of decimal places for each indicator in numerical format.
After the settings for the user's role and indicators are ready, unique reports for each employee are collected by perssing the button. Using the parameter settings menu, employees can adjust the period, budget version, and the conditions to calculate indicators, from the beginning of the year or for a specific period.