Course length: 4-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 4-days bootcamp style, saving both time and money.
Prerequisites
- Basic knowledge of Microsoft Windows operating system
- Good knowledge of Excel spreadsheet, functions, and charts
- Working knowledge of relational databases
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.