In-house Analytics & Reporting Platform
Built the analytics layer from scratch — React and TypeScript on GCP reading production MySQL — and turned it into the dashboard Fortune 500 and Tier-1 teams open every morning.
4×
Adoption growth
Expanding into media and OTT
22%
Of company revenue
From 5+ Tier-1 clients won
100%
Manual reporting replaced
Superset + SQL models took over entirely
<2s
Median dashboard load
On multi-million-row datasets
Provisional
I built the company's analytics product in-house rather than buying one: a React and TypeScript application on GCP that reads directly from MySQL and renders enterprise-grade charts, drill-downs and reporting for large customers.
The hard part was never drawing the chart. It was getting the data model right so the same number means the same thing on every screen, at every level of aggregation, for every customer's slice of the data. I designed the SQL models, the transformation layer and the rendering layer as one system, so correctness holds end to end — then wired Grafana and Datadog instrumentation underneath it.
It replaced manual reporting outright, and it now drives roadmap decisions rather than just describing the past.
This is a startup, so the role came with every hat: I ran the customer conversations, wrote the product definition, laid out the development plan, built the product myself, worked with the team on the connective pieces, delivered it, and then owned the feedback loop — shipping improvements as real enterprise usage exposed friction.
Alongside the in-house build I delivered embeddable analytics through Apache Superset and Metabase, so customers who wanted our dashboards inside their own products could have them without us rebuilding the surface each time.
What I owned
- Customer discovery and ongoing product-level communication with Tier-1 accounts
- Product definition and development planning from a vague enterprise ask
- Full-stack build: React + TypeScript frontend, data layer, GCP deployment
- SQL modeling and query design against production MySQL
- Data-level verification at every stage — query, transform, aggregate, render
- Embeddable dashboards via Apache Superset and Metabase
- Instrumentation and observability with Grafana and Datadog
- Post-launch feedback loop and continuous improvement
Stack
- React
- TypeScript
- Python
- SQL
- MySQL
- GCP
- Apache Superset
- Metabase
- Grafana
- Datadog
Adoption trajectory
IllustrativeShape of the 4× adoption growth as the platform expanded into media and OTT.
Screenshot slot
public/projects/enterprise-analytics-dashboard/drilldown.png