George Mount - Böcker
Visar alla böcker från författaren George Mount. Handla med fri frakt och snabb leverans.
3 produkter
3 produkter
Modern Data Analytics in Excel
Using Power Query, Power Pivot and More for Enhanced Data Analytics
Häftad, Engelska, 2024
431 kr
Skickas inom 7-10 vardagar
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
447 kr
Kommande
Add to your Excel toolkit by learning to implement advanced AI and automation techniques for data analysis As technology evolves all around us, professionals must keep learning new skills just to keep up with the heightened expectations of our leaders. That's especially true when it comes to artificial intelligence-related advancements in the field of data analysis. In Excel Power Tools: Unlocking the Power of AI, Python, and Power Automate, veteran analytics educator George Mount delivers a practical guide for everyday Excel users seeking to leverage the software's advanced features to import, clean, and analyze data. You'll learn to automate your data analysis and discover how to use power user features like pattern recognition, forecasting, and fuzzy matching. You'll: Develop a solid understanding of how to integrate AI into your work without radically changing the tools you use every dayLearn to use Python to automate routine data tasks and become more productive and efficientFind real-world examples of AI integration that illustrate the simple and accessible concepts discussed in the bookPerfect for professionals in routine reporting roles, including accountants, data analysts, financial analysts, marketing coordinators, controllers, and operations analysts, Excel Power Tools is also a must-read for data science professionals and other technical experts who wish to unlock the full capabilities of Excel.
473 kr
Skickas inom 7-10 vardagar
Data analytics may seem daunting, but if you're an experienced Excel user, you have a unique head start. With this hands-on guide, intermediate Excel users will gain a solid understanding of analytics and the data stack. By the time you complete this book, you'll be able to conduct exploratory data analysis and hypothesis testing using a programming language.Exploring and testing relationships are core to analytics. By using the tools and frameworks in this book, you'll be well positioned to continue learning more advanced data analysis techniques. Author George Mount, founder and CEO of Stringfest Analytics, demonstrates key statistical concepts with spreadsheets, then pivots your existing knowledge about data manipulation into R and Python programming.This practical book guides you through:Foundations of analytics in Excel: Use Excel to test relationships between variables and build compelling demonstrations of important concepts in statistics and analyticsFrom Excel to R: Cleanly transfer what you've learned about working with data from Excel to RFrom Excel to Python: Learn how to pivot your Excel data chops into Python and conduct a complete data analysis