Computer Science and Information Technology Vol. 7(3), pp. 82 - 95
DOI: 10.13189/csit.2019.070304
Reprint (PDF) (1255Kb)

SAS^® Metadata Audit Reporting Transition to Modern BI & Analytics

Pintu Kumar Ghosh ^*
Standard Chartered Bank, Singapore

ABSTRACT

In today's world, there has been huge transition from traditional BI (Business Intelligence) and Analytics to the modern one. In the past, we used to have a countable number of canned reports and analytical models; in modern BI (Self-Help reporting/In-memory/Tonnes of data) and Big Data Analytics space, the volumes have been growing very fast from a few Giga Bytes to Zeta Bytes of data. Starting from sourcing the data from disparate sources, housing them in various formats (structured to unstructured to text to streams) and finally landing them at Big Data/Data Lake platform for BI, Reporting, Visualization and Analytics use; IT change impact analysis and maintenance has been a challenge. That's when auditing and reporting metadata bring values to the problems. In every organization, Group IT requires a strategy to track data utilization or system adaptation in order to accelerate their decision-making process from time-to-time towards the growth and maturity. SAS^® 9 has various auditing features and solutions like SAS^® Audit, Performance and Measurement Package, SAS^® Environment Manager Audit Reporting and SAS^® VA (Visual Analytics) Administrator's Usage Reports. In this paper, an in-house and out-of-the-box users audit and metadata reporting approach has been depicted. It includes features like tracking number of SAS users and their usage of various client applications and the contents. It has also capability of capturing details like the various dormant SAS users/groups among the total registered SAS users/groups, an automatic housekeeping, scheduling and so on. If you are seeking for a solution for quick turn-around, it would help you to guide your organization whereby Enterprise BI & Analytics softwares like SAS^® (EBI) Enterprise BI, SAS^® EDI (Enterprise Data Integration) and/or SAS^® Visual Analytics have already been deployed.

KEYWORDS
Log Parsing, Metadata Reporting, Business Intelligence, Visual Analytics, Audit, Data Governance, Operation Risk, Architecture

Cite This Paper in IEEE or APA Citation Styles
(a). IEEE Format:
[1] Pintu Kumar Ghosh , "SAS^® Metadata Audit Reporting Transition to Modern BI & Analytics," Computer Science and Information Technology, Vol. 7, No. 3, pp. 82 - 95, 2019. DOI: 10.13189/csit.2019.070304.

(b). APA Format:
Pintu Kumar Ghosh (2019). SAS^® Metadata Audit Reporting Transition to Modern BI & Analytics. Computer Science and Information Technology, 7(3), 82 - 95. DOI: 10.13189/csit.2019.070304.