Advanced Excel and Data Modeling

Data Modeling: Data Visualization with Excel

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.
Data Visualization with Excel
Prerequisite 

Advanced Excel, Excel 301

Duration 
15 hours
Cost 
$699.00
Tags 

Course Schedule:

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