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

PoC for building unstructured note based data-mart

Учебный проект по курсу “Системная аналитика DWH”, онлайн-школа T1

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.

SQL Case Study With Code

Build a dashboard of PT Kimia Farma sales in a year

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 the documentation of creating the sales report dashboard Kimia Farma as the final project to complete the virtual internship experience by Rakamin

Kickstarter project campaigns analysis by leveraging the theory and practice of Data Warehouse and Business Intelligence.

Data-driven analysis of the real estate market (Santiago, Dominican Republic) using web scraping, ETL pipelines, PostgreSQL and Tableau dashboards.

Data Construct-Populate-Access-Manage - Open source data warehouse solution.

This repository contains a Data Warehouse and Business Intelligence project focused on developing a Data Mart-based dashboard for visualizing Indiegogo crowdfunding data

Salicyl Sales Dashboard