Solución de inteligencia de negocio para la gestión de proyectos utilizando Microsoft y Pentaho

Anabel Montero Posada; Margarita Andre Ampuero

Authors

Anabel Montero Posada Universidad Pontificia Javeriana
Margarita André Ampuero UNIVERSIDAD TECNOLÓGICA DE LA HABANA “JOSÉ ANTONIO ECHEVERRÍA”

Keywords:

project management metrics and indicators, project management, business intelligence, Microsoft Business Intelligence, Pentaho Analytics

Abstract

Project management is one of the most influential factors in the success of a project. In order to carry out a good project management, company’s managers need information that helps them in their decision-making process. In this sense, it is especially useful to have measures and indicators to support this.

This article presents a concrete proposal of measures and indicators in different areas of project management, from conducting a study of standards, standards and work related to the subject, as well as conducting surveys to managers of the organization where the project was developed.

The article includes the design and implementation of a solution using Microsoft and Pentaho business intelligence tools. This allows to support the proposal of measures and indicators for project management. This solution allows you to save historical records and perform different types of analysis on the data.

References

APM. (2012). Association for Project Management Body of Knowledge 6th Edition.

Asad, F., & Pinnington, A. (2014). Exploring the value of project management: Linking Project Management Performance and Project Success. International Journal of Project Management, 32, 202-217.

Asana. (2021). Asana official web site. Retrieved from https://asana.com/es/product

Association, I. P. M. (2015). ICB - IPMA Competence Baseline Version 4.0.

Atica. (2021). Inteligencia de negocio para la gestión de proyectos. Retrieved from http://aticaingenieria.cl/business-intelligence-for-project-management/

Barnes Reports: 2021 U.S. Industry & Market report. (2021). (pp. 1-1-196).

Ca_Technologies. (2021). CA Automic Analytics and Reporting for External Data. Retrieved from https://www.broadcom.com/products/software/business-management/clarity-ppm/what-is-project-portfolio-management

Chaves, W., Frosi, P., Santos, M., Teixeira, M., & Buiatte, L. (2011). A comparative Analysis of the Agile and Traditional Software Development Processes Productivity. Paper presented at the 30th International Conference of the Chilean Computer Science Society.

Forrester. (2015). The Forrester Wave™: Portfolio Management For The Tech Management Agenda, Q1 2015. Retrieved from www.forrester.com

Gartner. (2019). Magic Quadrant for Project and Portfolio Management. Retrieved from https://www.gartner.com/en/documents/3917095/magic-quadrant-for-project-and-portfolio-management

Gartner. (2020). Magic quadrant for analytics and business intelligence platforms. Retrieved from https://gravitar.biz/bi/power-bi-lider-gartner-2020/

ISO. (2012). ISO 21500: Guidance on project management.

Kazi, L., Radulovic, B., & Kazi, Z. (2012). Performance Indicators in Software Project Monitoring: Balanced Scorecard Approach. Paper presented at the IEEE 10th Jubilee International Symposium on Intelligent Systems and Informatics.

Kerzner, H. (2017). Project Management. A Systems Approach to Planning, Scheduling, and Controlling (12th ed.). New Jersey, US: John Wiley & Sons, Inc.

Kimball, R., & Caserta, J. (2004). The Data Warehouse ETL Toolkit. Indiana, US: Wiley Publishing, Inc.

Luján-Mora, S. (2005). Data warehouse design with UML. (Tesis de Doctorado), Universidad de Alicante, España.

Luján-Mora, S., Trujillo, J., & Song, Y. (2006). A UML profile for multidimensional modeling in data Warehouses. Data & Knowledge Engineering, 59(3), 725–769.

Makar, A. (2013). 14 quality checks for your IT project schedule. Retrieved from https://www.techrepublic.com/blog/it-consultant/14-quality-checks-for-your-it-project-schedule/

Montero, A. (2016). Solución de inteligencia de negocio para la gestión de proyectos aplicada en un entorno universidad - empresa utilizando Microsoft y Pentaho. (Tesis de Maestría), Instituto Superior Politécnico “José Antonio Echeverría”, La Habana.

Obolinx. (2018). Five Project Management Performance Metrics key to Successful Project Execution. Retrieved from https://www.obolinx.com/five-project-management-performance-metrics-key-to-successful-project-execution-operational-excellence/

Olszak, C., & Ziemba, E. (2020). Business Intelligence and Big Data: Drivers of Organizational Success: CRC Press.

Paymo. (2021). Paymo official web site. Retrieved from https://www.paymoapp.com/

Planisware. (2021). Planisware official web site. Retrieved from https://www.planisware.com/enterprise/planisware-enterprise

Planview. (2021). Planview official web site. Retrieved from https://www.planview.com/

PM_Solutions. (2005). Measures of Project Management Performance and Value. Retrieved from http://www.pmsolutions.com/audio/PM_Performance_and_Value_List_of_Measures.pdf

PMI. (2017). A Guide to the Project Management Body of Knowledge Sixth Edition.

Presedo, C., Dolado, J., & Aguirregoitia, A. (2010). Estudio de métricas para el control de proyectos software. SISTEDES, 4(No 1).

Pressman, R. S., & Maxim, B. R. (2015). Software engineering: a practitioner’s approach (8th ed.). New York, US: Mc Graw Hill.

Rad, R. (2014). Microsoft SQL Server 2014 Business Intelligence. Birmingham, UK: Packt Publishing Ltd.

Standish_Group. (2021). CHAOS Report: Beyond Infinity. Retrieved from https://hennyportman.files.wordpress.com/2021/01/project-success-qrc-standish-group-chaos-report-2020.pdf

Tihinen, M. (2014). Measurement-based management of global software development projects. (Tesis de doctorado), Technical Research Centre of Finland. Retrieved from http://www.researchgate.net/publication/271824917

TodoBI. (2020). Herramientas Business Intelligence Open Source. Retrieved from https://todobi.com/herramientas-business-intelligence-open-source/

Wrike. (2021). Wrike official web site. Retrieved from https://www.wrike.com/es/