Google Looker Dynamic Dashboards

Question

We have a requirement to build dynamic dashboards using Looker studio. We are gathering data from different projects into a warehouse (ELT involved) and then making it available to Looker studio for building dashboards.

These projects have varying fields (some fields are common and some are different). We don't want to build separate dashboard for each project. Instead, we would like to build a dynamic dashboard that can be used for all the projects with right level of drill down.

What's the best way to achieve that in Looker if we don't want to change our ELT process?

Answer 1

If i am understanding your question correctly you would like to link multiple data tables in Looker studio without changing the ELT process.

Looker Studio is a visualization tool and is not ideal for processing large amounts of data the things like power BI can, But so long as you have a common identifier between the tables you should be OK.

You can Blend tables from different data sources together providing they have at least one thing in column in common How to Blend. The problem with this approach is you can not add fields to a blended data table, use have to add a field to the visual.

or

As long as these columns have identical names the "controls" should filter both tables at the same time. This means can provide to illusion of a single data source when really it is from many. For some reason this does not work 100% of the time so I also create metrics in one table and change their field ID to match the field ID in the table I am trying to link to .

Hopefully this has been of some help.