I created a SVN repository for the used source codes:
(svn checkout http://lecture-hoppe.googlecode.com/svn/trunk/DMDW_2011/ lecture-hoppe-read-only)
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:
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!)
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:
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.
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:
[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]
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.
You can download and install this little Greasemonkey Script at http://userscripts.org/scripts/show/98208