Business intelligence solution presents customer data without delay

The accounts receivable (A/R) department at Virtek Vision International had its hands full. Credit managers at the Ontario-based supplier of laser marking products needed to keep collections up-to-date by identifying those potentially delinquent before they became problems. Until recently, workers relied on spreadsheets that pulled information from the company's ERP system.

05/01/2008


The accounts receivable (A/R) department at Virtek Vision International had its hands full. Credit managers at the Ontario-based supplier of laser marking products needed to keep collections up-to-date by identifying those potentially delinquent before they became problems.

Until recently, workers relied on spreadsheets that pulled information from the company's ERP system. The process was slow, cumbersome, and inflexible.

“We couldn't identify key accounts on one screen, and we didn't have access to certain data,” says Katherine Campbell, corporate controller. “In our ERP system, customer information is in one massive table and the data is located by field, but not labeled. It used to take credit managers an entire day to run the collections report, which was then emailed to those needing it.”

This process is much more efficient since the company deployed a business intelligence (BI) solution from a German company known as AXLE Studio . Using AXLE Studio 2007, credit managers get automatic warnings when an account becomes 45 days past due. The system also identifies which companies should be given restrictions on future orders.

Reports are generated and sent on-demand via email to unit managers.

“Our IT staff is working on getting the reports to run daily automatically,” says Campbell. “We want to enable users to create their own customized reports specific to their product lines. Managers should be able to see their receivables, backlog, and revenue.”

The AXLE system is part of a four-phase implementation process that began last year. It runs on an SQL Server database that also partially supports the BI functionality in Virtek's ERP system. In the future, the company plans to extend the system to include more users; and offer new functionality, including volume of order shipping, global cash reporting, and multiple currencies.

Right now, Virtek is working with Dynac , an Ontario-based value-added reseller for AXLE Studio, to build an extraction layer in the system that creates triggers to pull knowledge from disparate systems and display it in a meaningful way.

“Users can see how many new orders were booked today or how many were changed,” says Gary MacFarlane, Dynac CEO and cofounder. “Instead of having to look up the data in five or six places, the system gives it to them on one screen.”

Since the system is Intranet-based, it does not require any additional hardware or servers. It uses a fat client and is housed within the corporate structure.

Unlike most BI systems, AXLE Studio does not require building a data warehouse, so it's deployed more quickly.

“Data can be refreshed automatically, and query loading can be done at off-peak hours,” says MacFarlane. “Data warehouses typically are refreshed periodically, and often users must wait for current data to be uploaded.”



Laser marking systems specialist Virtek Vision International recently completed a four-phase deployment of an AXLE Studio business intelligence (BI) system. Now BI functionality is supported in Virtek’s ERP system, and cumbersome spreadsheets and reporting processes are part of the past.

Meant for small to midsize businesses, or divisions of larger companies, “The system does not have functionality like regression analysis or extensive statistical analysis tools common to large BI systems,” says MacFarlane. “However, it connects to key data sources such as general ledgers and ERP systems, and links to multiple database tables, and across multiple databases.”

AXLE Studio users can learn to become designers, building their own queries and cubes.

“There's no need for special licenses or extra modules, and users easily can turn functions on and off,” says MacFarlane. “They don't have to build extension modules, as is often required with traditional BI solutions.”

There are nearly 6,000 users of AXLE Studio worldwide, and the company only recently entered the North American market. Dynac represents AXLE in the Americas, offering installation, technical support, and user training.





No comments
The Engineers' Choice Awards highlight some of the best new control, instrumentation and automation products as chosen by...
The System Integrator Giants program lists the top 100 system integrators among companies listed in CFE Media's Global System Integrator Database.
The Engineering Leaders Under 40 program identifies and gives recognition to young engineers who...
This eGuide illustrates solutions, applications and benefits of machine vision systems.
Learn how to increase device reliability in harsh environments and decrease unplanned system downtime.
This eGuide contains a series of articles and videos that considers theoretical and practical; immediate needs and a look into the future.
Sensor-to-cloud interoperability; PID and digital control efficiency; Alarm management system design; Automotive industry advances
Make Big Data and Industrial Internet of Things work for you, 2017 Engineers' Choice Finalists, Avoid control design pitfalls, Managing IIoT processes
Engineering Leaders Under 40; System integration improving packaging operation; Process sensing; PID velocity; Cybersecurity and functional safety
This article collection contains several articles on the Industrial Internet of Things (IIoT) and how it is transforming manufacturing.

Find and connect with the most suitable service provider for your unique application. Start searching the Global System Integrator Database Now!

SCADA at the junction, Managing risk through maintenance, Moving at the speed of data
Flexible offshore fire protection; Big Data's impact on operations; Bridging the skills gap; Identifying security risks
The digital oilfield: Utilizing Big Data can yield big savings; Virtualization a real solution; Tracking SIS performance
click me