Enhancing Performance Metrics: A Google Looker Studio Approach to Key Performance Indicator (KPI) Management System for Homecorp Offshore Drafting Team
Downloads
The Homecorp Offshore Drafting Key Performance Indicator (KPI) Management System is a comprehensive process that aims to improve the management and monitoring of key performance indicators within the drafting department. This system utilizes Google Looker Studio, which provides a user-friendly real-time data analysis and visualization platform. It enables managers to make well-informed decisions and enhance departmental performance. The process begins with collecting daily task data, logged manually or through automated Google Apps Scripts into a Google Sheets database. This data includes task details such as type, status, and completion time. A KPI-pointing system, developed through focus group discussions, also assigns point values to tasks based on their complexity and time requirements.
Integrating Google Looker Studio with Google Sheets allows real-time synchronization and web-based monitoring of key performance indicators (KPIs). The dashboard offers detailed insights such as task counts, average KPIs, and monthly performance graphs, providing a comprehensive performance evaluation. The implementation of this system has been well-received by the team, with survey results indicating improvements in tracking performance metrics, ease of use, and enhanced collaboration. While these outcomes are positive, there is still a recognized need for further refinement, particularly in incorporating qualitative data and improving IT support. The KPI Management System has significantly enhanced performance monitoring and management for the drafting team. To keep the system up-to-date and effective, ongoing feedback and iterative improvements must be maintained. Potential future enhancements could include extending the system's use company-wide to foster a culture of continuous improvement and accountability.
Davenport, T. H., & Harris, J. (2007). Competing on analytics: The new science of winning. Harvard Business Press.
Google Cloud. (n.d.). Looker Studio. Retrieved from https://cloud.google.com/looker
Gupta, S., Sharma, A., & Singh, A. (2019). Data-driven approach to business process optimization using analytics. Procedia Computer Science, 165, 37-46.
Kim, Y., Lee, D., & Park, Y. (2021). Leveraging analytics platforms for performance management: A systematic literature review. Information Systems Management, 38(1), 62-77.
Neely, A., Gregory, M., & Platts, K. (2005). Performance measurement system design: A literature review and research agenda. International Journal of Operations & Production Management, 25(12), 1228-1263.
Parmenter, D. (2015). Key performance indicators (KPI): Developing, implementing, and using winning KPIs (4th ed.). John Wiley & Sons.
Jones, L., & Patel, R. (2020). The impact of data analytics on decision making: A Looker Studio case study. Journal of Business Analytics, 3(1), 1-15.
Armstrong, M., & Taylor, S. (2014). Armstrong's handbook of performance management: An evidence-based guide to delivering high performance. Kogan Page Publishers.
Bourne, M., Franco-Santos, M., & Wilkes, J. (2015). Performance management: A literature review. In Handbook of research on comparative human resource management (pp. 363-394). Edward Elgar Publishing.
Chen, M., Mao, S., & Liu, Y. (2018). Big data: A survey. Mobile Networks and Applications, 19(2), 171-209.
Chen, Y. W., Wang, C. C., & Yu, T. J. (2019). Study on the impact of business intelligence and performance management on enterprise performance. Symmetry, 11(2), 289.
Hinds, P., & Bailey, D. E. (2003). Out of sight, out of sync: Understanding conflict in distributed teams. Organization Science, 14(6), 615-632.
Hu, Q., Chen, W., & Zhou, Z. (2020). Research on performance management of offshore project team based on KPI. Advances in Social Science, Education and Humanities Research, 386, 371-374.
Lareau, A., & Smith, S. (2017). Managing the performance of culturally diverse teams: A review of the literature and recommendations for future research. Human Resource Management Review, 27(1), 89-106.
Rezvani, A., Chang, A., Wiewiora, A., & Ashkanasy, N. M. (2017). Managing virtual teams: A review of current empirical research. Human Resource Management Review, 27(3), 543-574.
Wu, M. (2020). Performance measurement: A review of literature and a framework for developing the next-generation performance measurement systems. International Journal of Production Research, 58(6), 1661-1682.
Creswell, J. W., & Creswell, J. D. (2017). Research Design: Qualitative, Quantitative, and Mixed Methods Approaches. Thousand Oaks, CA: SAGE Publications.
Lindberg, C. F., Tan, S., Yan, J., & Starfelt, F. (2015). Key performance indicators improve industrial performance. Energy procedia, 75, 1785-1790.
Wannes, A., & Ghannouchi, S. A. (2019). KPI-based approach for business process improvement. Procedia Computer Science, 164, 265-270.
Samsonowa, T., Buxmann, P., & Gerteis, W. (2009). Defining KPI sets for industrial research organizations—a performance measurement approach. International Journal of Innovation Management, 13(02), 157-176.
