Microsoft Power BI – Masterclass & Milestone and BEYOND

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Become an Expert with DAX

Lecture 1: Introduction

Lecture 2: What is DAX ?

Lecture 3: What is the logic behind DAX ?

Lecture 4: Understand the syntax

Lecture 5: DAX pre-start functions

Chapter 3: DAX Functions – DATES

Lecture 1: WEEKDAY()

Lecture 2: TODAY()

Lecture 3: LASTDATE()

Lecture 4: DATEVALUE()

Lecture 5: DATEDIFF()

Lecture 6: DATE()

Chapter 4: DAX Functions – Filters

Lecture 1: SUMMARIZE()

Lecture 2: REMOVEFILTERS()

Lecture 3: KEEPFILTERS()

Lecture 4: ISFILTERED()

Lecture 5: FILTER()

Lecture 6: CALCULATE()

Lecture 7: CALCULATETABLE()

Lecture 8: ALLSELECTED()

Lecture 9: ALLEXCEPT()

Chapter 5: DAX Functions – Conditions

Lecture 1: AND()

Lecture 2: OR()

Lecture 3: LOOKUPVALUE()

Lecture 4: IFERROR()

Lecture 5: IF()

Lecture 6: FIRSTDATE()

Lecture 7: CALENDAR() & CALENDARAUTO()

Chapter 6: DAX Functions – Math & Stats

Lecture 1: AVERAGE()

Lecture 2: AVERAGEX()

Lecture 3: DIVIDE()

Lecture 4: SUM()

Lecture 5: SUMX()

Lecture 6: ROUND() – ROUNDUP() – ROUNDDOWN()

Lecture 7: MROUND()

Lecture 8: POWER()

Lecture 9: MIN() – MEDIAN() – MAX()

Lecture 10: INT()

Lecture 11: DISTINCT()

Lecture 12: COUNTX()

Lecture 13: COUNTROWS()

Lecture 14: COUNTBLANK()

Lecture 15: COUNTA()

Lecture 16: COUNTAX()

Chapter 7: DAX Functions – Text

Lecture 1: RIGHT()

Lecture 2: LEFT()

Lecture 3: FIND()

Lecture 4: REPLACE()

Lecture 5: RELATED()

Lecture 6: EXACT()

Lecture 7: CONCATENATE()

Lecture 8: CONCATENATEX()

Chapter 8: Visualisation for Professional

Lecture 1: Introduction

Lecture 2: Hierarchy in visuals

Lecture 3: Grouping

Lecture 4: Sort by column

Lecture 5: See data & see records

Lecture 6: Spotlight & Focus mode

Chapter 9: Tooltips

Lecture 1: Tooltips – Introduction

Lecture 2: Tooltips – Overview

Lecture 3: Tooltips – Creation

Lecture 4: Tooltips – Configuration

Lecture 5: Tooltips – Setting a report

Lecture 6: Tooltips – Reverting to default

Lecture 7: Tooltips – Custom report & line chart

Chapter 10: Analytics Pane

Lecture 1: Introduction

Lecture 2: Overview

Lecture 3: Searching

Lecture 4: Average line

Lecture 5: Constant line

Lecture 6: Min line

Lecture 7: Max line

Lecture 8: Median line

Lecture 9: Percentile line

Lecture 10: Forecasting & Trend line

Chapter 11: Insights

Lecture 1: Introduction

Lecture 2: Overview

Lecture 3: Creation

Lecture 4: Visual Scatter Plot

Lecture 5: 100 stacked column chart

Lecture 6: Waterfall chart

Lecture 7: Discovering variation distribution

Chapter 12: Bookmarks

Lecture 1: Introduction

Lecture 2: Overview

Lecture 3: How to use it ?

Lecture 4: Arranging Bookmarks

Lecture 5: Bookmarks as a slide show

Lecture 6: Visibility of visuals on the report