Microsoft Excel – Advanced Data Analysis With Using Power Query, Power Pivot and DAX
This advanced Excel training focuses on three essential advanced features in Excel application Power Pivot, Power Query and Data Analysis Expressions (DAX). These are some of the advanced data analysis tools available in Excel.
In this course we will look at how to connect, transform and combine data from a wide variety of available data sources using Power Query before moving onto creating relationships between our data tables and building out a data model. We then look at performing powerful data analysis and calculations on our data model using DAX, and finally, we look at displaying our analysis using PivotTables and PivotCharts.