Write a proposal for a data warehouse architecture for your current workplace or one of your own choosing. Make sure that it includes the following elements:

A drawing of the complete star schema of dimension and fact tables

A complete description of how the attributes of all tables would meet the requirements for your organization$$s use of actionable Business Intelligence $($BI$)$ data

A detailed description of the ETL processing to include source production systems from which data will be extracted, the types of data cleansing activities that would be required due to overlapping data sources and content, and the proposed data warehouse loading plan to provide adequately refreshed data for effective decision making by your organization$$s executive and senior level business analysts

A detailed description of the challenges that might occur due to slowly changing dimensions and your strategy on handling them