Data Analysis Using SQL and Excel

One of the leading experts on business data mining shows managers how to leverage SQL and Excel to perform sophisticated types of business analysis without the expense of data mining tools and consultants. This book explains how to use the relatively simple tools of SQL and Excel to extract useful business information from relational databases. Each chapter discusses why and when to perform a particular type of business analysis to obtain a useful business result, how to design and perform the analysis using SQL and Excel, and what the results look like in SQL and Excel. It presents hints, warnings, and technical asides about Excel, SQL, and data analysis/mining.