Download Excel START File: people.highline.edu/mgirvin/A...
Download Access START File: people.highline.edu/mgirvin/A...
Download zipped folder with Text Files: people.highline.edu/mgirvin/A...
Download Excel FINISHED File: people.highline.edu/mgirvin/A...
Download Power BI FINISHED File: people.highline.edu/mgirvin/A...
Download pdf Notes about Power Query: people.highline.edu/mgirvin/A...
In this Video learn all about Power Query. A complete Introduction to all aspects of Power Query.
Topics:
1. (00:12) Introduction
2. (02:26) Example 1: Clean and Transform Data in Excel. Look at Excel Power Query User Interface & M Code. Look at Locations to Load Data. Edit, Delete and Add Steps to Power Query Solution. Add new data and Refresh Report and Power Query Transformation.
3. (27:20) Example 2: Extract & Import, Clean & Transform and Load Data from Relational Access Database into Excel Power Pivot Data Model and create Star Schema.
4. (40:37) Example 3: Extract & Import, Clean & Transform and Load Data From Multiple Text Files into Power BI Desktop Data Model. We will Combine all Text Files into Single Table.
5. (52:54) Example 4: Replace Complex Excel Array Formulas with Simple Power Query Solution. See how to Extract a Sorted Unique List.
6. (55:50) Summary
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.
Assigned Homework:
Download Word Document and read: people.highline.edu/mgirvin/A...
Then download the rest of the files and complete the homework:
people.highline.edu/mgirvin/A...
Examples of Finished Homework:
people.highline.edu/mgirvin/A...
people.highline.edu/mgirvin/A...
The Power Query logo used in this video is copyright of and used with the express permission of powerquery.training
Thanks to Ken Puls and Miguel Escobar for letting me use their logo!!!!
Негізгі бет MSPTDA 03: Power Query Introduction: Importing & Transformation Data in Excel & Power BI Desktop
Пікірлер: 641