Power Query Introduction - Importing & Transformation Data in Excel & Power BI Desktop

This introductory course demonstrates Power Query for extracting, importing, cleaning, transforming, and loading data in Excel and Power BI Desktop. Examples use Excel tables, an Access relational database, and multiple text files, including a star schema and a replacement for complex array formulas.

Syllabus

) Introduction.
) 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..
) Example 2: Extract & Import, Clean & Transform and Load Data from Relational Access Database into Excel Power Pivot Data Model and create Star Schema..
) 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..
) Example 4: Replace Complex Excel Array Formulas with Simple Power Query Solution. See how to Extract a Sorted Unique List..
) Summary.