The Leanpub 60 Day 100% Happiness Guarantee
Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.
See full terms...
Data Modeling with Power Pivot & DAX
Relational Thinking, Star Schema Design, and Measure-Driven Analysis in Excel
This book is 100% completeLast updated on 2026-07-20
Move beyond spreadsheets and think like a BI professional. Learn Power Pivot, star schema design, and DAX to build relational data models, dynamic measures, and scalable analytical solutions that power modern business intelligence.
Minimum price
$9.90
$16.00
You pay
Author earns
PDF
EPUB
About
About the Book
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.
Author
About the Author
fru kingsly
FRU Kingsly is a data professional, analytics educator, and technology consultant specializing in data analytics, business intelligence, data engineering, and analytical communication. His work focuses on helping individuals and organizations develop the technical skills and analytical thinking required to transform raw data into trusted business insight.
Through consulting, technical training, and professional curriculum development, he has worked across areas including SQL, Power BI, data warehousing, cloud analytics, visualization, and enterprise reporting systems. His approach emphasizes that analytics is not only about tools, but also about judgment, clarity, structure, and responsible decision-making.
Data Analytics Foundations was written to provide the kind of rigorous, structured analytical education that many professionals never formally receive: one that teaches not only how to perform analysis, but how to think analytically before touching the data.
Get the free sample chapters
Click the buttons to get the free sample in PDF or EPUB, or read the sample online here
Earn $8 on a $10 Purchase, and $16 on a $20 Purchase
We pay 80% royalties on purchases of $7.99 or more, and 80% royalties minus a 50 cent flat fee on purchases between $0.99 and $7.98. You earn $8 on a $10 sale, and $16 on a $20 sale. So, if we sell 5000 non-refunded copies of your book for $20, you'll earn $80,000.
(Yes, some authors have already earned much more than that on Leanpub.)
In fact, authors have earned over $15 million writing, publishing and selling on Leanpub.
Learn more about writing on Leanpub
Free Updates. DRM Free.
If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).
Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.
Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.
Learn more about Leanpub's ebook formats and where to read them
Write and Publish on Leanpub
You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses!
Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks.
Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. (Or, if you are producing your ebook your own way, you can even upload your own PDF and/or EPUB files and then publish with one click!) It really is that easy.