Comprehensive Power BI Video Course
Budget: $30 – $250 CAD
I am looking for an engaging Power BI course that covers Data Modeling, Data Visualization, and DAX Formulas. It should cater to all levels of expertise, from beginner to advanced.
Key Points:
- The course should be recorded, not one to one, providing flexibility for learners
- Supplementary materials are a must, including downloadable resources and quizzes/exercises to reinforce learning.
Ideal Freelancer:
- Experienced in Power BI, with a deep understanding of Data Modeling, Data Visualization, and DAX Formulas
- Prior experience creating engaging and comprehensive video courses
- Ability to cater to learners at all levels of expertise
course content
Download Resources
Downloading & Installing Power BI Desktop
Introduction to Power BI Desktop Interface
Connecting to Data
Remove Rows from Table
Adjusting or Changing Data Types of Columns
Adding Index Column and understanding alternate rows removal
How to Keep Rows
Choose Columns
Renaming Columns
Column Sorting
Column Profiling and Distribution
How to enable column profiling and distribution for entire rows in table
Concept of Appending Tables
Appending Queries
Adjusting Column Data Types in our Project
Splitting a Column
Arithmetic on Column
Adding a Conditional Column
Merging Queries - Price Column
Understanding & Exploring different mergers available in Power BI
Adding a Custom Column
Adding Column by Example
Duplicating a Column
Column Formatting
Extracting from a Column
Scientific Calculations on a Column
Trigonometric Calculations on a Column
Rounding Numbers in a Column
Information on Columns
Date & Time Column Transformations
Group By Transformation
Transpose of a Table
Reversing Rows of a Table
Count Rows
Fill Rows
Pivot columns
Unpivot Columns
Data Cleaning & Transformation
Data Cleaning and Transformation in Power query Editor
Introduction to DAX
Understanding Time Intelligence Part 1
Understanding Time Intelligence Part 2
Date Table by Calendar ( ) Function
Date Table by CalendarAuto ( ) Function
Understanding and Creating Date Hierarchies in Date Table
Extracting Year with Year ( ) Function
Extracting Month with Month ( ) Function
Extracting Week number with Weeknum ( ) Function
Extracting Quarter number with Quarter Function
Implementing Date Hierarchies Manually
Creating a Separate Table for Measures
DAX Function SUM ( )
DAX Functions MAX ( ) & MIN ( )
DAX Function COUNTROWS ( ) & AVERAGE ( )
DAX Function CALCULATE ( )
DAX Function TOTALYTD ( )
DAX Function DATEADD ( )
DAX , Arithmetic among measures
DAX Function IF ( ) Part 1
DAX Function IF ( ) Part 2
DAX Function SWITCH ( )
DAX VARIABLES
DAX Functions FIRSTNONBLANK ( ) and LASTNONBLANK ( )
Adjusting Stock Table Dates Hierarchy
DAX Function SAMEPERIODLASTYEAR ( )
Data Model View - Properties pane and Display Folders
Data Model View - Properties pane Continue
What is Data Modeling?
Why Data Modeling?
Types of Data Model
What is Cardinality? one-to-many Relation
Cardinality - one-to one Relation
Cardinality - many-to-many
Hiding Tables using Model View
Data modeling for our Project - Part 1
Data modeling for our Project - Part 2
Data Modelling and DAX
Giving Stylish Heading to Dashboard - Shapes & Text
Deploying Card Visual and its formatting
Card Visual with Currency Sign
Deploying 2nd Card Visual
Quick Deployment of Card Visual with formatting copied - adding one more measure
Deploying Line Chart
Formatting the Visuals e.g. Line Chart - Part 1
Formatting the Visuals e.g. Line Chart - Part 2
Formatting the Visuals e.g. Line Chart - Part 3
Deploying Column Clustered Chart with Hierarchical X-Axis
Understanding Filter Context and Relationships in Data Model View
Deploying Donut Chart
Star Schema Data Model Flexibility and Dataset Adjustment
Adding Constant Lines in Line Chart
Enabling Map Visuals from Settings
Deploying Filled Map Visual
Map Visual
Deploying Area Chart Visual
Deploying Area Chart Visual for YTD Values
Visualising Top 10 Products by Sales
Deploying Waterfall Chart Visual
Visualising further Sales KPIs using Cards
Adding Realistic Target in our Dataset
Deploying KPI Card Visual and a Slicer
Slicer Interaction Explained
Interaction among visuals Explained
Controlling or Editing Interactions among Visuals
Deploying Table Visual
Deploying Matrix Visual
Conditional Formatting of a Column of Table
Conditional Formatting of Column Chart Visual
Deploying AI Visual - Q&A
Understanding AI Visual - Key Influencers
Deploying AI Visual - Key Influencers
Book Marks
Adding Real Targets in Line Graph Visual
Introducing the Advance Tool Tip
Implementing the Advance Tool Tip
Use of Parameters
Navigation Buttons
What is Grouping?
What is Binning?
Themes for the Report
Mobile Layout of the Report
Implementing Pro-Custom Filter Pane Part 2
Pro Tip - Copying entire Custom filter pane Part - 1
Pro Tip - Copying entire Custom filter pane Part - 2
Formatting Slicer as per theme
Page Formatting
Editing interaction of slicers with visuals in our Project
Implementing Special Button - Clear All Filters
Assignment 2: Data Modelling, DAX and Visualisation
Data Visualisation , Reports and Dashboards
Introduction to Power BI Service
Power BI Service License Types
Signing into Power BI Service and Workspaces
Creating a Worksapce
Publishing Report in Power BI Service Workspace
Sharing Reports with others in Power BI Service
Workspaces, Apps and User Roles
128. Managing Access to Workspace and Assign roles
Dashboard in Power BI Service
Creating and Sharing Power BI App
Updating App Contents
Managing Access to App
Alerts, Subscription and downloading of Reports
What is On-Premises Data Gateway ?
Removing Existing Data Gateway
Deploying Data Gateway and Scheduling Auto Refresh
Row Level Security (RLS) Configuration in Power BI Service
Dynamic Row Level Security (RLS)
Understanding Incremental Refresh
Implementing Incremental Refresh
Getting Quick Insights on Dataset from Power BI Service
Endorsement of Semantic Models etc
Performance Analyzer
Tips to Enhance Report Performance
Power BI Service : Publishing and Managing Assets
Key Points:
- The course should be recorded, not one to one, providing flexibility for learners
- Supplementary materials are a must, including downloadable resources and quizzes/exercises to reinforce learning.
Ideal Freelancer:
- Experienced in Power BI, with a deep understanding of Data Modeling, Data Visualization, and DAX Formulas
- Prior experience creating engaging and comprehensive video courses
- Ability to cater to learners at all levels of expertise
course content
Download Resources
Downloading & Installing Power BI Desktop
Introduction to Power BI Desktop Interface
Connecting to Data
Remove Rows from Table
Adjusting or Changing Data Types of Columns
Adding Index Column and understanding alternate rows removal
How to Keep Rows
Choose Columns
Renaming Columns
Column Sorting
Column Profiling and Distribution
How to enable column profiling and distribution for entire rows in table
Concept of Appending Tables
Appending Queries
Adjusting Column Data Types in our Project
Splitting a Column
Arithmetic on Column
Adding a Conditional Column
Merging Queries - Price Column
Understanding & Exploring different mergers available in Power BI
Adding a Custom Column
Adding Column by Example
Duplicating a Column
Column Formatting
Extracting from a Column
Scientific Calculations on a Column
Trigonometric Calculations on a Column
Rounding Numbers in a Column
Information on Columns
Date & Time Column Transformations
Group By Transformation
Transpose of a Table
Reversing Rows of a Table
Count Rows
Fill Rows
Pivot columns
Unpivot Columns
Data Cleaning & Transformation
Data Cleaning and Transformation in Power query Editor
Introduction to DAX
Understanding Time Intelligence Part 1
Understanding Time Intelligence Part 2
Date Table by Calendar ( ) Function
Date Table by CalendarAuto ( ) Function
Understanding and Creating Date Hierarchies in Date Table
Extracting Year with Year ( ) Function
Extracting Month with Month ( ) Function
Extracting Week number with Weeknum ( ) Function
Extracting Quarter number with Quarter Function
Implementing Date Hierarchies Manually
Creating a Separate Table for Measures
DAX Function SUM ( )
DAX Functions MAX ( ) & MIN ( )
DAX Function COUNTROWS ( ) & AVERAGE ( )
DAX Function CALCULATE ( )
DAX Function TOTALYTD ( )
DAX Function DATEADD ( )
DAX , Arithmetic among measures
DAX Function IF ( ) Part 1
DAX Function IF ( ) Part 2
DAX Function SWITCH ( )
DAX VARIABLES
DAX Functions FIRSTNONBLANK ( ) and LASTNONBLANK ( )
Adjusting Stock Table Dates Hierarchy
DAX Function SAMEPERIODLASTYEAR ( )
Data Model View - Properties pane and Display Folders
Data Model View - Properties pane Continue
What is Data Modeling?
Why Data Modeling?
Types of Data Model
What is Cardinality? one-to-many Relation
Cardinality - one-to one Relation
Cardinality - many-to-many
Hiding Tables using Model View
Data modeling for our Project - Part 1
Data modeling for our Project - Part 2
Data Modelling and DAX
Giving Stylish Heading to Dashboard - Shapes & Text
Deploying Card Visual and its formatting
Card Visual with Currency Sign
Deploying 2nd Card Visual
Quick Deployment of Card Visual with formatting copied - adding one more measure
Deploying Line Chart
Formatting the Visuals e.g. Line Chart - Part 1
Formatting the Visuals e.g. Line Chart - Part 2
Formatting the Visuals e.g. Line Chart - Part 3
Deploying Column Clustered Chart with Hierarchical X-Axis
Understanding Filter Context and Relationships in Data Model View
Deploying Donut Chart
Star Schema Data Model Flexibility and Dataset Adjustment
Adding Constant Lines in Line Chart
Enabling Map Visuals from Settings
Deploying Filled Map Visual
Map Visual
Deploying Area Chart Visual
Deploying Area Chart Visual for YTD Values
Visualising Top 10 Products by Sales
Deploying Waterfall Chart Visual
Visualising further Sales KPIs using Cards
Adding Realistic Target in our Dataset
Deploying KPI Card Visual and a Slicer
Slicer Interaction Explained
Interaction among visuals Explained
Controlling or Editing Interactions among Visuals
Deploying Table Visual
Deploying Matrix Visual
Conditional Formatting of a Column of Table
Conditional Formatting of Column Chart Visual
Deploying AI Visual - Q&A
Understanding AI Visual - Key Influencers
Deploying AI Visual - Key Influencers
Book Marks
Adding Real Targets in Line Graph Visual
Introducing the Advance Tool Tip
Implementing the Advance Tool Tip
Use of Parameters
Navigation Buttons
What is Grouping?
What is Binning?
Themes for the Report
Mobile Layout of the Report
Implementing Pro-Custom Filter Pane Part 2
Pro Tip - Copying entire Custom filter pane Part - 1
Pro Tip - Copying entire Custom filter pane Part - 2
Formatting Slicer as per theme
Page Formatting
Editing interaction of slicers with visuals in our Project
Implementing Special Button - Clear All Filters
Assignment 2: Data Modelling, DAX and Visualisation
Data Visualisation , Reports and Dashboards
Introduction to Power BI Service
Power BI Service License Types
Signing into Power BI Service and Workspaces
Creating a Worksapce
Publishing Report in Power BI Service Workspace
Sharing Reports with others in Power BI Service
Workspaces, Apps and User Roles
128. Managing Access to Workspace and Assign roles
Dashboard in Power BI Service
Creating and Sharing Power BI App
Updating App Contents
Managing Access to App
Alerts, Subscription and downloading of Reports
What is On-Premises Data Gateway ?
Removing Existing Data Gateway
Deploying Data Gateway and Scheduling Auto Refresh
Row Level Security (RLS) Configuration in Power BI Service
Dynamic Row Level Security (RLS)
Understanding Incremental Refresh
Implementing Incremental Refresh
Getting Quick Insights on Dataset from Power BI Service
Endorsement of Semantic Models etc
Performance Analyzer
Tips to Enhance Report Performance
Power BI Service : Publishing and Managing Assets