Название: Modern Data Analytics in Excel: Using Power Query, Power Pivot, and More for Enhanced Data Analytics
Автор: George Mount
Издательство: O’Reilly Media, Inc.
Год: 2024
Страниц: 244
Язык: английский
Формат: pdf (true), epub (true)
Размер: 19.3 MB, 15.9 MB

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.

To make the most of this book, it is recommended that you have a Windows computer with the Microsoft 365 version of Excel for desktop. The features covered in this book are relatively new and may not be available in older Excel versions. Please note that many of these tools are still being developed for Mac, and compatibility may vary. Due to the fast-paced nature of Excel’s development, it is difficult to provide a precise list of what’s available for each version.

Chapter 7 of the book briefly explains how to load a Data Model from Excel into Power BI. It assumes that, as a Microsoft 365 for Windows user, you already have the free version of Power BI Desktop installed on your computer. Chapter 12 delves into the integration of Python with Excel, guiding you through the process of downloading Python for free. All subsequent tasks and exercises within the book are designed to be completed exclusively within Excel, eliminating the need for external programs. However, you will configure a few Excel add-ins as part of the process.

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