Windows functions are one of the most powerful T-SQL programming elements. These functions return a single aggregated value for each…
An awesome FP&A function will help drive business success. I’ve been a CFO, and I work with CFOs and Finance…
There are many scenarios where you need to update, delete or insert new records in a table. The T-SQL Merge…
Awesome Business Intelligence can underpin growth and inform business strategy. When discussing Business Intelligence many businesses focus on the tools…
The quantity of data is accelerating and the use of analytics is exploding. Can data analytics for SME businesses work?…
Microsoft promotes Power BI as the tool that lets users go from data to insights in minutes. This, of course,…
In a perfect world we would have perfect data. But the quality, consistency, existence and accessibility of data varies a…
Many people react differently to data depending on how it is presented. To demonstrate I’ve taken the referee scores and…