Data warehouse Project
Build a data warehouse and to do a presentation of the project.
Here is what needs to be done:
A. Select an application. It can be real or simulated.
B. Develop a data warehouse scheme.
C. Load the warehouse.
D. Mine the warehouse.
E. shwoing chart and dependency network and deciddion tree.
data warehouse tasks: First Style
1-Dimensions
2- The fact table
3- Browse the cube
4- Create Mining Structure:
• Dependency network
• Decision tree
• Drill through
• Mining legend
• Attribute profile
• Attribute Discrimination
• Mining accuracy chart.
data warehouse tasks: Second Style
1- Load database
2- Cleaning data and check keys ( model)
3- Create data ( dimension)
4- Duplicate: decision tree
5- Create relationship
6- Deploy cube
7- Report services