BI Case Study
Personal Project
Studio Pierrot Anime Analytics
Designed a dimensional model, built a SQLite warehouse via Python ETL, and created a multi-tab dashboard analyzing anime IP performance — comparing legacy franchises to current industry hits, with simulated financial metrics.
Not affiliated with Studio Pierrot. Built alongside the Google BI Professional Certificate.
Python ETL
SQLite
Dimensional Modeling
Chart.js
Jikan API
BI Capstone
Applied Analytics
Japan Inbound Travel Intelligence Hub
Built a central intelligence hub for a Japan DMC — covering demand dashboards, FX impact analysis, seasonality patterns, airport capacity monitoring, and 2026 staffing forecasts to prepare for the inbound tourism surge.
Python
SQL
Chart.js
Time-series Forecasting