Demonstrating USS data modeling with dbt and Rill.

Data Warehouse Repositories

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

Short videos on data modeling in Power BI

📊🌈🏛 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 🏵️

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.

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.

Hydrology ETL pipeline retrieving latest measurements from Environment Agency API and loading into SQLite star schema with validation and tests.

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.

ETL pipeline that converts specific JSON object and seed relational database

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…

A Power BI group (AEM9) project under the Analytics Extra Mentorship Program

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

Here's my first project on PowerBI. The project using Power BI based on DASHBOARD, ANALYSIS, REPORTING (DAR) format to find out the insight about those Vending Machine sale issue at HCM City, data source collected on March, 2021

Sales revenue data analysis using tableau and SQL

A complete, production-ready SQL Data Warehouse project implementing the medallion architecture (Bronze, Silver, Gold) featuring robust T-SQL ETL, star schema data modeling and a unified data catalog for analytics and business intelligence.

Data Modeling and ETL with PostgreSQL for Udacity Data Engineering Nanodegree

Database Management System & Datawarehouse

Built an ETL pipeline that extracts their data from S3, stages them in Redshift, and transforms data into a set of dimensional tables. Load data from S3 to staging tables on Redshift and execute SQL statements that create the analytics tables from these staging tables.

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.