This mini case study provides practice and preparation for the concepts that you learned in module 3. You will get to apply most of the concepts from module 3 and some of the concepts from module 2. This mini case study contains two data sources with sample data along with a statement of business needs. Using the data sources and business needs, you will specify a dimensional model with dimensions, measures, and grain, create a schema design for the data warehouse that integrates the data sources, identify summarizability problems in the design, and populate data warehouse tables from sample rows in the data sources