Data Analysis using SQL and Excel shows business managers and data analysts how to use the relatively simple tools of SQL and Excel to extract useful business information from relational databases. The book is organized around chapters that become increasingly complex in the use of SQL, Excel, and data mining concepts. Each chapter will explain:
· 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
· What the results look like in SQL and Excel

About the Author

Gordon S. Linoff is a cofounder of Data Miners, Inc., a consultancy specializing in data mining. He is the coauthor of the bestselling Data Mining Techniques, Second Edition, and Mastering Data Mining (both from Wiley). He has more than a decade of experience applying data mining techniques to business problems in marketing and customer relationship management.

Table of Contents:
Introduction · A Data Miner Looks at SQL · What's in a Table? Getting Started with Data Exploration · How Different is Different? · Where is it all Happening? Location, Location, Location · It is a Matter of Time · How Long Will Customers Last? Survival Analysis to Understand Customers and Their Value · Factors Affecting Survival: The What and Why of Customer Tenure · Customer Purchases and Other Repeated Events · What's in a Shopping Cart? Market Basket Analysis and Association Rules · Data Mining Models in SQL · The Best Fit Line: Linear Regression Models · Building Customer Signatures for Further Analysis Appendix A. Equivalent Constructs Among Databases Index