Research Article

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

by  Saumya Patel
journal cover
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 180 - Issue 20
Published: Feb 2018
Authors: Saumya Patel
10.5120/ijca2018916481
PDF

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 },
                        year    = { 2018 },
                        volume  = { 180 },
                        number  = { 20 },
                        pages   = { 45-47 },
                        doi     = { 10.5120/ijca2018916481 },
                        publisher = { Foundation of Computer Science (FCS), NY, USA }
                        }
                        %0 Journal Article
                        %D 2018
                        %A Saumya Patel
                        %T Business Intelligence: Concepts, Components, Features, Extraction Transformation Loading Technology%T 
                        %J International Journal of Computer Applications
                        %V 180
                        %N 20
                        %P 45-47
                        %R 10.5120/ijca2018916481
                        %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
  • S. AG, TBW10 - BI - Enterprise Data Warehousing, 2006.
  • R. S. a. C. L. Golfarelli Matteo, Beyond Data Warehousing: What’s next in Business Intelligence, 2004.
  • P. S. V.Sujatha bai, "Business Application with Sap Bi," International Journal of Computer Applications, 2012.
  • "SAP Business Explorer," [Online]. Available: https://help.sap.com/saphelp_nw73ehp1/helpdata/en/5b/30d43b0527a17be10000000a114084/frameset.htm.
  • P. Somasekaram, "Designing a Business Intelligence," 2013.
  • S. A. TBW20, BI - Reporting & Query Design, 2006.
  • Z. Ren, "Building Business Intelligence Application with SAP BI," IEEE Xplore, 2009.
  • S. N. S. T. Parul, "Performance Optimization for Extraction, Transformation, Loading and Reporting of data," IEEE Xplore, 2015.
  • S. A. Vassiliadis P., "Extraction, Transformation, and Loading," Encyclopedia of Database Systems. Springer, 2009.
  • N. Anand, "ETL and its impact on Business Intelligence," International Journal of Scientific and Research Publications, 2014.
  • D. R. J. Er. Sonal Sharma, "Modeling ETL Process in Data warehouse: An Exploratory Study Er. Sonal Sharma," IEEE Xplore, 2014.
  • M. S. O. L. M. Y. Nur Alia Hamizah Mohamad Rodzi, "Significance of Data Integration and ETL in Business," IEEE Xplore, 2015.
  • J. RANJAN, "BUSINESS INTELLIGENCE: CONCEPTS, COMPONENTS, TECHNIQUES AND BENEFITS," Journal of Theoretical and Applied Information Technology, 2009.
Index Terms
Computer Science
Information Sciences
No index terms available.
Keywords

Business Intelligence SAP ETL NetWeaver BI

Powered by PhDFocusTM