Course: 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.
Original: $199.99
-70%$199.99
$60.00Course: 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.
Product Information
Product Information
Shipping & Returns
Shipping & Returns
Description
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.