Stars, tables, and activities: How do we model the real world?

1

Looker

Even if you want to make Wide Tables, combining fact and dimensions is often the easiest way to create them, so why not make them available? Looker, for example, is well suited to dimensional models because it takes care of the joins that can make Kimball warehouses hard to navigate for business users.

#Data Dashboard #Business Intelligence #Data Visualization 14 social mentions

2

dbt

Tools that work well with Kimball models will suggest that you use Kimball models, while ones that do well with Wide Tables or Activity Schemas will push for those. As Aram Panasenco on dbt slack said:.

#Web Service Automation #Automation #Data Integration 2 social mentions