Designing business intelligence (BI) for production, distribution and customer services: a case study of a UAE-based organization
Business Process Management Journal
ISSN: 1463-7154
Article publication date: 25 January 2021
Issue publication date: 3 August 2021
Abstract
Purpose
Business intelligence (BI) is a strategic approach that can use analytical tools to collect and integrate information, apply business rules and ensure the appropriate visible output of organizational information. This study aims to present the design and implementation of BI in areas of business process improvement for production, distribution and customer services.
Design/methodology/approach
This study highlights the process of BI in the production, distribution and customer services based on the National Food Products Company (NFPC) in the United Arab Emirates (UAE). This study discusses the step-by-step development process of BI and refers to graphical illustrations of the business needs and the organization's target key performance indicators (KPI).
Findings
Based on the business needs and chosen KPIs to maximize production and improve distribution and customer services the BI tool shows that the “star scheme” is the most appropriate one. Relational Online Analytical Processing (ROLAP) based on Mondrian system is employed as Online Analytical Processing (OLAP) architecture since the NFPC's technological infrastructure was better adapted to this vision. The analysis starts with data retrieval from two databases' customer' and production and distribution databases. Finally, visualization and reporting processes that respect the end-users improve the NFPC's decisions.
Practical implications
The study will help other organizations, BI developers, data warehouses (DW) developers and administrators, project managers as well as academic researchers understand how to develop a successful BI framework and implement BI based on business needs.
Originality/value
This is a unique and original study on the BI experience from a UAE-based organization and will encourage other organizations to apply BI in their business process.
Keywords
Acknowledgements
Erratum: It has come to the attention of the publisher that the article, Nuseir, M.T. (2021), “Designing business intelligence (BI) for production, distribution and customer services: a case study of a UAE-based organization” published in Business Process Management Journal, Vol. ahead-of-print No. ahead-of-print, listed an incorrect affiliation for Mohammed T. Nuseir. This error was introduced in the editorial process and has now been corrected in the online version to Al Ain University. The publisher sincerely apologises for this error and for any inconvenience caused.
Citation
Nuseir, M.T. (2021), "Designing business intelligence (BI) for production, distribution and customer services: a case study of a UAE-based organization", Business Process Management Journal, Vol. 27 No. 4, pp. 1275-1295. https://doi.org/10.1108/BPMJ-06-2020-0266
Publisher
:Emerald Publishing Limited
Copyright © 2020, Emerald Publishing Limited