Construction of a Business Intelligence environment for the Secretariat of Social Assistance of the Municipality of São Paulo
DOI:
https://doi.org/10.33448/rsd-v10i11.18577Keywords:
Business Intelligence; Data Warehouse; KDD process.Abstract
The Data Science field has become one of the most promising markets in the technology field in recent years. The use of sophisticated techniques and hardware and software resources to handle large volumes of data and provide integrated environments to assist in decision making in large and medium organizations has advanced its frontiers and reached several other sectors (public and private) that were previously restricted only to the transactional aspect of the databases. This paper aims to describe the conception, modeling and implementation of an information management environment of the Municipal Secretariat for Social Assistance and Development - SMADS of the Municipality of São Paulo, aiming at the modernization of the Secretariat's information management, qualifying the elaboration, implementation and monitoring of public social assistance policies implemented in the city of São Paulo. The methodology used was the bottom-up approach initially presented by Ralph Kimball as a proposal to develop a fast and understandable DW project. The creation of the DW followed the steps of the KDD Process: data selection; pre-processing; transformation; interpretation and analysis. The project was carried out through a partnership between the City of São Paulo and UNESCO and covered all stages of a Business Intelligence (BI) process. This work describes the steps of: identification of needs, implementation of operational infrastructure, construction of the Data Warehouse (DW), implementation of ETL processes, preparation of panels, preparation of documentation and training of different user profiles. The following data sources were used: database of legacy systems used by SMADS as well as several external databases with emphasis on the Federal Government's CadÚnico. The results contemplated the creation of a Business Intelligence environment and the dissemination of the culture of creation of data visualization models for the decision-making process within the scope of the Social Assistance Secretariat of the Municipality of São Paulo, which allowed a better efficiency in the application and monitoring of public social assistance policies in the city of São Paulo.
References
Berson A., & Smith S. J. (1997). On Line Analytical Processing - Data Warehousing, Data Mining & OLAP. Computing McGraw Hill
Chaudhuri, S., & Dayal, U., (1997). An overview of data warehousing and OLAP technology, SIGMOD Rec., 26(1), 65-74
Costa, M. D., & Silva, I. A. (1999) Da. Inteligência competitiva: uma abordagem sobre a coleta de informações publicadas. Informação & Sociedade, 9(1).
Elias, D. (2014). A abordagem top-down e bottom-up no Data Warehouse. https://canaltech.com.br/infra/a-abordagem-top-down-e-bottom-up-no-data-warehouse-21108.
Estrela, C. (2018). Metodologia Científica: Ciência, Ensino, Pesquisa. Editora Artes Médicas.
Inmon, W. H. (1997). Como Construir o Data Warehouse. Editora Campus.
Kimball, R. (1996). The data warehouse toolkit: practical techniques for building dimensional data warehouses, John Wiley & Sons, Inc., 374
Kimball, R., & Caserta, J. (2004). The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data, John Wiley & Sons, 491
Kimball, R., Reeves, L., Ross, M., & Thornwaite, W. (1998). The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses, John Wiley & Sons, Inc., 800
Kimball, R., & Ross, M. (2002). The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, John Wiley & Sons, Inc., 421
Knafic, C. N. (2017). Storytelling com dados: um guia sobre visualização de dados para profissionais de negócios. Alta Books
Machado, F. N. R. (2007). Tecnologia e Projeto de DW. Editora Érica.
Pessato, T.; & Stein, M. (2014). O design como diferencial estratégico na construção de dashboards. Congresso Brasileiro de Pesquisa e Desenvolvimento em Design..
Raio-X da Rede Socioassistencial do município de São Paulo de janeiro de 2021. https://www.prefeitura.sp.gov.br/cidade/secretarias/assisten cia_social/observ atorio_social/monitoramento/?p=170850
Shams K., & Farishta M. (2001), Data Warehousing: Toward knowledge. Top. Health Informatics Management. 21(3), 24-32
ZentuT. (2021) Kimball vs Inmon in Data Warehouse Architecture. https://www.zentut.com/data-warehouse/ralph-kimball-data-warehouse-architecture/.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2021 José Avelino Placca; Priscila Nery de Castro
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
1) Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
2) Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
3) Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
