Excel Reporting That Scales
Build a FreshMart Dashboard with Power Query and DAXBy Vera Calderon
Length7h 3m
About this audiobook
Excel reporting and Power Query. Stop wrestling with messy spreadsheets and start building reports that actually scale. Excel Reporting That Scales is the hands-on guide for analysts, managers, and BI beginners who want to turn scattered data into clean, refreshable business intelligence using Power Query and pivot tables. Power Query and pivot tables are your keys to automating data cleaning and creating dynamic summaries—no coding required. This book takes you from absolute beginner to confident pro, with step-by-step tutorials, real-world examples, and practical exercises you can apply immediately. Learn how to connect multiple data sources, transform raw data into analysis-ready tables, and build interactive dashboards that update with a single click. Unlike Excel: The Absolute Beginner's Guide to Maximizing Your Excel Experience by [placeholder] or The Definitive Guide to DAX by [placeholder], this book focuses on the tools that matter most for everyday reporting: Power Query for data transformation and pivot tables for summarization. You'll master techniques to handle millions of rows, create measures with DAX, and design reports your team can trust and refresh themselves. Whether you're preparing monthly sales reports, financial summaries, or operational dashboards, this book gives you a scalable system that grows with your data. Say goodbye to manual copy-paste and hello to automated, professional-grade BI in Excel. Vera Calderon demystifies Power Query and pivot tables, showing you how to combine them for maximum impact. By the end, you'll have a repeatable process for any data challenge—from messy CSV files to complex relational models. This is not just another Excel book; it's your blueprint for building reporting that scales, impresses, and saves hours every week. Start today and transform your Excel skills into a career asset.
Audiobook details
GenreTechnology
Length7 hrs 3 mins
Narrated byListen with 1,000+ voices
FormateBook with Audio
LanguageEnglish
Table of contents
1Preface
2Chapter 1 — Meet FreshMart – The Dashboard You Will Build
3Chapter 2 — Power Query Foundations – Cleaning Your First Table
4Chapter 3 — Combining Multiple Files – The Folder Connector Magic
5Chapter 4 — Reshaping Data with Merges and Unpivots
Show all chaptersShow less
6Chapter 5 — Loading to Power Pivot – Your First Data Model
7Chapter 6 — Designing a Star Schema – Relationships and a Date Table
8Chapter 7 — DAX Essentials – Measures vs. Calculated Columns
9Chapter 8 — Mastering Filter Context with CALCULATE
10Chapter 9 — Time Intelligence Made Simple
11Chapter 10 — Advanced DAX Patterns – Ranking and Top N
12Chapter 11 — Key Performance Indicators – Profit, Returns, and Margins
13Chapter 12 — Building PivotTables – From Measures to Summaries
14Chapter 13 — Interactive Dashboards with PivotCharts and Slicers
15Chapter 14 — Dashboard Polish – Conditional Formatting and CUBE Functions
16Chapter 15 — Automating Refresh – When New Data Arrives
17Chapter 16 — Performance Tuning – Keeping Your Model Lean and Fast
18Chapter 17 — Collaboration and Sharing – Exporting Your Work
19Chapter 18 — Beyond the Dashboard – Next Steps in Your BI Journey
20About the Author
More from Vera Calderon
When the Heavens Went on SaleAshlee Vance18h 20m4.4 (3K)$40 · $0.00
Everybody Has a Podcast (Except You)Justin McElroy, Travis McElroy, Griffin McElroy5h 9m4.3 (2.3K)$24 · $0.00
Hands of TimeRebecca Struthers8h 8m4.4 (1.3K)$26 · $0.00
Never Lost AgainBill Kilday10h 1m4.4 (805)$29 · $0.00
How the Internet HappenedBrian McCullough13h 28m4.3 (2.7K)$23 · $0.00
Collected Writings of Nikola TeslaNikola Tesla, Thomas Commerford Martin21h 50m4.3 (1.7K)$1 · $0.00
Just AspireAjai Chowdhry9h 13m4.4 (260)$29 · $0.00
The Little Book of AliensAdam Frank8h 20m4.3 (1.3K)$26 · $0.00
The inventions, researches and writings of Nikola Tesla (Annotated)Thomas Commerford Martin16h 59m4.3 (1.3K)$2 · $0.00
KargilV.P. Malik15h 18m4.3 (2K)$24 · $0.00
Experiments with Alternating CurrentsNikola Tesla9h 16m4.3 (874)$1.99 · $0.00
Fire on the HorizonTom Shroder, John Konrad8h 23m4.3 (858)$26 · $0.00
The Smell of Kerosene (Annotated)National Aeronautics and Space Administration, Donald L. Mallick, Peter W. Merlin11h 32m4.3 (523)$2 · $0.00
The Boy Who Harnessed the WindWilliam Kamkwamba, Bryan Mealer10h 5m4.2 (78.9K)$29 · $0.00
Across the Airless WildsEarl Swift10h 8m4.3 (1.3K)$29 · $0.00
Console WarsBlake J. Harris20h 41m4.2 (13.7K)$46 · $0.00
Improvised Munitions HandbookU.S. Department of Defense4h 49m4.3 (1.6K)$0.99 · $0.00
Escaping GravityLori Garver10h 54m4.2 (2.2K)$20 · $0.00
Wireless WarsJonathan Pelson8h 2m4.3 (418)$20 · $0.00
Let There Be WaterSeth M. Siegel8h 36m4.2 (2.3K)$20 · $0.00
You may also like
Elements of ChemistryAntoine Lavoisier12h 24m4.1 (685)$9.10 · $0.00
Rapid Russian, Vols. 1 & 2Earworms Learning2h 15m4.6 (88)$20
Up Around the BendBill Brown Jr.29m$2
Dear Hearts and Gentle PeopleBill Brown Jr.37m$4
Iron ManBill Brown Jr.46m$5
AP World History Exam Study GuideMarie Peterson8h 47m$10
LauraBill Brown Jr.26m$2
The HomecomingBill Brown Jr.52m$5
I'll Never Fall in Love AgainBill Brown Jr.30m$2
Mrs. Robinson AccompanimentBill Brown Jr.22m$2
March in GBill Brown Jr.28m$2
Beyond The SunsetBill Brown Jr.19m$2
Grace Greater Than Our SinBill Brown Jr.1h 38m$10
Somewhere My LoveBill Brown Jr.1h 1m$10
Great is Thy FaithfulnessBill Brown Jr.1h 22m$10
The Big Sewing BookEva-Maria Heller2h 17m$5 · $0.00
Pennsylvania Journeyman & Master Plumber Exam Workbook 2026/2027Garrick Pellowe14h 5m$30
The history of filmKidsChoice48m$12 · $0.00
New Hampshire Real Estate Licensing Exam Workbook 2026/2027Marguerite Ostrander15h 52m$30
DominiqueBill Brown Jr.36m$4