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) [...]
Category > DMDW lecture
This is the archive of my lecture called “Data Mining – Data Warehouse” that took place from February 2011 to June 2011.
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 [...]
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 [...]
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” [...]
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.
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]