June to July 2026
Six weeks, remote
Data Analytics Intern
TrueSource, an OnPoint Group company
- My first estimate of a system's failure rate looked alarming. I took it to the person who owns the process, learned that much of what I'd counted was routing working as designed, and re-cut the outcomes into four categories: handled correctly, intended routing, caller error and true system error. The real error rate was far lower and matched the team's own figure.
- Found why the data was confusing: many call records weren't linked to a Salesforce work order, so outcomes couldn't be measured. Proposed a first-contact resolution metric, and learned it needs a clear definition before anyone builds scorecards on it.
- Audited 29 KPIs across 4 operational dashboards (31 tabs), documented 7 inconsistencies between them from formulas and date filters, and made 8 consolidation recommendations. The analytics team added disclaimers to the live dashboards and flagged one for a rebuild.
- Validated a Power BI model against Salesforce: sample-tested 10 records, then compared the full populations across 2 tables. After my manager's review I changed my first verdict and documented what my first check missed.
- Used AI to classify a large set of calls by reason and resolution, and added a third angle to the analysis that nobody had asked for.
- Gave five presentations in six weeks, the last one to company leadership.
What I took from it: check a number with the person who owns the process before trusting your own cut of the data, and change your conclusion when the evidence changes.