Published on the 22/07/2021 | Written by insightsoftware
AT A GLANCE
INDUSTRY
- Business and IT Consulting Services
BUSINESS OBJECTIVE
- Integrate data from the three various source systems
- A solution for effective data normalization and consolidation to simplify reporting
SOLUTION
- Jet Analytics
BUSINESS BENEFITS
- Automated data preparation making instant reports
- Fast and low-maintenance data transformation
- Can easily generate complete financial reports by themselves
FOR MORE INFORMATION
Insight Software
W: insightsoftware
E: aunz@insightsoftware.com
AU: +61 300 662 649
NZ: +64 4 473 7137
With increasing amounts of data to report on a solution was required to simplify reporting…
Quint is a global consultancy, training, and technology company. It supports organisations in designing and implementing digital transformation solutions. Quint’s key focus areas are digital strategy, data activation, lean agile enterprise, sourcing advisory, IT governance, enterprise cloud, enterprise DevOps, and enterprise automation.
The Challenge
Quint’s Malaysia branch had been using Microsoft Dynamics NAV for many years, integrated with its proprietary ERP system, Quint Information System (QIS). As the organisation grew, Quint decided to migrate all its systems into a new ERP, Odoo. However, with increasing amounts of data to report on, and with legacy data still residing in NAV and QIS, they needed a solution for effective data normalization and consolidation to simplify reporting and to establish a single source of truth.
After comparing different solutions on the market, they opted for insightsoftware’s Jet Analytics as a data preparation, automation, and modelling solution. Thanks to Jet Analytics, they could successfully integrate data from the three various source systems: legacy accounting data from NAV, legacy sales data from QIS, and combined accounting and sales data from Odoo. They also chose Jet Reports as a front-end financial reporting tool within Excel.
Jet Analytics is flexible and easy to use. If you have some basic database knowledge, you will discover even more possibilities with Jet.
Yin-Ting Chua, Software Development Engineer
Building to success with Jet
Using Jet Analytics and Jet Reports combined, Quint has been able to automate data preparation and make it report-ready in an instant. They can easily publish the data to their users with the built-in Jet Reports scheduler, which generates reports to the organisation’s cloud storage. In order to fully utilize the aggregated data, they are published to Google Data Source for report visualization via Google Data Studio.
Jet Analytics has allowed Quint to enable fast and low-maintenance data transformation. The data preparation and automation are done in a matter of minutes.
The finance team uses Jet Reports to generate and analyze monthly consolidated financial reports, always using reliable, single-source data prepared in Jet Analytics. “Jet Reports provides the finance team with a clear view of consolidated data within Excel,” said Yin-Ting Chua, Software Development Engineer at Quint. “Also, the team can easily generate complete financial reports by themselves.”.
By implementing Jet Analytics and Jet Reports, Quint has been able to enjoy several benefits:
- The finance team can easily access a common, reliable single source of truth collecting data from multiple source systems.
- Users can query data from Jet Reports in Excel without the need for P/SQL programming knowledge.
- Time-savings with data preparation, automation, and modelling done in a matter of minutes
Navigating Success
With simplified data management and reduced dependency on the IT department to create reports, finance users can now access the data they need and generate reports by themselves.
FURTHER READING
About This Vendor
More Case Studies
Jet boost for Beef + Lamb finance
For any business, accurate financial reporting provides the basis on which to make decisions and track performance over time…
Jet-powered: The data-driven motor company
European Motor Distributors implements Jet Enterprise for operational intelligence…
Revenue boost for wholesale distributor Kinsey’s Archery
A wholesale distributor of hunting and fishing equipment, Kinsey’s Archery has served thousands of customers for over 50 years…
UK cider house achieves real-time sales analysis
Westons Cider, an award-winning cider producer based in Herefordshire, England, was searching for reporting flexibility and in-depth profitability analysis for their growing business…
Amnesty International embraces jet propelled reports
Amnesty International was dealing with an outdated reporting system and needed to upgrade but the results went far beyond simple reporting…