Overview
The Challenge
Services
- Internal Web App
- Data Science Integration
- Revenue Forecasting
- Role-Based Access Control
- Interactive Reporting
- Data Visualization
- PostgreSQL
- Real-Time
- From 30–60 min Excel processing
- 5-Year
- Max forecast horizon
- Role-Scoped
- Per-user data access
- Custom
- Revenue model & market data engine
Forecasting Engine
From spreadsheet bottleneck to real-time data.
We worked alongside the Alcon data science team to build a structured database of products, sales history, revenue models, and market data. Internal staff log in to a role-scoped view of their own data, update estimated sales figures, attach notes explaining each change, and generate forecasts up to five years out, all grounded in actual historical performance and forward-looking market estimates. What once meant waiting an hour for a shared Excel file to recalculate now happens in seconds.
Interactive Reports
Revenue projections, visualized.
Forecast output is surfaced through an interactive charting layer built with shadcn/ui charts. Teams can explore multi-year projection curves, compare revenue model scenarios, and review market-adjusted estimates in a clean, purpose-built interface that turns dense model output into clear visuals that support real business decisions.
Built with
A modern stack purpose-built for real-time internal tooling.
- PostgreSQL
- React
- Shadcn/UI
- Tailwind CSS
- TanStack Query
- TanStack Router
- TypeScript
- Vite
- Zod
Insights
Related articles
When Spreadsheets Stop Working: How to Replace Excel with a Custom Internal Tool
A shared workbook is often where good business software begins. Here is how to tell when it has become a bottleneck, then turn its proven logic into a real-time, role-scoped web application your team can own.
When Your Process Is the Product: How to Tell It Is Time to Build a Custom Web App
Excel is only one container. Email, shared drives, SharePoint lists, and stitched SaaS tools become load-bearing software without anyone deciding they should. Here is how to tell when the process has outgrown the tool, who that decision belongs to, and what a custom web application actually replaces.
Related
Publishing Platform
Dave Campbell's Texas Football
20M+ annual visits. Custom publishing workflow, live scoring, podcasts, user personalization, and e-commerce.
Registration Platform
Performance Course
A multi-state parent registration and staff operations platform for one of the nation’s leading school-year athletic development programs, from K through high school.