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

Dive into a comprehensive 57-minute video tutorial on Power Query, covering its application in Excel and Power BI Desktop for importing and transforming data. Learn to clean and transform Excel data, explore the Power Query user interface and M code, and understand data loading locations. Master techniques for editing, deleting, and adding steps to Power Query solutions, as well as refreshing reports with new data. Extract, import, and transform data from relational Access databases into Excel Power Pivot, creating star schemas. Discover how to combine multiple text files into a single table in Power BI Desktop. Replace complex Excel array formulas with simple Power Query solutions, including extracting sorted unique lists. Includes downloadable start and finished files, along with supplementary materials for hands-on practice.

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.