Financial Statement Analytics Using Tableau: Evaluating Profitability, Risk, And Liquidity Trends At PT Sumber Alfaria Trijaya Tbk (2021–2025)

Irene Ipal Parinding; Aisyah  Zarkasi

doi:10.69657/d7kgbv63

Authors

Irene Ipal Parinding Universitas Negeri Makassar Author
Aisyah Zarkasi Universitas Negeri Makassar Author

DOI:

https://doi.org/10.69657/d7kgbv63

Keywords:

Akuntansi Manajemen, Visualisasi Data, Tableau, Kinerja Keuangan, Retail

Abstract

The fast-growing retail business environment requires management to make decisions quickly and accurately. However, traditional financial reports in the form of numerical tables are often difficult for managers to interpret rapidly. This study aims to build an interactive executive dashboard using Tableau to analyze the financial performance of PT Sumber Alfaria Trijaya Tbk (Alfamart) from 2021 to 2025. The research method used is a case study using secondary data from the company's audited annual financial statements. The analysis focuses on profitability (DuPont System), capital structure, liquidity, and revenue growth. The results show that data visualization through Tableau significantly helps management identify operational changes more quickly. Alfamart's performance over the past five years indicates stable revenue growth backed by a reduction in long-term debt risk and improvement in liquidity, despite a slowdown in asset efficiency. The implication of this study suggests that implementing data visualization technology in modern management accounting practices is essential to accelerate the performance evaluation process.

References

Appelbaum, D., Kogan, A., Vasarhelyi, M., & Yan, Z. (2017). Impact of business analytics and enterprise systems on managerial accounting. International Journal of Accounting Information Systems, 25, 29-44. https://doi.org/10.1016/j.accinf.2017.03.002

Bhimani, A. (2020). Digital data and management accounting: changes, challenges and opportunities. Management Accounting Research, 47, 100670. https://doi.org/10.1016/j.mar.2020.100670

Fairfield, P. M., & Yohn, T. L. (2001). Using asset turnover and profit margin to forecast changes in profitability. Review of Accounting Studies, 6(4), 371-385. https://doi.org/10.1023/A:1012430513430

Frank, M. Z., & Goyal, V. K. (2003). Testing the pecking order theory of capital structure. Journal of Financial Economics, 67(2), 217-248. https://doi.org/10.1016/S0304-405X(02)00252-0

Garrison, R. H., Noreen, E. W., & Brewer, P. C. (2021). Managerial Accounting (17th ed.). McGraw-Hill Education.

Gaur, V., Fisher, M. L., & Raman, A. (2005). An econometric analysis of inventory turnover performance in retail stores. Management Science, 51(2), 181-194. https://doi.org/10.1287/mnsc.1040.0298

Myers, S. C., & Majluf, N. S. (1984). Corporate financing and investment decisions when firms have information that investors do not have. Journal of Financial Economics, 13(2), 187-221. https://doi.org/10.1016/0304-405X(84)90023-0

Nissim, D., & Penman, S. H. (2001). Ratio analysis and equity valuation: From research to practice. Review of Accounting Studies, 6(1), 109-154. https://doi.org/10.1023/A:1011338221623

Rikhardsson, P., & Yigitbasioglu, O. (2018). Business intelligence & analytics in management accounting research: Status and future direction. International Journal of Accounting Information Systems, 29, 37-58. https://doi.org/10.1016/j.accinf.2018.03.001

Soliman, M. T. (2008). The use of DuPont analysis by market participants. The Accounting Review, 83(3), 823-853. https://doi.org/10.2308/accr.2008.83.3.823

Warren, J. D., Moffitt, K. C., & Byrnes, P. (2015). How Big Data will change accounting. Accounting Horizons, 29(2), 397-407. https://doi.org/10.2308/acch-51069

Yigitbasioglu, O. M., & Velcu, O. (2012). A review of dashboards in performance management: Implications for design and research. International Journal of Accounting Information Systems, 13(1), 41-59. https://doi.org/10.1016/j.accinf.2011.08.002