Getting Started
  • Course Structure & Outline
  • READ ME: Important Notes for New Students
  • DOWNLOAD: Course Resources
  • Setting Expectations
  • Helpful Resources
  • Introducing the Course Project
Introducing Power BI Service
  • Introduction
  • Meet Power BI Service
  • Account Types
  • Common User Personas
  • Creating a Power BI Account
  • PRO TIP: Signing up with a Non-Work Email
  • Activating Your Trial
  • Quick Tour of the Interface
  • Workspaces
  • Common Workspace Actions
  • Building Blocks of PBI Service
  • Introducing Power BI Service
Power BI Service Administration
  • Introduction
  • Admin Roles & Types
  • Admin Portal Settings & Options
  • Tenant Settings
  • PRO TIP: Configuring Custom Branding
  • BEST PRACTICES: Power BI Service Administration
  • Power BI Service Administration
Connecting to Data
  • Introduction
  • Data Connection Options
  • Loading a Local File
  • Loading Data from Excel
  • PRO TIP: Loading Data from SharePoint
  • ASSIGNMENT: Loading Local Data to a Workspace
  • INSTRUCTIONS: Loading Local Data to a Workspace
  • SOLUTION: Loading Local Data to a Workspace
  • Understanding Data Gateways
  • Setting Up a Data Gateway
  • Understanding Dataflows
  • Common Dataflow Use Cases
  • Creating a New Dataflow
  • Quick Tour of the Dataflow Interface
  • Connecting to a Dataflow in Desktop
  • ASSIGNMENT: Connecting to a Dataflow
  • INSTRUCTIONS: Connecting to a Dataflow
  • SOLUTION: Connecting to a Dataflow
  • DEMO: Creating a Dataflow (MySQL)
  • DEMO: Creating a Dataflow (Local MySQL)
  • Scheduled Refresh of a Dataflow
  • DEMO: Real World Automation Setup
  • BEST PRACTICES: Connecting to Data
  • ASSIGNMENT: Finishing the Power BI File
  • INSTRUCTIONS: Finishing the Power BI File
  • SOLUTION: Finishing the Power BI File
  • Connecting to Data
Reports & Dashboards
  • Introduction
  • Data Lineage
  • Report Interface & Tools
  • Inserting & Formatting Basic Visuals
  • PRO TIP: Adding Personal Bookmarks
  • PRO TIP: Adding an Image
  • ASSIGNMENT: Building a Report
  • INSTRUCTIONS: Building a Report
  • SOLUTION: Building a Report
  • Pinning Tiles to a Dashboard
  • Pinning Entire Reports to a Dashboard
  • Dashboard Interface & Tools
  • PRO TIP: Adding a Live Page
  • ASSIGNMENT: Assembling a Dashboard
  • INSTRUCTIONS: Assembling a Dashboard
  • SOLUTION: Assembling a Dashboard
  • Adding Data Driven Alerts
  • Exploring Data with Q&A
  • Generating Quick Insights
  • Designing for Mobile
  • Introducing the Power BI Mobile App
  • DEMO: Power BI Mobile App
  • BEST PRACTICES: Reports & Dashboards
  • ASSIGNMENT: Alerts and Q&A
  • INSTRUCTIONS: Alerts and Q&A
  • SOLUTION: Alerts and Q&A
  • Reports & Dashboards
Sharing & Collaboration
  • Introduction
  • Sharing & Collaboration Options
  • Sharing Reports, Dashboards & Apps
  • Defining User Roles & Permissions
  • Publishing Apps
  • Publishing to Web
  • PRO TIP: Generating Usage Reports
  • BEST PRACTICES: Sharing & Collaboration
  • ASSIGNMENT: Sharing & Collaboration
  • INSTRUCTIONS: Sharing & Collaboration
  • SOLUTION: Sharing & Collaboration
  • Sharing & Collaboration
Row-Level Security
  • Introduction
  • Static RLS