[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_28":-5,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58},"routes/_store+/_readers+/email_author.$slug/route",{"_9":10,"_11":-5},"book",{"_12":13,"_14":15,"_16":17,"_18":19,"_20":21,"_22":23},"currentUser","id","Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6Qm9va1Byb2R1Y3QvODE1ODc","title","Data Modeling with Power Pivot & DAX","state","published","contactAuthorMethod","email","aboutText","

About This Book

Most Excel users build spreadsheets. Professional analysts build models.

Data Modeling with Power Pivot & DAX is the fourth volume of the Excel for Data Analytics & Business Intelligence Pathway and your guide to transforming flat spreadsheets into scalable, relational analytical models.

This book introduces the Excel Data Model, Power Pivot, and DAX as a unified analytical platform. You'll move beyond formulas, lookup chains, and disconnected tables to build star schemas, create reusable measures, master filter context, and develop dynamic analytical models capable of answering complex business questions.

Inside this book, you will learn how to:

Design professional star schemas and relational data models.
Build and manage the Excel Data Model with Power Pivot.
Understand relationships, cardinality, and filter propagation.
Master DAX fundamentals, measures, calculated columns, and variables.
Learn CALCULATE, iterator functions, and evaluation context.
Build robust time intelligence and business calculations.
Optimize analytical models for performance, scalability, and maintainability.
Prepare for advanced Power BI, Microsoft Fabric, and enterprise BI development.

Unlike books that simply explain DAX functions, this volume teaches the mental model behind relational analytics. You will understand not only how to write DAX, but why it works—developing the reasoning required to build models that remain accurate under every reporting scenario.

This book is ideal for:

Data Analysts
Business Intelligence Developers
Financial Analysts
Power BI Professionals
Excel Power Users
Reporting and Decision Support Specialists
Anyone ready to move beyond traditional spreadsheets

If Power Query prepares the data, Power Pivot and DAX unlock its analytical power. This book shows you how to build models that deliver reliable, scalable, and decision-ready business intelligence.

","authors",[24],{"_12":25,"_26":27,"_28":29},"Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6UHJvZHVjdEF1dGhvci84NzIwMA","name","fru kingsly","user",{"_30":31},"avatar",{"_32":33,"_34":35,"_36":37},"url","https://secure.gravatar.com/avatar/cf6fc3b6c6994f1bb2c6772897e8dc89?r=pg&d=mm","styleName","medium","exists",true,"shoppingCartId","shoppingCart",{"_12":71,"_72":73,"_74":37,"_75":76,"_77":78,"_79":80,"_81":37},"locale","en","readerTheme","light","constants",{"_69":70},"publishers",{"_65":66,"_67":68},"learnerOrganizations",[],"needsLocaleCookieSync",false,"announcements",{"_59":60,"_61":-5},"sentryEnvironment","production","sentryRelease","9cf6b419f8c13fd5dae5d6b0c706fc3ddbbeb5fe","announcement_store",{"_62":52,"_63":64},"announcement_authors","flag","text","

Kick off your book project, get started with GhostAI, get better at marketing, or spend the day doing all three! Free live workshops on Zoom. Saturday, June 27, 2026.

\n","companies",[],"universities",[],"paypalClientId","AX53Cwz8jR6rVVzzZiZNWWXl0dGagi-GZrjG-S3Ua14E5nrKMn7DxDQ730O4R8LusLPp49ALn6aRVaEy","no-cart","count",0,"free","updatedAt","","paymentGateway","STRIPE","cartItems",[],"loading"]

Email the Author