All courses available in-class or via remote login

Dashboards and Data

Excel crunches numbers very effectively, but it must always be remembered that it is also a communication tool just like Dashboards. The messages in your data must be read and understood, without a struggle.

Dashboards must rely on good data or they won’t be effective or maintainable. The design aspect of the dashboard is also vital and relies on a totally different set of skills to get right. These are the skills of visual business intelligence. Here are some design ideas to think about.

 

Dashboard Design

The primary rule that should be followed is clear – simplify as much as possible. What is the key message that you are trying to communicate on the dashboard? Once you know that, put that data in the best position to be read. Studies consistently show that people’s eyes are drawn first to the top left of a screen, so that locality is “king”.

Your dashboard also shouldn’t be “everything to everyone”. Inconsequential data gets in the way of the primary information needed. Avoid the temptation to fill white space because your dashboard looks lopsided. The correct use of Proximity is an important principle in graphic design. Background fills should be used sparingly if at all. Use the white space between visualizations to split up the parts of your dashboards and if necessary, move some closer together and some further apart to show their relationships.

Data is important and doesn’t need jazzing up to make it look more impressive. Keep the use of green, yellow and red in either font colours or fills to the traditional meanings of those colours.

You should also de-emphasize labels and titles by using lighter colours and hues, so your data stands out from them. They should still be able to be read, but they are not the main information.

To sum up – key data has primary importance. Make it clear. Declutter the view. Don’t distract and your message will get across efficiently.

Contact Us

What is Remote Training?

Valued by Individuals

4.72 / 5
Over 26985 Reviews
Good knowledge and very useful. -Excel Intermediate Remote Online
Liliana - Excel Intermediate, .
The instructions were clear and provided advice on pivot tables and graphs which found very helpful. -Excel Intermediate Remote Online
Dayle - Excel Intermediate, .
Very informative and easy to follow and understand. -Excel Intermediate Remote Online
Cindy - Excel Intermediate, .
Very well presented, Steven was very patient and explained things very well. was a very informative day. -Excel Intermediate Remote Online
Katherine - Excel Intermediate, .
Very informative course, well presented and I will use a lot of this information -Excel Intermediate Remote Online
Valerie - Excel Intermediate, .
Steven was a great teacher he was very patient and did everything step by step so it wasn't confusing. Would recommend this course to someone who is wanting to learn about excel. -Excel Intermediate Remote Online
Maddison - Excel Intermediate, .
Steven was very patient and went back to re-do steps if we got confused. Learnt a lot and was very informative. -Excel Intermediate Remote Online
Kim - Excel Intermediate, .
Very informative - expanded on my knowledge. Some good tips were provided regarding shortcuts. -Excel Intermediate Remote Online
Michelle - Excel Intermediate, .
Very informative course! -Excel Intermediate Remote Online
Julie - Excel Intermediate, .
Steven was a great trainer -Excel Intermediate Remote Online
Michelle - Excel Intermediate, .
Thanks a good fast paced course with a knowledgable trainer -Excel Intermediate Remote Online
Vicki - Excel Intermediate, .
Really informative course with Jason. Went at a good pace and constantly asked if we had any questions. -Excel Intermediate Brisbane
Roland - Excel Intermediate, .
Great session! Very informative. Ken was a great presenter, very patient and helpful. -Power BI Intermediate Melbourne
Donna - Power BI Intermediate, .
xlnt presenter -Excel Intermediate Brisbane
Neal - Excel Intermediate, .
Ken is a very good teacher and the whole training course is very informative and enjoyable. -Power BI Intermediate Melbourne
TUAN - Power BI Intermediate, .
Great day. Learnt a lot of new info about how to better use excel and save myself a lot of time trying to figure things out. Will reduce my workload! -Excel Intermediate Brisbane
Natalie - Excel Intermediate, .
Thought it was great! Very engaging considering completed remotely. Definitely helpful. Thank you! -Power BI Intermediate Melbourne
Lauren - Power BI Intermediate, .
Thank you for the course. Very clear and concise. I would definitely recommend the intermediate course for people with beginner experience. -Power BI Intermediate Melbourne
Matthew - Power BI Intermediate, .
Excellent course, a lot of information to take in over a day but very useful and feel confident enough to play around PBI on my own. Facilitator was very engaging and entertaining, so helped us stay tuned throughout the day. -Power BI Intermediate Melbourne
Iantha - Power BI Intermediate, .
Great pace, good examples and easy to follow. -Power BI Intermediate Melbourne
Tania - Power BI Intermediate, .

Trusted by Business

Procured by Government

Awards and Accreditations

Nexacu offices Australia

Follow us