Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Power BI Query Editor
INTRODUCTION
Power BI and Query Editor – Introduction (7:26)
Power BI Desktop- Download and Install (5:05)
Power BI desktop and Query Editor – Introduction (9:18)
IMPORT & ANALYZE EXCEL DATA INTO POWER BI
How to Import Excel Data from a File – Preview (7:06)
How to Import data from Text – Tab delimited file (3:08)
How to Import data from Access files (3:39)
How to Load data in the data model and check the file path changes (8:46)
How to Import data from the CSV delimited file (4:35)
Filtering in Power Query Editor (9:08)
BUILT IN QUERY RIBBON TRANSFORMATION
What is in built Column Transformation (15:54)
What is in built Row transformations (10:01)
How to Filter the selected rows in Power Query (9:08)
INTRODUCING OTHER IN-BUILT TRANSFORMATION
What is Text Transformation in Power Query (12:16)
What is Numbers transformation in Power Query (13:53)
What is Date transformation in Power Query (9:52)
What is Conditional Columns in Power Query (8:15)
INTRODUCTION TO MULTIPLE DATA SOURCE / QUERIES
Difference between Append / Duplicate / Reference Queries (2:40)
Method to Append multiple files with different queries individually (5:25)
Method to Import multiple files with single query from a folder (6:43)
Method to Append the Data from multiple excel sheets and multiples files in a folder (6:26)
Differentiating Duplicate / Reference queries with its benefits (5:46)
MERGE QUERIES / MULTIPLE JOINS IN POWER QUERY
Left, Right, Outer joins – Part 1 in Power Query (9:31)
Left, Right Anti joins – Part 2 in Power Query (6:03)
Cross Joins / Cartesian Product using other functions in Power Query (7:26)
INTRODUCING POWER QUERY – BUILDING BLOCKS FOR M LANGUAGE
M – Text functions (14:02)
M – Date functions (8:48)
M – Conditional functions i.e. IF, AND, OR (12:01)
Adding Column from an example (9:00)
CASE STUDIES – PART 1
Introduction to Financial Statements (8:39)
What is a Payroll Data (8:34)
Easy Solution for Stacked data to columnar data – Address Book (7:34)
Applying Multiple filters on single column (3:46)
Easy Solution for Rows to columnar data set (7:45)
Easy Solution for Looking up discount rates (12:02)
What is Invoice data? (4:59)
LISTING POWER QUERY OBJECTS
Power Query Objects Introduction (0:54)
Define List as object and List functions in Power Query (12:30)
Define Record as object and Record functions in Power Query (9:32)
ADVANCED CASE STUDIES – PART 2
Introduction to Advanced Case Studies (2:01)
How to Extract the relevant data (14:24)
Calculating Individual sales to total sales percentage (7:50)
Solution for Multiple filters on a single column – part 2 (6:42)
Split a date range in per row – Leave Data Part (9:18)
Method to Import multiple files with single query from a folder
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock