Items related to Modern Data Analytics in Excel: Using Power Query,...

Modern Data Analytics in Excel: Using Power Query, Power Pivot, and More for Enhanced Data Analytics - Softcover

  • 4.75 out of 5 stars
    8 ratings by Goodreads
 
9781098148829: Modern Data Analytics in Excel: Using Power Query, Power Pivot, and More for Enhanced Data Analytics

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

"synopsis" may belong to another edition of this title.

About the Author

George Mount is the founder of Stringfest Analytics, a consulting firm specializing in analytics professional development. He has worked with leading bootcamps, learning platforms and practice organizations to help individuals excel at analytics.

George is the recipient of Microsoft's Most Valuable Professional (MVP) award for exceptional technical expertise and community advocacy in Excel, as well as the author of Advancing into Analytics: From Excel to Python and R (O'Reilly Media, 2021). He resides in Cleveland, Ohio.

"About this title" may belong to another edition of this title.

Buy Used

Condition: Very Good
Ship within 24hrs. Satisfaction...
View this item

FREE shipping within U.S.A.

Destination, rates & speeds

Search results for Modern Data Analytics in Excel: Using Power Query,...

Stock Image

Mount, George
Published by O'Reilly Media (edition 1), 2024
ISBN 10: 1098148827 ISBN 13: 9781098148829
Used Paperback

Seller: BooksRun, Philadelphia, PA, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback. Condition: Very Good. 1. Ship within 24hrs. Satisfaction 100% guaranteed. APO/FPO addresses supported. Seller Inventory # 1098148827-8-1

Contact seller

Buy Used

US$ 29.51
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: 2 available

Add to basket

Stock Image

Mount, George
Published by O'Reilly Media, 2024
ISBN 10: 1098148827 ISBN 13: 9781098148829
Used Softcover

Seller: SecondSale, Montgomery, IL, U.S.A.

Seller rating 4 out of 5 stars 4-star rating, Learn more about seller ratings

Condition: Good. Item in good condition. Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00078603638

Contact seller

Buy Used

US$ 31.94
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: 3 available

Add to basket

Stock Image

Mount, George
Published by O'Reilly Media, 2024
ISBN 10: 1098148827 ISBN 13: 9781098148829
Used Softcover

Seller: SecondSale, Montgomery, IL, U.S.A.

Seller rating 4 out of 5 stars 4-star rating, Learn more about seller ratings

Condition: Very Good. Item in very good condition! Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00077256404

Contact seller

Buy Used

US$ 31.94
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: 2 available

Add to basket

Seller Image

Mount, George
Published by O'Reilly Media, 2024
ISBN 10: 1098148827 ISBN 13: 9781098148829
New Softcover

Seller: GreatBookPrices, Columbia, MD, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. Seller Inventory # 46657649-n

Contact seller

Buy New

US$ 41.65
Convert currency
Shipping: US$ 2.64
Within U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Seller Image

Mount, George
Published by O'Reilly Media 6/4/2024, 2024
ISBN 10: 1098148827 ISBN 13: 9781098148829
New Paperback or Softback

Seller: BargainBookStores, Grand Rapids, MI, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback or Softback. Condition: New. Modern Data Analytics in Excel: Using Power Query, Power Pivot, and More for Enhanced Data Analytics 0.87. Book. Seller Inventory # BBS-9781098148829

Contact seller

Buy New

US$ 44.30
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: 5 available

Add to basket

Seller Image

Mount, George
Published by O'Reilly Media, 2024
ISBN 10: 1098148827 ISBN 13: 9781098148829
Used Softcover

Seller: GreatBookPrices, Columbia, MD, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: As New. Unread book in perfect condition. Seller Inventory # 46657649

Contact seller

Buy Used

US$ 45.94
Convert currency
Shipping: US$ 2.64
Within U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Stock Image

Mount, George
Published by O'Reilly Media, 2024
ISBN 10: 1098148827 ISBN 13: 9781098148829
New Softcover

Seller: California Books, Miami, FL, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. Seller Inventory # I-9781098148829

Contact seller

Buy New

US$ 50.00
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Stock Image

George Mount
Published by O'Reilly Media, Sebastopol, 2024
ISBN 10: 1098148827 ISBN 13: 9781098148829
New Paperback

Seller: Grand Eagle Retail, Mason, OH, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback. Condition: new. Paperback. 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 About the AuthorGeorge Mount develops data analytics curriculum and training programs through his company Stringfest Analytics. He's been featured on industry outlets such as Excel TV and the MyExcelOnline podcast through his website. His blog features content on Excel and, more generally, business analytics, training, and career development. He holds a master's degree in information systems with a certificate of achievement in quantitative methods from Case Western Reserve University. If you haven't modernized your data cleaning and reporting processes in Microsoft Excel, you're missing out on big productivity gains. This practical book serves as an introduction to the modern Excel suite of features along with other powerful tools for analytics. Shipping may be from multiple locations in the US or from the UK, depending on stock availability. Seller Inventory # 9781098148829

Contact seller

Buy New

US$ 53.30
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

George Mount
Published by O'Reilly Media, 2024
ISBN 10: 1098148827 ISBN 13: 9781098148829
New PAP

Seller: PBShop.store US, Wood Dale, IL, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

PAP. Condition: New. New Book. Shipped from UK. Established seller since 2000. Seller Inventory # GB-9781098148829

Contact seller

Buy New

US$ 53.40
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: 3 available

Add to basket

Seller Image

George Mount
Published by O'Reilly Media, US, 2024
ISBN 10: 1098148827 ISBN 13: 9781098148829
New Paperback

Seller: Rarewaves USA, OSWEGO, IL, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback. Condition: New. 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 QueryCreate relational data models and analysis measures with Power PivotPull data quickly with dynamic arraysUse AI to uncover patterns and trends from inside ExcelIntegrate Python functionality with Excel for automated analysis and reporting. Seller Inventory # LU-9781098148829

Contact seller

Buy New

US$ 55.80
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

There are 19 more copies of this book

View all search results for this book