Idea

Our clients manage an accounting company that has three office branches in Europe. They recently decided to collect the company's internal data to get an overview of different activities in real-time.

Challenges

The custom Business Intelligence service to be developed had to be flexible enough to:

• accept various data sources in CSV format;
• provide a secured Web-based dashboard;
• allow non-specialists to generate reports and query the data easily;
• make it possible to integrate generated reports with third-party Web-based user interfaces.

Solution

Based on these needs, Vantino developed a custom and flexible data analytics solution. It is based on the Superset business intelligence (BI) platform which was initially released by Airbnb.

A custom secure REST API allows to upload various sources of CSV data that are automatically exported from the company ERP and then imported to the analytics server database.

Analytics reports are being continuously updated, this allows management team to follow company's activities in real-time from a centralized Web interface. These reports may include for example sales monitoring, staff workload, marketing activities and much more. They are organized in different dashboards where information is displayed in a clear and structured way.

The fact that we went for a solution based on open-source technologies makes our customer less dependent on uncontrolled changes, provides a solution specifically tailored for its needs, does not require the payment of recurrent fees, offers more control over its data, and is potentially more secure as compared to depending on proprietary or Saas solutions.

Many companies face the problem of managing their growing amount of data: it indeed requires time and expertise to collect and analyze. As a consequence, although leveraging the company data can bring a clear competitive advantage, businesses often fail to exploit the Invaluable insights it provides.

We have the know-how and the expertise to help you build a custom business intelligence platform. Contact us to learn more or to get a consultation: sales@vantino.ch

Contact us to get a data management consultation. For more details, visit our Data & BI Consulting page and Data Analytics & BI services page.