Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Power Query and Power BI Combo Course
Rating: 4.6 out of 5(52 ratings)
284 students

Power Query and Power BI Combo Course

Learn Excel Power Query, Power Pivot and Power BI Tools. Learn how to analyze millions of rows of data in Power Query
Created bySaad Nadeem
Last updated 1/2025
English

What you'll learn

  • Power Query: Learn to extract, transform, and load data from various sources.
  • Power Pivot: Transform raw data into a data model for meaningful analysis.
  • Power BI: Create interactive reports and dashboards for effective data visualization.
  • Power Map: Craft stunning interactive sales maps to analyze geographical trends.
  • Turn data into insights: Quickly transform vast amounts of data into actionable information.
  • Build reports and dashboards: Design captivating visuals to communicate insights clearly.
  • Analyze data with speed and accuracy: Make informed decisions based on reliable data analysis.
  • Start from scratch: Build your skills from the ground up, no prior knowledge required.
  • Learn the latest tools: Master the current versions of Excel
  • Improve your Excel skills: Sharpen your general Excel knowledge for more efficient data manipulation.
  • Follow along with practice files: Apply your learning to real-world scenarios.
  • Regular course updates: Stay ahead of the curve with continuous content refreshes.

Course content

2 sections • 36 lectures • 3h 16m total length

  • Installing and Exploring Power Query5:33
  • Power Query Interface4:46

    Power Query interface to clean and transform data, combine multiple sources into a single data model, and perform operations like merge, append, split, pivot, and replace.

  • Power Query Update With Pivot Tables2:56
  • Format Dates and Values in Power Query2:28

    Format dates and values in Power Query by converting the date column and setting payments to currency, then load the updated table back into Excel.

  • Parsing URLs in Excel Power Query4:04
  • Split Text Fields in Excel Power Query7:10
  • Group By in Excel Power Query3:06

    Group by sales data in Power Query to calculate total sales by each salesperson and by sales region, using sum aggregations and advanced settings.

  • Unpivoting Columns3:13
  • Pivoting Columns in Power Query1:44
  • Split Columns into Other Columns4:19
  • Filtering Rows4:03
  • Sorting Data in Power Query2:36
  • Transform and Add Columns5:54
  • Combine Excel Data Files in Power Query6:19
  • Perform Auto Clean Up in Power Query7:08

    use Power Query and Power BI to import multiple workbooks from a folder, clean and split first and last names, and refresh to auto update pivots.

  • Extract Data from Forms in Power Query13:46
  • Extract Multiple Criteria in Excel Power Query3:37
  • Extract Multiple Worksheets in Excel Power Query4:29

    Learn to extract all worksheets from a single Excel file with Power Query, combine them into one table, and clean data by setting headers and removing extra headings.

  • Introduction to Joins1:34
  • Merging Tables In Power Query Using Joins6:14
  • Merge Tables in Power Query With Outer Joins3:01
  • Right Anti Join In Power Query7:25

    Use a right anti join in Power Query to identify students who need counseling by comparing two tables of class and student IDs.

  • Convert Reports to Pivot Table in Power Query3:42
  • Modulo to Arrange Data6:17
  • Get a List of File Names Through Power Query3:46
  • Get Files Names Based on User Selection9:21

Requirements

  • Willingness for learning

Description

Learn to do really cool stuff with data! Our awesome bundle combines two courses: one on Power Pivot, Power Query, and DAX in Excel, and another on Power BI. If you've maxed out on Excel and want to do more with your data, these tools are perfect.

Power Pivot, Power Query, and DAX Course:

This course helps you do fancy things in Excel. You'll learn to:

  • Get data from different places.

  • Make your data look nice and tidy.

  • Create cool charts and tables.

  • Use a special language called DAX to do smart calculations.

Power BI Course:

Power BI is like Excel but super easy. In this course, you'll learn:

  • What Power BI is and why it's awesome.

  • How to bring in data from different files.

  • Make your data look even cooler with charts and graphs.

  • Use simple tricks to filter and organize your data.

These courses are easy to follow, and we've included practice files so you can play around and get good at it. Start having fun with data!

More About Power Query


Power Query is available on Excel 2010 and 2013 through a free download from Microsoft as described in the course.

Lets face it, retrieving, cleaning and transforming data to report on can take hours of precious time. With Excel Power Query you can eliminate repetitive tasks freeing your time for other important tasks, like lunch and going home on time. Excel Power Query removes the hassle and complex formulas of manual tasks such as:

  • Finding the Data each time you need a report

  • Cleaning Columns of Data

    • Splitting or Joining Column Values

    • Removing unnecessary characters and extra spaces

    • Formatting data correctly

  • Filtering data needed for the report

  • Combining multiple Datasets into a master list

  • Manipulating the data layout to work with other tools, i.e. Excel PivotTables and Charts

In just 3 easy steps, you'll have a final report ready for presentation and your next raise.

  1. Get Data

  2. Transform/Clean Data

  3. Report on Data

Once you've got it all setup with Excel Power Query all you need to do is hit the Refresh button to update the report with next weeks data. Microsoft Power Query remembers all the steps you performed to get, transform and clean the data all you do is refresh and your report is updated.

Sounds all too easy, right? Enroll now and let me guide you through Excel Power Query and you'll quickly be on your way to harnessing the power of managing and reporting on data with Excel Power Query.

Who this course is for:

  • Everyone who wants to master Excel Dashboards
  • Business analysts
  • Data analysts
  • Students

Report abuse