BI Solution about Projects and HR

 This project, developed as part of an Engineering degree, focuses on the design and implementation of a Business Intelligence (BI) solution for a software company. The main objective is to support data-driven decision-making by tracking and analyzing key performance indicators (KPIs) in both the project management and human resources (HR) areas.

The Lean Startup methodology was used during the early stages to better understand user needs and define relevant KPIs. Product ownersplayed an active role in identifying the most valuable metrics, and several prototypes were created, tested, and approved to validate the direction of the solution.

The proposed solution has 4 componentes: Database, Web System, ETL System and Dashboards.

To manage data from multiple sources, the project includes a dynamic ETL (Extract, Transform, Load) system. This system allows end users to configure how data is extracted based on their needs. It uses Strategy and Factory design patterns to make it adaptable and easy to maintain. The ETL processes cover data from:

• Project area: Microsoft Forms, Jira, Odoo Projects Module, GitHub, GitLab, and custom Excel files used for test planning.
• HR area: Odoo Employees Module, Odoo Time Off Module, and Microsoft Forms.

A CRON-style automation feature was also implemented, letting users schedule the frequency of data updates for each data source. This keeps information current without requiring manual intervention.

Finally, a set of interactive dashboards was built using Power BI. These dashboards include all the KPIs requested by the product owners and provide a clear view of performance in both project and HR areas, helping teams make informed decisions based on real-time insights.