Data Warehousing with SPSS

Data Warehousing is the process of putting your data together so that it makes analysis and report creation simple, fast, efficient, error-free, and cost effective.  

My data warehouses are:

  • Designed to be "punch of a button" easy to run.
  • Designed to allow for quick and easy ad-hoc analyses and reporting.
  • Designed with automated file builds and automated standard reporting.
  • Designed using well structured code making them easy to maintain.
  • Designed with automatic data verification routines to spot any problems.
  • Well documented externally (how to run, how to maintain, sources of data files, data contacts, flowcharts/diagrams of program and data flows, etc.).
  • Well documented internally, with the standard program information (name of program, author, purpose, file and data sources, change log, etc) as well as references to the specifications driving that particular piece of code, any deficiencies in the data, clarifications of complex procedures, etc.

The typical enterprise has data stored in a variety of formats, with multiple types of software, and often stored on different operating systems. My data warehousing approach is to combine all of this information into a small set of files (generally 2 to 3) that contain all of the information commonly used for reporting and/or data mining. By having your information all in one place and in one format, reporting and exploration become much easier.  I like to call it putting all of your data in one pot where it's easy to find and use.

Our Data Warehousing Project Options:

We can handle data warehousing projects in a number of ways. We can charge by the week (40 hours), and are very flexible in how we will structure the project to your needs and schedule.  

We tailor each data warehouse project to the customer's needs. Depending on the systems requirements and level of your staff's expertise, we will customize the project so that the end result will be both a data warehouse, and someone at your organization who can use and maintain it. 

For sites where the staff have minimal or no SPSS skills, we can combine the data warehousing project with SPSS training so that your staff develops the necessary programming skills through building pieces of the data warehouse and eventually putting it all together.

This is the most effective method of training because your staff actually works on the implementation of your data warehouse. This means that your staff will be intimately knowledgeable about the inner workings of your warehouse, how best to use it and, perhaps more importantly, how to maintain it.

For the duration of the project, we will be working along side your staff doing the research and coding the SPSS systems, as well as operating as expert consultants for your staff when they have questions (and there are typically many questions).

Working Long Distance

And please note:  We do not have to be in the same place at the same time to accomplish all of this. We can do all of the work long distance.  This includes customer support, where we connect to your computer and provide you the programming, training, or support you need at the time.


The cost for all services is $100/hour.   The cost for data warehousing projects over 100 hours is $60/hour.  If you live in Texas, we add sales tax, which is 8.25% in Austin.