EUVIMEDEUVIMED entdecken
Open Access · CC BY 4.0

Basic Application of Business Intelligence in making E-Commerce Buyer Dashboard Indonesian Using Tableau Tools Development

Uya Asy Syuura Anandri, Abdullah

Journal of Computer Electronic and Telecommunication · 26.01.2026 · 6 (2)

DOI: 10.52435/complete.v6i2.747 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Journal of Computer Electronic and Telecommunication, online erschienen am 26.01.2026. Verfasst von Uya Asy Syuura Anandri und 1 weiteren Autor:innen. Die Arbeit wurde bisher 1-mal zitiert (Crossref). Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

This research examines the implementation of Business Intelligence (BI) for the creation of an Indonesian e-commerce buyer dashboard in 2024 with the aim of increasing the visibility of operational KPI and demonstrating a reproducible pipeline from data cleaning to visualization. The main issues addressed are the quality of order-level data (provincial writing variants, date format, numerical values, and PII anonymization) as well as the need to calculate buyer metrics (unique buyers, repeat rate) which is rarely ava1ilable in public aggregate data. The methods used include: (1) data cleaning and harmonizing using OpenRefine; (2) numerical transformation and validation with Python (pandas); (3) creating interactive worksheets and dashboards in Tableau (sales map per province; monthly trend line; bar with avg sales per product; sales pie by gender); and (4) sensitivity analysis to assess the impact of cleaning step variation on buyer-level KPI. Using the order-level dataset of cleaning results (1,000 transactions), a total revenue of Rp 2,298,975,000, 1,000 orders, and 178 unique buyers were found; seasonal patterns were seen with a peak in the fourth quarter and revenue concentration in urban areas (DKI Jakarta, West Java). The top-10 products contribute a significant portion of revenue, and repeat buyers show an important role in the sales structure

Zitieren

APA

Anandri, U. A. S., & Abdullah (2026). Basic Application of Business Intelligence in making E-Commerce Buyer Dashboard Indonesian Using Tableau Tools Development. Journal of Computer Electronic and Telecommunication, 6(2). https://doi.org/10.52435/complete.v6i2.747

Vancouver

Anandri UAS, Abdullah. Basic Application of Business Intelligence in making E-Commerce Buyer Dashboard Indonesian Using Tableau Tools Development. Journal of Computer Electronic and Telecommunication. 2026;6(2). doi:10.52435/complete.v6i2.747

BibTeX
@article{Anandri2026,
  author = {Anandri, Uya Asy Syuura and Abdullah},
  title = {Basic Application of Business Intelligence in making E-Commerce Buyer Dashboard Indonesian Using Tableau Tools Development},
  journal = {Journal of Computer Electronic and Telecommunication},
  year = {2026},
  volume = {6},
  number = {2},
  doi = {10.52435/complete.v6i2.747}
}
Kostenlos starten →