In my career I have used and built many ‘frameworks’. Typically they are focused on Data Warehouses delivery involving the Extraction, Transformation and Loading (ETL)…
Reconciliation is a component of integrated data solutions that will lead to the blame game if it is not attended to
As an industry, like many others, we are very proficient at reinventing our selves. After all we are now in the middle of the modern…
Ok, a quick post on connecting Power BI to Oracle. I wanted to do some simple testing by looking at row counts across a Oracle…
If you are involved in a data project, or the delivery of data as a service, this post is pitched at you. The recommendations are…
This post is a crash course on Azure DevOps and the GIT concepts and commands that are used to interact with it. Azure DevOps Server…
The following post is intended for users that are new to Azure Data Factory (ADF) and wish to get a crash course.
I was faced with the challenge of visualising object dependency in a SQL Server based project and came across this handy approach
This post is intended for those who are about to dip their toe into the world of Data Vaults. It is not intended to dissuade or persuade you in the choice of using a Data Vault (DV), there are many of those posts already and typically the stray into fundamentalism …
With the advent of some new terms like Delta Lake and Lake House I thought I would put together a brief summary for my customers are who are pondering what these model/storage approaches are.
