Exportar Publicação

A publicação pode ser exportada nos seguintes formatos: referência da APA (American Psychological Association), referência do IEEE (Institute of Electrical and Electronics Engineers), BibTeX e RIS.

Exportar Referência (APA)
Santos, M., Laureano, Raul M. S. & Carlos E. R. Albino (2018). 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. In 2018 13th Iberian Conference on Information Systems and Technologies (CISTI). (pp. 1-6). Cáceres, Spain: IEEE.
Exportar Referência (IEEE)
M. R. Santos et al.,  "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", in 2018 13th Iberian Conf. on Information Systems and Technologies (CISTI), Cáceres, Spain, IEEE, 2018, pp. 1-6
Exportar BibTeX
@inproceedings{santos2018_1711645683293,
	author = "Santos, M. and Laureano, Raul M. S. and Carlos E. R. Albino",
	title = "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",
	booktitle = "2018 13th Iberian Conference on Information Systems and Technologies (CISTI)",
	year = "2018",
	editor = "",
	volume = "",
	number = "",
	series = "",
	doi = "10.23919/CISTI.2018.8399472",
	pages = "1-6",
	publisher = "IEEE",
	address = "Cáceres, Spain",
	organization = "AISTI/UEx",
	url = "https://ieeexplore.ieee.org/document/8399472/"
}
Exportar RIS
TY  - CPAPER
TI  - 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
T2  - 2018 13th Iberian Conference on Information Systems and Technologies (CISTI)
AU  - Santos, M.
AU  - Laureano, Raul M. S.
AU  - Carlos E. R. Albino
PY  - 2018
SP  - 1-6
DO  - 10.23919/CISTI.2018.8399472
CY  - Cáceres, Spain
UR  - https://ieeexplore.ieee.org/document/8399472/
AB  - 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.
ER  -