Data Dashboards in Power BI

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.

Introduction

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

1. 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

2. Visualizing Data

• 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

3. 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

4. Mapping Options

• Exploring map options
• Shape map visual
• Drilling through map levels
• Mapping flow patterns
• Challenge: Map visuals
• Solution: Map visuals

5. Putting It All Together

• Customing tooltips
• Configuring chiclet slicers
• Displaying Top N rankings
• Syncing slicers between pages
• Creating dashboards
• Adding nudge prompts to promote interactions

6. Sharing Your Work

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

Conclusion

• Getting more out of Power BI