Excel Power Query, Power Pivot & DAX
Build and analyze data models using Excel’s trio of self-service business intelligence tools: Power Query, Power Pivot & DAX.
If you're looking to become an Excel power user and level up your data analytics game, this course is the A-Z guide that you're looking for.
We'll start with Power Query and practice extracting and loading raw data from multiple sources. We'll use the query editor to clean, transform and blend the data, and create completely automated procedures with just a few clicks.
From there we'll dive into the fundamentals of data modeling and database design, including table relationships, cardinality and normalization. We'll take a tour through Excel's data modeling interface, and practice creating a relational model from scratch.
Finally, we'll use Power Pivot and DAX to explore and analyze our model, and define powerful calculations using Data Analysis Expressions (DAX), including:
- Basic Math & Stats functions
- Conditional & Logical functions
- Text functions
- Calculate functions
- Filter functions
- Table function
- Iterator functions
- Time Intelligence functions
- and more!
If you're ready to learn powerful business intelligence skills and build the foundation for mastering tools like Power BI or Tableau, this is the course for you.
WHO SHOULD TAKE THIS COURSE?
- Excel users looking for an introduction to advanced analytics and business intelligence
- Anyone seeking to analyze large, complex datasets or relational models in Excel
WHAT ARE THE COURSE REQUIREMENTS?
- Microsoft Excel for PC/Windows, compatible with Power Query & Power Pivot (Power Pivot is currently unavailable in Excel for Mac)
- Experience with Excel PivotTables and formulas is strongly recommended