Power Query Introduction - Importing & Transformation Data in Excel & Power BI Desktop
Offered By: ExcelIsFun via YouTube
Course Description
Overview
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.
Taught by
ExcelIsFun
Related Courses
Практики создания аналитических панелей в среде Microsoft Power BISaint Petersburg State University via Coursera Практики анализа экономических данных от простого к сложному
Saint Petersburg State University via Coursera Getting Started with Power BI Desktop
Coursera Project Network via Coursera Curso Completo de Power BI Desktop
Coursera Project Network via Coursera Inteligencia Artificial en Power BI
Coursera Project Network via Coursera