Optimizes analytics your business with Microsoft SSAS and Power BI


Country or Region: Spain

Sector: Economics and Finance



Cobralia is a debt recovery company who represents several entities, banks, funds and utilities. They offer integral management advice in each of the above areas. In order to manage all these areas, they have a customised management system for each collection, legal process, required and specialised documentation concerning any legal actions and are constantly on the lookout for better, alternative solutions to manage each of these. Due to the large amount of variables involved, there was a need to create a unified system to analyse their business as a whole.

Cobralia are also committed towards diversity and equal opportunities. Their company’s pledge is to ensure that everyone has the same opportunities, rights and obligations. Although a dynamic group that aims to be self sufficient in regards to business intelligence, they have on this occasion engaged SolidQ services in order to obtain the required knowledge to mine the core of their own analytical BI system.

By implementing their new solution, Cobralia has now obtained a centralised platform with business data and user management, as well as different analytical reports.  

Current situation

Cobralia was lacking an analytical system that provided the assistance needed for data analysis and display. Due to the importance of monitoring each case file’s status, a special emphasis was made in achieving an automated system to analyse their correct monitoring, both in terms of volume, as well as individually, in order to make it easier for users who require this information.

Currently, this information is obtained from a series of Microsoft SQL Server data bases which provide data enrichment to support the analytical tier via several Microsoft SQL Server Integration Services and Microsoft SQL Server Analysis Services data transformations.

Project requirements:

  • Providing a unified platform in order to centralise the data
  • Need to provide reports for the rest of business users
  • Providing an analytical system for the monitoring of case files by the directors and managers

Their solution was dealt with in two stages. Phase one:

  • Data source enrichment system
  • Mining company data
  • Creation of a multidimensional model to cover users’ data mining
  • Using communication tools such as Trello or O365 in order to simplify the monitoring of tasks, as well as the control in the definition of requirements and documentation

A solution consisting of Microsoft SQL Server Integration Services was deployed, in addition to Microsoft SQL Server Analysis Services, to deal with and process data on a daily basis in approximately half an hour.

“Our new solution is becoming key aid in the decision making process, resource planning and to analyse all the business generated by the company’s productive area” Carlos Moreno, Director de Tecnología, Proyectos e Información


This platform simplifies the centralisation and analysis of the company’s data into a single corporate system.

It provides users with a solution based on merging the information consumed by the company with data from the Cube in order to analyse and enable users to create centralised reports for the rest of the company, providing support for the decision making and business monitoring processes.

“It has not only enabled us to research historical information in a more flexible and efficient manner, but we are also using the Cube to connect it with Power BI in order to prepare business and management dashboards” Carlos Moreno, Director de Tecnología, Proyectos e Información

Customized solutions


The SolidQ team can adapt each solution to fit your company. Would you like to take a leap and transform your business? Get in touch with us and we’ll see how to help you 🙂