Modern Data Analytics in Excel

Using Power Query, Power Pivot and More for Enhanced Data Analytics

Paperback Engels 2024 1e druk 9781098148829
€ 69,92
Levertijd ± 16 werkdagen
Gratis verzonden

Samenvatting

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

Specificaties

ISBN13:9781098148829
Taal:Engels
Bindwijze:paperback
Aantal pagina's:300
Uitgever:O'Reilly
Druk:1
Verschijningsdatum:30-4-2024
Hoofdrubriek:IT-management / ICT

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Inhoudsopgave

Preface
Learning Objective
Prerequisites
Technical Requirements
Technological Requirements
How I Got Here
What Is “Modern Analytics”? Why Excel?
Book Overview
Part I, Data Cleaning and Transformation with Power Query
Part II, Data Modeling and Analysis with Power Pivot
Part III, The Excel Data Analytics Toolkit
End-of-Chapter Exercises
This Is Not a Laundry List
Conventions Used in This Book
Using Code Examples
O’Reilly Online Learning
How to Contact Us
Acknowledgments

I. Data Cleaning and Transformation with Power Query
1. Tables: The Portal to Modern Excel
Creating and Referring to Table Headers
Viewing the Table Footers
Naming Excel Tables
Formatting Excel Tables
Updating Table Ranges
Organizing Data for Analytics
Conclusion
Exercises

2. First Steps in Excel Power Query
What Is Power Query?
Power Query as Excel Myth Buster
“Excel Is Not Reproducible”
“Excel Does Not Have a True null”
“Excel Can’t Process More Than 1,048,576 Rows”
Power Query as Excel’s ETL Tool
Extract
Transform
Load
A Tour of the Power Query Editor
The Ribbon Menu
Queries
The Imported Data
Exiting the Power Query Editor
Returning to the Power Query Editor
Data Profiling in Power Query
What Is Data Profiling?
Exploring the Data Preview Options
Overriding the Thousand-Row Limit
Closing Out of Data Profiling
Conclusion
Exercises

3. Transforming Rows in Power Query
Removing the Missing Values
Refreshing the Query
Splitting Data into Rows
Filling in Headers and Cell Values
Replacing Column Headers
Filling Down Blank Rows
Conclusion
Exercises
Afgekapt op 63 regels

Managementboek Top 100

€ 69,92
Levertijd ongeveer 16 werkdagen
Gratis verzonden

Rubrieken

Producten

    Auteurs

      Trefwoorden

        Artikelen

          Modern Data Analytics in Excel