filmov
tv
[[ 3 HOURS ]] Complete Power Query End to End - PowerBI Tutorial { End to End } Full Course Beginner
Показать описание
This FULL course in Power Query, In this video will cover how to write Power query in power bi development. We go through Creating a data transformations, handling data, query folding , data preview and many more concepts.
#PowerBI #PowerBIDesktop #PowerBITutorials
▬▬▬▬▬▬▬▬ Power BI - POWER QUERY- Tutorials - FULL COURSE ▬▬▬▬▬▬▬▬
1) 03:44 - Introduction
Power Query VS Power Pivot VS Power View
2) 12:37 - Excel Transformation
Remove Headers, Rows
Fill gaps, Unpivot
Data Types
3) 25:02 - Common Transformation
Split, derive a Column , remove Column
4) 37:32 - SQL Equivalent Transformation
Append Union / Union All
Merge Left/ Right/ Inner Join
Group By
5) 59:12 - Business Scenarios
Sort by month, Derive Age, Stored in Enter data,
Reading Multiple Excels, Split the delimited value into rows,
6) 01:41:58 - Data Preview Options
7) 01:49:04 - Handling nulls or blanks
8) 01:57:53 - Query Folding in Power BI
9) 02:09:17 - Power Query Tips & Tricks
Column From Examples
Reference vs Duplicate in Power Query
Query Dependency
Change Connection source / Source Type
Source Files:
1) Excel Transformation :
2) Append:
3) Merge
4) Excel Automation / Reading Multiple Excel Files
💬 For Learners Post queries and Interact 💬
Complete Playlists
#PowerBI #PowerBIDesktop #PowerBITutorials
▬▬▬▬▬▬▬▬ Power BI - POWER QUERY- Tutorials - FULL COURSE ▬▬▬▬▬▬▬▬
1) 03:44 - Introduction
Power Query VS Power Pivot VS Power View
2) 12:37 - Excel Transformation
Remove Headers, Rows
Fill gaps, Unpivot
Data Types
3) 25:02 - Common Transformation
Split, derive a Column , remove Column
4) 37:32 - SQL Equivalent Transformation
Append Union / Union All
Merge Left/ Right/ Inner Join
Group By
5) 59:12 - Business Scenarios
Sort by month, Derive Age, Stored in Enter data,
Reading Multiple Excels, Split the delimited value into rows,
6) 01:41:58 - Data Preview Options
7) 01:49:04 - Handling nulls or blanks
8) 01:57:53 - Query Folding in Power BI
9) 02:09:17 - Power Query Tips & Tricks
Column From Examples
Reference vs Duplicate in Power Query
Query Dependency
Change Connection source / Source Type
Source Files:
1) Excel Transformation :
2) Append:
3) Merge
4) Excel Automation / Reading Multiple Excel Files
💬 For Learners Post queries and Interact 💬
Complete Playlists
Комментарии