GRC-105 - Microsoft Power BI Advanced Dashboard Design Concepts and Strategies
Presenting data with Microsoft Power BI is simple as anyone can draw charts on the canvas and start visualizing numbers graphically. Unfortunately, it is not easy to design a good and appealing dashboard. This 2-day course is designed for Power BI creators who wish to learn how to create beautiful and effective dashboards, while avoiding all the common design pitfalls and mistakes.
After completing this course, students will be able to:
- Learn the 15 golden rules of dashboard design concepts in Microsoft Power BI.
- Obtain a visual chart reference for different types of dashboard objectives and use them in their day-to-day lives.
Intro: Strategizing a Power BI Dashboard
What people think a dashboard is and what it really is.
The 15 Golden Rules of dashboard design.
Lab 00 – Sample Personal Finance dashboard
Rule 1: Design for a Target
o Sample Dashboard Rule 0
- Design each dashboard for a single target person, group or specific goal.
- Lab 01
o Sample Dashboard Rule 1
Rule 2: Keep Everything at a Glance
o Sample Dashboard Rule 2
- Design each dashboard to present all information in a single non-scrollable screen.
- Lab 02
o Sample Dashboard Sizes
o Sample Dashboard Mobile
o Sample Dashboard Hierarchical
Rule 3: Keep it Simple
o Sample Dashboard Rule 3
- The foundation of a good design is simplicity!
- Lab 03
o Sample Dashboard Rule 3 Dark
Rule 4: Align All Elements
o Sample Dashboard Rule 4
- Always align all elements on the dashboard.
- Lab 04
o Sample Dashboard Placeholder
Rule 5: Be Consistent in Your Design
o Sample Dashboard Rule 5
- Repetition means familiarity.
- Implement a pattern of design.
- Lab 05
Rule 6: Highlight the Most Relevant Information
o Sample Dashboard Rule 6
- A good dashboard contains only information that is relevant to its scope.
- Lab 06
Rule 7: Be Clear
o Sample Dashboard Rule 7
- A good dashboard should use simple terminology and explain all abbreviations.
- Lab 07
Rule 8: Start from Zero
o Sample Dashboard Rule 8
- The value of the y-axis should start from zero albeit some exceptions.
- Lab 08
o Sample Dashboard Body Temperature
Rule 9: Shorten All the Numbers
o Sample Dashboard Rule 9
- Dashboard users usually aren’t interested in seeing precise figures.
- Lab 09
Rule 10: Show the Context
o Sample Dashboard Rule 10
- Indicating a context for a number is more informative.
- Lab 10
Rule 11: Choose the Right Colors
o Sample Dashboard Rule 11
- Colors are not only decorative, but they convey messages and cause emotions.
- Lab 11
o Sample Dashboard ColorHelper
Rule 12: Dashboards are NOT Reports
o Sample Dashboard Rule 12
- A dashboard is just an overview to monitor a certain situation and should not go deep into the details.
- Lab 12
Rule 13: Show Variations
o Sample Dashboard Rule 13
- A dashboard should present comparisons and highlight changes where possible.
- Lab 13
o Sample Dashboard Variations
Rule 14: Leave the Noise Off
o Sample Dashboard Rule 14
- Very often, there are too much information which are useless to be presented.
- Lab 14
Rule 15: Pick the Right Charts
o Sample Dashboard Rule 15
- Too many times people present the right data but with the wrong chart.
- Lab 15
Attendees preferably have a basic knowledge of using Microsoft Power BI Desktop to create reports and dashboards. It is also a good course for people who want to kickstart their Power BI reporting and dashboard ventures.
This course is not associated with any Certification.