It’s T-SQL Tuesday time again, and this month’s honor to host the blog party goes to Brent Ozar. The topic is data types: Mad about money? Feverish about float? Tell us what you use your favorite data type for, and what people need to know before they get started using it. Data types have so many interesting […]
Tag: data modelling
STAR SCHEMA ALL THE THINGS
The title says it all, but I’ll explain it anyway. When building a data model that will be used for analysis by human beings, always create a star schemas. Or multiple star schemas connected with conformed dimensions. Why? Because it’s the most intuitive and user-friendly interface. Because remember, your data model is the user interface […]
Speaking at SQLSaturday Vienna 2021
I’m thrilled to announce I’ve been selected to speak at SQLSaturday Vienna. Actually, it’s on Friday 15th of January, so don’t get fooled by the name. I’m bringing the session Self-service BI – Why Data Modelling Is Still Important, which is a beginner level talk about why you should pay attention to the data model […]
Data Modeling for Self-Service BI @ Techorama 2018
I’m delighted to announce I’ll be giving a session about data modeling in a self-service BI environment at Techorama 2018 (the Internet is divided on the correct spelling: modelling or modeling. Apparently it depends on which side of the pond you’re on). Techorama is one of the biggest Microsoft-oriented tech events in Europe (it takes […]