DMDW – Presentation of your ETL project

Hello Students,

as you know, every student
has to present his ETL project.

The task:

  1. Please Extract the content of the room-plan excel file
    (write me a mail if you don’t know the password)
  2. then Transform it to a new structure.
    (e.g. normalize the content, clean it, deal with typos, parse the dates…)
  3. and finally Load it to a new target.
    (In most cases this target will be a database system.)
  4. Present your solution to the other students, give me your materials. Don’t forget you name on the slides.

You are free to use any programming language, script or dedicated tool. Every database system is allowed. And you are still free to choose a complete different way as long as your solution covers the three letters!

Some Notes:

  • Every team will have to present a unique solution to migrate the data.
    Every team should have a size of one to max. three people.
  • It should be a hands-on lab for the other students.
  • I will upload all materials to this blog.
  • Preferred time box: 45 – 90 minutes
  • The fewer manual steps the better!
    (A good ETL application will not require manual steps during the process. It will have a self-explaining interface AND / OR it will run at night without any interaction.)
  • The presentation is required.
    A presentation qualifies you for the exam. No presentation. No grade. Everybody team member should attend to presentation.
  • Again: Don’t forget your full names on the slides (if you use power point) or in a separate text file (if you prefer a whiteboard).

You can present your solution at:

  • Friday, the 6th of Mai 2011 from 9:30 AM to 12:00 noon
  • Friday, the 13th of Mai 2011 from 9:30 AM to 12:00 noon
  • optionally: a third Friday we will choose together

So yes! The next two Fridays will be very long, since the regular lecture will be in the afternoon.

Trackback URL


2 Comments on "DMDW – Presentation of your ETL project"

  1. 1. Johannes Hoppe (@JohannesHoppe)
    03/05/2011 at 21:20

    http://bit.ly/lEoo9O – DMDW – Presentation of your ETL project #dmdwlecture

  2. 2. Maximilian
    13/05/2011 at 08:02

    Is the room for the presentation the same as our usual room?
    CU in 30min (-_~)


Connect with Facebook

Hi Stranger, leave a comment:

ALLOWED XHTML TAGS:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="" highlight="">

Subscribe to Comments
Projekt-
Verfügbarkeit:
ab 15.01.2013