Business Intelligence and Data Warehousing Project

This repository contains analysis of IMDB data from multiple sources and analysis of movies/cast/box office revenues, movie brands and franchises.

4IT436 | Business Intelligence project

This repository contains analysis of IMDB data from multiple sources and analysis of movies/cast/box office revenues, movie brands and franchises

Data Warehouse Repositories

This project is all about Data Integration. It involved all the ETL (Extract, Transform and Load) operations. In this project, the ETL was done once by using SQL queries and once by using SSIS (SQL Server Integration Services)

Experiments with ETL Engineering and KPIs visualization through Excel

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 contains all the assignments, workshops and mini-projects of course - DAMG7370 Designing Advanced Data Architectures for Business Intelligence

Build a Real-Time Streaming ETL Pipeline with Apache Kafka, Kafka Connect, and ksqlDB

This Project Will help you to build a ETL Model for Your Company

Building an Azure Data Warehouse for Bike Share Data Analytics. Project to load data from Postgres DB in Azure into Azure Synapse.

⚙️ Atlas ETL | The unified report library ETL.

Design and Implementation of a data warehouse on the "Northwind" database.

Project involves merging customer reviews from Fudgemart and FudgeFlix to create a unified data warehouse using Kimball's approach. Utilizing Power BI, it aims to extract actionable insights for Fudge Inc., guiding strategic decisions, product enhancements, and market expansion based on comprehensive business intelligence.

Analysis of customer orders in retail application from Oracle database

ETL Pipeline using SSIS

This repository contains modeling of the Sakila ERD to a star schema using the Kimball approach and performs ETL (Extract, Transform, Load) from the source ERD to the destination star schema to optimize BI queries.

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).