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 Power BI dashboard design 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.

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.

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

• Design each dashboard for a single target person, group or specific goal.
• Lab 01
  • Sample Dashboard Rule 0
  • Sample Dashboard Rule 1

Rule 2:    Keep Everything at a Glance

• Design each dashboard to present all information in a single non-scrollable screen.
• Lab 02
  • Sample Dashboard Rule 2
  • Sample Dashboard Sizes
  • Sample Dashboard Mobile
  • Sample Dashboard Hierarchical

Rule 3:    Keep it Simple

• The foundation of a good design is simplicity!
• Lab 03
  • Sample Dashboard Rule 3
  • Sample Dashboard Rule 3 Dark

Rule 4:    Align All Elements

• Always align all elements on the dashboard.
• Lab 04
  • Sample Dashboard Rule 4
  • Sample Dashboard Placeholder

Rule 5:    Be Consistent in Your Design

• Repetition means familiarity.
• Implement a pattern of design.
• Lab 05
  • Sample Dashboard Rule 5

Rule 6:    Highlight the Most Relevant Information

• A good dashboard contains only information that is relevant to its scope.
• Lab 06
  • Sample Dashboard Rule 6

Rule 7:    Be Clear

• A good dashboard should use simple terminology and explain all abbreviations.
• Lab 07
  • Sample Dashboard Rule 7

Rule 8:    Start from Zero

• The value of the y-axis should start from zero albeit some exceptions.
• Lab 08
  • Sample Dashboard Rule 8
  • Sample Dashboard Body Temperature

Rule 9:    Shorten All the Numbers

• Dashboard users usually aren’t interested in seeing precise figures.
• Lab 09
  • Sample Dashboard Rule 9

Rule 10:    Show the Context

• Indicating a context for a number is more informative.
• Lab 10
  • Sample Dashboard Rule 10

Rule 11:    Choose the Right Colors

• Colors are not only decorative, but they convey messages and cause emotions.
• Lab 11
  • Sample Dashboard Rule 11
  • Sample Dashboard ColorHelper

Rule 12:    Dashboards are NOT Reports

• A dashboard is just an overview to monitor a certain situation and should not go deep into the details.
• Lab 12
  • Sample Dashboard Rule 12

Rule 13:    Show Variations

• A dashboard should present comparisons and highlight changes where possible.
• Lab 13
  • Sample Dashboard Rule 13
  • Sample Dashboard Variations

Rule 14:    Leave the Noise Off

• Very often, there are too much information which are useless to be presented.
• Lab 14
  • Sample Dashboard Rule 14

Rule 15:    Pick the Right Charts

• Too many times people present the right data but with the wrong chart.
• Lab 15
  • Sample Dashboard Rule 15
     

GRC-102: Conquering DAX 2019

This GRC-102: Conquering DAX 2019 workshop is a complete course about the DAX language. DAX is the native language of Power BI, Power Pivot for Excel, and SSAS Tabular models in Microsoft SQL Server Analysis Services. The training is aimed at users of Power BI, Power Pivot for Excel, and at Analysis Services developers that want to learn and master the DAX language. This DAX training course covers the latest version of DAX 2019.

GRC-107: Building A Data Literate Culture In Your Organization

When information becomes a valuable asset, data becomes a strategic priority. Data is becoming a competitive differentiator for top organizations as they focus on digital transformation while still in the early stages of adoption. Data serves as a significant catalyst for a company's digitalization and transformation activities.

GRC-112: Microsoft Power BI Data Modeling with DAX

This GRC-112: Microsoft Power BI Data Modeling with DAX workshop is a complete course about the DAX language. DAX is the native language of Power BI, Power Pivot for Excel, and SSAS Tabular models in Microsoft SQL Server Analysis Services.

PL-300T00: Microsoft Power BI Data Analyst

In today's digital age, subject matter experts with Power BI proficiency are at the forefront of the technological revolution. These experts are capable of making new sources of information more accessible, understandable, and useful to organizations of all sizes.

By obtaining the Microsoft Certified: Power BI Data Analyst Associate credential, you are validating your Power BI data analysis skills and standing out in a world where the demand for this expertise is rapidly increasing.

Turn your data into immediate impact.

Do more with less using an end-to-end BI platform to create a single source of truth, uncover more powerful insights, and translate them into impact with these recommended resources:

• The Common Questions and Answers for Power BI
• Why POWER BI makes your reporting life easier?
• Low-Code Datamart with Microsoft Power BI
• The Future Of Enterprise Analytics Is Power BI And Azure
• Microsoft Power BI: Creating Meaningful Data Reports
• Real-Time Streaming In Microsoft Power BI
• How Do You Extract The True Value Of Your Data With Power BI?