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
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
- Direct Query vs Import Data
- Recap and What's Next
Module 3: Modeling with Power BItitle
- 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 Visualizations
- Creating Visualizations
- 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
- Drill through
- Custom Report Themes
- Grouping and Binning
- Selection Pane, Bookmarks & Buttons
- Recap and What's Next
Module 5: Publishing and Sharing
- Introduction
- Sharing Options Overview
- Publish from Power BI Desktop
- 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 6: Refreshing Datasets
- Understanding Data Refresh
- Replacing a Dataset
- Troubleshooting Refreshing
Module 7: 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