SPSS Statistical Services for SQL2005

The second potentially interesting set of BI-related tools today I saw mentioned on Jamie MacLennan’s blog: a beta of SPSS Statistical Services for SQL2005, which you can find out more about here:

A quick look at the user guide, which is also downloadable, shows what it’s all about. For AS2005 users there’s an addin for the Business Intelligence Development Studio which allows you to do two things: create calculated columns in your dsv which bin/band/bucketise values (for example if you had a Customer Age column you could use this to create a column which grouped ages into a number of age range categories), and explore the data in SPSS. For SSIS users there are a bunch of data flow and transformation components to do things like interact with SPSS data sources, do anomaly detection, and use various SPSS statistical functions.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: