Power Query for Excel & Power BI Course

1 Review
2 Hours
$25.00$199.00
You save 87% -

46 Lessons (2h)

  • Your First Program
  • 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

YL
Yoda Learning

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

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.