Shop all O'Reilly Media

Modern Data Analytics in Excel - by George Mount (Paperback)

Name: Modern Data Analytics in Excel - by George Mount (Paperback)
Brand: O'Reilly Media
SKU: 90099352
Price: 38.31 USD
Availability: InStock

undefined out of 5 stars with 0 reviews

5 Questions

$38.31Save $21.68 (36% off)

In Stock

Free & easy returns

Return this item by mail or in store within 90 days for a full refund.

Eligible for registries and wish lists

Save 5% every day

With Target Circle™ Card

About this item

Details

Highlights

If you haven't modernized your data cleaning and reporting processes in Microsoft Excel, you're missing out on big productivity gains.
Author(s): George Mount
241 Pages
Computers + Internet,

Description

About the Book

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.

Book Synopsis

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

Specifications

Dimensions (Overall): 9.19 Inches (H) x 7.0 Inches (W) x .51 Inches (D)

Weight: .87 Pounds

Suggested Age: 22 Years and Up

Number of Pages: 241

Genre: Computers + Internet

Publisher: O'Reilly Media

Format: Paperback

Author: George Mount

Language: English

Street Date: June 4, 2024

TCIN: 90099352

UPC: 9781098148829

Item Number (DPCI): 247-26-0994

Origin: Made in the USA or Imported

If the item details aren’t accurate or complete, we want to know about it.

Shipping & Returns

Shipping details

Estimated ship dimensions: 0.51 inches length x 7 inches width x 9.19 inches height

Estimated ship weight: 0.87 pounds

We regret that this item cannot be shipped to PO Boxes.

This item cannot be shipped to the following locations: American Samoa (see also separate entry under AS), Guam (see also separate entry under GU), Northern Mariana Islands, Puerto Rico (see also separate entry under PR), United States Minor Outlying Islands, Virgin Islands, U.S., APO/FPO, Alaska, Hawaii

Return details

This item can be returned to any Target store or Target.com.

This item must be returned within 90 days of the date it was purchased in store, delivered to the guest, delivered by a Shipt shopper, or picked up by the guest.

See the return policy for complete information.