Business questions are driver questions that business teams should elaborate in a collaborative bottom-up approach based on the company's strategic planning. These questions aim to provide a guideline and find proper answers to the organization's department or area indicators.
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.