Power BI is probably the market leader in self-service Business Intelligence tools. This course will review the concepts involved in the use of this powerful tool: loading and transforming data (ETL processes), creation of visualizations, introduction to the DAX data modeling language, uploading reports to the Power BI Service, and creation and sharing of dashboards.

Course content:

Introduction

• Introduction to Business Intelligence
• Evolution of Power BI
• Power BI Core Components
• Power BI Desktop Overview

Query editor

• ETL process definition
• Transformations:
  • Basic transformations
  • Combining queries
  • Query merging
  • Unpivoting queries
• Introduction to the M language
• Query grouping
• Custom columns
• Columns from examples
• Conditional columns

Report editor

• Introduction to the data model
• Creating and configuring visual objects
• Using hierarchies
• Data segmentation
• Synchronizing segmentations
• Managing interactions among visualizations
• Bookmarks
• Drillthrough
• Customization of the information window
• Personalized visualizations

Power BI service

• Report publication
• Creation and presentation of dashboards
• The Quick Findings tool
• Sharing reports and dashboards
• Working areas management

DAX

• Introduction to DAX
• Modeling of simple metrics