Design of Visibility for Order Lifecycle using Datawarehouse
G. Jayashree1, Dr. C. Priya2
1G.Jayashree, Research Scholar, Department of Computer Science, School of Computing Sciences, VELS Institute of Science, Technology and Advanced Studies (VISTAS), Chennai, India.
2Dr. C. Priya, Research Supervisor, Department of Information Technology, School of Computing Sciences, VELS Institute of Science, Technology and Advanced Studies (VISTAS), Chennai, India.
Manuscript received on July 14, 2019. | Revised Manuscript received on August 20, 2019. | Manuscript published on August 30, 2019. | PP: 4700-4707 | Volume-8 Issue-6, August 2019. | Retrieval Number: F9171088619/2019©BEIESP | DOI: 10.35940/ijeat.F9171.088619
Open Access | Ethics and Policies | Cite | Mendeley
© The Authors. Blue Eyes Intelligence Engineering and Sciences Publication (BEIESP). This is an open access article under the CC BY-NC-ND license (http://creativecommons.org/licenses/by-nc-nd/4.0/)
Abstract: Data warehouse, shortly called DW, a repository to store historical data was widely used across organizations for analyzing the data for any business decisions to be decided. It acts as a decision support system, which will help the decision makers to provide any conclusion based on the analyzed data. DW can be used across any particular fields in the public domain. Some of them would include Retail, Insurance, Finance, Sales, Services, Health Care, Education, etc. This paper analyses and proposes the data ware house design considerations for the supply chain. The design was explained with a detailed case study on understanding the visibility of sales order at various stages.
Keywords: Bottom-Up Approach, Business Intelligence, Data Mart, Data Mining, Data Visualization, DW, Supply Chain, Order Visibility, Dimension, Fact Star Schema, OLAP, Top-down Approach.