Background
Under the European Regulatory Reporting rules, financial institutions must send the European Central Bank (ECB) a set of financial and supervisory data every month in a structured format, with strict requirements on quality, completeness and timeliness.
Solution
To support this process, we built a Business Intelligence system that:
- Extracts data from fixed-width files through an ETL flow (SSIS + T-SQL)
- Centralizes it in a Data Warehouse on SQL Server
- Processes it in a tabular model (SSAS), accessible via Power BI
What users do
- Check the quality and structure of the data
- Validate compliance with ECB rules
- Generate the final file for the ECB in a traceable, controlled way



