DMDW Lesson 02 – Data Mining Basics with Adventure Works

I’m planning to repeat the 15 example questions (“homework”) tomorrow.
We will continue by normalizing a database table together on the white board.

I am sure that most of you (my students) have never done any data mining stuff before.
This is great, since I love it to throw students directly into the cold water for their first swimming lesson! :mrgreen:

I’m expecting that you have the following tools
and resources on your laptop:

• Microsoft Visual Studio 2008 (not 2010, not Express!)
• SQL Server 2008 (not Express!)
• MSSQL Server Community Projects & Samples
  http://www.codeplex.com/SqlServerSamples
  (e.g. SQL2008.All_Product_Samples_Without_DBs.x86.msi)
• Adventure Works Databases for SQL Server 2008
  http://msftdbprodsamples.codeplex.com
  (e.g. AdventureWorks2008_SR4.exe)

There aren’t big differences in the various releases. I’m using an unpatched SQL Server 2008. Never versions of the SQL Server or the Samples will work, too. We will use the Data-Mining tools that Microsoft is giving to us. It will be you task to repeat everything at home.

Please keep in mind that Microsoft Visual Studio 2010 does not support Business Intelligence Development Studio Integration Services projects for SQL Server 2008 (R2). To work around this issue, you will have install Visual Studio 2008 alongside Visual Studio 2010 on the same machine and then open the Business Intelligence Development Studio projects in Visual Studio 2008.

Here is the guide that I will follow:
http://msdn.microsoft.com/en-us/library/ms167167.aspx

Update: Here are the slides!