galaxy-schema

Generate a complete fictional Contoso retail dataset for Power BI and BI: star schema, deterministic, idempotent.

Airline analytics DWH with SSAS cube and Tableau dashboards built on SQL Server.

Modern Automated Cloud ELT Pipeline for US Airline Data using Snowflake, dbt, Airflow, Backblaze B2, Docker, and Power BI. | DEPI Graduation Project

"Graduation project for ITI: A complete Hospital Management and Analytics System combining patient management, staff administration, and analytics dashboards."

End-to-end data engineering & BI project on Microsoft Fabric — Medallion architecture, Kimball galaxy schema with SCD Type 2, and a 6-page Power BI report, built on the Olist Brazilian e-commerce dataset.

Data Warehouse Engineering project built using datasets from the Brazilian e-commerce platform Olist. The project demonstrates the design and implementation of a modern data warehouse in SQL Server using the Medallion Architecture, including ETL pipelines, data cleansing and transformation, and dimensional modeling with a Galaxy Schema.

Dashboard Executivo em Power BI (Business Intelligence) para exploração interativa de métricas de produtividade e grafos de colaboração acadêmica no IFSP - Câmpus Pirituba.

End-to-end ETL Data Pipeline for Olist E-Commerce. Spark ingestion, Parquet transformation, Data Warehousing (Galaxy Schema) with SCD Type 2, incremental PostgreSQL loading, daily scheduling, Analytical SQL queries, and persistent Audit Logging.

Part 1: Building an enterprise-style Power BI semantic model using dimensional modeling and Star Schema principles.

An end-to-end business intelligence solution for a global hardware company, built with Power BI. Features a complex Galaxy Schema data model, advanced DAX for multi-faceted analysis, and a five-page report tailored for Finance, Sales, Marketing, Supply Chain, and Executive stakeholders.

End-to-end analytics project using PostgreSQL and Tableau to explore renewable energy technologies globally - integrating data prep, data modeling & design, SQL analysis, and dashboards. Covers trends in consumption, capacity, generation, emissions, costs, and public investments.

An end-to-end Formula 1 Data Analytics Platform built in SQL Server and Power BI. Features a Medallion Data Warehouse (Bronze, Silver, Gold), exploratory data analysis (EDA), advanced SQL analytics, and interactive dashboards.