Power Query for Excel & Power BI Course

Power Query for Excel & Power BI Course

1 Review
2 Hours
$24.99$100.00
You save 75%

46 Lessons (2h)

  • Your First Program
  • Download Practice Files
  • Section 01: Getting Ready
  • Section 02: Data Preparation - Part 1 (Blending)
  • Section 03: Data Preparation - Part 2 (Cleaning)
  • Section 04: Data Preparation - Part 3 (Re-Structuring)
  • Section 05: Data Preparation - Part 4 (ETL Project)
  • Section 06: Bonus Tricks

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 average rating: ★ ★ ★ ★ ★ ★

  • 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.
1 Review
4/ 5
All reviews are from verified purchasers collected after purchase.
ks

karl smith

Verified Buyer

Essential skills for personal development and useful knowledlege to have in my skillset. Made me more marketable career-wise.

Nov 23, 2022
Your Cart
Your cart is empty. Continue Shopping!
Processing order...