Samples

Have a look on some samples from previous works!

This slideshow requires JavaScript.

Our client needed a Cross Training Matrix where he could easily follow his employees’ skill level. An excel template has been created where the ratings from 0 to 4 are reflecting the skill level for the respective training. The usage of the template is very simple, the numbers 0-4 have to be introduced in the cell which it’s turning automatically into a cirle with marked quarters according to the proper level. The template is very catchy and it summarizes the status of employees’ skills, showing the total rate based on which a rank can be stood up.

This slideshow requires JavaScript.

The above is an insight to a Sales Dashboard, the performance of the company can be easily followed by these pivot tables and charts. The evolution of sales volume and value per product in different periods can give a picture of trends to the management and helps in decision making for future plans. The excel is dynamic, in case something changes in the input data the tables and charts will be updated automatically.

This slideshow requires JavaScript.

Similar KPI Dashboard has been prepared for another client about revenues, expenses and net profit, please find some details above. Monthly and yearly data has been analysed and compared to previous periods.

This slideshow requires JavaScript.

Regional Sales Report is a PPT with linked Excel tables and Graphs, this way the data can be changed anytime – headers and footers are also linked, so they can also be calculated/ filtered based on data. The Input Data source is a Sharepoint extract through Access and exported into Excel. The report has been created with Excel Macro, the graphs are also imported by macro in PPT. The macro is loading the data from many excel files, it’s making the KPI aggregation to region and channel level in a well-structured form.