The Wholesale distribution and retail industries faces huge challenges in quickly identifying how the supply chain is performing, how to manage supply in real time, how to further improve the supply chain. The warehouse operations and transportation data gathering and analysis is the key to give insight into historic and current status of the business process and enable key decision making to improve the efficiency of the business. The objectives of this paper are to introduce effective and cost effective data analytics feature using the key Oracle database features to analyze the current and historic supply chain data to extract actionable information.

Keywords : Data Analytics; Supply chain analysis; Data warehouse Performance; Dustribution Industry