Data Mart based on Vancouver and Denver crimes data
Canadian disaster machine learning analysis and predictive model
Syracuse University, Masters of Applied Data Science - IST 722 Data Warehouse
Building an ETL workflow in SSIS for a retail data warehouse.
All assignments and the final project are completed in class CSCI 5408 (Data Management, Warehousing and Analytics) of MACS at Dalhousie University. CSCI 5408 DMWA Dalhousie University.
Star-schema data mart on PostgreSQL built from Goodbooks CSVs. Demonstrates advanced SQL (window functions, JSONB, GROUPING SETS), indexes (covering/partial/GIN/pg_trgm), materialized views, incremental MERGE loads, pgTAP tests, and GitHub Actions CI. Includes Docker quickstart and SSH-tunnel instructions
Sample analytics app created using SAPUI5 based on a data mart on SAP Cloud Platform.
Build a dashboard of PT Kimia Farma sales in a year
SQL Case Study With Code
DW://master is an interactive educational platform for mastering data warehousing concepts — from core architecture to advanced slowly changing dimensions (SCD), schema design, IBM Watsonx.data lakehouse technology, and SQL aggregation analytics. Features an AI tutor powered by Claude Sonnet 4 that answers questions about each topic in real-time📊.
Data Construct-Populate-Access-Manage - Open source data warehouse solution.
Data-driven analysis of the real estate market (Santiago, Dominican Republic) using web scraping, ETL pipelines, PostgreSQL and Tableau dashboards.
This project extracts and transforms data from the OTRS (Helpdesk) system, storing it in a dimensional model for BI purposes. The analytics focus on service request performance, including SLA compliance, ticket volume, and agent workload. SQL. Pentaho PDI. Metabase.
This repository contains a Data Warehouse and Business Intelligence project focused on developing a Data Mart-based dashboard for visualizing Indiegogo crowdfunding data
Medical Exams Data Mart ETL pipeline using Pentaho PDI 7 and PostgreSQL - Star Schema dimensional model
Add a description, image, and links to the data-mart topic page so that developers can more easily learn about it.
To associate your repository with the data-mart topic, visit your repo's landing page and select "manage topics."