So I have loaded the scripts from every episode of Friends into a Snowflake database and I aim to analyse the words used and create a dashboard that anyone can have a play with by creating a roll up table with various statistics. For now that is a work in progress, so instead I am also going to use it in an episode by episode Friends trivia video series.
A lot of the data that I am working with doesn't lend itself to creating complex star schemas (more on data modelling in a later post) however I want to try and at least want to go to some effort. The one thing that pretty much all my tables have in common is date, so I want to build a date dimension. My strength training happens on a day, my running and walking, parkrun and hopefully the weather data I intend to integrate will have a date on it. This means if I have a date dimension and I aggregate my various facts at date level I can use them together in a single visualisation. There are various methods I could have used to create the date dimension and I went with using the dbt spine, this was really simple using the utilities: Used the date functions in Snowflake to extract relevant fields such as year, month, day in words and year month etc.
Comments
Post a Comment