Tech consultancy gets single source of truth for reporting

Published on the 22/07/2021 | Written by insightsoftware

Quint_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

Beef+Lamb + Jet Reports

Jet boost for Beef + Lamb finance

August 28, 2017 | insightsoftware

For any business, accurate financial reporting provides the basis on which to make decisions and track performance over time…

Jet Reports and EMD

Jet-powered: The data-driven motor company

July 11, 2016 | insightsoftware

European Motor Distributors implements Jet Enterprise for operational intelligence…

Revenue boost for wholesale distributor Kinsey’s Archery

August 6, 2014 | insightsoftware

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

August 1, 2014 | insightsoftware

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

Amnesty International embraces jet propelled reports

June 8, 2014 | insightsoftware

Amnesty International was dealing with an outdated reporting system and needed to upgrade but the results went far beyond simple reporting…

Processing...
Thank you! Your subscription has been confirmed. You'll hear from us soon.
Follow iStart to keep up to date with the latest news and views...
ErrorHere