Data, Information and Analytics

April 26, 2021January 19, 2025Analytics Industry, Azure, Data, Microsoft, SQL

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.

February 6, 2021January 22, 2025AI, Analytics Industry, Architecture, Azure, Build, Business Data Vault, Business Intelligence, Change, Data, Data Lake, Data Lakehouse, Data Vault, Flexibility, Raw Data Vault

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! […]

December 29, 2020January 22, 2025AI, Analytics Industry, Business Intelligence, Churn, Data, Data Quality, Data Science, IT, Membership, Renewal, Reporting, Visualisation

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

December 7, 2020February 16, 2025Business Relationships, Change, Engagement, IT, Project Management

Lack of Engagement

Oh, the discomfort of having a genuine need (i.e. not one that you have raised), access to budget, but a lack of […]

November 14, 2020January 22, 2025Analytics Industry, Architecture, Build, Business Data Vault, Change, CICD, Data, Data Lake, Data Lakehouse, Data Quality, ELT, ETL, Framework, Informatica PowerCenter, IT, MATILLION, Maturity, SQL

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 […]

November 10, 2020January 22, 2025AI, Analytics Industry, Architecture, Build, Reconciliation, Reporting

Data Reconciliation

Reconciliation is a component of integrated data solutions that will lead to the blame game if it is not attended to

November 1, 2020January 22, 2025AI, Analytics Industry, Business Intelligence, IT

Is Business Intelligence Still a ‘thing’? It seems so …

As an industry, like many others, we are very proficient at reinventing our selves. After all we are now in the middle […]

October 30, 2020January 19, 2025Data, Microsoft, Oracle, Power BI, SQL

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 […]

October 19, 2020January 19, 2025Architecture, Build, Business Relationships, Data, Data Lake, Data Lakehouse, Data Quality, Data Vault, IT

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. […]

September 10, 2020January 19, 2025Build, Data, IT, SQL

SQL Dependency

I was faced with the challenge of visualising object dependency in a SQL Server based project and came across this handy approach