Airline analytics DWH with SSAS cube and Tableau dashboards built on SQL Server.
Generate a complete fictional Contoso retail dataset for Power BI and BI: star schema, deterministic, idempotent.
"Graduation project for ITI: A complete Hospital Management and Analytics System combining patient management, staff administration, and analytics dashboards."
A production-grade, enterprise data engineering & analytics platform transforming 5 heterogeneous HR and operational source feeds into a high-performance Kimball Galaxy Schema (Fact Constellation) for executive decision-making.
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.
End-to-end Data Engineering project for a Bicycle Store, using SQL Server and Python to build a Medallion Architecture data warehouse with Bronze, Silver, and Gold layers.
Dimensional data modeling portfolio: redesigning a complex analytical model into a validated star/galaxy schema with documented grain, relationships, data quality checks and row-level security.
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.
Part 1: Building an enterprise-style Power BI semantic model using dimensional modeling and Star Schema principles.
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.
End-to-end B2B last-mile delivery analytics platform using SQL, Power BI, and advanced DAX to analyze revenue leakage, delivery performance, financial risk, and retailer/supplier concentration.
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 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.
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.
To associate your repository with the galaxy-schema topic, visit your repo's landing page and select "manage topics."