• Skip to primary navigation
  • Skip to main content
  • Skip to footer
Logotipo de Bluetab

Bluetab

Targeted Innovation

  • Solutions
    • DATA STRATEGY
    • DATA FABRIC
    • AUGMENTED ANALYTICS
  • Software
    • TRUEDAT
    • FASTCAPTURE
    • TAILORED ENTERPRISE SW
  • About Us
  • Our Offices
  • Talent
  • Blog
  • Español

data-fabric

Unified Data warehouse

September 11, 2020 by Bluetab

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
Foto por NASA en Unsplash

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…

Foto por Bernard Hermant en Unsplash

Global model of banking supervision

Banks must meet a growing volume of complex and granular reporting requirements. The methods used to collect reporting data are not fully harmonized, often leading to redundancies, overlaps, and inconsistencies in the resulting data sets. In this context there is…

Foto por Mari Helin en Unsplash

PSD2 regulations

PSD2 is a European regulation on digital payment services. This system facilitates payments throughout Europe with greater security as well as offering a banking service adapted to new technologies. With it, the importance that the world of 'APIS' or 'Application…

Filed Under: Casos Tagged With: data-fabric

Global model of banking supervision

September 11, 2020 by Bluetab

Global model of banking supervision

Banks must meet a growing volume of complex and granular reporting requirements. The methods used to collect reporting data are not fully harmonized, often leading to redundancies, overlaps, and inconsistencies in the resulting data sets. In this context there is a need to integrate existing statistical data requirements, as far as possible, into a single, standardized reporting framework that would be applicable throughout the euro area and could also be adopted by other European countries, thus easing the burden of bank reports and improving the quality of the data reported to the authorities.

The project scope covers the main supervisory reports: the ECB’s granular credit and credit risk data collection (AnaCredit), the ECB’s stock trend statistics (SHS), the balance sheet items statistics of monetary financial institutions (BSI) of the ECB, as well as statistics of interest rates of the monetary financial institutions of the ECB (MIR); likewise, other needs are considered as a requirement, such as the balance of payments and national accounts.

Our team carries out the project based on persistence in a big data lake, with ingests and transformations of the information in scala / spark technology. The transformation rules to create additional information have been defined based on “Validation and Transformation Language (VTL)” with minor adaptations to improve ease of use and end-user readability.

The generated system that follows this process begins by feeding the input layer from the banks’ internal IT systems, following the structure of the defined input layer cubes. The data processes can be divided into layers (input, enriched layer and output layer) and three phases that separate those layers: transformations in the input layer, output layer and the assignment application that describe the relationships between them. All phases can include validations, for example validations that ensure the integrity of the input layer, validations that ensure the consistency of the enriched input layer, validations that apply the validation rules (external) in the non-reference output layer.

SUCCESS STORIES
Foto por NASA en Unsplash

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…

Foto por Bernard Hermant en Unsplash

Global model of banking supervision

Banks must meet a growing volume of complex and granular reporting requirements. The methods used to collect reporting data are not fully harmonized, often leading to redundancies, overlaps, and inconsistencies in the resulting data sets. In this context there is…

Foto por Mari Helin en Unsplash

PSD2 regulations

PSD2 is a European regulation on digital payment services. This system facilitates payments throughout Europe with greater security as well as offering a banking service adapted to new technologies. With it, the importance that the world of 'APIS' or 'Application…

Filed Under: Casos Tagged With: data-fabric

PSD2 regulations

September 11, 2020 by Bluetab

PSD2 regulations

PSD2 is a European regulation on digital payment services. This system facilitates payments throughout Europe with greater security as well as offering a banking service adapted to new technologies. With it, the importance that the world of ‘APIS’ or ‘Application Program Interface’ is acquiring in different financial sectors is once again evident.

Bluetab carries out the start of the project for the main Spanish Financial Institution. We generate the necessary documentation to determine the scope of the project, perform the analysis of the availability of information within the platform, as well as address the definition and analysis of requirements (KPIs, data source)

The development of the project is based on the design and programming (data modeling, ETL processes), tests and putting into production (deployment, process optimization, etc.). All based on processes under Powercenter, in a Teradata database with reports to the end user in Microstrategy.

SUCCESS STORIES
Foto por NASA en Unsplash

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…

Foto por Bernard Hermant en Unsplash

Global model of banking supervision

Banks must meet a growing volume of complex and granular reporting requirements. The methods used to collect reporting data are not fully harmonized, often leading to redundancies, overlaps, and inconsistencies in the resulting data sets. In this context there is…

Foto por Mari Helin en Unsplash

PSD2 regulations

PSD2 is a European regulation on digital payment services. This system facilitates payments throughout Europe with greater security as well as offering a banking service adapted to new technologies. With it, the importance that the world of 'APIS' or 'Application…

Filed Under: Casos Tagged With: data-fabric

Footer

LegalPrivacy Cookies policy
  • LinkedIn

Patron

Sponsor

© 2020 Bluetab Solutions Group, SL. All rights reserved.

  • Solutions
    • DATA STRATEGY
    • DATA FABRIC
    • AUGMENTED ANALYTICS
  • Software
    • TRUEDAT
    • FASTCAPTURE
    • TAILORED ENTERPRISE SW
  • About Us
  • Our Offices
  • Talent
  • Blog
  • Español