Curriculum

  • 1

    PART 1: Introduction to Power BI

    • Part 1: Exersize Files

    • Think with the result in mind

    • What you need to know about the interface

    • Simple way to master Power BI - part 1

    • Simple way to master Power BI - part 2

    • Explore your dataset

    • Exploring the Query Editor

    • Time intelligence & datetables

    • Data cleaning with Power Query

    • Advance transformations in Query Editor

    • Additional advanced transformations in Query Editor

    • Relationship view in Power BI

    • Basic DAX calculations

    • Measure table

    • Additional DAX calculations

    • Context & Dimensions in Power BI

    • Drill-down with date dimension

    • DAX calculations with time intelligence

    • Visualize your data

    • Custom visualizations

    • Explore your data

    • DAX calculations with time intelligence #2

    • DAX calculations with time intelligence #3

    • DAX vs No DAX

    • Running totals

    • Sales by countries

    • Introduction to scenario analysis

    • Sales calculation

    • Most profitable clients

    • Customer classification

    • Sales contribution on workdays & weekends

    • Visualizing your data #2

    • Custom KPI's

    • How to deal with blanks in slicers

    • How to publish reports

    • How to create date tables in DAX

    • What is the difference between SUMX & SUM

    • Best & worst customers / products

    • How to create a BUMP chart
  • 2

    PART 2: Master DAX

    • PART 2: Excersize Files

    • Data preparation

    • DAX - Basic calculations

    • DAX - Timeintelligence & Cummulative sales

    • DAX - Past sales

    • DAX - Compare timeframes

    • DAX - Sales example

    • DAX - Moving averages

    • DAX - Compare selected countries

    • DAX - Identifying best selling days

    • DAX - Dependents on top salespeople

    • DAX - Customers we lose

    • DAX vs No-DAX

    • Different views on your data

    • Show further details on specific data

    • Leverage multiple data inputs

    • DAX - Apples to apples comparison in time periods

    • Final report - part 1

    • Final report - part 2
  • 3

    PART 3: Deep Dive Analysis

    • PART 3: Excersize Files

    • Publishing reports to PBI Service

    • Building a Dashboard in PBI Service

    • Data gateways

    • Import data and establishing a data model

    • Map Visualizations

    • Security settings in PBI Desktop

    • User security roles in PBI Service

    • The 80/20 Rule

    • Activating inactive relationships

    • Recognize customers with a strong gain growth

    • Cumulative sale & Budget

    • Break even budget

    • Sales Forecasting

    • Table conditional formating

    • Showing images in tables
  • 4

    PART 4: Excel, DAX and more...

    • PART 4: Excersize Files

    • Table functions - part 1

    • Table functions - part 2

    • Powerful DAX functions - part 1

    • Relationships in Power BI

    • Many to Many relationships

    • Columns and Classifications

    • Customer classifications

    • Dynamic measures - part 1

    • Dynamic measures - part 2

    • Time Intelligence & Visualization

    • Excel and Power BI Desktop

    • Excel and Power BI Service - part 1

    • Excel and Power B Service - part 2

    • Excel and Power BI Service - part 3

    • Advanced searching with DAX

    • Custom data visualization - part 1

    • Custom data visualization - part 2

    • Animated data visualization

    • Report creation workflow

    • Dynamic reporting
  • 5

    PART 5: DAX Analytics

    • PART 5: Excersize Files

    • Tooltips in Power BI - part 1

    • Tooltips in Power BI - part 2

    • Ask questions in Power BI

    • Synchronize slicers across reports

    • Time intelligence and running totals

    • DAX all and allselected

    • Iterators in Power BI

    • Combine rankings of different measures

    • Best, average and worst sales

    • Dynamic selection

    • Pareto chart in Power BI

    • Time intelligence differences

    • Cluster analysis in Power BI

    • Custom data visualization - part 1

    • Custom data visualization - part 2

    • Custom data visualization - part 3

    • Custom map visualization - part 4
  • 6

    PART 6: R scripts, DAX and more...

    • PART 6: Excersize Files

    • Data modelling

    • DAX challenge - Handling price adjustments

    • DAX challenge - Calculate age of persons

    • DAX challenge - open customer complains

    • Additional time intelligence in Power BI

    • Always show most recent data

    • DAX challenge - First product ordered by each customer

    • Custom data visualization using R Scripts - part 1

    • Data import and transformation using R scripts

    • Custom data visualization using R scripts - part 2

    • DAX challenge - Last product ordered by each customer

    • DAX challenge - Recurring Customers and sales calculation

    • Report building

    • Publishing reports to Power BI Service

    • Dashboard building in Power BI Service

    • Data gateways
  • 7

    PART 7: Python, DAX and more...

    • PART 7: Excersize Files

    • Data import & modeling

    • Setting up Python in Power BI

    • Python data visualization - part 1

    • Python data visualization - part 2

    • Python in query editor

    • Data import with Python

    • Balance sheet excel introduction

    • Power BI Grouping Items

    • Balance sheet in Power BI

    • DAX table functions

    • DAX challenge - calculate new customers

    • DAX challenge - new customer performance

    • DAX challenge - customers lost

    • Customer data visualization

    • Final Report