TIQETS.ENGINEERING
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:
- active customers from orders
- ad costs allocation from orders and Google Ads reports
- conversion funnels from pageviews and a multitude of goals
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.
