Home

Quick Links

Legal

navigation

Case Studies

Monday, March 30, 2015

Intematix Uses Dynamic Insights by Armanino to Empower its Business Users with Better, Faster Access to Data


At A Glance

Customer Profile:

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.

Software & Services

  • Dynamic InsightsSM by Armanino with PrecisionPoint and QlikView
  • Armanino consulting services

Benefits

  • Eliminates manual consolidation and reporting, with one dashboard alone saving two hours per day for one FTE
  • Gives executives visibility into overall company performance in one currency
  • Provides increased insight into global operations and performance, with one single source of truth

Challenge

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.


Business Solution

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.”


Business Results

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.”


Next Steps

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.


For More Information

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.

RELATED ARTICLES

• 

COMMENTS

comments powered by Disqus