syllabus | announcements | assignments | discussion
E-Mail: redmond@lasalle.edu |
|
The Cognos PowerPlay software can be accessed by going to here PPT slide about breaking down names and addresses into fine-grained details. (right click to download) SQL Script to create and populate tiny example 3NF source system DB for OC example. (right click to download) SQL Script to create tiny example DW star schema DB for OC example. (right click to download) Winzipped SQL Server Integration Services Project to turn the 3NF DB into the Star Schema (with mostly just straight line processing) (right click to download) Winzipped SQL Server Integration Services Project to turn the 3NF AdventureWorks sample DB into the book Star Schema (with lots more steps needed in the real world) (right click to download)
Some interesting links related to Data Warehousing. Some material is introductory, other material you should be able to understand by the end of the class.
Some things which may not be relevant this semester (links may be broken at this point while I decide):An article introducing Data Mining can be accessed by going to here A newer edition is available from the consultants who wrote it: here Using Cognos Transformer to Convert a Single Table
Huge file to serve as small example in creating data cube in Cognos Transformer working here here |