Data Miners Logo
Home About Us Consulting Services Conferences and Classes Links Contact Us
Selected Books Companion Pages Search
Bookstore illustration  

Companion page for Data Analysis Using SQL and Excel

by Gordon S. Linoff. 2008 John Wiley & Sons.

To order Data Analysis Using SQL and Excel from Amazon click here .

What This Page Contains

This page is a companion page for the book Data Analysis Using SQL and Excel. It provides the data sets and scripts for loading the data sets, and Excel files 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:

  1. Microsoft SQL Server (free/trial download available at SQL Server download )
  2. MySQL (free/trial download available at MySQL download )
  3. SAS (free/trial download not available)
  4. Oracle (free/trial download at Oracle download )

In addition, SAS files are provided as a compressed library.

The queries have not been validated on other databases, such as PostgreSQL (free/trial download available at PostgreSQL download ).

Instructions for Downloading and Installing
  1. Download the text files.
  2. Download the appropriate script for your environment.
  3. 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 using an ftp tool or the ftp command line interface.

    mysql.sql. Script for loading data into a mysql database.

    sql-server.sql. Script for loading data into a Microsoft SQL Server database. Script for loading data into SAS datasets. 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, 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
    No file associated with this chapter


Visit Roberta Sutter Web Design