Cerensa® Business Intelligence

Architecture in a glimpse: To render PowerBI reports, we had to set up a structure that feeds a data warehouse as soon as the user inputs information. That is fetched by our third-party ETL that provides an external data warehouse and data marts, planned as a snowflake schema. By normalizing our client's information in this schema, we can observe their data from dimensions that would not be possible in other ways.

Cerensa's clients' information provides insights that can directly impact their strategic decisions. For that purpose, the company created a robust business intelligence solution that integrates its platform with Microsoft Power BI. That allows easy analysis of a massive amount of data, using custom tables, charts, and filters.

My role in this solution was to document operational database schemas and business rules and provide them to our third-party ETL — Extract, Transform, Load —, ConnWare¹. And then build Power BI reports that consume that data and embed them into Cerensa's platform.

¹. ConnWare is a Netherlands-based software company focused on integrations. We worked closely with them, represented by one of its associates, Victorino Villa.