Introduction: Business Intelligence and Power BI

• What is Business Intelligence
• What is the function of the different parts of the Power BI package?

Collect & Transform

• Import data into Power Pivot
• Transform data through Power Query
• Merge tables using Power Query

Setting up a data model in Power Pivot

• Creating relationships between tables
• Expanding tables (calculated columns)
• Hide columns and tables
• Custom sorting

Setting up measurements

• Normal aggregating functions (SUM, COUNT, COUNTROWS, ETC.)
• Using Aggregating Expressions (SUMX, AVERAGEX, MAXX...)
• CALCULATE and various filter functions
• Date calculation (SAMEPERIODLASTYEAR ...)

How to Create Dashboards in Excel

• PivotTables
• Building dashboards using Slicers