Skip to main content

Our work

Selected engagement highlights across analytics, AI enablement, and data modernization.

Showing 18 projects

Performance & KPI Design

KPI Redesign to Improve Conversion & Experience Consistency

National home improvement retailer

Situation

Flooring installs had conversion leakage and inconsistent customer experience. Existing measures didn't isolate what store teams could influence, and some stores routed around central services, increasing variability.

Task

Create operational KPIs reflecting controllable drivers of conversion and experience quality, align stakeholders, and operationalize the metrics for coaching and field action.

Action

Created an Estimate Quality KPI based on project square footage (rather than total cost) to normalize job scope and align performance to what associates control. Created a Store-Only Request Rate KPI to surface experience fragmentation. Aligned Merchants, Store Ops, leadership, Analytics, and Field teams on definitions. Published store dashboards with associate-level drill-down and field leadership reports.

Results (3)

  • Shifted decision-making from pricing proxies to scope and behavior levers
  • Improved consistency by reducing store-only workarounds
KPI DesignConversionCXField AnalyticsStakeholder Alignment
Performance & KPI Design

Enterprise Performance System: North Stars + Team KPIs

National home improvement retailer

Situation

Performance visibility across service teams was fragmented; leaders lacked consistent rollups while teams lacked role-specific KPIs tied to day-to-day execution.

Task

Create a scalable performance system combining shared north stars with team-controllable metrics, delivered in tools that work for both leaders and front-line coaching.

Action

Anchored north stars on Conversion Rate and Measure Volume. Built enterprise dashboards in Tableau and delivered individual report cards via Excel and Outlook automation for push distribution. Delivered role-specific KPI suites for field measurement (scheduling, on-time behavior, customer feedback, compliance) and call center teams (phone metrics, productivity, real-time execution).

Results (3)

  • Established consistent performance operating system across the organization
  • Enabled aligned leadership rollups and actionable coaching signals
TableauPerformance ManagementAutomationOperating Model
Performance & KPI Design

Behavior-Based Engagement Metrics Replacing Proxy KPIs

Professional education and services organization

Situation

Teams relied on proxy KPIs (signups and certificates) that didn't reflect real engagement, limiting content optimization and decision quality.

Task

Replace proxy measures with behavior-based engagement metrics and deliver dashboards content teams can use to improve performance.

Action

Built engagement measurement using verified participation signals with platform tracking in 8-minute intervals requiring explicit user confirmation. Standardized consumption metrics using minutes/hours watched and consumption rate, analyzed against customer consumption percentages per week. Delivered customized dashboards per content team enabling targeted actions: promote strong content, redesign, resequence, or retire low performers.

Results (3)

  • Shifted teams from optimizing proxy outcomes to optimizing verified engagement behavior
  • Improved content decision-making with actionable consumption data
Product AnalyticsEngagementKPI DesignBehavior Metrics
Performance & KPI Design

Product Experimentation Framework

B2B SaaS platform

Situation

Teams lacked a structured experimentation process and consistent measurement methodology for product changes.

Task

Create a framework for reliable product testing and data-driven decision-making.

Action

Built an experimentation framework with standardized metrics, statistical rigor, and controlled rollout processes to enable teams to test product changes with confidence.

Results (3)

  • Improved experiment velocity and decision clarity
  • Standardized measurement for product changes
A/B TestingProduct AnalyticsExperimentation
Predictive Analytics & ML

Granular Demand Forecasting for Proactive Staffing

National home improvement retailer

Situation

Demand for field services fluctuated by geography, and staffing decisions were reactive—capacity gaps appeared after demand spikes had already hit.

Task

Forecast service volume at granular geographic levels so hiring, training, and scheduling could ramp ahead of demand.

Action

Partnered with a data scientist to build and operationalize a forecasting model at the geographic quota-group level, incorporating seasonality, promotions/marketing effects, local trend signals, and operational factors. Translated forecasts into workforce planning inputs for hiring pipeline timing, training readiness, and scheduling capacity.

Results (3)

  • Shifted from reactive to proactive capacity planning
  • Improved hiring and scheduling alignment with demand patterns
ForecastingWorkforce PlanningModelingOperations Analytics
Predictive Analytics & ML

Training Recommendation Model Tied to Customer Survey Outcomes

Global automotive manufacturer

Situation

Customer survey outcomes and training data existed in separate systems across the global dealer network, limiting the ability to tie learning programs to customer experience results.

Task

Unify survey outcomes with course completion history and produce actionable recommendations for training that improves specific deficiencies.

Action

Consolidated survey outcomes into a unified dataset spanning sales and service. Joined to global dealer personnel training records. Built a recommendation model in R using classification and regression approaches including Random Forest, producing recommended courses by deficiency pattern. Delivered outputs in Tableau with individual employee drill-down and dealership rollups.

Results (3)

  • Enabled targeted training interventions by specific deficiency pattern
  • Shifted training from generic pushes to evidence-based recommendations
Machine LearningRTableauTraining AnalyticsCX
Predictive Analytics & ML

Reducing Avoidable ED Visits via Risk Tiering & Visit Recommendations

Healthcare services company

Situation

Avoidable Emergency Department visits were a key cost and care-quality issue. Care managers needed a consistent way to identify rising-risk patients and intervene earlier.

Task

Tier patient risk and recommend care intensity including visit frequency using clinical and non-medical context, operationalized for care manager workflows.

Action

Built risk tiering and visit-frequency recommendation models using classification and regression including Random Forest. Combined diagnostic codes with utilization and treatment signals, enriched with census and public data for contextual risk factors. Embedded outputs into call-center care manager workflows to steer patients toward primary care and virtual visits when appropriate.

Results (3)

  • More frequent engagement and proactive routing toward primary and virtual care
  • Aligned interventions with program goal of reducing avoidable ED visits
Healthcare AnalyticsMachine LearningRisk ModelingSDoH
Marketing & Customer Analytics

Funnel & Incremental Lift Measurement for Quarterly Promotions

National coffee chain (via agency)

Situation

Quarterly promotional games needed to drive participation and measurable behavior change, not just awareness—but no measurement framework existed to connect the funnel to actual outcomes.

Task

Design measurement and reporting tying the promo funnel (play → rewards → signup) to incremental customer behavior, and feed learnings into each quarter’s iteration.

Action

Defined KPIs across the full funnel plus behavior outcomes: participation, rewards earned and redemption, loyalty engagement, and visits per week. Integrated web/app activity, POS transactions, and loyalty usage into a cohesive measurement view. Compared promo vs. non-promo periods using visits-per-week to quantify lift, and segmented results to identify what drove stronger participation and frequency.

Results (3)

  • Created a repeatable measurement loop for iteration-over-iteration improvement
  • Grounded promotional decisions in actual engagement and frequency lift
Marketing AnalyticsMeasurementLoyaltyFunnel Analysis
Marketing & Customer Analytics

CDP & Journey Optimizer Implementation Under Security Constraints

Major financial institution (via agency)

Situation

The institution implemented a real-time CDP and journey orchestration platform to enable unified profiles and personalized journeys, but banking-grade security constraints—especially encryption requirements—created architectural blockers.

Task

Drive implementation end-to-end: define measurable onboarding and cross-sell use cases, translate business goals into data and engineering requirements, and manage delivery risk when security requirements exceeded platform capabilities.

Action

Shaped priority use cases (onboarding into programs, cross-sell) with measurement expectations. Mapped data flows and defined requirements across stakeholders, analytics, and engineering. Managed delivery friction by adjusting sequencing and scope when vendor-promised features weren’t production-ready and when encryption requirements exceeded platform capabilities.

Results (3)

  • Moved program from tool installation to operational planning with measurable use cases
  • Surfaced implementation risk early, enabling realistic delivery approach
MarTechCDPJourney OrchestrationDelivery RiskStakeholder Alignment
Platform Modernization

Rebuilding the Analytics Foundation: Lakehouse + Trustworthy Reporting

Professional education and services organization

Situation

Reporting quality was poor and fragmented, with key information spread across multiple platforms and important data not consistently available. Existing BI reporting lacked reliability and trust.

Task

Build a central data foundation and deliver reporting stakeholders trust—then prove the new numbers are better than legacy reporting.

Action

Built a Microsoft Fabric Lakehouse as the central hub for data consolidation. Conducted discovery to locate sources, identify missing information, and understand team needs. Reconciled legacy vs. new logic, explained differences, and iterated until stakeholders accepted the improved definitions and outputs.

Results (3)

  • Established dependable data foundation replacing fragmented reporting
  • Increased trust through explainable, reconcilable metrics
Microsoft FabricLakehouseBI ModernizationStakeholder Trust
AI & Automation

Conversational Intake to Jira for Predictable Analytics Delivery

Professional education and services organization

Situation

Analytics requests arrived through scattered emails and DMs to individuals, creating confusion, inconsistent requirements, and limited visibility into the backlog.

Task

Centralize intake and triage while improving request quality without forcing rigid forms on stakeholders.

Action

Implemented conversational intake using Microsoft Copilot Studio integrated with Jira, creating tickets that rolled into projects. Kept intake dialog-based to gather context naturally, with asynchronous follow-up for missing details instead of blocking submissions. Ran weekly triage meetings using the structured backlog to improve ability to pivot for urgent work without losing queue control.

Results (3)

  • Reduced person-dependent chaos in request routing
  • Improved prioritization and organization of analytics work
Workflow AutomationCopilot StudioJiraOperating Model
AI & Automation

Knowledge Assistant for Legacy Reporting Inventory & Deduplication

Professional education and services organization

Situation

Reports, queries, and dashboards were distributed across the organization with unclear ownership and duplicates, making replacement planning difficult and undermining trust in data.

Task

Inventory legacy reporting at scale, capture requirements consistently, identify duplicates, and drive consolidation toward a single source of truth.

Action

Built a conversational assistant that initiated discovery from forwarded emails containing existing reports, then interviewed stakeholders via chat to capture purpose, users, cadence, definitions, and desired future state. Persisted captured inventory into SharePoint and a structured repository in the Fabric Lakehouse. Focused on capture, organization, and duplicate detection across dozens of artifacts to support consolidation decisions.

Results (3)

  • Eliminated duplicate reporting through structured inventory and detection
  • Advanced single-source-of-truth approach across the organization
AIKnowledge ManagementDeduplicationReporting Modernization
Governance & Compliance

Governance Council + Enforced Metrics, Access Controls & Auditability

Professional education and services organization

Situation

Inconsistent metric definitions, uneven access practices, and limited auditability created reporting disputes and governance/compliance risk.

Task

Establish a governance operating model that standardizes definitions, enforces permissions, and provides audit trails.

Action

Operated a governance council and implemented board-approved governance policies. Defined metric standards, usage permissions, access levels, and audit logging. Enforced rules through platform controls: Fabric permissions, Power BI workspace and dataset controls, and Microsoft Purview for governance visibility and enforcement.

Results (3)

  • Reduced shadow reporting and ad-hoc SQL outputs
  • Increased adherence to approved metric definitions
GovernanceSecurityMicrosoft PurviewPower BIAuditability
Operations & Finance

Factory Fire Response: Financial Documentation & Stakeholder Coordination

Manufacturing company

Situation

A factory fire destroyed the manufacturing facility, creating immediate operational and financial disruption requiring rapid documentation and stakeholder management.

Task

Own the financial documentation required for insurance and disaster recovery, and support continuity communications with vendors and customers.

Action

Led end-to-end financial documentation: coordinated inventory and asset records, assembled supporting evidence, and prepared structured loss documentation. Managed vendor and customer communications during disruption, including limited outsourcing while leadership evaluated viability.

Results (3)

  • Delivered complete, organized documentation for insurance and closure activities
  • Reduced confusion for vendors and customers during disruption
OperationsFinanceCrisis ResponseStakeholder Management
Operations & Finance

Drug Disposal Cost Reduction

Pharmaceutical company

Situation

Recurring operational costs tied to drug disposal were materially impacting spend with no existing initiative to address them.

Task

Deliver a targeted savings initiative for the CFO by reducing disposal cost without compromising compliance or operational needs.

Action

Executed a CFO-sponsored special project combining vendor renegotiation with process change: analyzed cost drivers, reframed requirements into negotiable terms, negotiated improved vendor pricing and terms, and supported implementation to ensure the change was repeatable.

Results (3)

  • Delivered significant annual cost savings in drug disposal
  • Maintained full regulatory compliance throughout the transition
Cost ReductionVendor ManagementFinanceCompliance
Operations & Finance

Consolidated Operational Reporting for Executive Leadership

Real estate management company

Situation

Operational updates were scattered across teams and formats, slowing decision-making and obscuring performance visibility for leadership.

Task

Create a simple reporting system that gives leadership fast visibility into operational execution across maintenance and collections.

Action

Consolidated maintenance reports and tenant rent collection into a standardized spreadsheet with consistent structure and definitions, replacing fragmented updates and enabling quick review and follow-up.

Results (3)

  • Improved speed and clarity of operational insight for leadership
  • Reduced time spent chasing updates across teams
OperationsReportingExecutive SupportProcess Design
Enablement & Change Management

Data Literacy Enablement: Roundtables + Training Library

Professional education and services organization

Situation

Analytics adoption was constrained by uneven data literacy. Teams needed role-appropriate training and shared language for dashboards and KPIs.

Task

Improve analytics skills across the organization and create a repeatable learning cadence for data-adjacent staff.

Action

Ran bimonthly analytics roundtables for people working with data to learn and share practices covering dashboard literacy, KPI interpretation, experimentation concepts, platform basics, and responsible AI usage patterns. Delivered company-wide sessions showcasing delivered work and teaching fundamentals. Recorded all sessions to create a reusable training library.

Results (3)

  • Raised baseline analytics fluency across the organization
  • Improved stakeholder engagement with dashboards and metrics
Data LiteracyTrainingChange ManagementAdoption
Enablement & Change Management

Analytics Team Scale-up & Operating Model

Mid-market services organization

Situation

Growing analytics backlog and inconsistent delivery were slowing business initiatives, with no clear operating model for the team.

Task

Build and scale the analytics organization to meet growing demand with repeatable processes.

Action

Expanded the analytics team with clear operating cadence, tooling standards, and governance. Introduced structured intake, prioritization, and delivery workflows to ensure consistent output quality.

Results (3)

  • Expanded team capacity and delivery speed
  • Reduced backlog and improved stakeholder satisfaction
Team BuildingHiringProcess DesignOperating Model