Overview
-
Build and use optimal data dashboards with Microsoft Power BI. Learn how to design and customize the setup of visuals and charts to make your findings easy to understand.
Syllabus
-
Introduction
- Power BI ecosystem
- Things to keep in mind
- Selecting dashboard colors properly
- Importing visuals into Power BI
- Data sources for your analysis
- Data queries
- Joining tables in Power BI
- Utilizing a report theme
- Table visuals
- Matrix visuals
- Drilling into hierarchies
- Applying static filters
- Creating lists
- Creating bins
- Using DAX in Power BI dashboards
- Using Quick Measures in Power BI dashboards
- Challenge: Designing your dashboard
- Solution: Designing your dashboard
- Heatmaps in Power BI
- Visualizing time-intelligence trends
- Ranking categorical totals
- Comparing proportions
- Creating sparklines to quickly view trends
- Setting up histograms
- Challenge: Develop the table visuals solution
- Solution: Develop the table visuals solution
- Examining key performance indicators (KPI)
- Visualizing trendlines as KPI
- Forecasting with trendlines
- Leveraging violin plots to quickly analyze a dataset
- Visualizing flows with Sankey diagrams
- Creating a scatter plot
- Challenge: Adding KPI metrics
- Solution: Adding KPI metrics
- Obtaining shapefiles
- Setting up custom shapefile mapping
- Mapping with ArcGIS or ESRI
- Configuring Mapbox layers to provide more detailed views
- Mapping flow patterns
- Challenge: Mapping visuals
- Solution: Mapping visuals
- High-level dashboard
- Growth Rates dashboard
- Local dashboard
- Migration analysis dashboard
- Adding slicers for filtering
- Adding nudge prompts to promote interactions
- Searching the dashboard with a slicer
- Creating dynamic labels
- Highlighting key points on the dashboard
- Customizing tooltips to add visualizations without taking up space
- Syncing slicers to filter pages
- Configuring chiclet slicers
- Showing the "Top N" rankings
- Challenge: Combined dashboard view
- Solution: Combined dashboard view
- Setting up and formatting phone views
- Exporting data
- Creating templates
- Creating PDF files
- Uploading to the cloud
- What can you do now?
