Intematix is an industry-leading producer of essential materials used in LED lighting solutions. The company needed a way to integrate data from its Microsoft Dynamics AX system and provide consolidated reporting from four global business entities in one currency. Intematix chose Dynamic InsightsSM by Armanino as its reporting and business intelligence solution. Now, executives and other business users around the world have access to the data they need via easy-to-use dashboards.
Founded in 2000, Intematix is a global developer and manufacturer of essential materials used in LED lighting solutions. With offices and manufacturing centers located around the world – including China, Hong Kong, and Taiwan – Intematix turned to Microsoft Dynamics AX for a robust ERP solution to supports its global operations. Armanino, one of the largest independent accounting and business consulting firms in the U.S. and one of the largest Microsoft Dynamics Partners in North America, was chosen as the implementation partner.
After the successful deployment of the new ERP system, Intematix then decided to tackle the challenge of reporting and business intelligence. The company began searching for a solution that would allow it to accurately and flexibly create consolidated reports across its four operating companies and multiple currencies in Microsoft Dynamics AX.
Intematix chose Dynamic InsightsSM by Armanino, which combines PrecisionPoint data warehouse software and the QlikView business discovery platform to create an easy-to-use reporting and analysis solution. “PrecisionPoint eliminates a great deal of work because it reconciles the data and transactions from the Microsoft Dynamics database, from subledgers to General Ledger,” says Alex Wong, director of IT and business systems at Intematix. “We were very impressed with QlikView, especially its powerful extract, transform and load database functions (ETL), scalable scripting, and run-time performance.”
Using its Dynamic Insights solution, Armanino built an executive dashboard as a pilot project for Intematix, combining key performance indicators such as revenue, operating expenses, accounts receivable, and inventory value. “Armanino really understands our business model, which enabled them to quickly create the new executive dashboard,” says Wong. “From Armanino, we learned how to master the QlikView scripts and to create our own dashboards in-house.”
Wong appreciates the minimum overhead, speed of deployment of QlikView documents in a production environment, and role-based security that QlikView provides the Intematix IT team. “With QlikView, we can now build the type of dashboard that aligns with business requirements,” says Wong. “It saves us immense amounts of time to reconcile the information in the QlikView documents, and enables key business owners in the company to view the same source of data, so we have one version of the truth.” After the pilot project, his team went on to deliver a booking, backlog, and billing (BBB) dashboard as well as a sales analysis dashboard.
While the IT group is happy with its new reporting tools, the core business leaders in the company are thrilled with the new insight they’ve gained. “This is the first time that our executives have had a consolidated view in U.S. dollars of the entire company instead of looking at separate reports,” says Wong. “The sales teams get immediate information from the BBB dashboard. Before QlikView, it took one person two hours each day to compile the BBB information for sales.”
With Dynamic Insights, the IT group is accelerating the process of getting consolidated data into the hands of the business users around the world who need it. For instance, Wong’s team plans to soon roll out a new inventory dashboard with value, aging, and on-time delivery to give the corporate finance and operations departments greater visibility and control.
Armanino is a Qlik Elite Solutions Provider, Gold Certified Microsoft Dynamics AX Partner, and the exclusive distributor of PrecisionPoint in North America. By leveraging the power of these solutions combined in Dynamic InsightsSM, Armanino provides a comprehensive roadmap for company growth. With every project, we take a strategic approach to ensure successful deployments, user training and outstanding value, year-after-year.
Download Case StudyMarch 30, 2015
