Completed
) Introduction
Class Central Classrooms beta
YouTube playlists curated by Class Central.
Classroom Contents
The Magic of Power Query to Import, Transform & Load Data
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Power Query Icon as Magic
- 3 ) Files to download and unzip folder
- 4 ) What is Power Query? What does Power Query do?
- 5 ) Example 1: Import Text File to create report and chart. Then get a new Text File next month and everything will update.
- 6 ) A complete introduction to Power Query.
- 7 ) Two methods to update report when you get a new Text file: 1) Edit Query, or 2) Duplicate Query.
- 8 ) Example 2: Clean Bad Data in an Excel Sheet, Load to Excel Sheet, Build PivotTable. Then add new data and refresh the Query and the PivotTable Cache.
- 9 ) Example 3: Import multiple Text Files from Folder and Append into single Proper Data Set.
- 10 ) Summary