ADVIZOR’s value proposition for analytics is spearheaded by a Bell Labs-sourced technology for in-memory analytics, which enables two major functions—storing data in memory and visualization. The technology efficiently integrates tables of data from multiple databases to display the client details and customer-to-order relationships, where each order has multiple items. “ADVIZOR has enriched Bell Labs’ technology further to provide the Visual Discovery software (VDS)—a user-friendly tool for interactive data visualization— that operates on diverse on-premise environments like the Windows, iPads, and cloud,” says Cogswell. VDS prioritizes optimizing cycle time to increase the economic value for customers.
To deploy VDS, ADVIZOR thoroughly assesses clients’ key objectives and pain points concerning cycle times, pricing margins or even customer retention. Later, a tool to integrate data from multiple systems and formats such as MySQL and PostgreSQL is employed, following which VDS is loaded on to the memory and factory core system. “The ERP system has details of customers’ orders—the parts, pricing and the in-out times of machines—while machines provide operational information between the in and out times,” explains Cogswell. All the data is blended, and metrics are created to improve the delivery efficiency of each order and displayed as heat maps.
ADVIZOR has enriched Bell Labs’ technology further to provide the Visual Discovery software—a user-friendly tool for interactive data visualization—that operates on diverse environments
Cogswell shares the experience of working with a metal surface plating company that lacked visibility into the exact buckets-per-minute moved by the machines, for whom ADVIZOR created a heat map visual of dollars per bucket-minute. The heat map featured rectangles representing customers, sized by the number of orders from each customer and colored by dollars per bucket-minute (DPB). Higher DPB colors rectangles green, and lower values, red. Clicking on rectangles displays underlying order data, which the management can utilize to identify the steps and initiate corrective measures. Regression algorithms support dynamic linking of data to heat maps through charts and tables.
Heat maps helped SWD—a metal finishing, dip spin coatings facility— optimally use the data from its dip spin line facility, which improved collaboration between teams and personnel manifold. Costs and operation timelines were significantly optimized, which boosted the order delivery efficiency and hence customer satisfaction. The successful collaboration continues with ADVIZOR’s engagement in building dashboard-enabled visualization capabilities for SWD’s upgraded dip spin facility.
With in-memory analytics being the new buzzword in business, ADVIZOR is poised to engage with customers worldwide. “It would be about deriving insights from data that was never designed for analytics,” concludes Cogswell.