Category > DMDW lecture

This is the archive of my lecture called “Data Mining – Data Warehouse” that took place from February 2011 to June 2011.

DMDW – ETL Projects – Student Presentations II

13. Team “CLOVER ETL” Members: Kongari, Venkata Ramana Mutyala, Satya Allam, Manoj   14. Team “CLOVER ETL 2″ Members: Jeevangikar Rajeevan Rao Chinthanippula Ugendar Nitin Lamba   15. Team “Talend” Members: Slama Mokhtar Metwaly Ahmed Redet  Asfaw   16. Team “SAP” Members: MAHESH KUMAR SANDIP RANA AHSAN ALI CHEVALWALA   17. Pentaho Data Integration (Kettle) [...]

Continue reading

DMDW + RIA Projects – Student Presentations on 2011-07-29

It’s time for your presentations! Every team, hat hasn’t shown their project should be there. You can present your solutions at: Friday, the 29th of July 2011 from 9:30 AM to 12:45 PM and Friday, the 29th of July 2011 from 14:00 PM to 15:30 PM Room: t111 / t112 Please inform your fellow students about [...]

Continue reading

DMDW – Text exam | Exam time and room

The exam starts today (Friday, 27th of Mai) at 14:00. Room: t83 Duration: 180 minutes All you need is an indelible pencil.     Many of you asked for a test-exam. Here it is! You can estimate your knowledge for the upcoming DMDW-exam with the following questions. Please note that the real exam will be [...]

Continue reading


DMDW – ETL Projects – Student Presentations

This is a list of all the interesting projects that my students have made. Well done! I’m happy with the results! Team “Pure Access” Team “Access to Access2MySQL to MySQL” Team “Silverlight to MS SQL” Team “PHP to MySQL” Team “Pentaho Data Integration (Kettle)” Team “SSIS” Team “Pentaho Data Integration (Kettle)” Team “Groovy to MongoDB” [...]

Continue reading


DMDW Lesson 08 – Further Data Mining Algorithms

This will be our last lesson, so let’s concentrate on finishing the last required algorithms. Please collect some questions in advance! I would like to discuss them in the remaining time. I will prepare a small text exam, too.

Continue reading


DMDW Extra Lesson – NoSQL and MongoDB

This Friday I introduced you (== my students) to the wonderful new world of databases that are “not only SQL“ (NoSQL). Later on we played with the MongoDB shell and created, read, updated and deleted some documents. For the MongoDB workshop we used some training data that you can find here. Please don’t forget to [...]

Continue reading

,

DMDW – Presentation of your ETL project

Hello Students, as you know, every student has to present his ETL project. The task: Please Extract the content of the room-plan excel file (write me a mail if you don’t know the password) then Transform it to a new structure. (e.g. normalize the content, clean it, deal with typos, parse the dates…) and finally [...]

Continue reading


MongoDB – Training Data

My favourite next topic will be a short excursion to MongoDB. MongoDB (from “humongous”) is a scalable, high-performance, open source, document-oriented database. It has no SQL, JSON-style documents and is fast as hell! Please install MongoDB as described here: Quickstart Windows And please download these files with sample data: dba-training-data.zip These MongoDB Quick Reference Cards [...]

Continue reading

,

DMDW Lesson 05 + 06 + 07 – Data Mining Applied

In this series of lectures (05. + 06. + 07.) we will concentrate on applied data mining. Dates Lesson 05. – 01.04.2011 Lesson 06. – 08.04.20111 Lesson 07. – 15.04.2011 The current agenda Applications of Data Mining Data Mining Algorithms Repetition – Datatypes, Contentypes Data Mining Algorithms – Decision Trees Data Mining Algorithms – Clustering [...]

Continue reading


DMDW Materials – Last update: 2011-04-01

2011-04-01 I created a SVN repository for the used source codes: http://lecture-hoppe.googlecode.com/svn/trunk/DMDW_2011 (svn checkout http://lecture-hoppe.googlecode.com/svn/trunk/DMDW_2011/ lecture-hoppe-read-only)   2011-03-24 I would like to do a practical session with the “SQL Server Business Intelligence Development Studio”. Our source will be an old excel file with room plans. You can download it here: dmdw_rooms_fh_heidelberg-2006-04-03.zip To ensure a little [...]

Continue reading


prev posts
Projekt-
Verfügbarkeit:
ab 15.01.2013