Business Intelligence with Power BI

Introduction

This course description is in English only.

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