Article

October 26, 2026

Development of a recruitment and selection panel to improve the monitoring of selection processes

Ana Carolina Pereira De Araujo; Stefano Francisco Pereira Duarte

DOI: 10.22167/2675-6528-202600521

Article derived from a Course Conclusion Work (TCC), with content based on the student’s original work and adapted to the editorial format of the E&S Magazine with the support of the ResumeAI tool, an artificial intelligence solution developed by Instituto Pecege for textual synthesis and organization.

Summary

The study addressed the challenges in monitoring selection processes, arising from data fragmentation, lack of standardization, and manual report generation, which compromised visibility and decision-making. The objective was to structure an analytical solution capable of organizing, integrating, and providing information in an automated, clear, and accessible manner. The methodology adopted the PDCA cycle, with the Ishikawa Diagram for cause identification and the 5W2H plan for action planning. Operational databases were processed and standardized via Power Query, enabling the construction of a structured data model in Power BI and the development of visualizations aligned with the process needs. As a main result, the consolidation of scattered data, increased information reliability, reduction of rework, and expanded transparency and user autonomy in indicator monitoring were observed. The time to generate reports decreased from 1h30-2h to 10 minutes daily, and the update frequency changed from weekly to daily, with direct access to the dashboard. It was concluded that the developed dashboard met the study’s purpose, configuring itself as a practical, sustainable, and applicable solution for Recruitment and Selection management, strengthening data-driven decision-making.

Keywords: Process monitoring; Business Intelligence; Data management; PDCA; Decision making.

1. Introduction

In the contemporary corporate context, characterized by intense digital transformation and the growing demand for data-driven decisions, the area of recruitment and selection (R&S) assumes an increasingly strategic role in organizations. The competitiveness of the job market, the pressure for greater operational efficiency, and the need for predictability in selection processes make structured monitoring of the stages an essential requirement for aligning Human Resources with other requesting areas (Breviário et al., 2025; Peeters; Paauwe; Van De Voorde, 2020; Rasmussen; Ulrich; Ulrich, 2024). In this scenario, Business Intelligence (BI) tools have stood out for their intrinsic ability to organize, integrate, and visualize data clearly, dynamically, and strategically, offering robust management support (Microsoft, 2024; PMI, 2021).

Despite technological advancements, many R&S departments still face significant challenges related to information fragmentation, lack of standardization in databases, and difficulty in consolidating essential metrics for decision-making. In the specific case studied, the absence of a unified view of the recruitment funnel generated considerable rework for the Recruitment and Selection team. The manual preparation of weekly reports, necessary to serve managers and internal clients, consumed time, increased the probability of operational errors, and delayed the delivery of crucial business information, such as vacancy status, deadlines, and average time in each process phase.

Additionally, the limited visualization of data made it difficult to identify bottlenecks in the workflow, making tracking unintuitive and restricting the strategic potential of the Human Resources sector. More complete analyses depended on successive data consolidation rework. This operational gap, evidenced by both specialized literature and the team’s daily practice, demonstrates the urgent need for more robust analytical structures capable of transforming raw data into accessible, reliable, and up-to-date information to support decisions (Milani et al., 2020; Ghatak, 2022).

In this context, performance measurement through indicators becomes a key element for the professionalization of Recruitment and Selection, allowing the process to be driven by concrete evidence, rather than predominantly by subjective perceptions. Indicators such as average time to fill vacancies, volume of open positions, and adherence to deadlines enable greater process control, identification of inefficiencies, and support for managerial decisions. The literature indicates that the adoption of analytical practices in HR, often referred to as People Analytics, contributes to increased predictability, operational efficiency, and strategic alignment of the area with organizational objectives, reinforcing HR’s role as a strategic business partner (Milani et al., 2020; Peeters; Paauwe; Van De Voorde, 2020; Rasmussen; Ulrich; Ulrich, 2024).

The development of analytical solutions applied to the organizational context converges with approaches of continuous improvement and Quality Management, in which the structured use of data plays a central role in the control and enhancement of processes. The Plan-Do-Check-Act (PDCA) cycle, widely used in corporate environments, provides a solid methodological basis for identifying problems, implementing improvements, monitoring results, and standardizing more efficient practices (Werkema, 2012). Thus, the construction of a Business Intelligence dashboard aimed at monitoring the selection process is configured not only as a technological solution but also as a management tool, capable of supporting continuous monitoring, reducing operational variabilities, and offering greater reliability to the information used by the Recruitment and Selection team and by the managers involved.

Given this scenario, this work proposes the development of a Business Intelligence dashboard aimed at monitoring selection processes, with the objective of reducing rework, increasing information transparency, optimizing response time to internal clients, and improving decision-making in the Recruitment and Selection area.

2. Material and Methods

This study was characterized as an applied research, of a descriptive nature, with a qualitative methodological approach, focused on the development of a practical solution for an organizational problem. The empirical object was the Recruitment and Selection (R&S) process of a large company in the electricity sector, with national operations and approximately 16,000 employees. The unit of analysis focused on the R&S department, which had about nine recruiters, one supervisor, and one manager, responsible for conducting and monitoring the selection processes.

To structure the project development, the PDCA cycle methodology (Plan, Do, Check, Act) was adopted, widely used in continuous improvement and quality management processes (Werkema, 2012). This approach allowed the study to be divided into interdependent and sequential stages, ensuring coherence between the diagnosis, planning, development, evaluation, and the necessary adjustments for the construction of the Business Intelligence dashboard.

In the Planning (Plan) stage, the central problem, the objectives for building the dashboard, and the information collection criteria were defined. A meeting was held with the project’s focal people, during which the Ishikawa Diagram was applied to identify and organize the main factors hindering the monitoring of selection process data (Werkema, 2012). Complementarily, the 5W2H plan was used to guide the definition of actions foreseen in the planning.

The data collection was based on the operational spreadsheet used by the Recruitment and Selection team, updated daily by recruiters with information on the progress of selection processes. These data were subjected to organization, standardization, and structuring procedures in Power Query, in order to ensure adequate conditions for analytical modeling, according to good data preparation practices (Kimball; Ross, 2013).

In the Execution (Do) stage, data were treated and organized in Power Query, including cleaning, integration, date standardization, and textual field review. The historical database was integrated, encompassing data from selection processes registered since 2023, and continuous consolidation between historical data and updated records was automated. The team was communicated about the updates and received guidance on best practices.

With the data structure completed, the construction of the dashboard in Power BI began. The data model was established, defining the relationships between the main Recruitment and Selection table and auxiliary tables, such as companies, cities, professional levels, recruitment types, and SLA classifications. DAX measures were developed for calculating the average SLA of vacancies, performance indicators by stage, and process count metrics (Microsoft, 2024; PMI, 2021).

Filters, segmentations, and interactive parameters were configured to provide clear and intuitive navigation. Visualizations were defined by selecting charts, cards, and dashboards that best represented the relevant information, resulting in an organized and dynamic interface. SLA (Service Level Agreement) tracking by stage of the recruitment and selection process was implemented to measure the average time vacancies remained in each phase of the R&S flow.

The calculation of the average SLA per stage was performed based on the sum of the total days that vacancies remained in a given stage, divided by the number of vacancies that passed through that phase. To ensure the reliability of the indicator, the time vacancies spent in each stage was determined from the number of times each vacancy appeared in a given phase, based on daily backups performed in the Recruitment and Selection database.

In the Verification (Check) stage, the panel’s adherence to the area’s informational needs, the stability of the data flow, and the conformity of the source base to standardization rules were evaluated. The panel analysis was guided by previously defined criteria, considering the clarity of the visualizations, adherence to essential indicators, data structure coherence, and alignment with best practices in information management and visualization (PMI, 2021; Microsoft, 2024).

Finally, in the Action (Act) stage, specific adjustments were made to re-establish data flow stability and ensure the continuity of the dashboard update. Guidelines were reinforced to the Recruitment and Selection team regarding the importance of not altering file names, tabs, or columns in the operational database. Structural recovery adjustments were made in Power Query, and measures and relationships in Power BI were reviewed, including rewriting the SLA measure with validation rules and handling of null values (Werkema, 2012).

3. Results and Discussion

The initial project planning stage involved a meeting with stakeholders, in which the Ishikawa Diagram, also known as the Cause and Effect Diagram, was employed. The objective was to identify and organize the main factors hindering the visualization and adequate tracking of selection process data. This tool allowed for a structured analysis of the problem, grouping the causes into classic categories such as methods, labor, measurement, materials, machines, and environment, according to Ishikawa’s methodology (1985).

The application of the Ishikawa Diagram revealed that the problem was not restricted to a single operational point, but stemmed from structural and management failures that directly impacted the efficiency of the Recruitment and Selection process. Among the main factors identified were the lack of team training and guidance, resistance to change, absence of database standardization, recurring errors in information consolidation, and the lack of automation to ensure consistent data updates. These findings are in line with Werkema (2012), who emphasizes the importance of structured root cause identification in continuous improvement projects.

Based on the multifactorial diagnosis performed, a detailed action plan was developed using the 5W2H methodology, which transformed the identified causes into a set of practical and organized actions. This plan guided the definition of the project’s subsequent activities, ensuring an objective and targeted approach to problem-solving. The structuring of actions through 5W2H is fundamental for transforming diagnoses into concrete initiatives, especially in contexts of continuous improvement (Werkema, 2012).

The development of a detailed schedule, aligned with the 5W2H plan and the PDCA cycle, organized the project activities from September 2025 to March 2026. The planning phase focused on database analysis, initial information structuring, and prototype creation. The execution stage, which extended from October 2025 to January 2026, included adjustments to the Business Intelligence dashboard, automation implementation, and Service Level Agreement (SLA) monitoring.

The verification and results phases occurred between January and March 2026, allowing for the analysis of areas for improvement and the assessment of the solution’s implementation effects. This temporal organization ensured that the project evolved in a structured and progressive manner, with validation of intermediate deliverables, which is crucial for the control and success of complex initiatives, as pointed out by the Project Management Institute (PMI, 2021). The disciplined application of the Plan-Do-Check-Act cycle, combined with well-defined planning, increases the effectiveness of continuous improvement actions and reduces rework (Werkema, 2012).

The data processing stage in Power Query was fundamental to ensure the integrity and consistency of the information. The tool was configured to automatically copy the operational base used by recruiters and apply systematic transformations, such as formatting adjustments, date standardization, review of textual fields, and consolidation of duplicate records. These practices are essential for the reliability of Business Intelligence solutions, according to the recommendations of Kimball and Ross (2013).

In addition, the historical base of selection processes, recorded since 2023, was also processed and standardized in Power Query. This integration allowed for continuous consolidation between historical data and updated records, expanding the volume of information and the analytical depth of the monitoring. The integration of historical and operational data is a crucial aspect for consistent analyses and for supporting managerial decision-making (PMI, 2021; Milani et al., 2020).

With the data structure consolidated, the construction of the dashboard in Power BI began. Firstly, the data model was established, defining the relationships between the main Recruitment and Selection table and auxiliary tables, such as companies, cities, professional levels, recruitment types, and SLA classifications. This model ensured referential integrity and consistency of the analyses, being a crucial step in building a robust BI system.

After modeling, DAX measures were developed to calculate the average SLA of vacancies, performance indicators by stage of the selection process, and process count metrics, enabling structured monitoring of the recruitment funnel. Subsequently, interactive filters, slicers, and parameters were configured, providing clear and intuitive navigation for users, resulting in an organized and dynamic interface aligned with the sector’s needs.

During the execution phase, SLA (Service Level Agreement) monitoring was implemented per stage of the selection process, with the objective of measuring the average time vacancies remained in each phase of the Recruitment and Selection flow. To enable this indicator, historical records of vacancy movements were adopted through daily backups of the operational database, ensuring the traceability of status changes over time.

The consolidation of this data in Power Query allowed for the precise determination of the average time vacancies remained in each stage, offering a detailed view of the funnel’s behavior and facilitating the identification of operational bottlenecks. The implementation of this control significantly enhanced the robustness of the analytical dashboard by reducing distortions and enabling consistent temporal analyses of performance indicators, which is fundamental for strategic decision-making (Kimball and Ross, 2013; Rasmussen et al., 2024).

In the Check stage of the PDCA cycle, operational weaknesses related to data governance were identified. Interruptions in Power Query and Power BI were observed due to changes in the source file name, which compromised references and temporarily prevented automatic updates. These findings reinforce the sensitivity of Business Intelligence solutions to uncontrolled changes in the structure of source data, as highlighted by Kimball and Ross (2013).

Additionally, the absence of a record of the number of interviewed candidates was identified, which made it impossible to calculate the conversion rate between interviewed and hired individuals. In the SLA monitoring by stage, it was verified that part of the team did not update the status of vacancies daily, generating distortions in the calculation of time per stage, including cases of negative SLA due to invalid dates. These results reinforce the dependence between the quality of data input and the reliability of indicators (Milani et al., 2020; Rasmussen et al., 2024).

Based on the identified inconsistencies, punctual adjustments were made to re-establish data flow stability and ensure the continuity of the dashboard update. Guidelines were reinforced to the Recruitment and Selection team regarding the importance of not altering file names, tabs, or columns in the operational database, preventing operational failures such as broken connections and temporary loss of information in the analytical model. These preventive actions are crucial for maintaining a stable analytical environment.

In the technical scope, structural recovery adjustments were made in Power Query, reestablishing removed columns and revalidating compromised transformation steps. In Power BI, the SLA measure was rewritten to incorporate validation rules, null value handling, and safeguards against illogical results, such as negative SLAs. These actions allowed for the recovery of the solution’s full functionality and reinforced preventive maintenance practices, preparing the analytical environment for continuous improvements, in line with the principles of continuous improvement (Werkema, 2012).

General Discussion of Results

The implementation of the Business Intelligence dashboard allowed the consolidation of data that was previously dispersed, resulting in a structured, integrated, and automatically updated database. The application of diagnostic and planning tools, such as the Ishikawa Diagram and the 5W2H plan, enabled targeted action on the factors limiting the efficiency of the selection process. The standardization of the database, combined with the use of Power Query and the construction of the analytical model in Power BI, contributed to the availability of more reliable, clear, and accessible information for the Recruitment and Selection team.

Qualitatively, the results showed improvements in bottleneck identification, recruitment funnel visibility, SLA accuracy per stage, and the possibility of comparative analyses by area, job type, or process phase. The developed solution establishes a solid foundation for future evolutions, such as the expansion of strategic indicators and the enhancement of automations, contributing to the increased analytical maturity of the Recruitment and Selection area.

The quantitative results reinforce the impact of the implemented solution, showing a significant reduction in the time required for generating the management report. Previously, the preparation of the weekly report demanded between 1h30 and 2h, involving the manual consolidation of the operational spreadsheet and sending information via email. With the implementation of the Power BI dashboard, the total update time became approximately 10 minutes per day, already including basic data integrity checks. This reduction represents a significant operational gain, freeing up the team’s time for analytical and strategic activities (Milani et al., 2020).

Another relevant aspect is the frequency of information updates, which evolved from a weekly model to daily monitoring. This change significantly increased the visibility of the recruitment funnel and enabled continuous monitoring of job openings. Frequent access to updated indicators strengthens the predictability of Human Resources processes and contributes to decisions more aligned with organizational needs (Peeters; Paauwe; Van De Voorde, 2020).

The increased autonomy of Business Partners in accessing information is also highlighted, which no longer depends on the manual sending of reports by email but occurs through direct access to the dashboard. This change contributed to greater process transparency and information democratization, expanding the strategic role of HR by allowing different stakeholders to monitor indicators in real-time (Rasmussen et al., 2024). Information reliability also advanced significantly, moving from vulnerable to manual errors to high, due to the standardization of the database and automation of the workflow.

Thus, the results obtained confirm that the implementation of the Business Intelligence panel promoted consistent gains in operational efficiency, reduction of rework, and greater transparency in monitoring selection processes. The increase in informational agility and communication flow between the Recruitment and Selection team and Business Partners evidences the advancement of the area’s analytical maturity, contributing to more efficient and data-driven decision-making, fully meeting the study’s objective.

4. Conclusion

The present study sought to structure an analytical solution to organize, integrate, and provide information in an automated, clear, and accessible manner, aiming to improve the monitoring of selection processes and decision-making in the Recruitment and Selection area. It was verified that the implementation of the Business Intelligence dashboard, built using Power Query for data processing and standardization and Power BI for modeling and visualization, allowed the consolidation of data that was previously dispersed. A significant increase in information reliability, an expressive reduction in rework, and an expansion of user transparency and autonomy in indicator monitoring were observed. Quantitatively, the time to generate management reports decreased from one hour and thirty minutes to two hours to approximately ten minutes daily, and the update frequency changed from weekly to daily, with direct access to the dashboard by Business Partners. The developed solution is configured as a practical and sustainable contribution to the management of Recruitment and Selection, strengthening data-driven decision-making and driving the area’s analytical maturity.

Despite the advances, operational limitations related to data governance were identified, such as the system’s sensitivity to changes in source file names and the inconsistency in the daily update of vacancy status by the team, which generated distortions in the calculation of time per stage. Additionally, the absence of records for the number of interviewed candidates made it impossible to calculate the conversion rate. For future studies, it is suggested to expand strategic indicators, improve automations, and incorporate additional data for more comprehensive analyses, such as the conversion rate between stages. The developed dashboard establishes a robust foundation for continuous monitoring and process improvement, consolidating the strategic role of the Human Resources area through more efficient and data-driven management.

Bibliographic References

Breviário, Á. G. do; Rocha, L. A. C.; Rebello, F. A. S.; Vidal, R. L. da S.; Oliveira Filho, A. de S. 2025. Recrutamento e seleção no século XXI: superando barreiras digitais, critérios tradicionais e potenciais não convencionais. Revista Eletrônica Multidisciplinar de Investigação Científica 4(21): e1181825.

Ghatak, R. 2022. People analytics: data to decisions. Springer, Singapore

Ishikawa, 1985 [Referência completa não encontrada no documento original]

Kimball, R.; Ross, M. 2013. The data warehouse toolkit: the definitive guide to dimensional modeling. 3. ed. Hoboken: Wiley.

Microsoft. 2024. Human resources sample: take a tour – Power BI. Microsoft Learn. Disponível em: <https://learn.microsoft.com/en-us/power-bi/create-reports/sample-human-resources>. Acesso em: 16 jan. 2026

Milani, A. M. P.; Soares, J. A.; Andrade, G. L.; et al. 2020. Visualização de dados. SAGAH, Porto Alegre, RS, Brasil

Peeters, T.; Paauwe, J.; Van De Voorde, K. 2020. People analytics effectiveness: developing a framework. Journal of Organizational Effectiveness: People and Performance 7(2): 203–219.

Project Management Institute [PMI]. 2021. Um guia para o conhecimento em gerenciamento de projetos (Guia PMBOK®). 7. ed. PMI, Pennsylvania, USA

Rasmussen, T. H.; Ulrich, M.; Ulrich, D. 2024. Moving people analytics from insight to impact. Human Resource Development Review 23(1): 11-29.

Werkema, C. 2012. Métodos PDCA e DMAIC e suas ferramentas analíticas. GEN/Atlas, Rio de Janeiro, RJ, Brasil

Article originating from the Final Course Project of the Specialization in Project Management of the MBA USP/Esalq

To learn more about the course, click here and access the MBX Academy platform

You may also like

November 17, 2026

Detection and Diagnosis of Diseases in Corn and Rice in Mozambique with Deep Learning

Mozambican agriculture depends on corn and rice, fundamental crops for food security, but their productivity is strongly affected by phytosanitary diseases, whose early and accurate identification remains a challenge in resource-limited contexts. The study aimed to develop and compare Deep Learning-based models for the automatic detection and diagnosis of diseases in corn and rice leaves in Mozambique. Three approaches were used: a classic Convolutional Neural Network (CNN) developed from scratch, and two transfer learning models, ResNet50 and MobileNetV2. The dataset consisted of images from public databases and collected in the field, which underwent cleaning, balancing, and artificial augmentation steps. The models were trained and evaluated with standard performance metrics, including accuracy, precision, recall, F1-score, Log Loss, and Cohen’s Kappa. The classic CNN presented the best overall performance, with 94% precision, recall, and F1-score, and 93% accuracy and Cohen’s Kappa. MobileNetV2 achieved 91% F1-score and 90% accuracy, standing out for its lower Log Loss (0.30) and training time (6h32min59s). ResNet50 reached 80% F1-score and 79% accuracy. It was concluded that Deep Learning techniques have high potential to support phytopathological diagnosis in real agricultural contexts, contributing to faster and more accurate decisions in the management of corn and rice diseases.

Keywords: Deep learning; Rice; Plant diseases; Corn; Computer vision.

November 17, 2026

Artificial intelligence in accounting operational routines and financial efficiency

The incorporation of Artificial Intelligence (AI) and automation tools has reconfigured the routines of Brazilian accounting offices, impacting productivity, error mitigation, and financial efficiency. These impacts were analyzed in a small accounting firm, specialized in serving service providers in the medical field in São Caetano do Sul, São Paulo. The research adopted a qualitative approach, with a single case study design and incorporated units of analysis. Data were collected through a structured questionnaire, applied via Google Forms between January and February 2026, to five professionals in the operational structure of the firm in a census survey. The treatment followed content analysis with a priori and emergent categories. All respondents declared the use of automated tools or tools with AI resources. The perception of reduced execution time, decreased operational errors, rework, and better use of the team’s time converged in 80% of affirmative responses and 20% partial responses. The most benefited activities were bank reconciliation, import of fiscal documents, and tax assessment, with visible gains on typing errors, duplicate entries, and incorrect classification. Human intervention remained indispensable in tax planning, scenario analysis, and verification of ancillary obligations. The overall evaluation of AI’s contribution was predominantly favorable, with moderation linked to the complexity of fiscal regulations.

Keywords: Content analysis; Process automation; Accounting 4.0; Small business; Digital transformation.

November 17, 2026

Factors influencing schedule management in sewage treatment plant “retrofit” projects

Projects involving “retrofit” in Sewage Treatment Plants (STP) are characterized by high complexity, operational restrictions, and multiple technical interfaces. The study analyzed the perception of the professionals involved regarding the management and adherence to deadlines in “retrofit” projects for sewage treatment plants, considering technical, operational, and organizational factors. The research was characterized as an applied study, with a quali-quantitative approach, designed as a field survey. Data analysis was performed using descriptive statistics and qualitative categorization, employing SWOT, risk matrix (Probability x Impact), and 5W2H action plan tools. The results indicated a high perception of clarity (77.8%) and realism of deadlines (100% agreement), evidencing consistent initial planning. However, 77.7% of respondents pointed out that rework and scope changes directly impacted deadline adherence. The integration between engineering, manufacturing, and Production Planning and Control (PPC) showed an intermediate evaluation (77.7% partial/total agreement), indicating fragility in interfunctional coordination. The risk matrix highlighted as critical: scope changes, operational limitations of the STP, and technical complexity, all with a high level. As a central improvement, the standardization of scope change control, analysis, and approval was proposed, aiming to reduce rework and increase schedule predictability.

Keywords: Performance; Integration; Planning; Rework; Risk.

November 17, 2026

B2C Acquisition in diagnostic medicine: strategic partnerships with specialized medical offices

The diagnostic medicine sector in Brazil operates with high dependence on health plan providers, which limits the financial autonomy of service providers. This study proposed and analyzed a direct patient acquisition model (B2C) for a highly complex diagnostic medicine institution, structured through partnerships with Oncology and Cardiology practices and operationalized by a personalized customer service called concierge. The investigation adopted a mixed-methods approach in three phases: a field survey with a structured questionnaire applied to 87 patients, mapping of the operational flow using “Service Blueprint”, and analysis of the conversion rate from 312 medical referrals registered in the pilot project. The results indicated that trust in medical referral achieved 92.0% agreement, establishing itself as the main factor for adherence. The convenience of performing the exam on the same day reached 78.2%, and the willingness to pay directly was 55.2%, with polarization associated with the predominance of health plan users. The “Service Blueprint” identified three critical points in the transitions between stages of the patient journey. The overall conversion rate was 51.0%, with superior performance in Oncology (58.2%) compared to Cardiology (45.0%), and the greatest loss was concentrated in the acceptance and scheduling stage (28.3%). It was concluded that the model demonstrated possible operational viability and indications of patient acceptance, conditioned by price transparency and a reduction in the interval between consultation and approach by the concierge.

Keywords: Direct payment; Patient journey; Supplementary health; Concierge service; Conversion rate.

November 17, 2026

The role of the school manager in promoting an inclusive culture: leadership and educational policies

The research analyzed the school manager’s performance in promoting an inclusive culture, considering the need to transform legal guidelines and pedagogical foundations into effective institutional practices. It was assumed that school inclusion requires planning, organization, and strategic leadership in the school’s daily operations. A qualitative approach of an applied nature was adopted, developed in three complementary stages: documentary analysis of Brazilian legislation on inclusive education, bibliographic review on school leadership and management, and data systematization using management tools such as SWOT analysis and the PDCA cycle. The results indicated that the school management’s performance directly influenced the consolidation of inclusive environments, especially in the organization of processes, continuous team training, and strengthening of a collaborative institutional culture respectful of diversity. Structural, pedagogical, and relational challenges that demanded planned interventions were also identified. Finally, a Practical Guide for School Managers was developed, with guidelines, protocols, and operational orientations for decision-making and the organization of inclusive processes. It was concluded that the construction of an inclusive culture depended on the management’s ability to articulate public policies, pedagogical practices, and institutional processes, consolidating inclusion as a permanent commitment in the school context.

Keywords: educational accessibility; educational equity; participatory management; strategic planning; institutional processes.

November 17, 2026

An AI artifact based on Design Thinking to support the elicitation of software requirements from user needs

The development of software oriented to user needs frequently faces challenges in requirements elicitation, stemming from ambiguities in natural language and communication failures. Given this, an intelligent artifact integrating Design Thinking and Artificial Intelligence was proposed and validated, focusing on the Empathy and Definition stages, to support the collection, interpretation, and structuring of user needs. The research, of an applied, qualitative, and exploratory nature, conducted a Proof of Concept in a controlled environment, employing hypothetical scenarios. The artifact operated through guided natural language interviews, organizing information into elements such as pain points, context, and impact, and generating traceable problem syntheses. The results indicated that the system organized unstructured reports, reduced ambiguities, and preserved the meaning of the original information in most cases. The ability to reorganize logically in complex scenarios was also observed, although with limitations in separating multiple problems and dependence on instructions. It was concluded that the artifact has potential as a support for requirements elicitation, improving the clarity and structuring of information, but requires supervision and contextual control.

Keywords: Design Thinking; Requirements Elicitation; Requirements Engineering; Artificial Intelligence; Natural Language Processing.

November 17, 2026

The Extinction of the Monophasic Tax System in the Pharmaceutical Industry in Light of the Tax Reform

The consumption Tax Reform, established by Constitutional Amendment No. 132/2023, introduced structural changes to the Brazilian tax system, with the replacement of the Social Integration Program (PIS) and the Social Security Financing Contribution (COFINS) by the Contribution on Goods and Services (CBS), in a dual Value Added Tax (VAT) model. The objective was to analyze the impacts of the extinction of the single-stage system on the pharmaceutical industry, in light of the new regulatory design and its economic and legal effects. A qualitative, exploratory research was conducted through a case study and documentary analysis of legislation and specialized doctrine. It was examined whether the end of the single-stage system would imply a relevant increase in the tax burden for the sector. The results indicated that, although the formal overcoming of the single-stage system has occurred, the material exemption of medicines has been preserved, mainly due to the application of reduced rates of 60% and, in certain cases, a zero rate of the Tax on Goods and Services (IBS) and CBS. The change in model may cause occasional variations in revenue collection, without characterizing a structural increase in the tax burden, tending towards neutrality over time. It was preliminarily concluded that the Tax Reform reorganized the taxation technique in the pharmaceutical industry, replacing a concentrated regime with more transparent exemption mechanisms. This approach proved compatible with the principles of neutrality, full non-cumulativeness, and fiscality, maintaining tax protection for essential medicines and aligning fiscal policy with the fundamental right to health.

Keywords: CBS; COFINS; IBS; Dual VAT; PIS.