Books  Data Analysis & Modelling  Data Analysis & Statistics 

Data Analysis Using SQL and Excel

Out of Print

By: Gordon S Linoff(Author)

744 pages, illustrations

John Wiley & Sons

Paperback | Oct 2007 | #220893 | ISBN-13: 9780470099513
Out of Print Details

About this book

Useful business analysis requires you to effectively transform data into actionable information. Data Analysis Using SQL and Excel helps you use SQL and Excel to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more. Each chapter explains when and why to perform a particular type of business analysis in order to obtain useful results, how to design and perform the analysis using SQL and Excel, and what the results should look like.



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

Write a review

There are currently no reviews for this product. Be the first to review this product!


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.

Bestsellers in this subject

Choosing and Using Statistics

NHBS Price: £28.10 $38/€32 approx

Statistics for Ecologists Using R and Excel

NHBS Price: £34.99 $47/€39 approx

Handbook of Meta-analysis in Ecology and Evolution

NHBS Price: £62.95 $85/€71 approx

The New Statistics with R

NHBS Price: £29.99 $41/€34 approx


NHBS Price: £60.99 $83/€69 approx

VAT: GB 407 4846 44
NHBS Ltd is registered in England and Wales: 1875194