Healthcare Market-Explorer Dashboard with Geospatial Analytics
An enterprise conversational-AI platform
Overview
A React-based market-explorer dashboard for the platform’s healthcare vertical, surfacing hospital pricing, insurance-network coverage and competitiveness across US metropolitan markets. It combines an interactive Mapbox map, charted analytics and tabular drill-downs over a serverless Firebase Functions data layer.
The Challenge
Healthcare cost and network data is dense, geographic and hard to compare. Stakeholders needed to explore rates, coverage and market scores by MSA (metropolitan statistical area), hospital and insurance network, and to see those comparisons on a map and in charts rather than raw tables.
What We Built
A React single-page app (React Query via @react-query-firebase, React Router, Formik + Yup forms, react-pro-sidebar) with a Firebase Cloud Functions backend exposing a focused set of analytics endpoints, each as its own function: getAllHospitals, getAllInsuranceNetworks, getAllMSACodes, getAllProcedureCode, getCoverageByMsa, getInsuranceByMsa, getPriceByMsa, getRateData, getRatesBasedOnHospitals, getRatesBasedOnInsuranceNetworks, getAverageNetworksMarketScoreByMsa, getEstimatedTotalCost, getMostPopularServices, and more. The functions query a relational store through Knex. On the client, mapbox-gl/react-map-gl render geospatial views, recharts draws the analytics, and react-table plus react-paginate handle large result sets, with react-toastify and loaders for UX.
Technologies & Approach
React with React Query for data fetching/caching against a serverless Firebase Functions API kept the deployment simple while isolating each analytics query as an independent, cacheable endpoint. Knex provided SQL access on the backend; Mapbox GL and Recharts did the heavy lifting on geographic and statistical visualization.
Outcome / Impact
Delivered an interactive market-intelligence tool that turns dense healthcare pricing and network data into map-based, charted, drillable insight by metro area, one of several per-vertical builds in this platform family.
Capabilities Demonstrated
- Geospatial visualization with Mapbox GL in React
- Serverless analytics APIs (Firebase Functions + Knex/SQL)
- Healthcare pricing, coverage and market-score analytics
- Interactive dashboards with charts, paginated tables and forms