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
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 6m4.3 (874)$1 · $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)$1.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
The PerfectionistsSimon Winchester11h 46m4.2 (9.9K)$29 · $0.00
Rethinking NarcissismDr. Craig Malkin6h 7m4.2 (3.4K)$24 · $0.00
You may also like
Rapid Russian, Vols. 1 & 2Earworms Learning2h 15m4.6 (88)$20
The Violoncello and Its HistoryWilhelm Joseph von Wasielewski8h 28m4.4 (10)$2 · $0.00
Fifty SoupsThomas J. Murrey45m3.8 (33)$2 · $0.00
Latin for BeginnersBenjamin L. D'Ooge12h 38m3.5 (68)$2 · $0.00
Building Structural Systems IllustratedTomás Encinas14h 59m$70
Electrical Reference for Journeyman ElectriciansRaymond Kerrigan15h 11m$60
How to Make Money Flipping Lawn and Garden Equipment - How to Buy Mowers, Trimmers, and Outdoor Equipment Cheaply, Repair Common Faults, and Sell in SeasonJACK FLIPWELL10h 15m$7.90 · $0.00
Early Italian PaintingJoseph Archer Crowe, Giovanni Battista Cavalcaselle, Anna Jameson5h 6m3.9 (19)$15 · $0.00
The Big Sewing BookEva-Maria Heller2h 17m$5 · $0.00
Why You Should Ditch the Rice Cereal- Alternative First FoodsAurora Brooks1h 8m$3.50 · $0.00
Flip and Flap know the seaSilvia Strufaldi3m$3 · $0.00
AP World History Exam Study GuideMarie Peterson8h 47m$10
Check Point CCSA LabsDominic Pereira7h 50m$5 · $0.00
REST APIs, Endpoint by EndpointOmar Brandt7h 36m$5 · $0.00
C++ Fundamentals That StickMarcus Farrell7h 9m$5 · $0.00
18 DynamoDB ProjectsEsther Larkin7h 58m$5 · $0.00
Great is Thy FaithfulnessBill Brown Jr.1h 22m$10
Inglês Simplicado E Para Todos.Castigo Hilário Massave1m$11 · $0.00
The Art & Practice of TypographyEdmund G. Gress10h 53m$2 · $0.00
A Short History Of ArchitectureArthur Lyman Tuckerman4h 30m$2.40