snowflake-schema

This repository is a place for the Data Warehousing course at the Information Systems & Analytics department, Santa Clara University.

End-to-end lakehouse pipeline for retail data: Postgres to Databricks (incremental ingestion), dbt (incremental models, SCD2, metadata-driven OBT), Airflow orchestration, S3 secondary ingestion, CI-gated on dbt tests.

A large-scale data framework that will enable us to store and analyze financial market data and drive future predictions for investment.

This project simulates a real-world enterprise data migration and modernization strategy. It extracts transactional data from a simulated "On-Premise" environment (hosted on AWS EC2), performs heavy distributed processing using a Hadoop/Spark cluster, and ultimately serves the data via a Cloud-Native, serverless architecture to optimize costs .

SQL, Databases, warehouses, Data lake, cloud storage, MYSQL, Data Pipeline

End-to-end Snowflake Data Engineering project covering data ingestion, transformation, dimensional modeling, automation, security, data quality, performance optimization, and production-oriented workflows.

End-to-end data warehouse for multi-country market-share analytics (FMCG / nutrition) across two markets — Spain (ES) and Portugal (PT) — built on a medallion architecture in Snowflake, feeding Power BI dashboards.

This repo contains HR Analytics project to analyze what factors impact employee attrition using dataset for Atlas Labs Company.

A data visualization project using Power BI to analyze trends, business metrics, and key insights through interactive dashboards.

SQL, Databases, warehouses, Data lake, cloud storage, MYSQL, Data Pipeline

This repository contains practical examples of data warehousing concepts, including star schema and ETL processes, all implemented using MySQL.

Open-source Supply Chain analytics on Microsoft Fabric: a scalable Bronze-Silver-Gold pipeline with automated CSV ingestion, Delta Lake transforms, semantic modeling (DAX & RLS) and interactive Power BI reports. Join to enhance pipelines, refine models, and build next-gen supply-chain insights!

YAML format for star schema and snowflake schema

Snowflake Inc. is a fully managed Software-as-a-Service (SaaS) platform that unifies data warehousing, data lakes, data engineering, data science, and AI workloads

✅ Terraform module to create and manage Snowflake databases and schemas using infrastructure as code.

Power BI dashboard analyzing Netflix's 8,000+ title global library — content acquisition trends, catalog diversity, and regional distribution gaps using a Snowflake schema data model.

Building a powerbi dashboard by pulling da

Enterprise-grade Sisense ElastiCube architecture & SQL modeling for AMEX. Features a hybrid ETL pipeline, Snowflake schema design, and 360° operational visibility dashboards.

TIL: Data Warehouse and ETL Architecture