Projects / Open Source Business Intelligence Project

The need:

A business intelligence solution used to analyze the company’s business operations and interactions with customers. The customer had a number of data sources and a variety of databases. The customer was interested in a data solution based on open source to reduce costs.

Business specification:

Business activity analysis:

Growth and expansion trends of customers by marketing channels (Funnel) and products, customer usage patterns of products and services, Customer abandonment trends by products and marketing channels.

Strategic reports:

Quarterly reports and quarter comparison reports, annual reports and annual comparison reports.

Tactical reports:

Operational reports that deal mainly with measuring the day-to-day activity, which allowed making decisions during a workday – in order to improve daily business outcomes.

The solution:

Step 1

Planning a system that is able to process and retrieve very large amount of data in a short time. For this purpose, we developed a complex data warehouse that included data from a variety of very large databases.

Step 2

Accessibility to very large amounts of data via reports, in a way that the report gives a clear and articulate business answer through a minimum use of data screens. We chose to use an end-user Self Service BI tool, whereby the end user can develop their own reports.


Business outcome for the company:

The client received a business intelligence system, which helped him to identify faults and to improve day-to-day outcome and a strategic management tool that was used in all the administration meetings.

WhatsApp chat