I'll be using this website to improve my speed and skills as a data analyst. I can almost guarantee it won't be useful to you now, but it helps me to clarify my understanding by writing it down and perhaps one day it will be worth discussing and I'll open it up to comments. 😉
In part two of this series using Microsoft’s Wide World Importers sample database, we design a dimensional model for sales and build it using dbt and Snowflake
In part one of this series using Microsoft’s Wide World Importers sample database, we focus on loading the data into a Snowflake environment to enable future model creation and analysis. We also use dbt to establish the loaded tables as data sources, we document them, add testing and create a code base in GitHub to store transformation scripts and implement version control.