POWER QUERY | COMPLETE FREE AND COURSE | NOOBIE TO PRO IN 33 QUICK LESSONS

This is Simolytics. Welcome to another lesson. If you find this video helpful, don't forget to like, subscribe, and share your thoughts or questions in the comments. Let's get started. Okay, it all starts with Excel. As you may know, Excel is the most popular electronic spreadsheet software of the world. Everybody uses Excel, and as the time goes on, Excel becomes more and more intelligent and full of features. And two of these important features are Power Query and Power Pivot. They both are add-ons to Excel. Power Query was released initially for Excel 2010 and 2013 as a separate add-on, which means you had to open a separate program if you wanted to work with Power Query. But in 2016, it was totally embedded into Excel. So now you don't have to add anything. Power Query will come as a native feature in any current version of Excel. Okay, but what does Power Query do? We're going to talk a lot about it, but basically just as a quick overview, Power Query is used to import data into Excel and also into PowerBI. We're going to talk a lot about it all. Power Query is used to import data from multiple sources. So you can import data for example from databases, from CSV files, from the web, from other Excel files, text files, PDF files. So basically you can import every sort of data from all sorts of different sources into power query and then you can merge glance transform and do every kind of transformation to set up your data so that you can use it however you want whether it is in Excel or PowerBI. So basically it is a platform where you can import consolidate and transform data as you may want. Also Excel has a row limit. So if you have a table that is over 1.05 million rows, you can't handle them in bare Excel. You have to use something else. And power query on the other hand will let you work with any number of rows you may want. Then we come to Power Pivot. Power Pivot was integrated into Excel in the 2013 version. And maybe if you have a basic installation of Excel, maybe on your computer, you won't see Power Pivot right off the bat. But I'm going to show you in the next videos how to enable it.