Tech consultancy gets single source of truth for reporting

November 2024
M	T	W	T	F	S	S
				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30
« Oct		Dec »

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

AT A GLANCE

Quint

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.