CFP last date
22 April 2024
Reseach Article

Business Intelligence: Concepts, Components, Features, Extraction Transformation Loading Technology

by Saumya Patel
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 180 - Number 20
Year of Publication: 2018
Authors: Saumya Patel
10.5120/ijca2018916481

Saumya Patel . Business Intelligence: Concepts, Components, Features, Extraction Transformation Loading Technology. International Journal of Computer Applications. 180, 20 ( Feb 2018), 45-47. DOI=10.5120/ijca2018916481

@article{ 10.5120/ijca2018916481,
author = { Saumya Patel },
title = { Business Intelligence: Concepts, Components, Features, Extraction Transformation Loading Technology },
journal = { International Journal of Computer Applications },
issue_date = { Feb 2018 },
volume = { 180 },
number = { 20 },
month = { Feb },
year = { 2018 },
issn = { 0975-8887 },
pages = { 45-47 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume180/number20/29052-2018916481/ },
doi = { 10.5120/ijca2018916481 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-07T01:01:15.214038+05:30
%A Saumya Patel
%T Business Intelligence: Concepts, Components, Features, Extraction Transformation Loading Technology
%J International Journal of Computer Applications
%@ 0975-8887
%V 180
%N 20
%P 45-47
%D 2018
%I Foundation of Computer Science (FCS), NY, USA
Abstract

The ERP systems, CRM systems, banking and credit card systems and Corporate Governance regulations have exponentially increased data volumes needing analysis.Data storing mechanism and strong solutions would be needed for the entire process of data extraction from its sources to its analysis. Because of constant innovation in data processing, huge volume of data is needed to be stored in more detailed format. To analyse the data meaningfully, data reduction and a well-defined structured is also needed.The analysis necessary to create “business intelligence” from the collected raw data requires a varied tool set. By investigating the business needs, it defines the abilities on the roles and requirements of real time BI. The paper explores the concept of BI, objective of BI system, its key components and features, and Extraction, Transformation, Loading (ETL) process.

References
  1. S. AG, TBW10 - BI - Enterprise Data Warehousing, 2006.
  2. R. S. a. C. L. Golfarelli Matteo, Beyond Data Warehousing: What’s next in Business Intelligence, 2004.
  3. P. S. V.Sujatha bai, "Business Application with Sap Bi," International Journal of Computer Applications, 2012.
  4. "SAP Business Explorer," [Online]. Available: https://help.sap.com/saphelp_nw73ehp1/helpdata/en/5b/30d43b0527a17be10000000a114084/frameset.htm.
  5. P. Somasekaram, "Designing a Business Intelligence," 2013.
  6. S. A. TBW20, BI - Reporting & Query Design, 2006.
  7. Z. Ren, "Building Business Intelligence Application with SAP BI," IEEE Xplore, 2009.
  8. S. N. S. T. Parul, "Performance Optimization for Extraction, Transformation, Loading and Reporting of data," IEEE Xplore, 2015.
  9. S. A. Vassiliadis P., "Extraction, Transformation, and Loading," Encyclopedia of Database Systems. Springer, 2009.
  10. N. Anand, "ETL and its impact on Business Intelligence," International Journal of Scientific and Research Publications, 2014.
  11. D. R. J. Er. Sonal Sharma, "Modeling ETL Process in Data warehouse: An Exploratory Study Er. Sonal Sharma," IEEE Xplore, 2014.
  12. M. S. O. L. M. Y. Nur Alia Hamizah Mohamad Rodzi, "Significance of Data Integration and ETL in Business," IEEE Xplore, 2015.
  13. J. RANJAN, "BUSINESS INTELLIGENCE: CONCEPTS, COMPONENTS, TECHNIQUES AND BENEFITS," Journal of Theoretical and Applied Information Technology, 2009.
Index Terms

Computer Science
Information Sciences

Keywords

Business Intelligence SAP ETL NetWeaver BI