ADVIZOR Solutions: Synthesizing Analytics-Ready Data:

Doug Cogswell, CEO, ADVIZOR Solutions, has good news for manufacturers and shop floor businesses. While analytics provides a huge incentive to businesses, mid-market manufacturers lack the resources to leverage it. Further, the data generated in manufacturing facilities is not analytics-ready but meant for daily workflow. Business intelligence expert, ADVIZOR bails manufacturers out of their predicament by enabling visibility into processes to combat the high cycle times and enable a realistic view of machine performance, which ultimately impacts revenue. ADVIZOR has pioneered accessing and blending disparate data sets to tailor them for analytics and uncover the “stories hidden” in them to obtain human understanding. 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.