Automated Data Analysis Using Excel Second Edition Data Mining Book

Unlock the power of data analysis with this comprehensive guide! Dive into the world of automated data analysis using Excel, Second Edition, a valuable resource for anyone looking to master data mining and knowledge discovery. This book covers key topics relating to the latest version of MS Office through Excel 2019, including the creation of custom ribbons by injecting XML code into Excel Workbooks and how to link Excel VBA macros to customize ribbon objects. It now also provides examples in using ADO, DAO, and SQL queries to retrieve data from databases for analysis. Operations such as fully automated linear and non-linear curve fitting, linear and non-linear mapping, charting, plotting, sorting, and filtering of data have been updated to leverage the newest Excel VBA object models. The text provides examples on automated data analysis and the preparation of custom reports suitable for legal archiving and dissemination. Perfect for students, researchers, and professionals alike, this book is your key to unlocking insights and making data-driven decisions. Ideal for use in academic settings, professional development courses, or self-study. Type: Textbook Author: Brian D. Bissett, Chapman & Hall/CRC Publication Name: Automated Data Analysis Using Excel Subject: Data Analysis, Data Mining, Business Analytics, Statistical Analysis, Data Science Subject Area: Mathematics, Computer Science, Business, Statistics Publication Year: 2019 Format: Book, Textbook