Image Image Image Image Image
Scroll to Top

To Top

DMDW lecture

23

Mrz
2011

inDMDW lecture

vonJohannes Hoppe

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:


Tags |

18

Mrz
2011

inDMDW lecture

vonJohannes Hoppe

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.


Tags |

06

Mrz
2011

inDMDW lecture

vonJohannes Hoppe

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:

  1. Please solve the Microsoft Analysis Services Basic Data Mining Tutorial: http://msdn.microsoft.com/en-us/library/ms167167.aspx
  2. 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

 

Tags |

03

Mrz
2011

inDMDW lecture

vonJohannes Hoppe

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]

BUT

[BOX_START]I’m going to post some practical tasks („homework“) for you! These tasks are mandatory![BOX_STOP]

Tags |

24

Feb
2011

inDMDW lecture

vonJohannes Hoppe

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)

Tags |

11

Feb
2011

inDMDW lecture

vonJohannes Hoppe

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]



Tags |