From the course: Excel Business Intelligence: Power Query
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Meet Power Query aka Get & Transform - Microsoft Excel Tutorial
From the course: Excel Business Intelligence: Power Query
Meet Power Query aka Get & Transform
- [Instructor] Alright, time to officially meet our good friend Power Query. Now Power Query, aka Get and Transform, allows you to do a number of things. First, you can connect to data across a wide range of sources. Second, you can filter, shape, append, merge, blend, transform raw data. Basically do anything to it before it gets loaded up for further analysis, and modeling. And then, third, you can create stored, and saved procedures to automate each step of your data prep. Kind of like a VBA macro. Now, to access the Power Query tools it depends on the version of Excel that you're using. If you're using a recent version like Office 365, or Excel 2016 you should see those tools in the Data tab under the Get and Transform section. That's where you can insert new queries, show all of your workbook queries, and also list out the recent sources. So let's take a look at what types of data connections are available to us. So when you click on the actual New Query button you'll see all of…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
(Locked)
Power Query introduction27s
-
(Locked)
Meet Power Query aka Get & Transform2m 40s
-
(Locked)
The Query Editor3m 17s
-
(Locked)
Options for loading data in Excel1m 40s
-
Basic Power Query table transformations8m 6s
-
(Locked)
Text-specific query editing tools10m 17s
-
(Locked)
Number-specific query editing tools7m 41s
-
(Locked)
Date-specific query editing tools7m 39s
-
(Locked)
Create a rolling calendar with Power Query5m 2s
-
(Locked)
Add index and conditional columns with Power Query7m 44s
-
(Locked)
Group and aggregate data with Power Query7m 10s
-
(Locked)
Modify Excel workbook queries4m 18s
-
(Locked)
Merge queries7m 43s
-
(Locked)
Append queries5m 49s
-
(Locked)
Connect Excel to a folder of files9m 32s
-
(Locked)
Excel Power Query best practices2m 42s
-
(Locked)
Pivot and unpivot data with Power Query8m 52s
-
(Locked)
-