Projects
NHL Analytics Data Warehouse
Full NHL analytics data warehouse by scraping official data using Python and modeling it into a PostgreSQL dimensional warehouse with multi-grain fact tables.
PostgreSQL Data Warehouse (Bronze–Silver–Gold)
Structured data warehouse using a three-layer approach (Bronze/Silver/Gold) in PostgreSQL, powering a Looker Studio dashboard for customer and product reporting.
HIFK Playoff Profit Calculator
Scenario-based financial model to evaluate the profitability of playoff home games, quantifying financial risk and break-even points across different playoff outcomes.