CFP last date
20 January 2025
Call for Paper
February Edition
IJCA solicits high quality original research papers for the upcoming February edition of the journal. The last date of research paper submission is 20 January 2025

Submit your paper
Know more
The week's pick
Responsive image
SFLA-Based Line Balancing and Task Optimization in Master-Slave Controlled Hanger Transportation Systems for Garment Production

Duc Hoang Nguyen
Random Articles
Reseach Article

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

by Saumya Patel
journal cover thumbnail

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

Powered by PhDFocusTM