Course length: 5-days
Course Overview
Seven 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 1
- Excel Level 2
- Introduction to Power BI
- Working knowledge of relational databases.
Outline
- Understand Core Data Concepts
- Ingest, clean, and transform data.
- Gain Knowledge of working with relational and non-relational data in the cloud.
- Model data for performance and scalability.
- Connect to a range of external data sources.
- Understand how DAX Queries Work
- Understand DAX functions and syntax.
- Use DAX variables and formatting.
- Optimize data models and DAX queries.
- Work with DAX Patterns.
- Execute M language functions for complex data transformations.
- Design and Create Reports for Data Analysis
- Transform Data into ready-to-use structures that fit the report format.
- Refresh data quickly and easily to always have the latest information.
You May be interested in: