Power BI Desktop Level 1 Course Outline

Special Note to New Hampshire Residents
This course has not yet been approved by the New Hampshire Department of Education. Please contact us for an update on when the class will be available in New Hampshire.

Overview
Get Power BI Desktop
Getting started with Power BI Desktop

Connect to Data
Data Sources in Power BI Desktop
Connect to web data
Import Excel Workbooks
Analysis Services Tabular Data

Shape and Combine Data
Query overview
Shape and combine data
Data categorization
Relationship view
Create and manage relationships in Power BI Desktop
Common query tasks

Data Fundamentals
Data Type in Power BI Desktop
Measures in Power BI Desktop
Tutorial: Create your own measures
Calculated columns
Tutorial: Create calculated columns
DAX Basics
Calculated tables

Working with Reports
Report View
Sort by column
Tips and tricks for creating reports
Import and display KPIs (Preview)

Creating Solutions
Tutorial: Importing and analyzing data from a web page
Tutorial: Analyzing sales data from Excel and an OData feed
Tutorial: Facebook analytics

Sharing your Work
Publish from Power BI Desktop
Dashboards in Power BI
Share a dashboard from Power BI

View outline in Word

BBD110

Attend hands-on, instructor-led Power BI Desktop Level 1 training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Excel Analytics Courses and select the one that's right for you.