GitHub topics: fact-table
samuel-wahinya/VelociMart-Business-Intelligence-Report
This project showcases how i helped VelociMart shift from Excel-based reporting to a robust data infrastructure using SQL Server and Tableau. Built around Sales, Customers, and Products Data Marts, it follows the Medallion Architecture (Bronze → Silver → Gold) to deliver clean, analysis-ready views for effective business insights.
Language: TSQL - Size: 2.22 MB - Last synced at: 5 days ago - Pushed at: 11 days ago - Stars: 0 - Forks: 0
vaxdata22/Water-Quality-DW-on-SQL-Server
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.
Language: Jupyter Notebook - Size: 394 KB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 1 - Forks: 1
vaxdata22/Water-Quality-DW-on-Oracle-Database
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.
Language: Jupyter Notebook - Size: 380 KB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0
sharmasapna/Pubmed_datawarehousing
Data Warehouse creation using MySQL and R
Size: 909 KB - Last synced at: over 1 year ago - Pushed at: over 3 years ago - Stars: 0 - Forks: 0
aehabV/AirlineDW
Data Vault model for analyzing the flight activity and reservation processes of a major airline company. Provides SQL scripts, queries, and reports for gaining insights into business operations and improving performance.
Size: 1.53 MB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0
Faisal-AlDhuwayhi/Data-Warehouse
Building Data Warehouse and ETL pipelines using Amazon S3 and Redshift
Language: Python - Size: 4.88 KB - Last synced at: almost 2 years ago - Pushed at: over 2 years ago - Stars: 1 - Forks: 0
KountourisPanagiotis/aueb-sql-final-project-database
A Coding Factory @ AUEB - SQL Project. - Final Project - Camping Database
Language: TSQL - Size: 9.77 KB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0
jackmulligan-ire/ppr-pipeline
Irish Property Price Register transformed into a data warehouse via an EtLT pipeline.
Language: TypeScript - Size: 22.7 MB - Last synced at: about 2 years ago - Pushed at: about 2 years ago - Stars: 2 - Forks: 0
