Full Development Code for iTrack PSES Web App: Public Service Employee Survey (PSES) Results Interactive Tracker (https://itrack.shinyapps.io/PSES and )
Re-use of codes and contributions are welcome!
As per Treasury Board PSES site, "the objective of the Public Service Employee Survey (PSES) is to provide information to support the continuous improvement of people management practices in the federal public service. The survey results will allow federal departments and agencies to identify their areas of strength and concern related to people management practices, benchmark and track progress over time, and inform the development and refinement of action plans. Better people management practices lead to better results for the public service, and in turn, better results for Canadians."
Unfortunately, the way the PSES results are published (as html files at <https://www.canada.ca/en/treasury-board-secretariat/services/innovation/public-service-employee-survey.html, where they are displayed separately for each department and each year). makes it difficult to conduct comparative multi-factor analysis of the departments performance to address the following questions:
- Which Department or which division within the same Department has the best resuls -- thus can be used as role model, and Which Department or which division within the same Department has worst ones -- thus needing measured to improve the situation? (performance variation analysis)
- When (in which years)_ did the performance improved / deteriorated in this Agency (or division within the Agency) ? (performance dynamics analysis)
- Which factors (which questions) are most likely the main contributors to the observed performance deteriotation or improvement ? (correlation analysis)
The iTrack PSES Web App is meant to resolve this limitation. It introduces a novel 21-century style, data science driven, framework for presenting and analyzing PSES results, which provides a very intuative, as much automated as possible, way to obtain answers to above questions.
The framework is illustrated using the PSES results from the author's home Agency/Directorate (https://itrack.shinyapps.io/PSES-CBSA-SE), the PSES results for which from 2008 to 2018 have been aggregated from multiple years and tracked over time and over the organization - compared vertically (ie. across the Org. Chart) and horizontally (across the years)
The original plan was to make the iTrack PSES App fully automated for all Public Service and all years, so that results can be tracked vertically and horizontally for any Public Service agency or department. This however has become harder than expected, due to large variation of questions structure accross the years and changes in organizational structures of the organizations. So, the App is left as is.
The Code is fully functional, albeit latest revisions have introduced some bugs (which should be easily detected and fixable)
The work is done at author's own time and initiative in effort to contribute to Public Service performance, as well as means to practice various new concepts and techniques related to doing open responsible Data Science using R and R Studio.
This work would not be possible without the support of many colleagues in my Agency and the open R Community. Kudos and big thanks to all of them!