Learning Objectives
Build a Dimensional Model for CarMax's Data Warehouse
Write SQL queries to transform data
Write SQL queries to perform EDA on the built data warehouse
Overview
CarMax is a rising startup in the booming used cars industry in the US.
With the rise in demand for used cars, the company's data infrastructure is undergoing immense pressure.
The Management is urgently looking for a solution to have a solution in place that could help their analysts have access to clean and accurate data to be able to take informed decisions about business growth
What would that solution be?
Prerequisites
- Basic understanding of Dimensional Modeling
- Working Knowledge of SQL
- Understanding of how COPY command works
- Basic Data Transformation skills using Snowflake