Uploaded February 2023 | Updated November 2026, 3 hours ago
Do you want to use SQL with Power BI to take your data analysis to next level? Join me on this free & live masterclass to learn how to set up SQL queries as data source, how to parameterize them in your Power BI report.
We will be using the FREE Awesome Chocolates Dataset for this live stream. Download the dataset .SQL file from below link.
chandoo.org/wp/learn-sql-for-data-analysis
β± In this video:
=============
0:00 - Introduction and hellos
5:04 - Agenda slides
8:37 - Where to download the sample data (SQL files)
16:10 - Introduction to SQL
30:15 - How to get SQL data into Power BI?
44:37 - Creating a simple Power BI report
1:04:00 - How to parameterize the query?
1:22:56 - How to show the parameter values on the Power BI report? (product codes etc.)
1:30:30 - How to parametrize dates?
1:39:47 - How to show "last updated date" on the Power BI report?
1:44:30 - Other questions & Closing remarks
π‘π» LEARN MORE:
================
SQL - Full course - youtu.be/l8DCPaHc5TQ
Power Pivot - youtu.be/PQ5lALdFHCU
Power Query - youtu.be/PiFAa_jjaEI
Power BI - youtu.be/uwe8C7K8fXY
+ Full course - chandoo.org/wp/power-bi-course
#SQL #PowerBI #realtimeproject
Do you want to use SQL with Power BI to take your data analysis to next level? Join me on this free & live masterclass to learn how to set up SQL queries as data source, how to parameterize them in your Power BI report.
We will be using the FREE Awesome Chocolates Dataset for this live stream. Download the dataset .SQL file from below link.
chandoo.org/wp/learn-sql-for-data-analysis
β± In this video:
=============
0:00 - Introduction and hellos
5:04 - Agenda slides
8:37 - Where to download the sample data (SQL files)
16:10 - Introduction to SQL
30:15 - How to get SQL data into Power BI?
44:37 - Creating a simple Power BI report
1:04:00 - How to parameterize the query?
1:22:56 - How to show the parameter values on the Power BI report? (product codes etc.)
1:30:30 - How to parametrize dates?
1:39:47 - How to show "last updated date" on the Power BI report?
1:44:30 - Other questions & Closing remarks
π‘π» LEARN MORE:
================
SQL - Full course - youtu.be/l8DCPaHc5TQ
Power Pivot - youtu.be/PQ5lALdFHCU
Power Query - youtu.be/PiFAa_jjaEI
Power BI - youtu.be/uwe8C7K8fXY
+ Full course - chandoo.org/wp/power-bi-course
#SQL #PowerBI #realtimeproject

![End to End Power Query Data Cleaning Masterclass [FREE Workbook]
In this beginner to PRO session, learn Power Query to automate data cleaning, transformation tasks. We will be using a real-life dataset to perform data cleaning with Power Query (for Power BI).
Sample workbook: https://chandoo.org/wp/wp-content/uploads/2026/04/pq-data-cleanup.xlsx
What do I learn?
βοΈ Introduction to Power Query in Power BI
βοΈ How to understand Power Query UI
βοΈ Data cleaning basics (removing columns, renaming)
βοΈText transformation examples
βοΈ Working with Date columns
βοΈ Conditional (IF THEN ELSE) columns in Power Query
βοΈ Business operations on data
βοΈ Reference queries (one data source, multiple outputs)
βοΈ Dependency view and how to use it
βοΈ Automation with Power Query - Parameters
βοΈ Fixing errors
βοΈ Basic analysis of data in Power BI after Load
βοΈ Refresh process
β
Who is this for?
πΆ Power Query beginners
π©βπ»People who work with lots of data (in Excel or Power BI)
βοΈ Looking to automate / simplify data management / cleaning processes
π«NOT for people who already know & use Power Query a lot
π Video Chapters
0:00 - Introduction
5:30 - Brief Intro Power Query and how it fits in
11:40 - Sample Data & how to load it into PQ in Power BI
19:00 - Power Query UI Explained
24:00 - Data Cleaning basics with Power Query - Removing columns
28:00 - Date cleanup
32:30 - Text transformations in Power Query
37:30 - Arithmetic operations
41:00 - How to think about Power Query
44:30 - Salary bucket (conditional columns)
52:00 - Reference queries, multiple outputs from one source
56:30 - Using dependency view to understand various queries in your data
58:30 - Introduction to parameters and automation with PQ
1:02:00 - Closing & loading the data, testing everything in Power BI
1:05:30 - Adding new data, changing file names (parameter testing)
1:07:40 - Fixing refresh errors
1:11:00 - Using other sources (demo with SQL Server)
1:13:30 - Q&A
1:26:30 - Doing the same in Excel (demo with Blank Query, Copy pasting M Code)
#POWERQUERY #POWERBI End to End Power Query Data Cleaning Masterclass [FREE Workbook]](https://i.ytimg.com/vi/UhD3LbbimZ0/mqdefault.jpg)


![Excel SCAN Function is Shockingly Powerful! [Step-by-Step]
Every heard of SCAN function in Excel? Today, let me show you why you need this function and how it changes the way you solve your data problems. I think SCAN is Magic β¨
You are going learn:
What is SCAN function in Excel
SCAN syntax and application
How to use SCAN to calculate running total quickly
Using SCAN to get Maximum values
SCAN with LAMBDA
Advanced SCAN usage when your data is dynamic
~WHAT IS SCAN FUNCTION~
Scan function in Excel lets us run an operation on a range and returns all the intermediate results.
For example, you can use SCAN function to calculate running total of a range.
~WHAT IS THE SYNTAX OF SCAN~
SCAN(initial_value, range or array, operation)
For example:
=SCAN(0, A1:A10, SUM)
is going to return the running to of the range A1:A10
You can also use LAMBDA functions with SCAN to create more complex calculations.
=SCAN(0, A1:A10, LAMBDA(a, b, SUM(a,b)))
will return the same values as the first SCAN example above.
β± Video timestamps:
0:00 - What is SCAN function & Why it is important?
1:46 - Understanding how SCAN works
3:46 - Using SCAN to calculate running MAX
4:57 - Using LAMBDA functions with SCAN
6:38 - How I use SCAN to solve tricky problems
πΊ Watch next
How to use LAMBDA function in Excel - https://youtu.be/YrMCkE59ef4
How to use FILTER function in Excel - https://youtu.be/JuTdj2j-9Kg
Top 10 Essential Excel functions - https://youtu.be/HgNCvd8IbSc
π Sample Workbook:
If you need a file with SCAN examples, download the scandoo.xlsx here:
https://chandoo.org/wp/wp-content/uploads/2024/03/scandoo.xlsx
~
What is the favourite Excel function of a German Shepard πΆ?
LAMBda... π
#Excel #functions Excel SCAN Function is Shockingly Powerful! [Step-by-Step]](https://i.ytimg.com/vi/VrQSgI596IQ/mqdefault.jpg)





