GlobalMart, a fast-growing e-commerce startup, is expanding its operations and analytics capabilities. To support this growth, it relies on dimensional modeling for business intelligence. However, several challenges arise:
📌 Data Integrity & Normalization: Inefficient database design leads to null values, redundancy, and inconsistencies in customer and order data.
📌 Query Performance: Analysts struggle with slow queries when analyzing large volumes of sales and transaction data.
📌 Historical Tracking: Customer details, sales regions, and account balances change over time and require proper versioning.
📌 Schema Design: Choosing between Star and Snowflake schemas impacts query speed and storage efficiency.
Your Task: As a Data Engineer, your goal is to analyze, design, and optimize GlobalMart’s dimensional data model.