Projects

Discover how we tackle challenges, offer innovative solutions, and generate impact for our clients. Our case studies showcase how we turn visions into tangible realities by optimizing processes, implementing disruptive technologies, and delivering tangible results. Explore how our consultancy drives business success and find inspiration for your next project.

Integration and Data Analysis for Credit Risk Modelling

Challenges
The bank faced the challenge of developing predictive models to accurately estimate its credit risk and meet the regulator's demands. To do this, they needed data that reflected the characteristics of their portfolio. These data were dispersed and stored in large databases, preventing manual analysis.

Solution and Implementation

Prioritizing the variables with the highest predictive power, our approach involved the analysis and integration of data sourced from various corporate systems, as well as the meticulous evaluation of the data's suitability.

We developed various tools to integrate this heterogeneous data, perform data quality assessments and presented analytical solutions for the calculation and derivation of key variables in case of absence of data.

The results and tools were presented and delivered as a final solution to the bank's internal team for their ownership.

Impact

Our tools allowed the bank to:

establish data traceability to reliable sources
reduce integration time
create more accurate predictive models

Programming Language and Software Used

SQL, Python, PySpark, Microsoft Excel, Power BI, Databricks

Data Driving Architecture and Construction Company

Challenges

The company faced major administrative and financial challenges due to poor cash flow management and prediction practices. Additionally, they did not have clarity about the line of business and customer profile where they had the greatest competitive advantage to focus their commercial efforts.

Solution and Implementation

We analyzed the business and its processes and presented suggestions for good administrative practices along with templates for internal use that would allow exhaustive monitoring of projects and cash flows.

With the information from the templates created and the data available in the accounting platform, we developed a tool to integrate the data and process it graphically to visually analyze the distributions of income and expenses according to various categories, seasons of highest and lowest performance, customer profiles, profitability by project type.

Impact

The new business practices established, along with the templates created by FlowMetrix for monitoring, and the strategy-driven data analysis tools allowed the company to:

analyze cash flow dynamics to anticipate liquidity requirements
evaluate the performance of each line of business and project type for strategic decision making
free up time previously dedicated to administrative tasks

Programming Language and Software Used

Python, VBA, Microsoft Excel, Power BI