Microsoft Excel – Advanced Data Analysis With Using Power Query, Power Pivot and DAX
Course Duration
2 Weekends
Course Price
₦ 30,000.00
Course Level
Advanced
Course Overview
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.
What You Will Learn
- How to get started with Power Query
- How to connect Excel to multiple workbooks
- How to get data from the web and other sources
- How to merge and append queries using Power Query
- All about creating Pivot Charts and PivotTables and using your data model
- How to use slicers to adjust the data you display
- How the Power Pivot window works
- How to set up and manage relationships in a data model
- How to create a PivotTable to display your data from the Power Pivot data model
- How to add calculated columns using DAX
- How to use functions such as CALCULATE, DIVIDE, DATESYTD in DAX
Course Requirements
- Laptop installed with Microsoft Excel 2016
- Experience with managing data using Excel
