Error Communication Flagging & Reporting
Jun
2023
Problem / Purpose
Leadership needed a way to identify client or internal emails referencing possible service errors (e.g., payroll issues), but scanning raw email threads was inefficient and unreliable.
Solution
Used the cleaned email dataset to identify common error-related phrases. Created a dedicated table tagging emails based on matching keywords, and built a Tableau report that allowed users to dynamically include/exclude flagged phrases. Enabled fast scanning and review of potential service issue communications.
Key Achievements / Impact
Delivered a dynamic reporting solution that enabled stakeholders to efficiently monitor communications for possible service breakdowns. Provided a flexible interface to refine keyword sets and reduce manual email review time.
Key Technologies / Tools Used
Snowflake, SQL, Tableau, Text Analysis, Text Mining, Data Product Design
Role
Data Scientist
ProService Hawaii