The world's fastest open query engine for sub-second analytics both on and off the data lakehouse. With the flexibility to support nearly any scenario, StarRocks provides best-in-class performance for multi-dimensional analytics, real-time analytics, and ad-hoc queries. A Linux Foundation project.

Personal Data Engineering Projects

Udacity Data Engineering Nano Degree (DEND)

A framework for rapid reporting API development; with out of the box support for high cardinality dimension lookups with druid.

Python scripts to set up a multidimensional model and run an ETL process for Ethereum data analysis.

API-first semantic layer engine with MCP server that compiles declarative YAML models into optimized, dialect-specific SQL across PostgreSQL, Snowflake, ClickHouse, Dremio, and Databricks.

A project to design a fact and dimension star schema for optimizing queries on a flight booking database using PostgreSQL, a relational database management system. This schema is well-suited for a flight booking database, as it allows for efficient querying of data such as booking dates, flight routes, and passenger information.

This repository is a place for the Data Warehousing course at the Information Systems & Analytics department, Santa Clara University.

Create Data Lake on AWS S3 to store dimensional tables after processing data using Spark on AWS EMR cluster

No description provided.

Demonstrating the core skills acquired by making use of Advanced Database Modeling.

This project encompasses the complete data lifecycle, from data extraction and transformation to in-depth analysis and compelling visualizations. The process is divided into three main phases

Enterprise-grade Data Platform for NYC Taxi Analytics. Orchestrated with Airflow (Astro) & dbt, served via FastAPI & Power BI. Features Medallion Architecture, Data Quality Observability (Slack), and Star Schema modeling.

Batch & streaming data pipelines built using Databricks with Pyspark and modeled the data into star schema to analyze in PowerBI, Formula-1 racing data from multiple data sources, APIs.

This repository is about designing a database model for Global Super Store. This project is the final project of the 7th course "Advanced Data Modeling" of Meta Database Engineer Professional Certificate on Coursera.

This project models an Online Cab Reservation System using a Star Schema for Dimensional Modeling. The database design focuses on analyzing reservations, driver performance, customer data, and more. The system is implemented in MySQL.

Microsoft Power BI é um ferramenta de BI Self-Service que empondera o usuário a criar Relatórios e Dashboards - Aqui terá dicas de aprendizagem - DAX - Soluções

ETL pipeline and data warehouse for e-commerce analytics using PostgreSQL and Python. Includes transformation scripts, schema modeling, and business insights via SQL.

Data Warehousing (DW) Project Building and Analysing a DW for NatureFresh Stores in NZ, built using a high-performance Oracle database 12c, and Index-Nested Loops Join-Oracle.

This repository is my final project for the Data Engineering Nanodegree Program.

Solo-built a senior-level analytics platform in 5 weeks: 471 messy government files → 320+ tested dbt models → 18 marts with 100+ CFO & equity KPIs → public BigQuery + 3 boardroom-ready Power BI dashboards. From zero knowledge to production-grade warehouse in 4 months — core build done in 5 weeks

Udacity Data Engineer Nanodegree - Postgres data modeling

No description provided.

DW de e-commerce (Kimball/Star Schema) em SQL Server, com scripts, dados sintéticos e docs para estudos.

Global Cycling Company Data Warehouse! We gather data from AdventureWorks 2016, utilize tools like SSMS for efficient storage and retrieval, and employ ETL processes for seamless integration and analysis. 🚴‍♂️🛠️

This repository contains the end-to-end pipeline for building a data warehouse for a real estate management company. The pipeline includes data generation, ETL process, creation of star schema dimensions and fact table, visualization using Power BI, and automation with Pabbly Connect.

Data Warehousing project | Outsourced for Autumn Group | Retail Outlet DW | Melbourne based | Sep - Feb 2018

Source code for the Kimball-style date dimension generator dimdates.com.

Data Engineering Projects including Data Modeling, Data Warehouse, Data Lake Development

YAML format for star schema and snowflake schema