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
()
1. Working with Data
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
()
2. Creating Visuals
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
()
3. Comparing Multiple Variables
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
()
4. Mapping Options
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
()
5. Creating Dashboards
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
()
6. Sharing Dashboards
Setting up and formatting phone views
()
Exporting data
()
Creating templates
()
Creating PDF files
()
Uploading to the cloud
()
Conclusion
What can you do now?
()
Glossary_Data_Dashboards_Power_BI.zip
(100 KB)
Ex_Files_Data_Dashboards_Power_BI_Upd.zip
(340.0 MB)