data-modelling

Optimus is an easy-to-use, reliable, and performant workflow orchestrator for data transformation, data modeling, pipelines, and data quality management.

dbt + Metabase integration

Data pipeline performing ETL to AWS Redshift using Spark, orchestrated with Apache Airflow

BENERATOR is a leading software solution to generate, obfuscate, pseudonymize and migrate data for development, testing, and training purposes with a model-driven approach.

Cool DE Projects

📈 🐍 Multidimensional synthetic data generation with Copula and fPCA models in Python

Hypergol is a Data Science/Machine Learning productivity toolkit to accelerate any projects into production with autogenerated code, standardised structure for data and ML and parallel processing out-of-the-box.

A practical guide to dimensional data modeling with clear examples, SQL scripts, and explanations of dimension types, fact tables, and star schema design. Built for learning and real-world reference

This repository is a working ETL framework which utilizes user data from Spotify API using ➲Python for Extraction and Transformation ➲SQL for Data Loading and Staging ➲Airflow for Data Orchestration and Monitoring ➲PowerBI for Reporting

⚙️ ETL pipeline on AWS using S3 and Redshift

Optimus is an easy-to-use, reliable, and performant workflow orchestrator for data transformation, data modeling, pipelines, and data quality management.

🎥 Email marketing campaign analysis

COVID-19 Surveillance Data Modelling and Management Pipeline in Piedmont.

A CIDOC-CRM-based Application Profile, consisting in a set of entities and properties for representing the digitisation process of cultural heritage objects in a machine-readable format.

This project showcases an end-to-end ELT (Extract, Load, Transform) pipeline leveraging the TPCH orders table from Snowflake's sample database. The primary goal is to demonstrate modern data engineering practices using Snowflake, dbt (Data Build Tool), and Apache Airflow.

Extensible Object Model Data Abstraction

DRA is an AI paid-media operating system. Plan Studio builds a channel-by-channel paid media plan from your website — where to spend, how much, and what to create — launches campaign targets, then tracks plan vs actuals and benchmarks. Built for mid-market marketing teams. Open source (MIT). Google Ads, GA4, GAM, Meta Ads, SQL, CSV, Excel, PDF.

Developed a 3-page Power BI dashboard (global and Asian overview) using Python scripts to load and clean World Bank data (1960–2020), reducing data processing time by 25\%. and Containerized the database in Docker, enabling scalable access, and visualized trends (e.g., 3\% annual GDP growth in Asia), enhancing stakeholder insights.

A Firestore ODM, with built-in validation, to make life easier for Go devs.

This repo covers the processes of designing a database by performing logical, conceptual and physical data modelling processes, creating the designed database using DML and DDL on various database server systems and performing SQL queries on the created database.