Get the best dashboard practices! In this post, we’ll show you how to improve your Excel skills with the help of a FAQ section.
How many performance indicators are needed? You should know exactly. If the goal is to track only 5-10 KPIs, it is sensible to use a gauge chart; most companies will need a lot more than that. A gauge chart is an incredible tool, but it could be more efficient. On the other hand, if the goal is to track more than 10 KPIs, then the best choice is the bullet chart.
How to track and visualize budget vs. actual performance? By all means, use a variance chart, but as an alternative, the bullet chart is suitable.
What should be the format of the final work? Will we have to share our information through the intranet or only share it with a few managers? We have to pay attention to set authorizations. For example, the template should always be read-only! Imagine where it would lead if somebody opens the file, modifies it, and then forward it in an e-mail. I don’t even dare to think…
Compatibility first! Remember that different versions of Excel have different functions. If the file was created with Excel 2016 and someone wants to open it with Excel 2007, nothing good will come out of it.
Data Cleansing: Last but not least clean raw data using built-in and macros and VBA solutions! It’s crucial to convert tabular format data into an Excel table. All right, the task is given! But how should we start?
Dashboard Practices and Fundamentals
Focus on the essence! The basis of every report is the one-page layout. Keep in mind that the user doesn’t always interested in the details. For example, a CEO is usually still busy, having just enough time to look through some KPIs. At the same time, the business analyst has to see even the smallest details.
Before you effectively start creating a dashboard, here are some useful tips and advice:
- KISS! Keep it simple, sparse. Very important is that we appropriately apply this rule! Don’t jam the screen full of unusable charts. This only distracts attention from the essence!
- Apply user-friendly interface. What we measure is not the only important thing. Representation is also important. When you create a report, you have to think about others also have to understand it besides you.
- Add an alert for KPIs. Apply varied tools! Some great technics are gauge charts, traffic lights, free widgets, bullet charts.
- Use form controls
- Ability to pull real-time data from several bases. The most frequent data sources are the following: online and offline database, OLAP cubes, pivot tables, text files, internal and external data sources.
- Logical structure behind the scenes: most of the mistakes can be filtered out if we work with well-structured databases and data tables. Use three worksheets. The first one contains the raw data tables. On the second one, we make the calculations. Finally, on the third one, we display the final dashboard
- Displays actual data, forecast, or trends.
Conclusion – Use the best practices
When an idea is born in our heads, there are two possible ways to go about it. In the first scenario, we immediately get to work and neglect the planning part. But, of course, this never leads to nowhere. So in the second case, we carefully plan the design and the necessary steps.
What do you think is more productive in the long run? In our opinion, the planning phase should take up 70% of the whole project. The remaining 30% is needed for the implementation. Mistakes are a lot less if we advance step by step. Stay tuned, and we’ll append the article with the latest dashboard practices!
I am not a designer but would like to create splendid presentations. What should I do? Read on! More of our free tools support beginner users also.