MicroSoft Power BI
Module 1: Quick Start Power BI Service
- Get Power BI Tools
- Introduction to Tools and Terminology
- Dashboard in Minutes
- Refreshing Power BI Service Data
- Interacting with your Dashboards
- Sharing Dashboards and Reports
- Recap and What’s Next
Module 2: Getting and Transforming Data with Power BI Desktop
- Introduction to Power BI Desktop
- Getting Data: Excel vs Power BI Desktop & Service
- Data Structure for Q&A
- DirectQuery vs Import Data
- Recap and What’s Next
Module 3: Modeling with Power BI
- Introduction to Modeling
- Setup and Manage Relationships
- Cardinality and Cross Filtering
- Default Summarization & Sort by
- Creating Calculated Columns
- Creating Measures & Quick Measures
- Recap and What’s Next
Module 4: Power BI Desktop Visualisations
- Creating Visualisations
- Color Formatting
- Setting Sort Order
- Scatter & Bubble Charts & Play Axis
- Tooltips
- Slicers, Timeline Slicers & Sync Slicers
- Cross Filtering and Highlighting
- Visual, Page and Report Level Filters
- Drill Down/Up
- Hierarchies
- Reference/Constant Lines
- Tables, Matrices & Conditional Formatting
- KPI’s, Cards & Gauges
- Map Visualizations
- Custom Visuals
- Managing and Arranging
- Drillthrough
- Custom Report Themes
- Grouping and Binning
- Selection Pane, Bookmarks & Buttons
- Recap and What’s Next
Module 5: Power BI Service Visualisation Tools
- Introduction
- Standalone Tiles
- Data Driven Alerts
- Quick and Related Insights
- Custom Q&A questions
Module 6: Publishing and Sharing
- Introduction
- Sharing Options Overview
- Publish from Power BI Desktop x
- Publish to Web
- Share Dashboard with Power BI Service
- Workspaces and Apps (Power BI Pro)
- Content Packs (Power BI Pro)
- Print or Save as PDF
- Row Level Security (Power BI Pro)
- Export Data from a Visualization
- Publishing for Mobile Apps
- Export to PowerPoint
- Sharing Options Summary
Module 7: Refreshing Datasets
- Understanding Data Refresh
- Personal Gateway (Power BI Pro and 64-bit Windows)
- Replacing a Dataset
- Troubleshooting Refreshing
Module 8: Power BI and Excel Together
- Options for Publishing from Excel
- Pin Excel Elements to Power BI
- Connect to Data using Power BI Publisher/Analyze in Excel
- Excel 2016 Publish: Upload and Export to Power BI
- Sharing Published Excel Dashboards