Power Query
Power Query Material
Demo Power Query
2 Topics
Course Outline
What Is Power Query?
Course Introduction
1 Topic
Course Outline
Introduction to Power Query
3 Topics
What Is Power Query?
Why Power Query Over Traditional Methods?
Power Query Experiences
Launch Power Query Editor
5 Topics
Extract the Data in Power BI
Extract the Data in Excel
Environment
Data From Web
Combine From Folder
File Tab
1 Topic
Close & Load
Home Tab
16 Topics
New Query Section
Data Source Settings
Automation in Power Query in Power BI
Automation in Power Query in Excel
Query Section
Manage Columns
Reduce Rows
Split Column
Group By
Data Types
Fixing Header
Find & Replace
Combine Files
Merge Queries – Single Column
Merge Queries – Multiple Columns
Append Queries
Transform Tab
9 Topics
Transpose & Reverse Rows
Fill Up & Down
Pivot Unpivot
Move Columns
Format Cell Values Using Various Functions
Extract the Data
Parse the Data
Number Columns Transformations
Date & Time Columns Transformations
Add Column Tab
4 Topics
Column From Examples
Custom Column
Conditional Column
Index Column & Duplicate Column
View Tab
1 Topic
Quick Go Through
Left Panel
1 Topic
Duplicate & Reference Queries
Case Studies
2 Topics
Intro Exercise
Expense_Actual vs Allowance
0% Complete
0/57 Steps
Previous Topic
What Is Power Query?
Power Query
Demo Power Query
What Is Power Query?
In Progress
Lesson Progress
0% Complete
Previous Topic
Back to Lesson
error:
Content is protected !!
WhatsApp us