Blog - BI Design SQL Server BI Southcoast, Hampshire

The issue When migrating the solution I’m currently working on to Azure eight months ago I was initially...

My next tip is to test your BI solution with the volume of data that you are expecting. ...

In this article I’ll discuss making your data warehouse better. I’ll admit that this is a pretty obvious...

In this article I’m going to show you how I build my time dimensions. There are lots of...

In this article I’ll be discussing the benefits of using a consistent unknown member key across your data...

My fifth data warehousing tip is to always use surrogate keys for your dimension and fact tables. Surrogate...

My fourth data warehousing tip is to trust your instinct when it comes to building solutions, and if...

My third data warehousing tip is to build thin slice. Deliver subsets of valuable functionality. Get feedback and...

I’ve seen data warehouses that nobody trusts, or are just too complex for end users to report on. ...

My first data warehousing tip is to store fact data at the leaf level. If you aggregate your...

The final (and much delayed) part of this series focuses on the choice between replicating stored procedure calls...

The impact of having data sitting in the distribution database that doesn’t need to be there can be...

1 2