Syracuse University, Masters of Applied Data Science - IST 722 Data Warehouse
-
Updated
Mar 24, 2020 - TSQL
Syracuse University, Masters of Applied Data Science - IST 722 Data Warehouse
Project involves merging customer reviews from Fudgemart and FudgeFlix to create a unified data warehouse using Kimball's approach. Utilizing Power BI, it aims to extract actionable insights for Fudge Inc., guiding strategic decisions, product enhancements, and market expansion based on comprehensive business intelligence.
Production-style end-to-end ELT pipeline built using Python, Snowflake, dbt, and Power BI. Ingests REST API data, transforms semi-structured JSON into a Kimball star schema, and enables scalable revenue analytics through optimized BI modeling.
Add a description, image, and links to the kimball-lifecycle topic page so that developers can more easily learn about it.
To associate your repository with the kimball-lifecycle topic, visit your repo's landing page and select "manage topics."