Power Pivot and Power Query

MCW240

More Information



MCW240 - Power Pivot and Power Query

Power Pivot is an Add-in that works on top of Excel. It enables you to combine data from multiple sources and analyze all the data as if it was all created in Excel. Learn how to bring data from different sources in the data model window then create relationships between the different sources, and analyze the data model using Excel Pivot Tables, Slicers and Timelines. Using Power Query, bring data into the Power Query editor, to transform the data, merge or append multiple sources, and create measures. Learn the powerful M language of Power Queries to create a proper data set that can be analyzed all together, for a better business decision.


Loading availability...