DMDW lecture
DMDW Lesson 04 – Data Mining Theory
On 23, Mrz 2011 | inDMDW lecture | vonJohannes Hoppe
In this lecture we will concentrate on the theory behind data mining.
We will also look at an already seen algorithm: the decision tree!
Please note that this topic continues with the next lesson No 5.
Here are the slides:
DMDW Lesson 03 – Data Warehouse Theory
On 18, Mrz 2011 | inDMDW lecture | vonJohannes Hoppe
I’m planning to give you a detailed introduction to the concepts of the data warehouse world.
We will also see why data mining and data warehouses are closely connected to each other.
Preparation for DMDW Lesson 03 – Database Basics and ETL
On 06, Mrz 2011 | inDMDW lecture | vonJohannes Hoppe
In preparation for the next lesson
I am giving to you two tasks:
- Please solve the Microsoft Analysis Services Basic Data Mining Tutorial: http://msdn.microsoft.com/en-us/library/ms167167.aspx
- Please read the following text about ETL: dmdw_03_basics_ETL.pdf
I gave you 15 questions to check your knowledge about databases in general. Here are my answears:
dmdw_02_basics_homework.pdf
DMDW – No lectures at 04.03.2011 and 11.03.2011
On 03, Mrz 2011 | inDMDW lecture | vonJohannes Hoppe
[BOX_START]A lot of students can’t join the course at
Friday, the 4th of February (2011-03-04) and
Friday, the 11th of February (2011-03-11).
To avoid further complications,
there won’t be a lecture at these days.[BOX_STOP]
[BOX_START]I’m going to post some practical tasks („homework“) for you! These tasks are mandatory![BOX_STOP]
DMDW Lesson 02 – Data Mining Basics with Adventure Works
On 24, Feb 2011 | inDMDW lecture | vonJohannes Hoppe
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)
DMDW Lesson 01 – Data Mining / Data Warehouse
On 11, Feb 2011 | inDMDW lecture | vonJohannes Hoppe
Hello Students, today is the first Data Mining/Data Warehouse lecture.
I’m very happy with the exams of the RIA lecture. You deserve an early weekend! :-)
So today we will just have a short lesson with some basic stuff. Take a look at the required tools and the homework!
[BOX_START]Update:
For the peoples that missed the first lecture:
You don’t have to send to me the answers.
(you can, if you want)
But next week I will select some students that will have to answer the questions in front of the other students.[BOX_STOP]