talk-data.com talk-data.com

Meetup talk 2025-09-23 at 18:45

Data Modelling for Super Stars! How to collaboratively design your star schema with end users

Description

Despite claims to the contrary, dimensional modelling and star schemas are alive and well the in the modern data world. But whilst developers might have great technical skills and understand how to build a star schema, they may lack the business domain knowledge to ensure that what they deliver is fit for use by analysts and self-service users. On the flip side, these end users often know what they want and need from a data platform, but struggle to explain this in a way that makes it easy for developers to implement.

How can we improve the requirements gathering process to make sure we avoid the tensions that can arise from this?

This session will cover a data modelling requirements approach that looks to bridge the gap between business and IT by using an end-to-end process for working with business users to collaboratively design a dimensional model, making sure you build super star schemas and turn your self into a data modelling superstar.

About Johnny: Johnny currently works as a data and analytics consultant. He’s been working with Business Intelligence software since 2007, specialising in full stack data platform development since 2016. He’s a self-confessed Business Intelligence geek and in his spare time runs the website, SubStack and YouTube channel Greyskull Analytics, where he likes to nerd out about all things data.