Call for Paper - January 2023 Edition
IJCA solicits original research papers for the January 2023 Edition. Last date of manuscript submission is December 20, 2022. Read More

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

International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Year of Publication: 2018
Saumya Patel

Saumya Patel. Business Intelligence: Concepts, Components, Features, Extraction Transformation Loading Technology. International Journal of Computer Applications 180(20):45-47, February 2018. BibTeX

	author = {Saumya Patel},
	title = {Business Intelligence: Concepts, Components, Features, Extraction Transformation Loading Technology},
	journal = {International Journal of Computer Applications},
	issue_date = {February 2018},
	volume = {180},
	number = {20},
	month = {Feb},
	year = {2018},
	issn = {0975-8887},
	pages = {45-47},
	numpages = {3},
	url = {},
	doi = {10.5120/ijca2018916481},
	publisher = {Foundation of Computer Science (FCS), NY, USA},
	address = {New York, USA}


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.


  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:
  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.


Business Intelligence, SAP, ETL, NetWeaver, BI