Finance Insights Portal

This project addressed the challenge of fragmented financial data at Caliza, a company operating digital dollar accounts and stablecoin transfers. Caliza's data resided in various systems, including transactional databases, partner data, and contractor agreements initially managed in Google Sheets. This lack of a unified data structure hindered the ability to calculate Profit and Loss (P&L) with the necessary granularity and the flexibility to filter by different criteria, impeding informed strategic decision-making.To overcome these challenges, Datakimia developed a robust data pipeline leveraging Fivetran for efficient ETL from Caliza's diverse databases into BigQuery. DBT was utilized for data transformation and modeling, integrating ledger data with contract information from providers (Effectiv, Jumio, Fortress) and integrators (Juno) to create a comprehensive data model for P&L calculation. The resulting insights were then presented through intuitive dashboards built with Apache Superset, providing a clear view of revenue and expenses with filtering capabilities and near real-time updates.