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 사용자와 귀사의 재능과 경험을 공유하세요.


파트너가 되어야 하는 이유에 대해 알아보세요.