Português
Ciência-IUL
Publications
Publication Detailed Description
How tax audit and tax advisory can benefit from big data analytics tools data analysis and processing in relational databases using SQL Server and Power Pivot & Power View in Excel
2018 13th Iberian Conference on Information Systems and Technologies (CISTI)
Year (definitive publication)
2018
Language
Portuguese
Country
Spain
More Information
Web of Science®
This publication is not indexed in Web of Science®
Scopus
Google Scholar
Abstract
In the context of business analytics, the tax consultants and auditors face challenges when conducting data analysis for tax optimization based on big commercial databases extracted from the management systems of organizations. This article focuses on big data analytics by using Business Intelligence (BI) tools provided by Microsoft. In this paper, we combine the storage and pre-processing capacity of SQL Server (Developer edition) with the analysing and reporting add-ins supported by Excel (Power Pivot and Power View). Both BI solutions were applied on accounting and tax data extracted from a ERP system in order to demonstrate how tax professionals can conduct big data analysis to maximize value added tax recovery.
Acknowledgements
--
Keywords
Microsoft,Big Data,tax,SQL Server,Power Pivot & View.
Fields of Science and Technology Classification
- Physical Sciences - Natural Sciences
Funding Records
| Funding Reference | Funding Entity |
|---|---|
| UID/GES/00315/2013 | FCT |
Contributions to the Sustainable Development Goals of the United Nations
With the objective to increase the research activity directed towards the achievement of the United Nations 2030 Sustainable Development Goals, the possibility of associating scientific publications with the Sustainable Development Goals is now available in Ciência-IUL. These are the Sustainable Development Goals identified by the author(s) for this publication. For more detailed information on the Sustainable Development Goals, click here.
