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
Практики работы с данными средствами Power Query и Power PivotSaint Petersburg State University via Coursera Практики анализа экономических данных от простого к сложному
Saint Petersburg State University via Coursera Introduction to Power BI
DataCamp Learn Excel 2016 Intermediate Level - Beyond the Basics
Udemy Excel Básico Avançado 5 Cursos - Formação Especialista
Udemy