Hands-On Power BI Training For Data Science

Duration: 8 Hours – 4 Hours Per Day

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