YoVDO

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

Offered By: ExcelIsFun via YouTube

Tags

Microsoft Power BI Courses Data Analysis Courses Data Transformation Courses Data Models Courses Power Query Courses Power BI Desktop Courses

Course Description

Overview

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.


Taught by

ExcelIsFun

Related Courses

Практики работы с данными средствами Power Query и Power Pivot
Saint 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