Random Forest AB - KPI and Budget Comparision - Consulting Services

A dashboard demonstrating KPI:s and budget tracking for an imaginary Consulting Services company.

パートナーに問い合わせる ビデオを見る

The Scenario

The scenario for this demo is a simplified consultancy firm with about 200 consultants working for clients paid by the hour. The consultants are permanently hired on fixed salary so apart from the normal financial KPI:s it is important with achieving as high utilization as possible. The company has three departments in Sweden of different sizes. Budget is set in the beginning of each year for each of the departments. 

Target Audience

This is a dashboard primarily targeted for management, giving a quick glance at the current status but also empowering them to understand and ask the right questions in order to take action for better performance.


To achieve better corporate performance and being able to act on deviations in time, management needs to get a view of the current status, but also the long term yearly goal. Normally an indicator on a high level consists of many sub-indicators which makes it hard to understand the underlying reason for a deviation. I.e. if profitability goes down, it could be due to higher cost or lower income. Lower income can depend on consultants not working hard enough, or just that there just happened to be a big holiday that wasn't being calculated with.

Being able to se the long term yearly goal together on the key performance indicators with the most important sub-indicators and how they deviate against target is a powerful way of giving quick insights on a company performance. Being able to also highlight, drill and change perspective empowers management to get answers or sharpening their questions to middle management.


Visit http://www.randomforest.se for help with building BI solutions with Power BI and Azure.

Power BI パートナーになりませんか?

認定パートナーはチームにとって重要な存在です。新しいビジネス チャンスを見出し、つながりを持ち、会社の持つ能力や経験を世界中の Power BI ユーザーと共有しましょう。


パートナーになる メリットを確認する