Modern Data Analytics in Excel: Using Power Query, Power Pivot, and More for Enhanced Data Analytics

Modern Data Analytics in Excel: Using Power Query, Power Pivot, and More for Enhanced Data Analytics
by 作者: George Mount (Author)
Publisher Finelybook 出版社: O’Reilly Media
Edition 版本: 1st
Publication Date 出版日期: 2024-06-04
Language 语言: English
pages 页数: : 241 pages
ISBN-10 书号: 1098148827
ISBN-13 书号: 9781098148829

Book Description

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


“As an Excel teacher, the book helped me to gain a better knowledge in data analysis and gave me new ideas on how to teach materials. I found the explanations in the book very valuable. Not only do I know HOW to use some functionalities, but also WHEN and WHY. I loved the great explanations, I can learn much more efficiently if I truly understand the material. The book was very well-written , easy to understand and full with interesting background information.”
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 Mount is the founder of Stringfest Analytics, a consulting firm specializing in analytics professional development. He has worked with leading bootcamps, learning platforms and practice organizations to help individuals excel at analytics.
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.

Amazon page


Formats: PDF, EPUB | 33.4 MB

下载地址 Download解决验证以访问链接!
未经允许不得转载:finelybook » Modern Data Analytics in Excel: Using Power Query, Power Pivot, and More for Enhanced Data Analytics