Top of Mind
Turning massive Excel models into an AI-assisted planning platform. We unified Top of Mind’s fragmented media data, automated TV-planning analysis, and reduced complex decision cycles from a week to only hours.
Phase 1 Delivery
6 Months
Analysis Speedup
1 Wk → Hours
Excel Replaced
200–300 MB
Website
topofmindbd.com open_in_newWhat we’ve built for Top of Mind
Media Analytics & AI Planning Platform
Built a unified platform for automated data ingestion, OLAP query analysis, report exports, and AI-assisted decision making. The system replaces fragile 200–300 MB Excel workbooks with a centralized, high-performance analytical engine for TV-planning and media expenditure modeling.
Key Solutions Built
- check_circle Automated ETL pipeline for multiple media formats
- check_circle ClickHouse OLAP integration for high-speed querying
- check_circle Visual Query Builder with drag-and-drop aggregates
- check_circle Automated TVR, SOM, SOV, and SOE calculations
- check_circle Direct Excel & PPTX report export functionality
- check_circle Controlled AI Agent for natural-language data queries
The Challenge
Critical media decisions were trapped inside scattered tools and fragile 200–300 MB Excel spreadsheets. Analysts manually extracted viewership data, rebuilt calculations, and spent up to a week rerunning parameters whenever assumptions changed.
Our Approach
Mapped the entire analysis lifecycle, centralized clean data using ETL, provided an intuitive visual query interface, and added controlled natural-language AI querying on top of an explainable analytical schema.
Results & Impact
- • Complex analysis cycles dropped from a week to hours
- • Reused saved queries for instant campaign updates
- • Eliminated dependency on massive Excel workbooks
- • Direct export to client presentations
- • Initiated Phase 2 for commercial SaaS transformation
Have a similar data problem?
Turn fragmented data and spreadsheet-heavy analysis into a reusable intelligence platform.