Mount, George
Modern Data Analytics in Excel: Using Power Query, Power Pivot, and More for Enhanced Data Analytics
- ISBN 13:
- 9781098148829
- author:
- Mount, George
- format:
- Paperback
- publisher:
- O'Reilly Media
- language:
- English
- Publication Year:
- 2024
- Pages:
- 241
- Dimensions:
- 23.3 x 17.8 x 1.3 centimetres (0
- Genre:
- Computers, Applications, Microsoft Excel,
- Condition:
- New
- Availability:
- Item usually sent within 7 working days
Description
Unlock the full potential of Microsoft Excel with modern data analytics tools. This practical guide shows you how to build repeatable data cleaning workflows, design relational data models, and create dynamic reports using Power Query, Power Pivot, and more. You'll learn how to harness the power of Excel's latest features, including dynamic array functions, AI-powered insights, and Python integration, to uncover patterns and trends in your data. With this book, you'll be able to automate analysis and reporting, making it easier to make informed business decisions. Whether you're a business analyst, data analyst, or business intelligence specialist, this book provides the tools and techniques you need to take your Excel skills to the next level.