Modelling Event and Snapshot for Use in Looker

[jasonhodson]

What's your key point?

This is a large post about how to use dbt to stand up a model to provide combined insights into events (the occurrence of something) and snapshots (how many of something are in a particular stage). It demonstrates extensive use of dbt Jinja and practical application in exposing the data in Looker.

Prior art:
Any other posts that exist on this topic (here or elsewhere).

Not that I know of

Link to notes / outline / draft:
Google docs preferred, please set sharing to anyone with the link can view.

https://docs.google.com/document/d/1_bmKR-UoKVg-B1aBavbDDjyOHG1JuU6YX6dKpCmvxTY/edit?usp=sharing

Estimated first draft date:
Leave blank if you already shared a draft above.

Any open questions / requests for help from the group?

This is a "soup to nuts" post, discussing requirements gathering and documentation, model creation, standing up in Looker, along with case studies. While the model could be adapted for use by other analytic tools, the use of LookML makes it very specific to Looker.