Modern Data Analytics in Excel: Using Power Query, Power Pivot and More for Enhanced Data Analytics 1st Edition 275956

Код товару: 275956Паперова книга
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 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.
1'700 ₴
Купити
Monobank
до 10 платежей
от 191 ₴ / міс.
  • Нова Пошта
    Безкоштовно від 3'000,00 ₴
  • Укрпошта
    Безкоштовно від 1'000,00 ₴
  • Meest Пошта
    Безкоштовно від 3'000,00 ₴
Modern Data Analytics in Excel: Using Power Query, Power Pivot and More for Enhanced Data Analytics 1st Edition - фото 1

Характеристики

  • Бренд
  • Автор
  • Категорія
    Програмування
  • Рік
    2024
  • Сторінок
    300
  • Формат
    165х235 мм
  • Обкладинка
    М'яка
  • Тип паперу
    Офсетний
  • Мова
    Англійська
  • Ілюстрації
    Чорно-білі

Від видавця

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

Відгуки про Modern Data Analytics in Excel: Using Power Query, Power Pivot and More for Enhanced Data Analytics 1st Edition

Modern Data Analytics in Excel: Using Power Query, Power Pivot and More for Enhanced Data Analytics 1st Edition
Modern Data Analytics in Excel: Using Power Query, Power Pivot and More for Enhanced Data Analytics 1st Edition
1'700 ₴
Купити
Java без збоїв
1681
Стивен Стелтинг
85 ₴
Hands-On Smart Contract Development with Hyperledger Fabric V2. Building Enterprise Blockchain Applications. 1st Ed.
244754
Matt Zand, Xun Wu
2'300 ₴
Machine Learning and Generative AI for Marketing: Take your data-driven marketing strategies to the next level using Python
308962
Yoon Hyup HwangNicholas C. Burtch
1'400 ₴
UX Design with Figma: User-Centered Interface Design and Prototyping with Figma (Design Thinking) First Edition
305812
Tom GreenKevin Brandon
1'600 ₴
Version Control with Git: Powerful Tools and Techniques for Collaborative Software Development 3rd Edition
256215
Prem Kumar PonuthoraiJon Loeliger
1'700 ₴1'581 ₴
Game Development with GameMaker: A Primer on Game Development and Design Second Edition
291028
Sebastiano M. Cossu
2'400 ₴
Programming WebRTC: Build Real-Time Streaming Applications for the Web 1st Edition
275785
Karl Stolley
1'700 ₴