Design of Customer Information Management System

The Customer Information Management (CIM) needs to handle, maintain and store the customer data. To facilitate this objective, the need for an application that takes the customer and the item details from the external source files and store the same in the Data Warehouse (DW) is required. It is an ETL system developed to create the mapping to load the target from the source files after applying criteria as required by the administrator and will also provide the overall features and functionalities required to store and maintain customer data. The data stored in the DW is transformed (cleaned and integrated), thus it is credible and can be used for business insights. This serves as an important component for BI (Business Intelligence) which will help in transforming raw/operational data into some meaningful information. The Fact_Inventory which is developed provides us the historical data in a summarized form which can be used for managerial, strategic and analytical decisions by the Analysts team and the end users. It acts as a vast storehouse for the already operated data and can be referred to as an ‘Informational System’.