Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.
Read instantly on your browser with Kindle for Web.
Using your mobile phone camera - scan the code below and download the Kindle app.
Follow the author
OK
Modern Data Analytics in Excel: Using Power Query, Power Pivot, and More for Enhanced Data Analytics
Purchase options and add-ons
If you haven't modernized your data cleaning and reporting processes in Microsoft Excel, you're missing out on big productivity gains. And if you're looking to conduct rigorous data analysis, more can be done in Excel than you think. This practical book serves as an introduction to the modern Excel suite of features along with other powerful tools for analytics.
George Mount of Stringfest Analytics shows business analysts, data analysts, and business intelligence specialists how to make bigger gains right from your spreadsheets by using Excel's latest features. You'll learn how to build repeatable data cleaning workflows with Power Query, and design relational data models straight from your workbook with Power Pivot. You'll also explore other exciting new features for analytics, such as dynamic array functions, AI-powered insights, and Python integration.
Learn how to build reports and analyses that were previously difficult or impossible to do in Excel. This book shows you how to:
- Build repeatable data cleaning processes for Excel with Power Query
- Create relational data models and analysis measures with Power Pivot
- Pull data quickly with dynamic arrays
- Use AI to uncover patterns and trends from inside Excel
- Integrate Python functionality with Excel for automated analysis and reporting
- ISBN-101098148827
- ISBN-13978-1098148829
- Edition1st
- PublisherO'Reilly Media
- Publication dateJune 4, 2024
- LanguageEnglish
- Dimensions7 x 0.5 x 9 inches
- Print length241 pages
Frequently bought together

Customers who viewed this item also viewed
The Definitive Guide to Power Query (M): Mastering complex data transformation with Power QueryPaperbackFREE Shipping on orders over $35 shipped by AmazonGet it as soon as Thursday, Jun 11
Master Your Data with Power Query in Excel and Power BI: Leveraging Power Query to Get & Transform Your Task FlowPaperbackFREE Shipping on orders over $35 shipped by AmazonGet it as soon as Thursday, Jun 11
Storytelling with Data: A Data Visualization Guide for Business ProfessionalsPaperbackFREE Shipping on orders over $35 shipped by AmazonGet it as soon as Thursday, Jun 11
Excel Power Pivot & Power Query For DummiesPaperbackFREE Shipping on orders over $35 shipped by AmazonGet it as soon as Friday, Jul 3Usually ships within 1 to 2 months
Advancing into Analytics: From Excel to Python and RPaperbackFREE Shipping by AmazonGet it as soon as Thursday, Jun 11Only 7 left in stock (more on the way).
Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365) (Business Skills)PaperbackFREE Shipping by AmazonGet it as soon as Thursday, Jun 11
Customers also bought or read
- Data Visualization with Microsoft Power BI: How to Design Savvy Dashboards
Paperback$41.33$41.33FREE delivery Thu, Jun 11 - SQL for Data Analysis: Advanced Techniques for Transforming Data into Insights
Paperback$36.49$36.49FREE delivery Thu, Jun 11 - The Definitive Guide to Power Query (M): Mastering complex data transformation with Power Query
Paperback$32.71$32.71Delivery Thu, Jun 11 - Python for Excel: A Modern Environment for Automation and Data Analysis
Paperback$61.50$61.50FREE delivery Thu, Jun 11 - Data Science for Business: What You Need to Know about Data Mining and Data-Analytic Thinking
Paperback$25.50$25.50Delivery Jun 14 - 16 - Python for Data Analysis: Data Wrangling with pandas, NumPy, and Jupyter
Paperback$43.99$43.99FREE delivery Thu, Jun 11 - Essential Math for Data Science: Take Control of Your Data with Fundamental Linear Algebra, Probability, and Statistics
Paperback$37.10$37.10FREE delivery Thu, Jun 11 - Master Your Data with Power Query in Excel and Power BI: Leveraging Power Query to Get & Transform Your Task Flow
Paperback$19.44$19.44Delivery Thu, Jun 11 - Storytelling with Data: A Data Visualization Guide for Business Professionals#1 Best SellerInformation Management
Paperback$23.18$23.18Delivery Thu, Jun 11 - Data Analysis in Microsoft Excel: Deliver Awesome Analytics in 3 Easy Steps Using VLOOKUPS, Pivot Tables, Charts And More
Paperback$19.99$19.99Delivery Thu, Jun 11 - Learning Microsoft Power BI: Transforming Data into Insights
Paperback$37.72$37.72FREE delivery Thu, Jun 11 - Practical Statistics for Data Scientists: 50+ Essential Concepts Using R and Python
Paperback$45.25$45.25FREE delivery Thu, Jun 11 - Power Query Beyond The User Interface: Solving Advanced Data Cleaning Problems Using M (Colour Version)
Paperback$62.99$62.99FREE delivery Thu, Jun 11 - R for Data Science: Import, Tidy, Transform, Visualize, and Model Data#1 Best SellerMathematical & Statistical Software
Paperback$44.99$44.99FREE delivery Thu, Jun 11 - Practical SQL, 2nd Edition: A Beginner's Guide to Storytelling with Data#1 Best SellerData Mining
Paperback$19.99$19.99Delivery Thu, Jun 11 - Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365) (Business Skills)
Paperback$51.22$51.22FREE delivery Thu, Jun 11 - Mastering Microsoft Power BI: Expert techniques to create interactive insights for effective data analytics and business intelligence, 2nd Edition
Paperback$39.84$39.84FREE delivery Thu, Jun 11 - Becoming a Data Head: How to Think, Speak, and Understand Data Science, Statistics, and Machine Learning
Paperback$22.30$22.30Delivery Thu, Jun 11 - Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas
Paperback$31.22$31.22Delivery Thu, Jun 11 - Collect, Combine, and Transform Data Using Power Query in Power BI and Excel (Business Skills)
Paperback$41.99$41.99FREE delivery Thu, Jun 11 - Building Interactive Dashboards in Microsoft 365 Excel: Harness the new features and formulae in M365 Excel to create dynamic, automated dashboards
Paperback$29.99$29.99Delivery Thu, Jun 11 - Data Modeling with Microsoft Excel: Model and analyze data using Power Pivot, DAX, and Cube functions
Paperback$36.99$36.99FREE delivery Thu, Jun 11 - The Big Book of Dashboards: Visualizing Your Data Using Real-World Business Scenarios
Paperback$27.53$27.53Delivery Jun 14 - 15 - Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot (Business Skills)
Paperback$46.56$46.56FREE delivery Jun 23 - 30
From the brand
-
Explore more Data Science
-
Start learning with O'Reilly
-
More From O'Reilly
-
Sharing the knowledge of experts
O'Reilly's mission is to change the world by sharing the knowledge of innovators. For over 40 years, we've inspired companies and individuals to do new things (and do them better) by providing the skills and understanding that are necessary for success.
Our customers are hungry to build the innovations that propel the world forward. And we help them do just that.
From the Publisher
What Is “Modern Analytics”? Why Excel?
Modern analytics refers to the use of advanced tools and techniques to prepare and analyze data, ranging from simple retrospective analyses to predictive modeling and artificial intelligence. In the evolving landscape of data-driven decision making, it’s essential to have tools that are versatile and interoperable, enabling users to perform a wide range of analytics activities.
Previously, Excel fell short in meeting these requirements. However, Excel has undergone significant transformation over the past decade, making it a true powerhouse for modern data analytics.
This book aims to dispel common misconceptions held by technical professionals about Excel and to demonstrate its capabilities in the modern analytics realm. By showcasing features such as Power Pivot, Power Query, and other tools, this book challenges the belief that Excel is limited to basic formulas and functions. It emphasizes that today’s Excel has evolved into a robust platform capable of handling complex data analytics tasks.
Ultimately, this book showcases Excel as a powerful and versatile tool for modern analytics. It seeks to debunk myths, guiding technical professionals and managers to fully exploit Excel’s potential for effective data analysis and decision making. In doing so, it enables users to harness Excel as a crucial component of the contemporary analytics toolkit, providing insights and driving success in our data-driven world.
Editorial Reviews
Review
Laura Szepesi
Excel Trainer and Consultant
"Modern Data Analytics in Excel is a must-read for analytics professionals eager to expand their expertise with Excel's latest features. The book covers an impressive array of techniques for cleaning and analyzing data, all within a remarkably concise format. I found the insights into Power Query and Power Pivot especially enlightening, but it was the author's ability to weave these concepts together into a clear and accessible narrative that truly stood out. Whether you're a seasoned analyst or just starting out, this book serves as a refreshing primer on the exciting possibilities now available in Excel. Highly recommended for anyone looking to elevate their analytics game."
Jeff Stevens
Data/BI Analyst
"This book gets to the core and is concise. All the relevant topics are covered for those wanting to learn data analysis in Excel. Those starting out in FP&A or looking to upskill would really benefit from reading this book."
Mark Depow, CPA, ACA, CFE
Financial Analyst
"What sets this book apart is its incredible capability of simplifying complex techniques for all level of users. From beginners to seasoned Excel users, you'll effortlessly understand and apply the concepts to your work. Combining Python, Excel, Power Query, and Power Pivot, it empowers you to explore boundless possibilities in data analysis and automation."
Carolina Lago
Managing Director, Tactic Financial
"I highly recommend Modern Data Analytics in Excel! In this book, Excel MVP George Mount takes us on a comprehensive journey through Microsoft Excel, showing how versatile it can be for data analytics. Starting with the basics and moving to more complex features like Power Query and Power Pivot, George does an excellent job breaking down advanced concepts into understandable pieces. What stands out is the practical approach used, with work files, exercises, and resource links that let you practice and explore as you learn. As someone reviewing this book from an accountant's perspective, I believe that its clarity and practicality make it a valuable reference resource for professionals who live in this world. Accountants, who often deal with complex datasets and require accurate analysis, will appreciate the review of fundamental to advanced analytics techniques.
The advanced topics explore how Excel is evolving to incorporate more advanced analytics, including the possibilities available through AI and Python integration. These topics can seem overwhelming, but George makes them less daunting and approachable. This foresight into Excel's role in future data analysis is helpful, suggesting ways professionals can stay ahead in their field. Looking to build (or enhance) your Excel data analytics skills? Pick up this book!"
Don Tomoff, MBA, CPA
Invenio Advisors, LLC
About the Author
George is the recipient of Microsoft's Most Valuable Professional (MVP) award for exceptional technical expertise and community advocacy in Excel, as well as the author of Advancing into Analytics: From Excel to Python and R (O'Reilly Media, 2021). He resides in Cleveland, Ohio.
Product details
- Publisher : O'Reilly Media
- Publication date : June 4, 2024
- Edition : 1st
- Language : English
- Print length : 241 pages
- ISBN-10 : 1098148827
- ISBN-13 : 978-1098148829
- Item Weight : 7.4 ounces
- Dimensions : 7 x 0.5 x 9 inches
- Best Sellers Rank: #716,515 in Books (See Top 100 in Books)
- #56 in Data Mining (Books)
- #61 in Business Intelligence Tools
- #63 in Spreadsheet Books
- Customer Reviews:
About the author

George Mount is the founder and CEO of Stringfest Analytics, a consulting firm specializing in analytics education and upskilling. He has worked with leading bootcamps, learning platforms and practice organizations to help individuals excel at analytics. George regularly blogs and speaks on data analysis, data education and workforce development.
George holds a bachelor’s degree in economics from Hillsdale College and master’s degrees in finance and information systems from Case Western Reserve University. He resides in Cleveland, Ohio.
Customer reviews
Customer Reviews, including Product Star Ratings help customers to learn more about the product and decide whether it is the right product for them.
To calculate the overall star rating and percentage breakdown by star, we don’t use a simple average. Instead, our system considers things like how recent a review is and if the reviewer bought the item on Amazon. It also analyzed reviews to verify trustworthiness.
Learn more how customers reviews work on AmazonTop reviews from the United States
- 5 out of 5 stars
Fantastic Book
Reviewed in the United States on July 9, 2024The author gives an outstanding overview of using modern Excel for analytics. At just over 200 pages (the print edition), the book cannot go into depth on all topics. It gives a broad overview and gets fairly detailed on Power Query and Power Pivot. Given the limited space, on numerous occasions, the author recommends subject specific books for additional details.
The author has a wonderful writing style that makes the book an easy read. That is not an easy accomplishment for a technical book. While the book has some great technical information, the strength of the book is the authors ability in explaining an approach to using the tools together in a cohesive strategy. Few if any technical books succeed on this level. I think highly enough of this book that I just order the author's previous book.
One person found this helpfulSending feedback...Sending feedback...HelpfulThank you for your feedback.Sorry, we failed to record your vote. Please try againThanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again - 5 out of 5 stars
A Happy Camper
Reviewed in the United States on September 15, 2024Modern Data Analytics in Excel is the book I wish I had when I was starting out: with Excel and as a Data Analyst. It is so clear, easy to follow, and very interesting. I'm so glad George wrote it.
For several years I often struggled because I didn't know about Power Query & Power Pivot. But you don't have to. Modern Data Analytics in Excel will get you up and running in no time with these 2 extremely powerful tools. Very much worth the price.
Sending feedback...Sending feedback...HelpfulThank you for your feedback.Sorry, we failed to record your vote. Please try againThanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again - 5 out of 5 stars
A hands-on way to learn for experienced Excel users
Reviewed in the United States on June 1, 2024Excel has changed a lot over the past 10 years, particularly for data analysis. For long-time Excel users like me, trying to learn how to use Power Query and Power Pivot is a bit of an uphill battle, especially since we're already comfortable analyzing data through functions (e.g., SUMIFS, AGGREGATE, etc.) and standard Pivot Tables.
I've been following the author on LinkedIn for sometime and had been looking forward to this book and it's exactly what I have been looking for. It comes with example files you can download and takes you through Power Query and Power Pivot so you can learn by doing. Highly recommended!
2 people found this helpfulSending feedback...Sending feedback...HelpfulThank you for your feedback.Sorry, we failed to record your vote. Please try againThanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again - 5 out of 5 stars
Must-Read for Analysts
Reviewed in the United States on April 28, 2024This book gives excellent tips to manipulate and analyze data in the latest version of Excel. Easy to follow and makes work much more efficient. I highly recommend it to anyone who works with a lot of data—make your life easier and buy this book.
3 people found this helpfulSending feedback...Sending feedback...HelpfulThank you for your feedback.Sorry, we failed to record your vote. Please try againThanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again - 2 out of 5 stars
Not worth the price, sorry
Reviewed in the United States on August 15, 2024The book is average black and white, regular paper- makes it difficult to read diagrams and excel snapshots. And for the price the book does not go into that level of details
2 people found this helpfulSending feedback...Sending feedback...HelpfulThank you for your feedback.Sorry, we failed to record your vote. Please try againThanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again - 5 out of 5 stars
Great resource for analysts!
Reviewed in the United States on May 8, 2024Do you want to become a highly valued team member who is considered a go-to resource for others? Read this book! I say this as a former analyst and former senior leader in a bank. This book will help you advance in your career both technically and as a leader.
Sending feedback...Sending feedback...HelpfulThank you for your feedback.Sorry, we failed to record your vote. Please try againThanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again - 5 out of 5 stars
Useful , get an overview.
Reviewed in the United States on May 1, 2024As expected, concise and focused.
Very helpful to get the needed overview.
Easily read yet packed with actionable info.
Sending feedback...Sending feedback...HelpfulThank you for your feedback.Sorry, we failed to record your vote. Please try againThanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again - 5 out of 5 stars
Analysis
Reviewed in the United States on May 3, 2024Another outstanding contribution to the world of data analysis from Stringfest. Concise and well written.
Terry
Sending feedback...Sending feedback...HelpfulThank you for your feedback.Sorry, we failed to record your vote. Please try againThanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again
Top reviews from other countries
DK_851 out of 5 starsSchwaches Buch
Reviewed in Germany on October 24, 2025Das Buch ist für diesen Preis eine Unverschämtheit. Ich konnte ein, zwei nützliche Tipps mitnehmen. Ansonsten bleibt das Buch größtenteils sehr oberflächlich und geht thematisch kaum in die Tiefe, bis es auf einmal zum Schluss fast schon auf Coding-Ebene u.a. bezgl. Python abdriftet. Ich hatte von Anfang an ein komisches Gefühl, wie man auf so wenig Seiten diese komplexen Themen adäquat abbilden wollte. Ich habe definitiv weitaus hilfreichere und bessere Excel- u. Datenmodellbücher.
Sending feedback...Thanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again













