615644 Data Warehousing

1
615-644 Data Warehousing
Week 5 Plastics Corporation Case Study
2
Plastics Corporation

• Medium-sized plastics manufacturer
• Goals
• Improve profitability
• Improve export performance
• Operations
• Design, manufacture, distribution
• Automotive, gardening and domestic sectors

3
Plastics Corporation

• Plastics Corporation recently merged with another
  plastic manufacturer
• One manufacturing company that still has two
  information systems
• Two distribution companies that each have an
  information system
• Needs a data warehouse!!

4
Plastics Corporation

• Three important problems
• Which customers are the key customers for
  Plastics Corporation?
• Which of the distribution channels performs best?
• Which products are the most profitable?

5
Plastics Corporation Operational Systems
Product Definition And Costing
Distribution, Sales And Inventory
Plastics Corporation
Plastics Product Database
Plastics Sales Database
Product Definition And Costing
Distribution, Sales And Inventory
Other Plastics Company
Other Coy. Product Database
Other Coy. Sales Database
6
Plastics Corporation Data Warehouse
Plastics Product Database
OLAP Tool
Data Extract and Loading System
Plastics Sales Database
Plastics Corporation Data Warehouse
Data Mining Tool
Other Coy. Product Database
Query System
Other Coy. Sales Database
7
Submission

• Report that describes and justifies the star
  schema design to management
• Around 3000 words in length
• Should include
• Executive summary
• Data warehousing overview (incl. benefits)
• Design of the data warehouse
• Explanation of how the data warehouse will be
  used to address the three problems
• Appendix data dictionary including data sourcing
  details