Microsoft Excel - Intro to Power Query, Power Pivot & DAX

Description

This course introduces you to Microsoft Excel’s powerful data modeling and business intelligence tools: Power Query, Power Pivot, and Data Analysis Expressions (DAX). If you’re aiming to become a true Excel power user and supercharge your analytics, this is your comprehensive A–Z guide.

We’ll begin by exploring the “Power Excel” landscape, explaining what these tools are and why they’re revolutionizing the world of self-service business intelligence.

Using sample data from a fictional supermarket chain, we’ll dive into Power Query—a tool that enables you to extract, transform, and load data from flat files, folders, databases, API services, and more. You’ll learn how to shape, blend, and explore project files, creating fully automated data-loading procedures with just a few clicks.

Next, we’ll venture into Data Modeling 101, covering key concepts of database design and normalization, including table relationships, cardinality, and hierarchies. You’ll get a hands-on tour of Excel’s data model interface, discover best practices and pro tips, and build your own relational database to analyze throughout the course.

From there, we’ll unleash the power of Power Pivot and DAX to explore and analyze your data model. Unlike traditional pivot tables, Power Pivot lets you work with hundreds of millions of rows across multiple data tables and craft advanced calculated fields using the powerful formula language Data Analysis Expressions (or “DAX” for short). We’ll go through basic DAX syntax and dive into essential and frequently-used functions like CALCULATE, FILTER, SUMX, and more.

If you’re ready to elevate your Excel skills and join the cutting edge of analytics and business intelligence, this course is your path forward. Say goodbye to tedious manual tasks and old-school Excel struggles—join me on this journey and transform into a certified NINJA.

See you in there!

Chris