Client's Commercial Sales and Retail Sales organizations struggle to wrangle point of sale (POS) data sets from their channel business partners such as Home Depot, Walmart, etc., both EDI and non-ED vendor portals to create meaningful analytical insights and dashboards.
The client selected KPIs from multiple vendors through a rigorous RFP process. KPI experience in Hortonworks Hadoop, Azure, EBS, and Tableau was the key differentiator for a client, in addition to KPI's blended shore model to minimize cost and risk for a client.
Hadoop-based POS Analytics system for data from files and client's Oracle EBS EDI tables. KPI also delivered a complex lookup program to map retailer part numbers to client's part numbers to ensure more accurate reporting. KPI delivered an automated data standardization and Tableau data sources that could hook into other systems/files to allow users to build complex reporting about point of sale data tying out to store attributes, custom calendars, targets, etc.