Power BI

Who should attend

This course is for those looking to learn Power BI including: Report Builders, Power BI Tools, Data Model Designers, and DAX Functions.

Team Pass by Learnit

Power BI

From $0
Two, 2-hour Modules (9am - 11:30am PT)

Learnit’s Power BI course is designed to train professionals on the features of Microsoft's powerful cloud-based business intelligence platform.

Course ID
L0049
Available times
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am

Course Outline

Module 1: Introducing Power BI 

This module introduces Power BI desktop, and explores the features that enable the rapid creation and publication of sophisticated data visualizations. 

Learning Outcomes: 

  • Import well-formed data into Power BI Desktop 
  • Build reports with stunning visual 
  • Publish a report to the Power BI service on Office 365 

Lessons 

  • Power BI Desktop introduction 
  • The Power BI web service introduction 
  • Building a report using Power BI Desktop and Excel data 
  • Publishing and sharing a Power BI report

Module 2: Shaping and Combining Data 

With Power BI desktop you can shape and combine data with powerful, built-in tools. This module introduces the tools that are available for preparing your data, and transforming it into a form ready for reporting. 

Learning Outcomes: 

  • Create and edit query steps in Power Query 
  • Learn basic data transformation tools 
  • Combine data from different data sources and tables 

Lessons 

  • Power BI desktop queries using Power Query 
  • Shaping data 
  • Transforming data 
  • Combining data 
  • Produce reports using your data transformations 

Module 3: Modeling data 

This module describes how to further shape and enhance data to fit your reporting needs 

Learning Outcomes: 

  • Understand the need for table relationships 
  • Discover and build DAX functions that enhance your dataset 
  • Learn to build calculated columns, tables and measures 

Lessons 

  • Table Relationships - why and how 
  • DAX (Data Analysis Expressions) function overview 
  • Build custom calculated columns using examples and from scratch 
  • Build custom data measures 
  • Using custom columns and measures in a report 

Module 4: Power BI web service and mobile app 

This module further describes the Power BI web service mobile app. We will also learn about the integration of Power BI and other web services 

Learning Outcomes: 

  • Learn about Power BI Dashboards 
  • Discover the Power BI mobile app 
  • Understand how to embed Power BI reports into other tools for easy access 

Lessons 

  • Power BI web service capabilities for creating and publishing reports 
  • Build a Power BI web service Dashboard 
  • Sharing a Power BI Dashboard 
  • Install the Power BI mobile app 
  • Using the Power BI mobile app 
  • Power BI reports embedded in web pages, MS SharePoint, MS Teams 

Skills covered

No items found.