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