I want to create a Looker dashboard that shows monthly trends for a whole lot of metrics (20+). These are all coming from different datasources at different grains, but the dashboard itself would just show the metric name and a monthly trend.
As I see it there are a few different ways I can build this out and I’m wondering what the most efficient option is in terms of performance and cost:
- I can create a DWH table that aggregates all my metrics from their original sources and display all of them on a dashboard
- I can create individual looks/explores for each metric and then put them together on a single dashboard
- I can merge multiple explores and display all metrics on a single dashboard
Have I got anything wrong? Which option would be the best?
LinkedIn
Twitter
