Search for question
Question

Write a case study paper that provides the following:

• Background of the company and business objectives.

• The architecture of the data warehouse.

• The source input systems and the scale at which data is generated.

• Data model: a diagram of the star schema with dimensions and fact tables describing how attributes of all tables would meet the requirement of generating actionable business intelligence data.

• The ETL processing that is required.

• The types of output reporting.

• Identify various stakeholders and how they will use the reports.

• Are there any data mining techniques being used? How is ad-hoc reporting supported?

• Identify any opportunities to apply big data technologies on the data warehouse and discuss how it could be beneficial. This is also a good place to discuss the pros and cons of building a data lake.

• Discuss any unique challenges that were encountered during the development of the data warehouse project and how they overcame them.

• Submissions should be between 1,750 words and 2,500 words in length.