DATA ENGINEERING SOLUTION
Description
30 July 2022
Data Engineering
Engineering Consultancy
Pap Solutions Pty Ltd. wanted to improve their data visualizations and reporting to have accurate results and key financial insights by integrating with the real-time data from an accounting platform XERO. As they have been in the industry from quite a long time, they have significant amount of data in xero which they like to use, however, as there are some limitations from third party integrations that the API exposed by Xero will only allow 100 records per call that makes it difficult for them to have al the data in the PowerBI (a Microsoft tool used for data reporting and visualization) and without that the reports that were built out will not have accurate results and will only provide perspective of a specific time period.
One of our highly skilled backend developer after doing some analysis able to develop multiple PowerBI custom connectors in .NET for them, which fetch data from Xero in batches and provided all the relevant information to PowerBI from where our key data analyst build meaningful and intelligent reports for them. Our team not only helped them in getting the visual representation of their overall finances but also provided them with the direction to make right decisions for their business.