Utilization dashboard design

At the beginning of this year, I got a project to prepare a decent looking demo dashboard in Power BI for our company to use at presales meetings. I chose the topic of utilization as it’s something everyone is interested in, regardless of the industry they’re working in. Tracking the productivity and efficiency of employees is crucial to all organizations, as a higher utilization rate will most likely result in more revenue for the company. Having a utilization report can help you detect unexploited and overdriven capabilities, so as to better plan your resources. The end result came out as below, but the way leading here was not the easiest one. Read on to explore the journey in my no. 1 strive in dataviz, dashboard design!

Final dashboard design

How do I start planning a dashboard from zero?

At first, I put together all the charts and KPI tiles I intend to use for the visualization on a blank canvas and organize them so that they would both follow business logic and provide good user experience. For this look, I wanted to do something modern, that has high contrast yet remains minimal, so I decided to go with minty colours on a dark background. It’s hard to draw something while you can’t see the outcome, so from a very early stage, I started using my sketch as a Power BI wallpaper and then finetuned it based on what I saw in the software. It might have taken more than 20 iterations while it came out as expected and took a lot of hours to accomplish.

Colour scale
Dashboard background is drawn in Adobe Illustrator

The interactive version can be checked out in the Power BI Data Stories Gallery, while dashboard functionality is demonstrated in the below animation.

Dashboard functionality

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.