2011 März
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!)
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:
RIA Presentations – Time and Room
On 23, Mrz 2011 | inRIA lecture | vonJohannes Hoppe
This Friday, the 25th of March (2011-03-25), I will be happy to see your presentations.
Leets meet at 10 o’clock AM in the foyer; too search for a suitable room!
I like presentations that are well prepared and where all team members are presenting. There is no fixed format ore time box!
It’s up to you how you want to convince me that you’ve created an amazing project. But please keep in mind that too long or too boring presentations won’t be very convincing! ;-)
Update 2011-03-25, 10:30:
We are in room 206. Everybody who is not presenting is getting in big troubles.
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.
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:
- Please solve the Microsoft Analysis Services Basic Data Mining Tutorial: http://msdn.microsoft.com/en-us/library/ms167167.aspx
- 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
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]
[BOX_START]I’m going to post some practical tasks („homework“) for you! These tasks are mandatory![BOX_STOP]
Greasemonkey Script: jQuery AJAX Latency Display
On 03, Mrz 2011 | inGeneral | vonJohannes Hoppe
Displays the time between two AJAX calls that were made through any jQuery function. It binds to ajaxStart() and ajaxStop(), so jQuery is used and required.
We use it for a manual UI tests where time is an acceptance criteria.
(function() { // ==UserScript== // @name jQuery AJAX Latency Display // @description Shows the time between ajaxStart() and ajaxStop(), jQuery is Required // @author Johannes Hoppe // ==/UserScript== var insertScriptContent = "\ var stopwatch;\ \ $(\"#latencyDisplay\").ajaxStart(function () {\ stopwatch = new Date();\ $(this).html(\"\");\ });\ \ $(\"#latencyDisplay\").ajaxStop(function () {\ elapsedTimeInSeconds = (new Date() - stopwatch) / 1000;\ $(this).html(\"AJAX Timer: \" + elapsedTimeInSeconds + \"s\");\ });" var insertDiv = document.createElement("div"); insertDiv.id = "latencyDisplay"; document.body.appendChild(insertDiv); var insertScript = document.createElement("script"); insertScript.type = "text/javascript"; insertScript.text = insertScriptContent; document.getElementsByTagName("head")[0].appendChild(insertScript); })();
You can download and install this little Greasemonkey Script at http://userscripts.org/scripts/show/98208