Data warehousing and business intelligence

Data warehousing and business intelligence
1.Introduction
1.1.The Company name and type of business
1.2.The Company objective, vision and scope
1.3.The department (or sub-section) to be considered.
2.Analysis of Operational Systems and Data Sources
2.1.A discussion of the organisations current operational system
2.2.The data sources used by the systems discussed in 2.1.
2.3.An ERD(s) for the business
2.4.A discussion of the advantages/disadvantages that a data mart would have for your organisation.
3.Data Mart Design
3.1.The identification of two subject areas, identified during 2, which would be of benefit to the managers your organisation.
3.2.The design of the star schemas associated with both subjects area identified in 3.1
3.3.A discussion of the granularity of dimension and fact tables
3.4.The extension of one of the star schemas into a snowflake schema.
4.Data Mart Implementation
4.1.Implement a prototype of the data mart by creation of the required tables.
4.2.Discuss how you will you implement the ETL process? E.g. full or incremental, online or offline extraction?
5.Data Analysis
5.1.A discussion on different OLAP techniques, with reference to data cubes.
5.2.An explanation how your data mart could provide relevant information for your managers
5.3.This should include three relevant data queries. (You need to include sample scripts)
6.Conclusions
6.1.A discussion of strategies to overcome future challenges.