DMDW lecture
DMDW – ETL Projects – Student Presentations II
On 29, Jul 2011 | inDMDW lecture | vonJohannes Hoppe
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“ 8-)
Members:
- MAHESH KUMAR
- SANDIP RANA
- AHSAN ALI CHEVALWALA
17. Pentaho Data Integration (Kettle)
Members:
- Shyamjith Valsalan
- DixitKumar Sheta
- Yaman Relhan
DMDW + RIA Projects – Student Presentations on 2011-07-29
On 25, Jul 2011 | inDMDW lecture, RIA lecture | vonJohannes Hoppe
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 this date!
Btw, the results for the RIA exam will be available soon!
DMDW – Text exam | Exam time and room
On 24, Mai 2011 | inDMDW lecture | vonJohannes Hoppe
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 longer, since it will take 3 hours.
Update 2011-05-25:
I’m getting several mails and comments for question number 5.
The question is concentrating on the SSIS control flow tasks that everybody should already know:
DMDW – ETL Projects – Student Presentations
On 13, Mai 2011 | inDMDW lecture | vonJohannes Hoppe
This is a list of all the interesting projects that my students have made.
Well done! I’m happy with the results! :-D
- 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“
- Team „Java to MySQL“
- Team „SSIS“
- Team „Java to MongoDB“
- Team „SSIS“
Please note: I’m still waiting on some mails. Please send to me the PowerPoint slides as well as the project files! (see comments below)
DMDW Lesson 08 – Further Data Mining Algorithms
On 10, Mai 2011 | inDMDW lecture | vonJohannes Hoppe
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.
DMDW Extra Lesson – NoSQL and MongoDB
On 06, Mai 2011 | inDMDW lecture, NoSQL | vonJohannes Hoppe
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 solve the exercises! You can contact me by blog-comment or mail, in case of further questions!
DMDW – Presentation of your ETL project
On 03, Mai 2011 | inDMDW lecture | vonJohannes Hoppe
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 Load it to a new target.
(In most cases this target will be a database system.) - Present your solution to the other students, give me your materials. Don’t forget you name on the slides.
MongoDB – Training Data
On 15, Apr 2011 | inDMDW lecture, NoSQL | vonJohannes Hoppe
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! :evil:
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 can be very helpfull:
Update:
Here are the slides for of NoSQL presentation and the MongoDB workshop!
DMDW Lesson 05 + 06 + 07 – Data Mining Applied
On 01, Apr 2011 | inDMDW lecture | vonJohannes Hoppe
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
I will probably change the agenda and slides during the days. Please make sure that you have the latest version.
DMDW Materials – Last update: 2011-04-01
On 24, Mrz 2011 | inDMDW lecture | vonJohannes Hoppe
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”.
[BOX_START]Our source will be an old excel file with room plans. You can download it here:
dmdw_rooms_fh_heidelberg-2006-04-03.zip
[BOX_STOP]
To ensure a little bit privacy, the zip file password protected. Ask me face-to-face for the password!
I’m expecting that you have the following tools
and resources on your laptop:
- Microsoft Visual Studio 2008 (not 2010, not Express!)