Challenge

Our client for this challenge is the number one intermediary in financial products for cars and utility vehicles and they are also among the largest media groups in Poland.

As the operations of our client grew, the amount of paid marketing content increased significantly. One of the key success factors, from both a cost and revenue perspective, is the conversion from an online marketing budget into views, leads, and subsequently closed sales.

1
Business environment analysis
2
Development
3
Aggregation and integration of data
4
Deployment and maintenance

Solution

During the course of the project, it became evident that the growing scale of the business and expectations to control and react to changing business environment require the company to gather data, analyse it and make decisions based on insights rather than intuition.

The first phase of the project concentrated on understanding the needs of the organisation as a whole and the needs of each particular department. Based on the acquired knowledge, areas to cover were indicated and technological solutions to choose from were shortlisted. As a result of multiple internal workshops, a decision was made to focus on Microsoft and open-source solutions. The company has used Office365 as a major business tool for several years already and their priority was to minimise the impact on users by sticking to solutions that they are familiar with. Microsoft Azure was chosen as a cloud platform for the development of applications and processing of the data, as well as PowerBI for data visualisation purposes. The GUI for the data lake as well as the data lake itself were based on open-source solutions and built from scratch.
In the next stage of the project, the data environment of the customer was mapped. We analysed data to see if APIs or other interfaces were allowing for data collection and if they fulfilled business requirements.

An arduous process of data collection began based on a complete list of data sources, data types to be collected, and available interfaces. A lot of data is collected using open-source-based software robots, which trawl through websites and gather data. The next step was to implement Brainhint Robot Farm, which enables orchestration of dozens of robots to ensure completeness and credibility of the data.

The last step was to roll out the technology for users. Data lake entered the production stage and was integrated with all of the data sources, such as the CRM system, publicly available websites and databases, call centre systems, and PowerBI to present the data. Additionally, we developed a GUI for data lake, which allows users to export data using an interface similar to Excel pivot tables. All systems were made available based on SSO to meet the security requirements of the organisation. Our work continues to provide department-specific functionalities.

Effects

We designed, developed, and implemented scalable data storage and management solutions to enable further growth of the organisation and to provide increases in effectiveness expected by investors.

Thanks to the creation of data lake, professional data management, and its enrichment, our client has gained the ability to access and analyse its vital business data at any time it is needed.

The project and its extensions also became a foundation for the development and implementation of solutions using artificial intelligence to automate decision making.

  • AI

    ready environment

  • 24/7

    access to data for users based on SSO

  • Data lake

    aggregating business and market intelligence data

  • PowerBI

    implemented as leading data reporting system

Contact us

We will get back to you within 24 hours.