Power BI Data Visualization and Dashboard Tips, Tricks, and Techniques

Introduction

• Design reports that deliver insights with Power BI
• How to use the exercise files and course assets

1. Get Started in Power BI

• Differentiate Power BI Desktop and Service
• Understanding Power BI licensing and using trial accounts
• Discover Power BI Service within Microsoft Fabric
• Navigate a Power BI report in Desktop
• Navigate the four views in Desktop
• Navigate the format and analysis panes
• Challenge: Create your own report using sample data
• Solution: Create your own report using sample data

2. Editing and Creating Types of Visuals in Power BI

• Understanding the publishing workflow
• Mastering bar charts in Power BI
• Drilling down line charts with date hierarchies
• Display single numbers with KPIs, new card visuals, and gauges
• Showcase proportion data with pies and treemaps
• Visualize distribution data with histograms and scatterplots
• Use maps and choropleths with confidence
• Compare table and matrix visuals
• Use custom visuals to solve unmet requirements
• Challenge: Create a report showing trends in profitability
• Solution: Create a report showing trends in profitability

3. Organizing and Interacting with Visuals

• Manipulating visuals within a report
• Using new and old slicers to filter your visuals
• Prevent frustration with layer order using Selection pane
• Learn how visuals filter each other by default and by design
• Understand dashboard design principles
• Organizing your visuals with bookmarks
• Challenge: Improve your report using three new tools
• Solution: Improve your report using three new tools

4. Report Design and Creation

• Understand when to make a new tab
• How to lay out your report page for maximum effect
• Use color well for your audience
• Mastering responsive design for mobile
• Challenge: Design a two tab report
• Solution: Design a two tab report

Conclusion

• What's next for Power BI success