This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
teaching:dw2013-w9 [2013/11/13 09:24] tcalders created |
teaching:dw2013-w9 [2013/11/27 02:05] tcalders [Exercises] |
||
---|---|---|---|
Line 5: | Line 5: | ||
* Transform/Cleanse | * Transform/Cleanse | ||
* Load | * Load | ||
- | * Data Mining | + | |
- | * Main techniques | + | |
- | * Classification | + | |
- | * Clustering | + | |
- | * Pattern Mining | + | |
- | * Examples and applications | + | |
===== Slides ===== | ===== Slides ===== | ||
* [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/DW08a-TL.pdf|Slides Transform-Load]] | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/DW08a-TL.pdf|Slides Transform-Load]] | ||
- | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/DW08b-DataMining.pdf|Slides Data Mining]] | ||
===== Reading material ===== | ===== Reading material ===== | ||
Line 19: | Line 13: | ||
===== Exercises ===== | ===== Exercises ===== | ||
+ | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/W8-ex/SSIS%20Update%20Exercise.pdf|ETL Update Exercise]] | ||
+ | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/W8-ex/CreateW9database-students.dtsx|the (incomplete)ETL package]] | ||
+ | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/W8-ex/createtablestatements.txt|Create table statements for the data warehouse]] | ||
+ | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/W8-ex/changes_DB_createtables.txt|Create table statements for the updates database]] | ||
+ | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/dates.csv|The dates source csv file]] | ||
+ | * Solutions | ||
+ | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/UpdateNorthwind.dtsx|SSIS Package]] | ||
+ | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/SSIS-Update%20Exercise%20Solution.pdf|Solution Explanation]] | ||
+ | * On the database server, a database with some example updates has been made available for testing purposes. The name of this database is "W9-updatesNorthwind". |