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

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.