Course content
- Introduction to Power BI and the Power Cloud ecosystem.
- Connecting to data sources such as databases and Excel sheets.
- Data querying with DAX:
- Variables.
- Functions.
- Conditionals and control flow.
- Data filtering using, e.g., FILTER, ALL, and ALLEXCEPT.
- Relationship to Excel programming.
- Data preprocessing with Power Query and M.
- Combine data.
- Transform data.
- Handle errors and NULLs in data.
- Write custom preprocessing functions with M.
- Model data: Create relationships, design tables, and calculate columns
- Visualization with Power View
- Interactivity and dashboards
- Report design
- Connecting Power BI to other tools, such as Excel