Data sources are physical or digital repositories where the information associated with the business is found. If in physical format (e.g., paper), this data should be converted to digital format to facilitate use and sharing. Usually, digital data sources can be around an organization such as management systems, strategic systems, SQL or NOSQL databases, and, spreadsheets.
Published in Chapter:
Designing Business Analytics Projects (BAP): A Five-Step Dashboarding Cycle
Luiz Pinheiro (Positivo University, Brazil) and Ricardo Matheus (Delft University of Technology, Netherlands)
Copyright: © 2022
|Pages: 24
DOI: 10.4018/978-1-7998-9016-4.ch004
Abstract
Private and public organizations have been using data for decision-making. However, these organizations have been struggling in putting into practice the design data analytics projects. In this sense, this chapter aims to present a proposal of a designing business analytics projects with a practical five steps dashboarding cycle. The first step, Business Questions, deals with the scope of a data analytics project creating problem-based questions. The second step, Data Sources, details which are the data sources to be collected. The third step, Extraction, Transform, and Loading (ETL), sets up data source routines of what, where, and when to collect data. The fourth step, Data Warehouse, creates a data repository where data is stored and treated after ETL process. The fifth step, Data Visualization, designs a web dashboard with interactive features such as tables and graphs. This chapter ends with three practical examples in both public and private organizations.