Bluetab

Regulatory Information Energy CNMC

by

Regulatory Information Energy CNMC

The remuneration model of the electricity market in Spain requires companies engaged in the distribution of electricity to provide a large amount of information to the CNMC about their investments and electricity grids with a level of detail that is hardly available in business management systems of distribution.

A system capable of communicating with the different data sources in order to obtain all the necessary information for the preparation of the reports that the different distributors have to present annually to the regulatory body regarding their expenses and investments made, has been developed.

The main processes that make up this system in charge of preparing and presenting information to the regulatory agency are:

  • barra-bluetab Investments: process that contains all the economic and technical information, as well as the time dedicated to the work, necessary to relate the investments made with the corresponding facilities.
  • barra-bluetab Consistencies: analysis process that guarantees that the information is valid to be presented correctly in the different reports.
  • barra-bluetab Inventory: process that contains all the information related to each of the facilities.
  • barra-bluetab Loading information and Master Data: processes responsible for transferring all the information from the source systems and their respective configurations necessary to adapt the data to the criteria of current legislation.
SUCCESS STORIES

NPS

by

NPS

Project for the Customer Experience area of ​​a Telco operator. Preparation and quantitative and qualitative analysis of customer surveys to determine the basic indicator of customer experience with the company and its services.

The Bluetab Data Scientist team designed an automatism for the extraction and processing of the sample databases and the subsequent collection, processing and analysis of customer responses. For this, SPSS migrated to R and Python, Spider, database treatment in SQL was used in the first versions to continue with the preparation of the introduction of survey results carried out with AI.

SUCCESS STORIES

Fraud prediction model

by

Fraud prediction model

Design of the predictive model of Web Frauds carried out by Bluetab for a leading financial institution in the Spanish market

It consists of developing a predictive algorithm capable of classifying browsing sessions according to their similarity to sessions in which a fraudulent transfer has occurred. The output of this algorithm will be a scoring (or a probability) that will allow ordering these sessions by their probability of being fraudulent.

For this, information from the management of alerts and claims of fraud in Remote Banking Transfers is used, as well as the daily information of the browsing sessions on the web and in the APP; therefore, the target audience or population on which this model will be executed is the one that has started a session by one means or another.

Our methodology is based on the construction of the target based on the crossing between fraud and navigation information (the most critical process of a predictive model), in the diagnosis of inconsistencies among fraudulent operations that do not have an associated session, outliers with some wrong record on date.

SUCCESS STORIES

CRM with artificial intelligence

by

CRM with artificial intelligence

As a follow-up to the technological strategy of one of the leading financial institutions, a machine learning algorithm is implemented to predict and prioritize the best offering mix to propose to customers, with the aim of increasing cross-selling and linking of the installed customer base.

By implementing ML, it is possible to enhance the commercial strategy of the entity, broadening the customer vision and integrating with the current CRM, which will increase the probability of success of the actions to be carried out, improving income and customer satisfaction and loyalty. For this, the algorithm prioritizes through existing campaigns crossing with alternative products such as loans, mortgages, funds, cards, pension plans, or different types and insurance coverage (home, health, car)

As output, it is intended to show the improvement by measuring the increase in specific indicators such as:

  • barra-bluetab Contracts
  • barra-bluetab value-customer ratio
  • barra-bluetab % digitization per customer
  • barra-bluetab Click-through rate
SUCCESS STORIES

MULTI-BRAND NDWH

by

MULTI-BRAND NDWH

Among the emerging operators in the telecommunications business, there has been an initiative that allows a single entity to integrate several commercial brands, integrating the processes common to all of them and making them as efficient as possible.

So, for the particular case of data management, a single, centralised repository is being built for all the relevant information for the different commercial brands, to allow for a unique exploitation of the data.

This platform has been developed on Google Big Query, Google Looker, Oracle, Microsoft and Tableau.

SUCCESS STORIES

Unified Data warehouse

by

Unified Data warehouse

The telecommunications sector has always been a very dynamic sector. In this sense, they have always had an urgent need to analyze their information in a convergent and unique way.

To this end, an agile end-to-end collaboration has been consolidated with the operator’s data area for the construction of the new DWH, from the analysis of the data sources to their exploitation by the user areas.

The technological platform used has been Teradata, Exadata, Oracle, PowerCenter and Microstrategy.

SUCCESS STORIES