Platform to Manage Supply Chain and Analyze Retail Performance

Challenge

• Leading specialty retailer of entertainment products required a platform to track inventory to manage the supply chain across all brands and to analyze retail sales performance
• Data was siloed across the organization including an AS400 ERP that made analytics challenging
• Current processes were run by using excel and other legacy technologies that were not timely, flexible, or stable
• Needed to enable analysts to be self-sufficient for all analytics

Solution

• Provided an initial implementation Roadmap to design the phased implementation approach
• Designed and built ETL infrastructure to collect, clean and transform source data

Result

• Increased performance by 5x of nightly load process
• Enabled business users to perform ad-hoc, drill up/down analyses on their desktop from “one version of the truth” for all inventory and retail sales data