Power BI Data Dashboards

Course details

Power BI is a powerful data analytics application for modeling data and creating data visualizations. To truly leverage the power of Power BI, you need to use your visuals impactfully to communicate trends and analysis to make decisions. In this course, data analytics and business analysis expert Helen Wall focuses on the Power BI dashboard, where users interact with charts and graphs that communicate trends in their data. Go over building data dashboards, setting up the Power BI model and ecosystem, and choosing colors. Explore various tools to work with and data and visualize it. Learn ways to compare multiple values, and dive into the mapping options available to you. Find out how to customize tooltips, configure chiclet slicers, display Top N rankings, and more, to put it all together in your own dashboard. To wrap up, learn how to share your work with a phone view, publishing to the Power BI service, and sharing Power BI models.

Concepts

Introduction

Building data dashboards in Power BI
What you should know
Setting up the Power BI model
Building the Power BI ecosystem
Choosing colors

Working with Data

Configuring table and matrix visuals
Building hierarchies
Creating lists and bins
Applying filters
Building and using DAX formulas
Using quick measures formulas
Formatting visuals
Adding color gradients to heatmaps
Utilizing report themes

Visualizing Data

Visualizing time-intelligence trends
Using column charts to visualize trends
Ranking categorical totals
Comparing proportions
Setting up histograms
Utilizing scatter plots
Building visuals with image data
Challenge - Visualizing data
Solution - Visualizing data

Comparing Multiple Variables

Analytics options - Reference, trend, and forecast lines
Creating sparklines to quickly view trends
Leveraging box plots and violin plots
Visualizing flows with Sankey charts
Examining key performance indicators (KPIs)
Challenge - Analyzing multiple variables
Solution - Analyzing multiple variables

Mapping Options

Exploring map options
Creating choropleths
Drilling through map levels
Mapping flow patterns
Creating paths between points
Challenge - Map visuals
Solution - Map visuals

Putting It All Together

Customing tooltips
Configuring custom slicer options
Displaying Top N rankings
Syncing slicers between pages
Creating dashboards
Adding nudge prompts to promote interactions

Sharing Your Work

Creating a phone view
Publishing to Power BI service
Sharing Power BI models

Conclusion

Getting more out of Power BI