Portfolio
Live projects and concept demonstrations showing our approach to NYC data challenges.
NYC 311 Service Pressure Dashboard
NYC 311 receives millions of service requests annually. Program managers need to quickly identify which Community Districts are experiencing elevated complaint volumes and what types of issues are driving that pressure.
Built a real-time choropleth dashboard that normalizes complaint counts by population, enabling fair comparisons across districts of different sizes. Added week-over-week trend indicators and drill-down capabilities.
Interactive map with 59 Community Districts, filterable by borough and complaint category. Click any district for detailed metrics including top complaint types, daily trends, and borough rankings.
Agency Spend Concentration Explorer
Agencies need visibility into vendor concentration to identify risk and ensure competitive procurement practices.
Aggregate Checkbook NYC data by agency, vendor, and contract type. Calculate concentration metrics (HHI) and flag outliers.
Dashboard showing spend distribution, top vendors by agency, and year-over-year concentration trends.
M/WBE Utilization Gap Map
NYC has M/WBE goals, but tracking utilization gaps by geography and industry sector requires significant manual analysis.
Combine contract data with certified M/WBE registry. Map utilization rates against goals by borough and NAICS code.
Geographic heatmap of utilization gaps with drill-down by industry sector and agency.
Capital Project Delay Tracker
Large capital projects often experience delays, but early warning signs are buried in progress reports and contract modifications.
Track milestone dates, budget modifications, and change orders over time. Flag projects deviating from baseline.
Portfolio view with project health indicators, deviation alerts, and historical trend charts.
Service Pressure Alerts
Service request spikes often indicate emerging issues, but staff can't monitor dashboards constantly.
Implement threshold and anomaly detection on 311 data. Send email alerts when districts exceed configurable limits.
Automated daily digest with flagged districts, plus immediate alerts for significant spikes.
Want to see a concept built for your team?
We can scope a prototype based on your data and requirements.