Power Pivot & Power Query & DAX in Excel

In this Excel course, we look at three crucial advanced Excel features - Power Pivot, Power Query, and DAX. These functions allow you to manipulate, analyze, and evaluate millions of rows of data from Excel or other databases. Learn how to bring your data together, merge, and clean it using Power Query before moving onto creating relationships between data tables and building out a data model. We then look at performing calculations on a data model using DAX, and finally, displaying an analysis using PivotTables and PivotCharts.