Blog - BI Design SQL Server BI Southcoast, Hampshire

Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but you have no idea...

There are some telltale signs that your growing business has outgrown Excel for your reporting needs. Excel is...

Are you currently using Microsoft Fabric or considering migrating to it? If so, there are a couple of...

You could be tolerating limited reporting because there isn’t an off the shelf solution that meets your needs...

Do you spend so long manipulating your data into something vaguely useful that you don’t have the time...

There are some fundamental boxes that your reporting system must tick. ✅ The figures must be accurate A...

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...

1 2