Target New ArrivalsFourth of JulyBack to SchoolCollegeClothing, Shoes & AccessoriesHome & DecorKitchen & DiningOutdoor Living & GardenGroceryHousehold EssentialsBabyBeautyPersonal CareSports & OutdoorsHealthWellnessSchool & Office SuppliesToys & GamesElectronicsVideo GamesMovies, Music & BooksParty SuppliesGift IdeasGift CardsPetsUlta Beauty at TargetShop by CommunityTarget OpticalDealsClearanceNew ArrivalsBack to SchoolCollegeTop DealsTarget Circle DealsWeekly AdShop Order PickupShop Same Day DeliveryRegistryRedCardTarget CircleFind Stores
Modern Data Analytics in Excel - by George Mount (Paperback) - 1 of 1

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

$38.31Save $21.68 (36% off)

In Stock

Free & easy returns
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

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



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
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 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.

Q: What is the main focus of the book?

submitted by AI Shopping Assistant - 3 months ago

  • A: The book focuses on modernizing data cleaning and reporting processes in Microsoft Excel to enhance productivity.

    submitted byAI Shopping Assistant - 3 months ago
    Ai generated

Q: What features are discussed for data analysis in Excel?

submitted by AI Shopping Assistant - 3 months ago

  • A: The book covers features like Power Query, Power Pivot, dynamic arrays, AI insights, and Python integration.

    submitted byAI Shopping Assistant - 3 months ago
    Ai generated

Q: How does the book help with data cleaning?

submitted by AI Shopping Assistant - 3 months ago

  • A: It teaches how to build repeatable data cleaning workflows using Power Query for efficient data management.

    submitted byAI Shopping Assistant - 3 months ago
    Ai generated

Q: What is the target audience for this book?

submitted by AI Shopping Assistant - 3 months ago

  • A: The book is aimed at business analysts, data analysts, and business intelligence specialists seeking advanced Excel techniques.

    submitted byAI Shopping Assistant - 3 months ago
    Ai generated

Q: Who is the author of this book?

submitted by AI Shopping Assistant - 3 months ago

  • A: The author of the book is George Mount, associated with Stringfest Analytics.

    submitted byAI Shopping Assistant - 3 months ago
    Ai generated
See all questions (5)

Additional product information and recommendations

Discover more options

Frequently bought together

Best-selling Computers & Technology Books

Get top deals, latest trends, and more.

Privacy policy
Terms