Abstract In recent years, language models and AI have reshaped how we interact with data. Yet, a significant portion of business knowledge still resides in relational databases (highly structured but not exactly user-friendly for those unfamiliar with SQL). So what if you could query that data using natural language, as if you were speaking to […]
Analytics
Intelligent Agents with n8n: AI-Powered Automation
Abstract We live in a time when automating processes is no longer a luxury, but a necessity for any team that wants to remain competitive. But automation has evolved. It is no longer just about executing repetitive tasks, but about creating solutions that understand context, learn over time, and make smarter decisions. In this blog, […]
Databricks Lakebase – Database Branching in Action
What is Databricks Lakebase? Databricks Lakebase is a Postgres OLTP engine, integrated into Databricks Data Intelligence Platform. A database instance is a compute type that provides fully managed storage and compute resources for a postgres database. Lakebase leverages an architecture that separates compute and storage, which allows independent scaling while supporting low latency (<10ms) and […]
Monitoring Object Creation/Deletion in Cloud Storage with GCP Pub-Sub
When using cloud-based event-driven systems, it’s essential to respond to changes at the storage level, such as when files are added, modified, or deleted. Google Cloud Platform (GCP) makes this easy by enabling Cloud Storage and Pub/Sub to talk to one another directly. This arrangement lets you send out structured real-time alerts whenever something happens […]
Using AI to Compare Retail Product Performance
AI this, AI that. It seems like everyone is trying to shoehorn AI into everything even if it doesn’t make sense. Many of the use cases I come across online are either not a fit for AI or could be easily done without it. However, below I explore a use case that is not only […]
Revisiting Semantic Layers: Lessons from Their Rise and Return
For most of my data-focused career, I’ve been dealing with semantic layers one way or another. Either because the tool I was using to present data required it explicitly, or because the solution itself needed data to have relationships defined to make sense and be better organized. With the recent focus and hype on AI-infused […]
An Introduction to PAPSS – Pan African Payment and Settlement System
In existence since just July of 2019, the Pan African Payment and Settlement System (PAPSS) has in many ways surpassed the payment and settlement process of the western banking world. PAPSS enables the efficient flow of money securely across African borders to minimize risk and thereby contributing to financial integration of the African continent. PAPSS […]
Master Data Management: The Key to Improved Analytics Reporting
In today’s data-driven business environment, organizations rely heavily on analytics to make strategic decisions. However, the effectiveness of analytics reporting depends on the quality, consistency, and reliability of data. This is where Master Data Management (MDM) plays a crucial role. By establishing a single, authoritative source of truth for critical data domains, MDM ensures that […]
Revolutionizing Clinical Trial Data Management with AI-Powered Collaboration
Clinical trial data management is critical to pharmaceutical research, yet it remains a significant challenge for many organizations. The industry faces several persistent hurdles: Data fragmentation: Research teams often struggle with siloed information across departments, hindering collaboration and comprehensive analysis. Outdated systems: Many organizations rely on legacy data management tools that fail to meet the […]
PWC-IDMC Migration Gaps
In the age of technological advancements happening almost every minute, upgrading a business is essential to survive competition, offering a customer experience beyond expectations while deploying fewer resources to derive value from any process or business. Platform upgrades, software upgrades, security upgrades, architectural enhancements, and so on are required to ensure stability, agility, and efficiency. […]
IDMC – CDI Best Practices
Every end product must meet and exceed customer expectations. For a successful delivery, it is not just about doing what matters, but also about how it is done by following and implementing the desired standards. This post outlines the best practices to consider with IDMC CDI ETL during the following phases. Development Operations Development Best […]
Data Cloud Workshop: From Readiness to Results
Data is Everywhere but Actionable Insights Remain a Challenge According to Salesforce, 94% of business leaders believe they aren’t getting enough value from their data. Marketers want to personalize at scale. Sellers crave visibility into buying signals and win themes. Service agents need contextual understanding. Business leaders demand connected reporting for smarter decisions. Yet disjointed […]