Modern Data Analytics in Excel: Using Power Query, Power Pivot, and More for Enhanced Data Analytics
Author: George Mount (Author)
Publisher finelybook 出版社: O’Reilly Media
Edition 版次: 1st
Publication Date 出版日期: 2024-06-04
Language 语言: English
Print Length 页数: 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
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.
