An activity schema models all data in the warehouse as a single time series table.
You don’t have to search through many tables or spend hours figuring out why numbers don’t match. All your company data is in one data model making it easy to find and always accurate.
No web of dependencies. All reporting and analyses tables depend on a single table in your warehouse.
Changes to BI tables (adding new columns, updating logic, etc.) can be done in a few clicks without adding any complexity to the definition.
Bridging data across systems doesn’t require custom engineering. You can bridge data from disparate systems easily and without defining foreign keys.
Any data table can be constructed using a combination of activities and relationships between those activities.
Dylan Levan - Senior Marketing Analyst