10 best practises to improve your Looker instance

Aurélien Roblin
7 min readMay 23, 2022

Hello everyone ! 👋

For 12 months I have been working exclusively on Looker. It’s a great BI tool, I love it !

It gives the ability to develop dashboards quickly and implement KPIs without waiting for the data engineering team.

It is very good !

But you have to be careful, your looker instance can quickly get messy.

In this article, I will share with you 10 of the best practices that we are implementing in my team.

They are based on my own experience, I hope they can be useful to you ! 🧙‍♂️

1. Separate explores in a specific file

Why : Your model file can quickly become huge. The ideal for your developers is to try to have small files responding to a use case. It’s also a good way to add governance to your code. Try to leave only the caching policy, the formats in your model file and of course all your includes for your different explores.

How : Create generic file with explore extension

--

--

Aurélien Roblin

Analytics engineer - Indie Maker | NoCode, SideProject, Data science