Predictive business intelligence dashboard for food and beverage business

Nathaniel Wikamulia · Sani Muhamad Isa

8 citations0/0 files storedBulletin of Electrical Engineering and Informatics

No readable copy stored yet — this record is metadata only.

No open-access location is known for this record yet.

Literature note Cite in a project Citation map

Big Data and Business Intelligence Decision Support System Applications Data Mining and Machine Learning Applications

Abstract

This research was conducted to provide an example of predictive business intelligence (BI) dashboard implementation for the food and beverage business (businesses that sell fast-expired goods). This research was conducted using data from a bakery's transactional database. The data are used to perform demand forecasting using extreme gradient boosting (XGBoost), and recency, frequency, and monetary value (RFM) analysis using mini batch k-means (MBKM). The data are processed and displayed in a BI dashboard created using Microsoft Power BI. The XGBoost model created resulted in a root mean square error (RMSE) value of 0.188 and an R2 score of 0.931. The MBKM model created resulted in a Dunn index value of 0.4264, a silhouette score value of 0.4421, and a Davies-Bouldin index value of 0.8327. After the BI dashboard is evaluated by the end user using a questionnaire, the BI dashboard gets a final score of 4.77 out of 5. From the BI dashboard evaluation, it was concluded that the predictive BI dashboard succeeded in helping the analysis process in the bakery business by: accelerating the decision-making process, implementing a data-driven decision-making system, and helping businesses discover new insights.

Paper brief

Loading…

Cite this work

Citation unavailable for this work.

BibTeX RIS CSL-JSON

No public copy is stored for this record, so only the metadata is cited.

Citations in this library

Citation map →

Stored only when both papers are in the corpus — 8 citations exist upstream.

References

2019Chapter 12: What does the Anthropocene hold for citizenship?1996The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling 2008Database Marketing 2017Probabilistic demand forecasting at scale 2005Research on customer segmentation model by clustering 2010The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Business Intelligence 2020Clustering optimization in RFM analysis Based on k-Means 2019Demand forecasting in restaurants using machine learning and statistical analysis

Explore the map →

Papers that cite the same references — the relational fallback while embeddings are still backfilling.

Imported from OpenAlex (CC0) — nothing here is generated.