Final Project
8.1 Building a Star Schema
You're a Data Engineer at NYC's Performance Analytics team. Your mission is to build a complete analytics-ready data warehouse using the medallion architecture. You've already built the bronze layer that ingests raw NYC 311 service request data daily. Now you need to transform this raw data into a star schema that business analysts can use to answer critical questions about city services.
Your Challenge:
Build the Gold layer (dimensional model) to enable fast, efficient analytics on NYC 311 complaints.