TowerHouse BI Platform
Graduation BI platform for communication campaign performance analytics.
The problem
Campaign performance data must land in a warehouse and surface on an executive dashboard.
The solution
SSIS ETL into a SQL Server warehouse, NestJS analytics API, Next.js executive dashboard. SSAS cube present for OLAP (not used by the web app).
Engineering
TowerHouse.BI.ETL (SSIS) · TowerHouse.BI.API (NestJS) · tower-house-bi-web (Next.js) · SQL Server warehouse.
My contribution
Graduation / freelance BI work spanning warehouse init, analytics API and executive web dashboard.
Outcome
Documented local run paths for the NestJS API (Swagger) and Next.js dashboard.
Key features
- ETL → warehouse → NestJS analytics → Next.js dashboard