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

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.