This course introduces Microsoft Excel’s powerful data modeling and business intelligence tools: Power Query, Power Pivot, and Data Analysis Expressions (DAX).

Using project files and hands-on demos, we’ll load and transform raw files with Power Query, create table relationships with Excel’s Data Model, and use Power Pivot and DAX to explore and analyze our data with powerful calculated fields.