Microsoft Power BI For End Users 55400AC - United Kingdom

Microsoft Power BI for End Users 55400AC course outline

Module 1: Introduction to Power BI

• What is Business Intelligence?
• Introducing Power BI
• Power BI Tools and Services
• Power BI Report Server
• Power BI (Online)
• Power BI Desktop
• Case Studies
• Support and Information
• Data Stories

Lab: Getting Ready

• Sign in to Office 365
• Download Course Files
• Place Data Sources into OneDrive
• Create Further User Accounts

Module 2: Requirements Gathering

• Welcome to House Rules Board Games
• Beginning a BI Project
• Grain Statements
• Data Discovery
• Refining Information
• Modeling Data
• Building Reports
• Roles
• Publishing
• Creating Dashboards
• Choosing Workspaces
• Create and Share a Report in Power BI

Lab: Build a Report in Power BI Web

• Connect to an Excel Spreadsheet
• Build Visualisations
• Create a Dashboard for Desktop and Mobile Users
• Share Your Report and Dashboard

Module 3: Extract, Transform, and Load Data

• Creating a Project with Power BI Desktop
• Pinning an Active Project
• What is in a PBIX File?
• Connecting to Data Sources
• Managing Data Connections
• Refine Data with Power Query
• Applied Steps
• M Code Language
• Designing Your Query
• Choose Columns
• Rename Columns
• Moving Columns
• Formatting Columns
• Replacing Values
• Expanding Related Columns
• Star Schemas
• Merge Columns
• Split Columns
• Custom and Conditional Columns

Lab: Starting a Project in Power BI Desktop

• Creating a New PBIX Project File
• Connecting to Data Sources
• Use the Query Editor to Refine Data
• Review the Table Relationships
• Optional – Connect to an Azure SQL Database

Module 4: Creating a Data Model

• Understanding Relationships
• Cardinality
• Cross Filter Direction
• Hiding Tables and Columns
• Formatting Columns
• Introducing DAX
• Designing Calculated Columns
• Creating Measures
• Adding Lookup Tables
• Structuring Data with Dimensional Hierarchies
• Roles and Row Level Security

Lab: Designing a Data Model

• Hide and Format Table Columns
• Create Calculated Columns
• Create Measures
• Using Geographical Data and Lookup Tables
• Create a Dimensional Hierarchy

Module 5: Designing Reports

• Adding Pages and Navigation Buttons
• Using Shapes, Text, and Images
• Creating a Theme
• Adding Visualisations
• Using Filters and Slicers
• Controlling Filters
• Adding Drill Throughs
• Adding Custom Visualisations
• Configure Phone Layouts
• Report Tips

Lab: Creating a Report

• Creating New Pages and Adding Basic Content
• Adding and Configuring Visualisations
• Design Slicers
• Create Bookmarks and Navigational Buttons

Module 6: Using Workspaces and Dashboards

• Power BI Licensing
• My Workspaces
• App Workspaces
• Premium Capacity Workspaces
• Creating a New Workspace
• Publishing a Project
• Parallels with Microsoft Excel
• Publishers and Viewers
• Reconnecting with Data Sources
• Introducing the On-Premises Data Gateway
• Scheduling the Data Refresh Frequency
• Assigning Security Roles
• Creating and Populating Dashboards
• Customising Dashboard Tiles
• Creating Tiles Using Q&A and Quick Insights
• Creating a Mobile Dashboard
• Sharing Reports and Dashboards
• Publishing Apps in a Workspace
• Publishing Content to Websites

Lab: Publish and Share Reports and Dashboards

• Publish Your Project to Power BI
• Create a Dashboard
• Use Quick Insights and Pin Visuals
• Use Q&A to Query Your Data Source
• Share Your Dashboard with Marketing