Microsoft Excel - Power Query
What is Power Query?
The "BI" (Business Intelligence) Process
The Value is in the Refresh
While there is certainly value in the initial analysis, the real value in any BI solution comes from the refresh. When your boss comes to you and asks you to update the solution it took you hours to build and gives you a deadline of 10 minutes, you need to be able to say "Yes, I've got this."
Video time: 05m 42s
Appending Tables (Joining Tables by Stacking Them Vertically)
Append All Files in a Folder - Theory
Power Query adds the ability to reach into a folder and append all files in the folder based on the transformations of a single file. Before you can leverage it, however, you need to learn the background, and that's what this lesson is all about.
Video time: 06m 03s
Merging Tables (Joining Tables Horizontally by Matching Data)
Create Columns from Examples
Sometimes trying to extract data from a column can be difficult, so why not let Power Query help? Microsoft has put significant effort into a tool called "Columns From Examples" where you can define and refine the output, and let Power Query build the formula to get the results.
Video time: 07m 10s