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

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.

Building an ETL workflow in SSIS for a retail data warehouse.

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

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

Salicyl Sales Dashboard

A collection of data that becomes the central source of information with specific objects in a consistent format is often referred to as a data repository. In a data warehouse, data users can access the repository to gain desired insights through specific analyses.

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