Armanino Case Study
Case Study
Intematix Uses Dynamic Insights to Empower Users

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


  • 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


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.

Download Case Study

March 30, 2015

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

Related News & Insights
FP&A for SaaS Companies: How to Drive Powerful Decisions from Your Data
Are you getting what you need from your financial planning and analysis?

March 23, 2023 | 11:00 AM - 11:30 AM PT
ERP & CRM Integration: Key Business Benefits and How to Get Started
These systems become more powerful for your business when they work together. Here’s why integration is worth it.

March 22, 2023
Learn the Latest Microsoft Dynamics GP Updates and Cloud Roadmap
Is it time to transition to more advanced Microsoft ERP solutions?

March 21, 2023 | 10:30 AM - 11:00 AM PT