Case Studies

We built an always-on HR assistant that answers policy questions in plain language. HR documents — the handbook, policy PDFs, benefits guides — were loaded into a searchable knowledge base.

HR Policy Assistant

AI, Automation

We built an identity resolution layer in Microsoft Fabric that assigns a single Universal ID to each distinct person and links their records across all source systems.

Identity Resolution Services

ETL/Data Engineering, Power BI, Microsoft Fabric

We built an event-driven provisioning pipeline on Microsoft Fabric. Employee records, IT ticket history, and hardware inventory were ingested into a lakehouse and reconciled into a single clean record per employee, then modeled into a warehouse containing employee and position dimensions alongside asset-assignment and onboarding-ticket facts.

HR Onboarding Automation

ETL/Data Engineering, Automation, Microsoft Fabric

Power BI Dashboard Modernization for Behavioral Health Provider

Behavioral Health Data

Power BI, Dashboard/Reports

We chose to employ cluster analysis to identify four unique personas of teachers.

Personas Analysis

AI/Data Science, Predictive Analytics, Python

We employed a random forest model. Each “tree” in the forest is a decision tree based on identifying patterns in the data that make a given house more or less likely to have sold in a particular way.

Real Estate

AI/Data Science, Decision Trees, Predictive Analytics, Python

Using AI to determine the sentiment and general topic of survey results, and then visualizing.

Sentiment Analysis

AI/Data Science, Python, APIs

Regression analysis to understand which engagement metrics raise an internal benchmark score.

EdTech Data Science

AI/Data Science, Regression, Python, Predictive Analytics

Complex mapping and analytics for survey and Census data.

Survey/NonProfit

Tableau, Excel, Dashboard/Reports

Analytics to inform inventory and management decisions.

Retail/POS

Power BI, Python, SQL, Dashboard/Reports

Dashboard to monitor helpdesk tickets with a Salesforce CRM database.

Ticketing/Salesforce

Power BI

Web-based visuals to quickly understand results for a COVID survey.

Survey/Government

Excel, HighCharts, JavaScript, Dashboard/Reports

Comprehensive and sliceable dashboard directly in the browser.

HR Dashboard

JavaScript, HighCharts, Dashboard/Reports

Simple in-browser visuals for quick analysis.

Nonprofit/Government

HighCharts, JavaScript, Dashboard/Reports

Sliceable Excel dashboards for call center analytics and monitoring.

Telecommunications/Call Center

Excel

Easy to understand visuals for quick analysis in the courtroom.

Legal Data/Law Case

Tableau

Part of a larger marketing dashboard - sample social media visuals.

Marketing Dashboard

Python, HighCharts, JavaScript