CSC603: Data Warehousing and Mining [DWM] & CSL603: Data Warehousing and Mining Lab [DWM Lab] <Semester VI>

End-to-end data engineering processes for the NIGERIA Health Facility Registry (HFR). The project leveraged Selenium, Pandas, PySpark, PostgreSQL and Airflow

Syracuse University, Masters of Applied Data Science - IST 722 Data Warehouse

Designed Multi Star schema with 10 Fact & 33 Dimension tables & developed Data Integration Pipeline by ETL workflow to load all tables (380M+ rows) from multiple sources such as CSV, MySQL, MSSQL & PostgreSQL by using Talend. Implemented Data Profiling, Error Handling, Load Statistics, Cleansing and Performance Tuning to address data quality gap…

This repository explores the data and technical architectures needed to enable enterprises to design, develop and deploy business intelligence (BI) and analytical applications that create value from the deluge of data enterprises have access to.

Modeling a database using the Star Schema, applied to the context of "CFB Pharmacy", which seeks to develop decision support systems for revenue analysis. The project was carried out in two stages: (A1) involved the creation of the relational and conceptual model; (A2) focused on the implementation of the dimensional model and Data Warehouse (DW).

This repo provides a step-by-step approach to building a modern data warehouse using PostgreSQL. It covers the ETL (Extract, Transform, Load) process, data modeling, exploratory data analysis (EDA), and advanced data analysis techniques.

Showcases work focused on utilizing statistical techniques and machine learning algorithms to forecast future trends and outcomes.

This project HealthCare Data Warehouse System is for the Data Warehouse and Mining University course...!

Modern Data Stack Template

Business Intelligence FER labs

Data Warehouse Basics

An integrated research and patent information system.