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

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

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

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

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

YAML format for star schema and snowflake schema

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!

This repository houses my project for a social media warehouse system that utilizes the Snowflake schema. It involves storing data from the Social Media Marketing, User, and Event database, which contains information on Facebook and Instagram ad engagement with users. An instance of this engagement is when a user conducts a transaction.

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

TIL: Data Warehouse and ETL Architecture

📊 Analyze employee data to uncover insights on attrition, performance, and demographics, empowering HR decisions for better workforce management.

Hackolade(https://hackolade.com) plugin for Snowflake

Snowflake Notes

Course of business intelligence bootcamp by Dibimbing

Transforming a Single Raw Dataset into a Structured Relational Model Using Power Query, Excel Data Model, and Tableau

Building a powerbi dashboard by pulling da

Analyzing Transport for London data over 12 years with Snowflake SQL to uncover usage patterns and insights

Data Warehouse creation using MySQL and R

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