Power BI Training

Power BI Course Content

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
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

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

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

Power BI Service Visualisation Tools

• Introduction
• Standalone Tiles
• Data Driven Alerts
• Quick and Related Insights
• Custom Q&A questions

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

Refreshing Datasheets

• Understanding Data Refresh
• Personal Gateway (Power BI Pro and 64-bit Windows)
• Replacing a Dataset
• Troubleshooting Refreshing

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