Course length: 7-days

Course Overview

Six days of leaning taken from PL 300 Microsoft Power BI Data Analyst, DAX for Business Intelligence, and Power Query for Power BI, delivered 5-days bootcamp style, saving both time and money.

Prerequisites

  • Excel Level 2
  • Power BI

Outline

  • Ingest, clean, and transform data.
  • Model data for performance and scalability.
  • Design and create reports for data analysis.
  • Understand core data concepts.
  • Knowledge of working with relational data in the cloud.
  • Knowledge of working with non-relational data in the cloud.
  • Knowledge of data analysis and visualization concepts.
  • Understand how DAX queries work.
  • Use DAX variables and formatting.
  • Build data models.
  • Work with DAX in Power BI, PowerPivot and SQL Server.
  • Understand DAX functions and syntax.
  • Work with DAX patterns.
  • Optimize data models and DAX queries.
  • Connect to a range of external data, from databases to Azure sources.
  • Cleanse and prepare external data so it can be used inside Power BI.
  • Refresh data quickly and easily to always have the latest information.
  • Transform data into ready-to-use structures that fit the report format.
  • Execute M language functions for complex data transformations.

You May be interested in:

  • Introduction to Data Modeling
  • DP 080 Querying Data with Transact SQL
  • SQL & Data Analysis