October Sale - 20% of all courses - Book Today

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.8/5
Over 23623 Reviews
Very good course - I learnt a lot. Tamara was really patient and helpful. -R Intermediate Brisbane
Elly - R Intermediate, .
Learnt lots good stuff to use for my work. Thank you -Excel Beginner Brisbane
Adam - Excel Beginner, .
Thank you for your time and it was very informative. Many Thanks -Excel Beginner Brisbane
Morgan - Excel Beginner, .
it covered all my needs. Thanks -Excel Beginner Brisbane
Rohan - Excel Beginner, .
Great learning and enjoyed . -Excel Beginner Brisbane
John - Excel Beginner, .
Very pleasant, informative day. -Power BI Beginner Brisbane
Bobbette - Power BI Beginner, .
This has been a very helpful introduction to Power BI - we'll be able to move some of our reports across to Power BI sooner than we expected. -Power BI Beginner Brisbane
Karen - Power BI Beginner, .
Great beginner session - trainer very personable. -Power BI Beginner Brisbane
Tracey - Power BI Beginner, .
Very helpful and hands on. A comprehensive look at the basics of PowerBI - definitely interested in learning more in the intermediate course. -Power BI Beginner Brisbane
Daniel - Power BI Beginner, .
Very valuable session. Can definitely see how we will use this in the workplace. Steven was a great trainer and kept the room going all day, -Power BI Beginner Brisbane
Amanda - Power BI Beginner, .
Steven was a great trainer. -Power BI Beginner Brisbane
Fay - Power BI Beginner, .
Great overview. -Power BI Beginner Brisbane
Barbara - Power BI Beginner, .
Very informative, the presenter was thorough and welcoming to all. I never felt uncomfortable asking questions. I am also grateful for the Course Manual, so I can review the Agenda topics again at my own pace. -Excel Intermediate Sydney
Janelle - Excel Intermediate, .
excellent teacher very impressed -Excel Intermediate Remote Online
Michelle - Excel Intermediate, .
Very informative. Some great hacks -Excel Intermediate Remote Online
Matthew - Excel Intermediate, .
Thanks Michael, you were patient and happy to go back over knowledge whenever people needed it. I love how excited you got over some of the technical aspects - they were really interesting! Sometimes it was a little hard to hear, might have been connectivity issues on my end, not sure. Thanks so much! -Excel Intermediate Sydney
Kristie - Excel Intermediate, .
The topics chosen were very useful. I especially think the If statements, vlook up, pivot table and flash fill will work well for me in the future. Michael was very helpful and always stopped to assist those who needed further info. He was also happy to answers questions in general related to excel. Potentially needed some polls or questions within the training to check learning and understanding. -Excel Intermediate Sydney
Jessica - Excel Intermediate, .
Michael is very good teacher. It was a great session and learned a lot in a short time. -Excel Intermediate Sydney
Philip - Excel Intermediate, .
very good. Need to practice now -Excel Intermediate Sydney
David - Excel Intermediate, .
Jason gave us a really good overview of both Power BI service and desktop and was very helpful answering our questions. The course was very helpful in cementing and extending my basic understanding of Power BI -Power BI Beginner Canberra
Paul - Power BI Beginner, .

Trusted by Business

south east asia microsoft training courses nexacu

Follow us