Three practices, one toolkit. Business intelligence turns scattered data into a clear view of what is. Advanced analytics moves past reporting into prediction. Custom software is the application your team runs the work in. Each ships production-ready, documented, and built to outlast the engagement.
Dashboards, reporting layers, and the semantic models behind them. Descriptive products that turn scattered data into a clear view of what is - and what has been.
Replaced client's manually compiled Excel portfolio status reports with a governed Microsoft Fabric Data App that gives eight departments at-a-glance triage of their Portfolio, refreshed straight from their application database.
A monitoring and diagnostic report that tells client how much to trust its demand forecasts - measuring accuracy and bias against arriving actuals across vintages, horizons, and methodology eras, which replaces roughly eight hours of manual forecast tracking each month.
A semantic model and BI solution that lets analysts explore and export time-series data from client's time series data warehouse without any SQL knowledge.
A semantic model and BI solution that automates client's monthly regulatory reporting to its regulator, integrating data from multiple utility service facilities and transforming thousands of transactional records into interactive analytics.
A semantic model and BI solution that integrates financial and operational data from multiple independent regulated entities into a single analytical platform, enabling cross-entity comparisons and data-driven analysis.
A semantic model and BI solution that automates demand forecast analysis, cutting manual Excel blending and enabling self-service insights for Finance Managers, Data Scientists, and Economists across client's operations.
Forecasting, segmentation, classification, ad-hoc modeling. Forward-looking products delivered as production-ready apps your team can run on a schedule.
A pipeline that ingests and processes IT Customer Support Service data, discovers and assigns topics to each ticket, ranks them by volume and resolution time, and produces a FAQ for staff to review on demand.
A pipeline that consolidates adjacent, common-owner tax lots into single buildable sites, correcting a long-standing supply overcount in client's six-year buildable land inventory.
An analytics tool to inspect regional planning simulation model calibration runs, enabling rapid loss-convergence visualization, parameter significance testing (pseudo-ANOVA/pseudo-F), and easy comparison of model specifications.
An automated time-series forecasting system that runs a multi-model competition across statistical, machine-learning, and transformer approaches to generate accurate 70-month forecasts for over three dozen demand series, enabling data-driven long-term capacity planning and budget development.
A reproducible, court-ready data pipeline that reconciled the opposing party's truck-diversion logs against scalehouse transaction records and exposed that 90% of sampled diversion claims were contradicted by their own data.
Full-stack web applications that replace the spreadsheets, forms, and handoffs running critical operations - internal tools, customer-facing products, AI-powered interfaces. Also where BI and advanced analytics ship as products, not just dashboards.
Designed and built an AI assistant that answers client staff and tax administrators' questions about the income tax, replacing hours of repetitive phone and email support that spike around quarterly filing deadlines.
A full-stack data management platform that consolidates fragmented operational and financial data from several of the client's source data systems into a centralized, validated database, replacing manual Excel workflows and providing a clean data foundation for ongoing cost-of-service rate studies.
A full-stack enterprise performance measures database system that replaces manual Excel-based workflows for 20+ client departments, featuring role-based access control, automated validation, and real-time reporting.
AI-powered tool that analyzes demand forecast dashboards and generates standardized narrative reports on demand, cutting manual report-writing time while enforcing consistency with client's reporting standards.