Building a Data Warehouse for Fudgemart Inc. by Integrating Data from two Subsidiaries to support Business Intelligent

dimensional modeling of AdventureWorks2017 for sales, creating a DataMart. It includes an ETL pipeline that loads the data from AdventureWorks2017 to AdventureWorksDM using SQL Server Integration Services (SSIS) and implements Slowly Changing Dimension (SCD) handling using the SCD wizard and Merge statement.

Business Intelligence and Data Warehousing.

datamart scripts - molap (Data Science)

Export from Odoo reports Datamart for BAT Argentina

Sales Dashboards using Power BI, for Heineken Sales and Nielsen Beer Market Data, as the final project from the Data Visualization course from the Big Data & Analytics Masters @ EAE class of 2021

Un caso de aplicación de datamart utilizando la base de datos Adventureworks2019

💻💵 Creating Data mart/ETL based on Lending Club dataset.

Project for building a ETL pipeline

This project showcases a comprehensive data warehousing solution for managing and analyzing employee performance data using PostgreSQL. The data warehouse consists of employee, department, and education information, along with performance metrics, all organized in a snowflake schema.

The data warehouse created consists of 2 data marts which can be used to find the analyse the sales for a company.

This project is a Data Engineering solution implemented to validate the data types of columns in PostgreSQL tables in a DataMart. It aims to validate whether the data stored in tables conforms to the expected data types, improving data integrity and reliability.

This repository includes an enhanced-entity-relationship diagram resembling Airbnb's database structure, along with SQL code used to construct a similar schema resembling Airbnb's setup using MySQL Workbench.

This repository presents a data pipeline from a fictitious company with two endpoints: a Data Warehouse and a Data Mart. The focus of the project is to use Pentaho and Dimensional Modeling.

Repository for tutorials, information and notes on technology in general.

The National Information Management Facility (NIMF) is a centralised datamart design that is used to consolidate fisheries data from various operational systems.