Case Studies

Employee Engagement and Satisfaction Dashboard

Posted by | Fuld & Company

A business services company conducted annual employee surveys to evaluate employee satisfaction, engagement, and recommendations to improve overall employment experience. After the survey deadline, they would spend four weeks analyzing the data and publishing results. The company wanted to reduce the turnaround time without compromising insights quality.


To leverage the survey data to better understand employees, automate subsequent result refreshes to achieve quicker turnarounds, and integrate survey findings with the learnings from annual appraisals.


  • Reviewed sanitized employee responses from surveys and key performance indicators from appraisal summaries. The company helped map appraisals with employee responses through internal employee IDs, which were masked and shared.
  • An automated data pipeline to ingest and normalize survey data was created. A star-schema model was developed to enable data trend reporting for KPIs such as NPS, CSAT, engagement, etc., and key learnings such as what was working or not.
  • Appraisal summaries were leveraged (including self-appraisals) to identify employees’ overall performance, key professional development areas, training needs, and satisfaction and engagement data to identify well-performing and highly-engaged employees who might have concerns that need attention and immediate intervention. In the long run, these timely interventions ensured higher employee retention rates.


  • Power BI dashboards were created to enable management to refresh, visualize, test, and validate survey results within two working days after survey deadlines.
  • HR personnel were able to follow up with employees to better understand their issues and plan necessary interventions to improve employee satisfaction.
  • A Power App was built for the HR team to compile details of its discussions with employees and close action items.



Tags: , ,

Related Resources

Read More

Grocery retailer uses machine learning to adjust daily prices to maximize revenue and profits

Background A US-based Grocery and Fresh retailer was grappling with retail giants like Walmart and national grocery chains, and wanted […]

Read More

Global medical equipment company discovers a new competitor…and a new market

A leading medical equipment manufacturer was concerned about a new entrant that had moved into one of its high-value, diagnostic […]

Read More

Identifying Drug Repurposing Collaboration Partners

A top pharma company actively working in the drug repurposing sector wanted to expand its portfolio by adding new indications […]

Subscribe to our mailing list for our latest updates: