Microsoft Power BI – beginners to advance Level Exam PL-300

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction – What to expect from the course

Lecture 2: Know Your Trainer

Lecture 3: Download Resources

Lecture 4: Downloading & Installing Power BI Desktop

Lecture 5: Introduction to Power BI Desktop Interface

Chapter 2: Data Cleaning and Transformation with Power BI Desktop

Lecture 1: Connecting to Data

Lecture 2: Remove Rows from Table

Lecture 3: Adjusting or Changing Data Types of Columns

Lecture 4: Adding Index Column and understanding alternate rows removal

Lecture 5: How to Keep Rows

Lecture 6: Choose Columns

Lecture 7: Renaming Columns

Lecture 8: Column Sorting

Lecture 9: Column Profiling and Distribution

Lecture 10: How to enable column profiling and distribution for entire rows in table

Lecture 11: Concept of Appending Tables

Lecture 12: Appending Queries

Lecture 13: Adjusting Column Data Types in our Project

Lecture 14: Splitting a Column

Lecture 15: Arithmetic on Column

Lecture 16: Adding a Conditional Column

Lecture 17: Merging Queries – Price Column

Lecture 18: Understanding & Exploring different mergers available in Power BI

Lecture 19: Adding a Custom Column

Lecture 20: Adding Column by Example

Lecture 21: Duplicating a Column

Lecture 22: Column Formatting

Lecture 23: Extracting from a Column

Lecture 24: Scientific Calculations on a Column

Lecture 25: Trigonometric Calculations on a Column

Lecture 26: Rounding Numbers in a Column

Lecture 27: Information on Columns

Lecture 28: Date & Time Column Transformations

Lecture 29: Group By Transformation

Lecture 30: Transpose of a Table

Lecture 31: Reversing Rows of a Table

Lecture 32: Count Rows

Lecture 33: Fill Rows

Lecture 34: Pivot columns

Lecture 35: Unpivot Columns

Chapter 3: Data Modelling and Data Analytics Expression (DAX)

Lecture 1: Introduction to DAX

Lecture 2: Understanding Time Intelligence Part 1

Lecture 3: Understanding Time Intelligence Part 2

Lecture 4: Date Table by Calendar ( ) Function

Lecture 5: Date Table by CalendarAuto ( ) Function

Lecture 6: Understanding and Creating Date Hierarchies in Date Table

Lecture 7: Extracting Year with Year ( ) Function

Lecture 8: Extracting Month with Month ( ) Function

Lecture 9: Extracting Week number with Weeknum ( ) Function

Lecture 10: Extracting Quarter number with Quarter Function

Lecture 11: Implementing Date Hierarchies Manually

Lecture 12: Creating a Separate Table for Measures

Lecture 13: DAX Function SUM ( )

Lecture 14: DAX Functions MAX ( ) & MIN ( )

Lecture 15: DAX Function COUNTROWS ( ) & AVERAGE ( )

Lecture 16: DAX Function CALCULATE ( )

Lecture 17: DAX Function TOTALYTD ( )

Lecture 18: DAX Function DATEADD ( )

Lecture 19: DAX , Arithmetic among measures

Lecture 20: DAX Function IF ( ) Part 1

Lecture 21: DAX Function IF ( ) Part 2

Lecture 22: DAX Function SWITCH ( )

Lecture 23: DAX VARIABLES

Lecture 24: DAX Functions FIRSTNONBLANK ( ) and LASTNONBLANK ( )

Lecture 25: Adjusting Stock Table Dates Hierarchy

Lecture 26: DAX Function SAMEPERIODLASTYEAR ( )

Lecture 27: Data Model View – Properties pane and Display Folders

Lecture 28: Data Model View – Properties pane Continue

Lecture 29: What is Data Modeling?

Lecture 30: Why Data Modeling?

Lecture 31: Types of Data Model

Lecture 32: What is Cardinality? one-to-many Relation

Lecture 33: Cardinality – one-to one Relation

Lecture 34: Cardinality – many-to-many

Lecture 35: Hiding Tables using Model View

Lecture 36: Data modeling for our Project – Part 1

Lecture 37: Data modeling for our Project – Part 2

Chapter 4: Data Visualisation and Creating Dynamic Reports and Dashboards

Lecture 1: Giving Stylish Heading to Dashboard – Shapes & Text

Lecture 2: Deploying Card Visual and its formatting

Lecture 3: Card Visual with Currency Sign

Lecture 4: Deploying 2nd Card Visual

Lecture 5: Quick Deployment of Card Visual with formatting copied – adding one more measure

Lecture 6: Deploying Line Chart

Lecture 7: Formatting the Visuals e.g. Line Chart – Part 1

Lecture 8: Formatting the Visuals e.g. Line Chart – Part 2

Lecture 9: Formatting the Visuals e.g. Line Chart – Part 3

Lecture 10: Deploying Column Clustered Chart with Hierarchical X-Axis

Lecture 11: Understanding Filter Context and Relationships in Data Model View

Lecture 12: Deploying Donut Chart

Lecture 13: Star Schema Data Model Flexibility and Dataset Adjustment

Lecture 14: Adding Constant Lines in Line Chart

Lecture 15: Enabling Map Visuals from Settings

Lecture 16: Deploying Filled Map Visual