Repeatable research
Source-specific collection and parsing produced structured rating exports.
Analytics product
Employee Sentiment Intelligence
Research tools, comparable ratings and executive reporting brought employee experience into a repeatable analytical product.
- My contribution
- Product lead · analytics engineering · executive storytelling
- Timeframe
- Multi-year product evolution
- Status
- Completed
THE WORK IN ONE LINE
Research, Python tooling and Power BI comparisons became a repeatable analytical offering and executive report.
01 / The problem
Useful feedback was hard to compare.
Employee research arrived across sources with different categories and units. A rating without its source or comparison group could look precise while answering the wrong question.
02 / What I built
I connected structured research inputs, source-specific Python parsers, Excel exports and Power BI measures. Company and cohort context stayed with the rating, then the findings became presentations an analyst could explain and use.
ESA / RESEARCH RATINGS
Fictional companiesA score with context.
FOCUS COMPANYCedar Works
Source: research samplePeriod: Q1 2026Unit: rating, 1–5
Cedar Works3.20 / 5
Selected peers3.80 / 5
Difference-0.60 pts
01 / PRESERVE THE SOURCE
Cedar Works / Career Opportunities
- Captured rating
- 3.2 / 5
- Source reference
- research-sample / cedar / Q1-2026
- Missing distribution
- Unavailable · not inferred from a mean
Cedar WorksSelected peer average
FROM CHECKED VALUES TO AN EDITABLE BRIEF
Career Opportunities
Cedar Works3.2 / 5Selected peer average3.80 / 5Gap-0.60 pts
Values are calculated from the sample. The observation remains a draft for analyst review.Inspect the ratings and calculation
| Company | Career Opportunities | Included |
|---|---|---|
| Cedar Works | 3.2 / 5 | Focus |
| Juniper | 3.9 / 5 | Selected peer |
| Alder | 3.7 / 5 | Selected peer |
| Maple | 3.8 / 5 | Selected peer |
peer_average = mean(selected_peers.same_scale_ratings)
gap = company_rating - peer_average
report.chart_values = checked_values
report.observation = draft_for_analyst_reviewThe peer average is an unweighted mean of the selected company ratings. It is not an industry benchmark.
Original illustrative reconstruction of the earlier research-rating workflow. The newer Voice Lab reporting app uses a different percentage scale and remains in development.
04 / Result & scope
What changed. What comes next.
Verified public career history and sanitized local product artifacts.
Defined comparisons
Dashboard measures put company ratings beside selected peer groups.
A reporting product
The delivered ESA practice evolved into defined offerings; the newer Voice Lab app remains in development.
Research toolkit
A project-folder builder, research launcher and capture/parser connect source pages to structured Excel outputs. Original source references and available source-specific metrics are retained.
Comparison design
The public example uses six older research-rating dimensions on a 1–5 scale. Selecting peers changes the actual comparison set. An equal-company mean is labeled selected peer average, never industry benchmark.
Voice Lab: the next chapter
The newer reporting app separates computed chart data from a draft narrative and maps both into editable PowerPoint templates. It uses different percentage-based dimensions and 24-month trends. Capture-to-generation and template-builder acceptance remain in progress.