Let us explore the world of Power Query and Power Pivot inside Power BI!
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!
Now how about for Excel Power Pivot?
Power Pivot 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!
We have over 60+ tutorials for you to learn and master Excel Power BI! So read on!
Click on any Excel Power BI link below and it will take you to the free example tutorial & downloadable Excel workbook for you to practice!
Power Pivot – Power BI
Power Query – Power BI