Data Miners Logo
Home About Us Consulting Services Conferences and Classes Links Contact Us
Selected Books Companion Pages Search Amazon.com
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.

Data

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 ftp.data-miners.com 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.

    sas-script.sas. Script for loading data into SAS datasets.

    oracle-scripts.zip. Scripts for loading data into an Oracle database.

    textfiles.zip. The data files.

    saslib.zip. The SAS files.

Excel Files with Charts and Queries

All Excel files
    all-chapters.zip
Chapter 1 A Data Miner Looks at SQL
    chapter-01.xls
Chapter 2 Whatís In a Table? Getting Started with Data Exploration
    chapter-02.xls
Chapter 3 How Different Is Different?
    chapter-03.xls
Chapter 4 Where Is It All Happening? Location, Location, Location
    chapter-04.xls
Chapter 5 Itís a Matter of Time
    chapter-05.xls
Chapter 6 How Long Will Customers Last? Survival Analysis to Understand Customers and Their Value
    chapter-06.xls
Chapter 7 Factors Affecting Survival: The What and Why of Customer Tenure
    chapter-07.xls
Chapter 8 Customer Purchases and Other Repeated Events
    chapter-08.xls
Chapter 9 Whatís in a Shopping Cart? Market Basket Analysis and Association Rules
    chapter-09.xls
Chapter 10 Data Mining Models in SQL
    chapter-10.xls
Chapter 11 The Best-Fit Line: Linear Regression Models
    chapter-11.xls
Chapter 12 Building Customer Signatures for Further Analysis
    No file associated with this chapter

 


Visit Roberta Sutter Web Design