International Journal of Advances in Applied Sciences
Vol 14, No 3: September 2025

Optimizing retail systems: using big data and power business intelligence for performance insights

Quoc, Huu Dang (Unknown)
Viet, Ha Le (Unknown)



Article Info

Publish Date
01 Sep 2025

Abstract

In the rapid development of information technology, using enterprise data to support timely management decisions is crucial in helping businesses operate effectively and improve competitiveness. This study uses Microsoft power business intelligence (MPBI) to analyze data in retail systems, allowing managers to grasp the business situation in real time, track advanced sales, optimize inventory control, and analyze customer behavior and supply chain visibility. From the data generated by the business, the study uses the streaming extract transform load (ETL) model to support real-time data aggregation, then converts to the MPBI data visualization system to convert data into visual charts, helping businesses easily monitor, track, analyze, and make decisions to promote business activities. The study proposes a data structure to organize retail information storage. It proposes a system of calculation formulas and data synthesis, making integrate and convert tabular data into visual charts. Through analysis of real data from the LH83 retail system, the study shows the feasibility of implementing a data visualization system and the difficulties encountered when businesses want to deploy this model.

Copyrights © 2025






Journal Info

Abbrev

IJAAS

Publisher

Subject

Earth & Planetary Sciences Environmental Science Materials Science & Nanotechnology Mathematics Physics

Description

International Journal of Advances in Applied Sciences (IJAAS) is a peer-reviewed and open access journal dedicated to publish significant research findings in the field of applied and theoretical sciences. The journal is designed to serve researchers, developers, professionals, graduate students and ...