At Tiqets, we maintain a number of derived views in our data warehouse. Instead of always going back to the raw data to answer a question, we model the data so it represents more “high-level” abstractions that are useful to the business. For example, we derive:
These views have been very useful in preventing repetitive work, but also in improving our understanding of the business. However, they were also a pain to manage.