Data Warehouse Repositories
📊🌈🏛 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 🏵️
A Sales and Product Management Dashboard created using SQL, Power BI and Microsoft Adventureworks2022 data
The project involves creating a data model for HNG Hire, implementing it in MySQL, and building a Power BI dashboard to display hiring statistics.
Sales revenue data analysis using tableau and SQL
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
Data Modeling and ETL with PostgreSQL for Udacity Data Engineering Nanodegree
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…
ETL pipeline that converts specific JSON object and seed relational database
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.
This is a dataware house produced in eclipse using python code, that works with a star schema i produced in order to store sales information for a fictional stationary company.
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.
Database Management System & Datawarehouse
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.
Apache Kafka Streamlit application for real-time tracking of pharmacy sales using the start schema data model.
The project involved designing a MySQL database to store and normalize transaction, customer, and product data. SQL queries were used to extract business insights like sales trends, product performance, and customer behaviors.
Its a PowerBI and mySQL linked Project for generating Sales Insights.
Add a description, image, and links to the starschema topic page so that developers can more easily learn about it.
To associate your repository with the starschema topic, visit your repo's landing page and select "manage topics."