Author: Erik Edin
-
Multi-currency accounting for transaction reconciliation
If you are doing transaction reconciliation for a Fintrech, are dealing with a somewhat unique challenge. The process of a reliable reconciliation process typically involves the following steps:
-
The most popular BI tools for Fintechs in 2024
A recent survey of product leaders in the Fintech Guild shows that Metabase is the most popular BI tool for Fintechs in 2024, followed by Looker, Tableau, Sigma, Omni and Mode Analytics. Metabase: Open-source and Budget-friendly With an open source code base, Metabase has been able to reach feature-parity with more established players like Looker…
-
Using AI to automate foreign key discovery
When setting up a data warehouse, understanding the relationships between various objects—both within a system and across systems—is essential. Foreign keys are the connective tissue, linking tables and datasets. When dealing with undocumented legacy systems, discovering these relationships manually can be tedious and time-consuming. Automated foreign key discovery, aided by AI, helps you get up…
-
Skills required to master data analytics in Fintech
Domains Methods of analysis Organisational skills Data modelling Statistics Data governance Tools Communication
-
Version control for BigQuery
Version control is an essential tool for data teams when creating tables and data sets for consumption by other people and teams. While a single data analyst might make to without one, as soon as you have a data team, version control is a key tool to enable collaboration and active participation of all team…
-
Dashboarding best practices
The dashboard is where most end users will consume the data. Assuming you already have accurate, timely and comprehensive data, the job of designing a dashboard comes down to selecting the right metrics and presenting them in a clear manner. Before you start, ask yourself the following: A modern data organisation typically aims to make…
-
The Affordable Data Infrastructure Stack
The goal of your data infrastructure is to enable data-driven decision making and give everyone access to accurate, comprehensive and timely data, while keeping things compliant. This particular stack is optimised for reporting and analytics, while keeping costs low. The basic layer cake of the data infrastructure stack looks like this: Data sources Data sources…
-
Four checks to know if your payments engine is a liability
Are you working for a fintech with an in-house payments system? You might be in trouble. Most successful fintechs arrive at a point where someone is asking why the numbers don’t add up, and no one is quite sure why. The basic payment flows are usually not the problem. However, bounce backs, manual corrections, system…
-
The basics of payment reconciliation for Fintechs
Reconciliation is the process of verifying that the numbers are correct. In accounting, this has typically meant matching expenses against the bank statement. If a line on the bank statement can’t be matched against an accounting entry, you have a break in your reconciliation. The accountant would then ask whoever is in charge of the…