Design an erd diagram for a star schema that will integrate

Assignment Help Computer Engineering

Reference no: EM133555611

Homework: Design and Implement a Data Mart

Create a Data Model for a Data Mart using Dimensional Modeling Principles

Prerequisite:

Before beginning this homework, ensure that you've thoroughly read and understood Chapters 9 (pages 197 to 235) and 10 (pages 237 to 251) on Dimensional Modeling from the course textbook.

Project Context:

You are stepping into the shoes of a Junior BI developer involved in a data mart project. As part of the requirements gathering phase, you have a discussion with Jim Riner, the Sales Manager. Jim identifies a crucial need for deeper sales data analysis that encompasses the following dimensions:

A. Products
B. Customers
C. Dates (Seasonality)
D. Orders
E. Sales Territory

Specific Dimension Requirements:

A. Product Dimension:

1. Analyze sales based on categories, subcategories, product names, colors, and models.

2. This will help in identifying top-selling items in various categories and attributes.

B. Customer Dimension:

1. Explore sales data to determine which customers purchase which items, pinpoint top customers, and analyze sales by the customer's zip, territory, country, and city.

2. This information can aid in tailoring promotional offers and understanding buying patterns of valued customers.

C. Date (Seasonality) Dimension:

1. Analyze which products have high sales during specific seasons, days, weeks, or years.

2. The granularity of this dimension should include: Date Surrogate Key, Date Value, Month, Year, IsHoliday, and Holiday Name.

D. Order Dimension:

1. Sales analysis based on Order ID, Order Detail ID, and Customer ID.

E. Sales Territory Dimension:

1. The analysis should cover territory name, territory group, country, or region codes.

2. The objective is to determine the profitability of specific geographic locations, products sold there, and revenue comparison between regions.

Task:

Given the requirements and understanding from chapters 9 and 10 on Star Schema, your task is to:

A. Design an ERD diagram for a Star Schema that will integrate the central fact table with the required dimension tables.

B. Refer to Figures 9.10 and 9.18 (for the date dimension) in the textbook as guidance.

Reference no: EM133555611

Questions Cloud

How myth might have impacted the people of that historical : Explore how 'myth' might have impacted the people of that historical time period and reflect on these myths from your modern American perspective.

Describe how the audience in dr. king speeches relates : Provide a summary of the two speeches. Compare Dr. King's leadership, charisma, power, and passion to capture his audience to Alicia Garza's speech.

Is qatar a clear or fluid artistic system : Is Qatar a clear or fluid artistic system?

What is john adams view of the relationship between : What is John Adams' view of the relationship between the Imperial Crisis, the decision to declare independence, and the War For Independence

Design an erd diagram for a star schema that will integrate : Create a Data Model for a Data Mart. Design an ERD diagram for a Star Schema that will integrate the central fact table with the required dimension tables.

What is the importance of globalization and colonialism : What the textbook's perspective on globalization and Colonialism and what is the importance of globalization and colonialism? Include a summary of your research

Conduct an informational interview with a person : Create a Career Plan that includes: a Professional Profile Statement (a polished aspiration and developed motivation); a Self-Evaluation of Skills

How the principle of nondiscrimination pertains to diversity : How the principle of nondiscrimination pertains to diversity and culture on the higher education campus and was or was not a part of this case.

Which of the following was enkidu brought closer to man : What problem(s) did Enkidu pose for thThrough which of the following was Enkidu brought closer to man's state from his natural state? Prayer Sex Battle Eatinge

User Account

All Pages