Employee sentiment,
at every scale.
I built the tools, data workflows and analytical views that turn employee feedback into practical client conversations.
- Industry
- Employer
- Topic
- Employee voice
The whole picture. Then the detail.
Explore a fictional reconstruction inspired by ESA Dashboard 3.0.
Where the experience diverges
Positive share of coded comments
Synthetic data. No employee or client records.
How to read this example
Select an industry, employer and topic to update the comparison and report below. Positive share is positive mentions divided by all sentiment-coded mentions for that topic. Each employer has 100 fictional mentions per topic; each fixed industry sample has 1,000. The industry sample represents a separate illustrative cohort, not an average of the three employers shown. One review can mention multiple topics. Gaps are percentage points (pp); these are not 1–5 star ratings, net sentiment scores or estimates of all employees.
A rating starts the conversation.
A Full ESA goes deeper.
The complimentary benchmark established context. Full ESAs added trends, taxonomy-level sentiment, employee voice and recommendations aligned to the client’s needs.
What sits beneath the overall score
Illustrative report · Cedar FinancialSynthetic data and sample narrative. Chart formats informed by the older Full ESA decks. Recommendations require analyst and client review.
I built the system
behind the story.
Research tooling, a shared data layer, analytical views and client-ready reporting—designed as one connected workflow.
Collect & structure
Configurable Python tools normalized source-specific ratings and review data.
Python · pandas · JSONConnect & classify
Smartsheet served as the interim database, with API write-back and industry and topic mapping.
Smartsheet API · NAICS · taxonomyExplore & interpret
Power BI connected industry benchmarks to employer sentiment, trends and individual comments.
Power BI · DAX · ESA Dashboard 3.0Explain & act
Full ESA reports translated findings into conversations and recommendations for the client team.
PowerPoint · analytical narrative
Smartsheet kept the data connected while I worked through the organization’s database approval process. Collection updates flowed into the on-premises dashboard, keeping employer ratings and benchmarks tied to the underlying research.
A later shift to Revelio Labs, without licensed API access, changed the collection architecture. I adapted the workflow to the available data and access, while preserving analyst review and a useful client deliverable.
A delivery tool.
A real handoff.
Voice Lab brought the later workflow into a desktop application. I installed it and trained the team to use it.
Its reports were less granular than the older Full ESAs. The broader system also explored Copilot-assisted guidance for client teams, executive producers and sales.
Tooling / Data architecture / Visualization / Automation / UI & UX