Category: Uncategorized
-
Creating a domain model diagram with AI
LLMs like ChatGPT can be a great assistant in automating foreign key discovery. Here, I walk through a Python implementation with GPT-4 that uses public datasets on BigQuery to demonstrate how it works in practice. Check out the code on Github: https://github.com/321k/FKScout. We’ll use the Overture Maps dataset, a provider of free and open map…
-
What CP24/20 means for reconciliation in the payments industry
The global payments industry has doubled in size since I organised my first event on the future of Banking in 2013, to $2.3 Trillion in annual revenue in 2023. With the growth, there has been a number of challenges, including some notable failures to safeguard customer funds. Wirecard being the most prominent one in Europe,…
-
Data team best practices in 2024
What’s considered best practices is constantly evolving, as new challenges emerge, and software change and automate the workflows of data teams. When Looker introduced a modelling layer with version control, it was a game changer for many data teams. When DBT introduced testable model generation inside data warehouses, it changed things againt. In 2024, data…
-
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: