Proactive Data Monitoring – How to avoid incidents
Introduction As data platforms become more complex, effective data monitoring becomes paramount. This is where proactive data monitoring comes into play. Unlike […]
Category: Data
GIT
A collection of basic GIT commands that can be helpful: Switching to the local branch: git checkout <name> Rename the local branch: […]
Moving from What Has Happened to What Will Happen
The Analytics Industry often promises that we can predict What Will Happen, or discover Hidden Correlations between seemingly unrelated variables in datasets. […]
Query Store
This blog is an easy-to-read summary of the Query Store functionality available in Azure SQL and other versions of SQL Server.
Data Flexibility
Data Flexibility is surely the goal. I can’t believe that it has taken me so long to write a post on this! […]
Membership, how to engage, grow and retain
Business that operate on a Membership Business model have different objects compared to say a Distributor or Retailer Model. This post is about how analytics supports this type of business
So you need a framework?
In my career I have used and built many ‘frameworks’. Typically they are focused on Data Warehouses delivery involving the Extraction, Transformation […]
Connecting Power BI to Oracle
Ok, a quick post on connecting Power BI to Oracle. I wanted to do some simple testing by looking at row counts […]
Effectively Delivering Data
If you are involved in a data project, or the delivery of data as a service, this post is pitched at you. […]
SQL Dependency
I was faced with the challenge of visualising object dependency in a SQL Server based project and came across this handy approach
