data analysis using sql/plsql

Data Analysis Using SQL and Excel
Gordon S. Linoff
ISBN: 978-0-470-09951-3
Paperback
645 pages
October 2007


* 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
* 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
* Presents hints, warnings, and technical asides about Excel, SQL, and data analysis/mining

Chapter 1 A Data Miner Looks at SQL.

Chapter 2 What’s In a Table? Getting Started with Data Exploration.

Chapter 3 How Different Is Different?

Chapter 4 Where Is It All Happening? Location, Location, Location.

Chapter 5 It’s a Matter of Time.

Chapter 6 How Long Will Customers Last? Survival Analysis to Understand Customers and Their Value.

Chapter 7 Factors Affecting Survival: The What and Why of Customer Tenure.

Chapter 8 Customer Purchases and Other Repeated Events.

Chapter 9 What’s in a Shopping Cart? Market Basket Analysis and Association Rules.

Chapter 10 Data Mining Models in SQL.

Chapter 11 The Best-Fit Line: Linear Regression Models.

Chapter 12 Building Customer Signatures for Further Analysis.

Appendix Equivalent Constructs Among Databases.

Code:

http://rapidshare.com/files/76425785/Wiley.Data.Analysis.Using.SQL.and.Excel.Oct.2007.pdf