Uso de dicionário semântico de dados na anotação de modelos de dados dimensionais para geração de indicadores de desempenho

Abstract

Key performance indicators (KPIs) are used by organizations to assess their performance, supporting the decision. With these indicators, they review their processes seeking continuous improvement. Dimensional models structure data by grouping it into “facts” and “dimensions.” The facts represent numeric fields that leverage the generation of KPIs. However, it is essential to follow data annotation techniques and recommended practices with metadata seeking to minimize divergent interpretations. In the context of the generation of KPIs, described how an annotation occurs according to the method “Semantic Data Dictionary” (SDD), which associates data with concepts to generate these indicators, enriching and formalizing them using ontologies. A “use case” (experiment) of data annotation of a dimensional model for KPI calculations is presented, based on SDDs. As a result, the experiment examines the potential of applying SDDs in the context of generating organizational performance indicators (KPIs). Besides the conceptual integration of the data, it is possible to consider another contribution, which is the formal structuring (in logic) of the KPIs in graphs of knowledge grounded on ontologies. Finally, this work contributes to data curation since the SDD follows acceptable modeling practices (FAIR principles).