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.
Overview
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?
Taught by
Helen Wall