Economics and Business
Quarterly Reviews
ISSN 2775-9237 (Online)
Published: 28 March 2023
Data Dashboarding in Accounting using Tableau
Clarence Goh
Singapore Management University, Singapore
Download Full-Text Pdf
10.31014/aior.1992.06.01.502
Pages: 269-275
Keywords: Dashboarding, Simulation, Tableau
Abstract
Data dashboarding, which involves organizing and visually displaying data in an easy to use interface to facilitate the processing of analyzing large, complex data sets, is an important tool in accounting decision making. This article discusses the role of data dashboarding in accounting and illustrates, using a worked example, how a data dashboard can be constructed in Tableau, a popular data visualization software.
References
American Institute of Certified Public Accountants (AICPA). (2019). Finance professionals have to tech-up within the next three years or it’s game over. Retrieved from: https://www.aicpa.org/news/article/new-report-finance-professionals-have-to-tech-up-within-the-next-three-years
Ayres, D., Schmutte, J., & Stanfield, J. (2017). Expect the unexpected: Risk assessment using Monte Carlo simulations. Journal of Accountancy. Retrieved from: https://www.journalofaccountancy.com/issues/2017/nov/risk-assessment-using-monte-carlo-simulations.html
Chaudhuri, S., Dayal, U., & Narasayya, V. (2011). An overview of business intelligence technology. Communications of the ACM, 54 (8), 88-98.
Dilla, W., Janvrin, D. J., & Raschke, R. (2010). Interactive data visualization: New directions for accounting information systems research. Journal of Information Systems, 24 (2), 1-37.
Eaton, T. V., & Baader, M. (2018). Data visualization software: An introduction to Tableau for CPAs. CPA Journal. Retrieved from: https://www.cpajournal.com/2018/06/20/data-visualization-software/
Goh, C. (2018). Excel and Simulation for Accountants. Journal of Corporate Accounting & Finance, 29 (2), 133-138.
Goh, C., Lee, B., Pan, G., & Seow, P. S. (2021). Forensic analytics using cluster analysis: Detecting anomalies in data. Journal of Corporate Accounting & Finance, 32 (2), 154-161.
Hagen, S. (2017). These are the 20 fastest growing skills in the online job market. Bloomberg. Retrieved from: https://www.bloomberg.com/news/articles/2017-01-25/these-are-the-20-fastest-growing-skills-in-the-online-job-market#xj4y7vzkg
Janvrin, D. J., Raschke, R. L., & Dilla, W. N. (2014). Making sense of complex data using interactive data visualization. Journal of Accounting Education, 32 (4), 31-48.
Kauflin, J. (2017). The 10 technical skills with explosive growth in job demand. Forbes. Retrieved from: https://www.forbes.com/sites/jeffkauflin/2017/01/08/the-10-technical-skills-with-explosive-growth-in-job-demand/?sh=5194fbe54f5c
Nielsen, S. (2018). Reflections on the applicability of business analytics for management accounting–and future perspectives for the accountant. Journal of Accounting & Organizational Change, 14 (2), 167-187.
Pan, G., Seow, P. S., Goh, C., & Yong, M. (2017). Riding the waves of disruption. CPA Australia: Singapore.
Payne, B. (2020). 5 skills you need to succeed in a digital economy. Chartered Institute of Management Accountants (CIMA). Retrieved from: https://www.cimaglobal.com/Members/Insights/2020-CIMA-Insights/5-skills-you-need-to-succeed-in-a-digital-economy/
Seow, P. S., Goh, C., Pan, G., Yong, M., & Chek, J. (2021). Embracing digital transformation in accounting and finance. CPA Australia: Singapore.
The Institute of Internal Auditors. (2022). Internal Audit Dashboard Reporting. Retrieved from: https://iia.org.au/sf_docs/default-source/technical-resources/2018-fact-sheets/fact-sheet---internal-audit-dashboard-reporting.pdf?sfvrsn=10
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.