Advanced Excel Data Modeling

In this course, students will learn how to use create data models using existing datasets and Power Pivot for the purposes of quick data analysis, performing calculations, and obtaining meaningful insights. Students will learn how to connect, transform, combine, and load data for the purposes of analysis, querying, and reporting of findings.

Who Is This Course For? 

advanced users, data analysts

What Will You Learn? 
How to build a performance dashboard report.
How to create and measure key performance indicators (KPIs)
How to write data analysis expressions (DAX) in PowerPivot.
How to create aggregations in PowerPivot.
How to perform calculations in PowerPivot.
How to create a data model using imported data.

Advanced Excel, Excel 301

15 hours

Course Schedule:

This course is not currently scheduled. Please sign up if you want to get this course soon.