Build and use optimal data dashboards with Microsoft Power BI. Make your findings easy to understand through the design and customized setup of visuals and charts.
Overview
Syllabus
Introduction
- Building data dashboards in Power BI
- What you should know
- Setting up the Power BI model
- Building the Power BI ecosystem
- Choosing colors
- 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 time-intelligence trends
- Using column charts to visualize trends
- Ranking categorical totals
- Comparing proportions
- Setting up histograms
- Utilizing scatter plots
- Challenge: Visualizing data
- Solution: Visualizing data
- 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
- Exploring map options
- Shape map visual
- Drilling through map levels
- Mapping flow patterns
- Challenge: Map visuals
- Solution: Map visuals
- Customing tooltips
- Configuring chiclet slicers
- Displaying Top N rankings
- Syncing slicers between pages
- Creating dashboards
- Adding nudge prompts to promote interactions
- Creating a phone view
- Publishing to Power BI service
- Sharing Power BI models
- Getting more out of Power BI
Taught by
Helen Wall
