Power Query for Excel & Power BI Course

1 Review

2 Hours

$24.99$100.00

You save 75%

46 Lessons (2h)

Your First Program
Preview

Download Practice Files
Practice Files
Section 01: Getting Ready
1_Introduction to Power Query - What is it? How to access it?3:05
2_Power Query User Interface - A Walkthrough2:58
3_Power BI - Nov 2019 Update0:53
4_M-Query Basics - Reading Commands in Power Query Editor2:23
5_Activate your Applied Steps Panel0:46
Feedback
6_Getting the List of all M-Query Commands2:47
7_Importing Data (incl Use First Rows as Header)2:48
Course Feedback
Section 02: Data Preparation - Part 1 (Blending)
1_Combine or Merge Multiple Files from a Folder6:02
2_Importing Data from the Web7:04
3_Merge Queries vs. Append Queries2:34
4_JOIN Types for Beginners3:59
5_Understanding JOIN Concept and its Types6:21
6_JOIN in Action - Basic Example5:57
7_Quick DOs and DONTs for Merge Queries3:05
8_Merging Queries with more than 1 KeyID Column6:35
9_Fuzzy Lookup5:37
Course Feedback
Section 03: Data Preparation - Part 2 (Cleaning)
1_Using First Rows as Header1:43
2_Cleaning Up Data with Case Change, TRIM, CLEAN3:29
3_Working with Data Types2:29
4_Fill Down Feature1:59
5_Removing Duplicates and Blank Rows4:05
6_Split Column - Part 1 (Delimiter and By Position)4:44
7_Split Column - Part 2 (Digit vs Non-Digit)3:24
8_Split Column - Part 3 (Split to Rows)4:53
9_Rectify Date Format using Data Type (Locale)5:12
10_Working with Column From Examples Feature3:56
11_Adding a Conditional Column3:22
12_Merge Columns (Concatenate)1:48
13_Replace Values and Extract Characters5:46
Course Feedback
Section 04: Data Preparation - Part 3 (Re-Structuring)
1_Unpivot Column - Cross Tab vs. Flat File3:57
2_Group By - Basic to Advanced4:51
3_Pivot Column - An Overview3:39
4_Transpose2:20
Course Feedback
Section 05: Data Preparation - Part 4 (ETL Project)
Project - Find Top 3 Analysts8:52
Course Feedback
Section 06: Bonus Tricks
1_Copy Data from Power Query Tables0:47
2_Column Profiling and Distribution3:01
3_Duplicate and Rename Queries0:57
4_Index Column1:01
Course Feedback

Prepare Your Data in No Time with 2 Hours of Content on Power Query, Excel, & SQL Server Data Tools

Yoda Learning

4.3/5 Instructor Rating: ★ ★ ★ ★ ★ ★

Yoda Learning is a team of 12+ industry professionals focused on developing project-based learning solutions, which allows students to accrue real-world experience and learn in an engaging and practical manner. Its courses encompass everything from web and mobile app development to data analytics and design.

Description

According to a Forbes survey, business users spend up to 80% of their time on data preparation, delaying the time to data analysis and decision making. Power Query is one of the most important data preparation tools. It acts as an ETL tool that can extract data across a wide variety of sources, transform it quickly and easily, and then load it directly into your table/data model. This course will teach you everything you need to know to import, merge, shape, and clean data. Power Query Course learning means you will spend negligible time in data preparation.

4.6/5 stars, Trustpilot: ★ ★ ★ ★ ★ ★

Access 46 lectures & 2 hours of content 24/7
Get data from a single file (Excel, Text, CSV, & more)
Import multiple files from a given folder
Get data from other sources like a table/range from the web & current workbook
Sort & filter columns
Convert data types – text, numbers, dates
Split or merge columns
Merge two queries like joining in SQL
Add calculated columns
Unpivot data to use pivot tables

Note: Software NOT included.

Specs

Important Details

Length of time users can access this course: lifetime
Access options: desktop & mobile
Certificate of completion included
Redemption deadline: redeem your code within 30 days of purchase
Updates included
Experience level required: intermediate
Have questions on how digital purchases work? Learn more here

Requirements

Excel 2010+ and Power BI

Terms

Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.

Your cart is empty. Continue Shopping!

Processing order...