Skip to content
Dashboard
Menu
Dashboard
Courses
Discussions
My Account
Contact Us
Course Overview
Get and Transform Data with Power Query
Course Content
Expand All
Module 2: Get and Transform Data
1 Lesson
Expand
Module Content
0% Complete
0/1 Steps
Getting Started – Module 2
Intro to Power Query
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Introduction to Power Query
The Get Data User Experience
Power Query UI Walk Through
Summary – Introduction to Power Query
Simple Transformations
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Cleansing Data
Splitting Columns into Columns and Rows
Cleansing Tables
Summary – Simple Transformations
Appending and Merging Data
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Appending Flat Files in a Folder
Merging Data with Joins
Audit Query
Summary – Appending and Merging Data
Star Schema
3 Lessons
Expand
Module Content
0% Complete
0/3 Steps
Flattening Tables
Building a Star Schema
Summary – Star Schema
Advanced Concepts
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Relative References in Queries
Conditional Logic If Statements
Accessing Data from Previous Row
Summary – Advanced Concepts