Googlers is a company that creates products intended to create opportunities for an extensive audience, regardless of their location across the globe. The company values diverse perspectives, imaginations and non-conformity to predefined norms and impossibilities. The goal is to build products while incorporating uniqueness of each individual involved in this process, aiming to make their products accessible and useful to all.
Do You Manage Peer Insights at Google?
Access Vendor Portal to update and manage your profile.
What I like most about Looker is hands down LookML and its native Git integration. As an engineer, I absolutely hate clicking around a clunky UI to build data models. Looker actually lets me treat data modeling like real software development. I can write modular code, keep my logic DRY, and use version control to track changes. When someone wants a new metric, I just open a pull request, get it reviewed, and merge it. It brings actual engineering best practices to business intelligence. Plus, giving stakeholders a sandbox to explore without breaking production data is simply a massive lifesaver.
Using LookML to define metadata for fields and tables is amazing, as we are able to generate it via a script developed on our side using the same DBML notation that our ELT tool uses, ensuring that both sides of our analytics infrastructure are always aligned and in-sync. Also, embedding predefined filters in a shareable URL is also a very efficient way to ensure that a stakeholder will see the same output as the person who developed the report is a huge plus.
The top features of this product are: - Grouping and Bucketing capabilities are great to get aggregated insights for a group rather than an atomized view scattered across many different categories - Chart options provided are amazing, with most of the basic charts and more being covered in the tool - Simplicity to add and remove metrics is also great. I also find the ability to create custom metrics a MUST for my quarterly and bi-annual planning operations.
What I dislike most is definitely debugging the auto-generated SQL. When a complex explore breaks or a dashboard is running painfully slow, deciphering the massive, nested queries Looker spits out under the hood is an absolute nightmare. Also, managing Persistent Derived Tables can be a huge headache. When a build fails, it silently cascades into broken dashboards for the end users. Plus, because LookML is proprietary, you are completely locked into their specific vendor ecosystem.
The selection of available visualizations seems not just limited but also antiquated, with a small number of options and some very important charts missing, since the ones available at the marketplace are not very robust and consistent in their end results. Basic visualization options with greater customizability (such as gauges and boxplots) are sorely missing in Looker, making some of the end dashboards look amateur by comparison.
Some of the things I think could be improved are: - MERGE! Merging tables is really painful and getting charts based on merged tables is even harder. We need a way to create merged tables that are then used as an Explore themselves (without having all fields in the merged table there and with the possibility to aggregate on the merged table results) - On merging, I also had issues sometimes with the merging fields, getting an error or not being able to use the right field to merge two explores / tables - Date fields aren't great. It may be on us, but there are so many date fields out there that sometimes it's not easy to determine which one to use (even more so for new joiners)