• 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.