COURSE DESCRIPTION:
It’s time to introduce Excel’s powerful trio of self-service BI tools: Power Query, Power Pivot, and Data Analysis Expressions (DAX). If you’re serious about business intelligence, these are essential skills to master.
This course takes a project-based approach, and is designed to guide you through the entire BI workflow from start to finish. Using data from a fictional supermarket chain, we’ll load and transform raw CSV files with Power Query, build our own relational data model from scratch, and explore and analyze our model using Power Pivot and DAX expressions.
