Business Intelligence & Analytics Portfolio
Olist brazilian eCommerce - Kaggle
The goal of this project is to replicate an end-to-end BI pipeline, transforming a transactional dataset into a scalable OLAP model in BigQuery and delivering an interactive Power BI dashboard. The focus is on data modeling, performance optimization, and production-grade analytics design.
Key points:
• OLTP → OLAP transformation (star schema design)
• BigQuery SQL modeling with partitioning & clustering
• Semantic and aggregation layers (views & pre-aggregations)
• End-to-end BI pipeline with Power BI dashboard
AirBnb analytics project
The goal of this project is to build an end-to-end analytics pipeline using dbt and Snowflake, transforming raw Airbnb-style data into a clean and scalable analytical model. The focus is on data quality, modular transformations, and production-ready data modeling practices, with version control managed through GitHub.
Key points:
• Layered architecture (raw → staging → marts)
• Data cleaning and standardization of messy inputs
• Data quality checks (built-in, custom, and unit tests)
• Incremental models and snapshots for performance and history tracking
• Reusable macros and modular SQL transformations