All You Need to Know About

Learn Power Query, Power Pivot & Power BI

Turn data into opportunity with Microsoft’s Business Intelligence & data visualization tools..

Power BI in Excel has a lot of powerful components working together: Power Query, Power Pivot and Power View.

Excel Power Query is one of the most powerful new features within Microsoft Excel and the easiest to learn.

It was first introduced as an Excel add-in in 2013 and was then made available in Excel 2010.  In Excel 2016 it was renamed to Get & Transform and was available (without using an add-in) under the DATA tab in the ribbon menu.  In Excel 2019, it will be renamed to Power Query once again!

You can use Power Query to clean & transform your data that you download from your ERP or accounting system and display it in a report for Excel to work with.

The best thing is that you can reapply the same transformation steps in just ONE single click, saving you HOURS! So next week when you get the same report with updated data, a simple REFRESH will transform your data once again!

Power Pivot on the other hand gives you the power to work with large sets of data.  In a nutshell, it allows you to use multiple data sources. Then you could import, merge and perform analysis on the resulting data. The beautiful thing with Power Pivot is it allows you to work on Big Data with no limitations.

Imagine getting data from multiple sources like SQL Server, Oracle, XML, Excel, Microsoft Access then build a Data Model from it. Then you can analyze these all into one awesome Pivot Table!

Read on to find our best Power BI Tutorials to get yourself up to speed!

Top 10 Tutorials

  1. 50 Things You Can Do With Excel Power Query– I have compiled an interactive tutorial on the 50 different things you can do with Excel Power Query.Read more
  2. Consolidate Multiple Excel Workbooks Using Power Query– Luckily with Power Query this consolidation task can be done in a couple of minutes! That’s right, only a couple of minutes.Read more
  3. Consolidate Multiple Excel Sheets Using Power Query Append– If you have multiple Excel worksheets that are in the same format and their underlying differences are their values and dates (e.g. January Sales List, February Sales List, March Sales List etc), then we can easily consolidate all the worksheets into one.Read more
  4. Replicating Excel’s LEFT Function with M in Power Query– If we want to use the LEFT Excel Function, it is not supported in the M programming language. But I have found a way for us to replicate the LEFT Function in M!Read more
  5. Enabling Power Pivot in Excel 2016– The good thing with Power Pivot is it already comes with your Excel 2016, we need to enable it to start using Power Pivot.Read more
  6. Replicating Excel’s RIGHT Function with M in Power Query– If we want to use the RIGHT Excel Function, it is not supported in the M programming language. But I have found a way for us to replicate the RIGHT Function in M!Read more
  7. Remove Rows Using Power Query– One of the most common steps I do, is to clean my data and remove rows, and Power Query gives you a lot of options to do so!Read more
  8. Remove Duplicates Using Power Query or Get & Transform– One of the steps it allows you to take is to remove duplicates easily. This removes the human error whenever you try to delete your duplicate data manually!Read more
  9. Linking Excel Tables in Power Pivot– When you have multiple tables, Power Pivot can help you link them together. After linking them together you can then create a Pivot Table that will give you a single view of data.Read more
  10. How To Install Power Query in Excel 2010– Power Query is a new add-in that was introduced in Excel 2013 by Microsoft and was that popular that they made it backward compatible with Excel 2010.Read more

Read More

Latest Tutorials

Want to get better at Excel?

Join Our Excel Community

Get our Free Weekly Excel lesson plans that cover the must know Excel features and tips to make you better at Excel!