This is a business intelligence project on analyzing super market data. Check out the README file for more details.

A simplified introdocutory data analysis report to show how using SQL queries can answer questions from a data warehouse with a star schema. The report answers why server downtime happens and how it can be fixed.

This is an MSSQL Data Warehouse and manual ETL demo on a specially formatted Water Quality dataset from DEFRA, UK. It is a personal academic-grade exercise to explore the basic concepts of data warehousing and manual ETL process from an academic perspective.

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…

Cloud Data Warehouse of Sparkify Data using Redshift

Projects from Udacity Data Engineer Nanodegree

Star Schema design and Data Ingestion

Builds dimension tables with configurable/variable granularity. Keeps those tables up-to-date. This makes reporting queries performant and doable. I use it with https://grafana.com/

Analyzed Zomato's restaurant data to reveal global insights, highlighting continent-wise restaurant counts, average costs, and ratings. Also, identified country-level cuisine counts to enhance Zomato's data-driven decision-making.

Contains script in Python for Data Pipeline solution on Azure Databricks

Udacity Data Engineering project: Data Warehouse

This is an Oracle DB Data Warehouse and manual ETL demo on a specially formatted Water Quality dataset from DEFRA, UK. It is a personal academic-grade exercise to explore the basic concepts of data warehousing and manual ETL process from an academic perspective.

Data Warehouse creation using MySQL and R

Using ETL process to Extract, Transform, and Load local data into a PostgreSQL database