Companion page for Data Analysis Using SQL
by Gordon S. Linoff. 2008 John Wiley & Sons.
To order Data Analysis Using SQL and Excel from
What This Page Contains
This page is a companion page for the book Data
Analysis Using SQL and Excel. It provides
data sets and scripts
for loading the data sets, and
associated with the book. The information on this
page is deemed accurate, but we are not responsible
for errors and omissions.
The data files are provided as compressed text files
with scripts for the following databases:
- Microsoft SQL Server (free/trial
download available at
Server download )
- MySQL (free/trial download available
- SAS (free/trial download not available)
- Oracle (free/trial download at Oracle
In addition, SAS files are provided as a compressed
queries have not been validated on other databases,
such as PostgreSQL (free/trial download available
Instructions for Downloading and Installing
- Download the text files.
- Download the appropriate script for your environment.
- Follow the instructions inside the script.
Scripts and Datasets
In many browsers, right clicking on a file link
will bring up a menu with a download, save target
as or save to disk option. If your
browser cannot handle these links, you may also obtain
the files via anonymous ftp from ftp.data-miners.com
using an ftp tool or the ftp command line interface.
Script for loading data into a mysql database.
Script for loading data into a Microsoft SQL Server
Script for loading data into SAS datasets.
oracle-scripts.zip. Scripts for loading data into an Oracle database.
The data files.
The SAS files.
Excel Files with Charts and Queries
All Excel files
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,
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
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
Chapter 12 Building Customer Signatures for
No file associated with this chapter