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.