starschema

Demonstrating USS data modeling with dbt and Rill.

This project demonstrates the development of a scalable end-to-end data pipeline for processing and reporting retail order data using Azure Cloud services, Delta Lake architecture, and Databricks.

Data Warehouse Repositories

A Sales and Product Management Dashboard created using SQL, Power BI and Microsoft Adventureworks2022 data

Power BI V2.0 — single-page career intelligence dashboard on 478K job postings with DAX measures, skill intelligence, and salary benchmarking

📊🌈🏛 This project develop a data warehouse for a bank using Amazon Redshift, VPC, Glue, S3 and DBT, following a ⭐ Star Schema architecture. The goal is to storage, manage, and optimize data to support decision making and reporting 🏵️

Short videos on data modeling in Power BI

An interactive Power BI dashboard analyzing sales performance by region, product, and time. It tracks key metrics, top-selling categories, and sales trends, offering detailed insights to support business decisions.

enterprise data warehouse integrating disparate sales databases using star schema and dimensional modeling. Scalable ETL pipeline processes 18K+ transactions with automated BI reporting. Achieves 90% query performance improvement through strategic indexing and pre-computed aggregations. Production-ready with cloud deployment.

The project is designed as a practical data engineering portfolio project: it demonstrates raw data ingestion, schema design, full-refresh loading, data quality profiling, standardization rules, and curated analytical tables.

Power BI dashboard on 478K+ real 2024 job postings — salary benchmarks, skill demand analysis, and geospatial hiring map

ETL pipeline that converts specific JSON object and seed relational database

End-to-end Data Warehouse project built with Python, PostgreSQL, and Docker using the World Superstore dataset. The project demonstrates ETL pipelines, star schema design, dimension and fact table modeling, and analytical SQL queries.

Data Warehouse project using MySQL with layered architecture (Bronze–Silver–Gold) and star schema modeling

Data engineering pipeline for historical US flight operations and weather analytics using PySpark, PostgreSQL, Docker, and dimensional data modeling.

This repository is about a project to create a datawarehouse and ETL pipeline on AWS for a music streaming app. They will define Fact and Dimension tables and insert data into new tables. At the end, I'm going to process two analytical queries to check it out the top ten artists and songs.

The project involves creating a data model for HNG Hire, implementing it in MySQL, and building a Power BI dashboard to display hiring statistics.

In this project, I'll apply what I've learned on data modeling with Postgres and build an ETL pipeline using Python. To complete the project, I will define the fact and dimension tables for a star schema for a particular analytic focus, and write an ETL pipeline that transfers data from files in two local directories into these tables in Postgre…

End-to-end NHS Trust financial analytics: Python ETL pipeline ingesting 6 NHS England TAC Excel files into MySQL, SQL star schema, analytical views, KPI computations, and Power BI export — covering 206 Trusts across 3 financial years (2021/22–2023/24)

Star schema sales dashboard built from MySQL to Power BI — full build process, DAX measures, and real debugging documented.