Tableau Web Data Connector for FactSet: Building Smarter Financial Dashboards

Introduction In today’s fast-moving financial landscape, data-driven decision-making is no longer optional—it is essential. Financial analysts rely on massive amounts of structured and unstructured data to make sense of market trends, evaluate stock performance, and prepare investment strategies. Tableau, a leading data visualization tool, plays a crucial role in this process by enabling professionals to…

Read More

Migrating from a Monolith to EDA on AWS

Migrating from a monolithic solution to an event-driven architecture (EDA) can be a daunting task, but it’s a journey that many organisations are now embarking on to enable greater agility, scalability, and innovation. In this post, I’ll share practical insights and techniques based on a real customer migration I worked on. These lessons are broadly…

Read More

Beyond Functional: Writing Professional and Performant SQL Queries

Structured Query Language (SQL) is one of the most widely used languages for interacting with databases, yet even experienced developers often make subtle mistakes that affect performance, readability, and security. Writing high-quality SQL queries is critical for scalability, maintainability, and efficiency. 1. The Siren Call of SELECT * Instead of Explicit Columns Problem: SELECT *…

Read More

Building Responsive Web Applications: A Modern Developer’s Guide

Content: Building responsive web applications has become essential in today’s multi-device world. With users accessing websites from smartphones, tablets, laptops, and desktops, developers must create experiences that work seamlessly across all screen sizes. Understanding Responsive Design Principles Responsive design isn’t just about making things smaller or larger. It’s about creating flexible layouts that adapt intelligently…

Read More

The Double-Edged Algorithm

In the heart of London’s financial district, algorithms are working around the clock to protect millions of pounds from fraudsters. Just a few miles away, in anonymous flats and co-working spaces, other algorithms—powered by the same artificial intelligence—are being weaponised to steal those very same funds. This isn’t science fiction; it’s the paradox defining our…

Read More

ETL: The Unsung Hero of Data-Driven Decisions

How the humble process of Extract, Transform, and Load turns raw data into a gold mine of insights. In a world obsessed with AI and real-time analytics, it’s easy to overlook the foundational process that makes it all possible. Before a machine learning model can make a prediction, before a dashboard can illuminate a trend,…

Read More