DOIONLINE

DOIONLINE NO - IJMPE-IRAJ-DOIONLNE-3426

Publish In
International Journal of Mechanical and Production Engineering (IJMPE)-IJMPE
Journal Home
Volume Issue
Issue
Volume-3, Issue-11  ( Nov, 2015 )
Paper Title
A Review on an ETL Process in Business Intelligence System in Telecom and Automobile Sector in Maharashtra
Author Name
Shailesh A Kahalekar, Sunil Patil
Affilition
Research scholar, Pacific university, Udaipur Principal, A.G.Patil Engg College, Solapur, India
Pages
146-151
Abstract
An Extraction, Transformation and Loading Process in Business intelligence is at the base and core of the data loading process for the purpose for both in Automobile and manufacturing industry and in telecom industry .This paper elaborates this data loading process and its importance in business intelligence system. Further it throws the light on the Business intelligence system being used -across world in the various systems in multidisciplinary data analysis. Further data loading process in case of the BSNL as a specific case is discussed in detail .It is further shown by the organizational process improvement due to the implementation of BI in the project management scenario in telecom and manufacturing sector ,organizationally. Keyword- Abbreviations :-E-Extraction, T-Transformation ,L-Loading , PSA-Persistent staging area, SAP- Systems, Applications, Products in data processing ,DSO-Data stored object, DTP-Data Transfer process .DW-Data wearhouse, BSNL-Bharat sanchar Nigam Limited, MTNL-Mahanagar Telephone Nigam Limited, ERP- Entreprise resource planning.
  View Paper