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
Mostrar todos os capítulosVer menos
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
LiftoffEric Berger9h 4m4.6 (9.5K)$29 · $0.00
The Honey BusMeredith May9h 31m4.4 (16.6K)$25 · $0.00
Collected Writings of Nikola TeslaThomas Commerford Martin, Nikola Tesla19h 42m4.4 (2.8K)$1.99 · $0.00
Operation PedestalMax Hastings12h 29m4.4 (5.2K)$29 · $0.00
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
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
Learn German for Beginners - Lesson 2Jasmin Voges38m$12 · $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
Handicraft for boysA. Frederick Collins6h 45m$2 · $0.00
AfghansSpool Cotton Co.33m$1 · $0.00