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

0. Introduction

01 - Building data dashboards in Power BI
02 - What you should know
03 - Setting up the Power BI model
04 - Building the Power BI ecosystem
05 - Choosing colors

1. Working with Data

06 - Configuring table and matrix visuals
07 - Building hierarchies
08 - Creating lists and bins
09 - Applying filters
10 - Building and using DAX formulas
11 - Using quick measures formulas
12 - Formatting visuals
13 - Adding color gradients to heatmaps
14 - Utilizing report themes

2. Visualizing Data

15 - Visualizing time-intelligence trends
16 - Using column charts to visualize trends
17 - Ranking categorical totals
18 - Comparing proportions
19 - Setting up histograms
20 - Utilizing scatter plots
21 - Challenge - Visualizing data
22 - Solution - Visualizing data

3. Comparing Multiple Variables

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

4. Mapping Options

30 - Shape map visual
31 - Shape map visual
32 - Drilling through map levels
33 - Mapping flow patterns
34 - Challenge - Map visuals
35 - Solution - Map visuals

5. Putting It All Together

36 - Customing tooltips
37 - Configuring chiclet slicers
38 - Displaying Top N rankings
39 - Syncing slicers between pages
40 - Creating dashboards
41 - Adding nudge prompts to promote interactions

6. Sharing Your Work

42 - Creating a phone view
43 - Publishing to Power BI service
44 - Sharing Power BI models

Conclusion

45 - Getting more out of Power BI

Power BI Data Dashboards

Authors

Helen Wall