Looker Products

[Dillan13]

Hi All

We are trying to create solutions for clients using Looker Studio. We wanted to see how we can use Looker to assist with advanced metrics and data prep. We can’t seem to find much content on the Looker Product itself (not Looker Studio). Even on the partner portal, it seems to talk about looker studio. Is there a good resource for looking at how we can build advanced dashboards (we don’t want to have to use 3rdparty tools)? The same question applies to Looker Studio Pro.

[a_shah]

Hi @Dillan13 

Advanced Metric: LookML is a scripting language that enables modularization of logic, which means that a logic can be broken down into smaller pieces and re-used in a hierarchical way. Liquid Parameters in LookML add flexibilities in SQL generation like no other tool in the market. Extend and Refinement concepts helps in segregating the responsibilities in an organization between a central data team and specific departments.

Data Prep: Once there is a explore create by joining views, Looker Explore UI can be used by a power user, to create broad datasets that can enable specific analysis and then you can select "Get LookML" from "Explore Action" menu (cog wheel). This LookML can be added to the project model and given a relevant name. subsequently any user can directly utilize this derived table to get a head start in the analysis.

These derived tables can be made Persistent Derived tables to store data to optimize the data scan bytes, which otherwise would have happened if the users would use the bigger raw dataset.

Looker Studio has lot of functionalities for visualization, and can also use the explores created in Looker. Usually Companies use Looker to create a business definition layer in terms of explores and then leverage these explores in Looker Studio, Tableau, Power BI and ThoughtSpot for specific visualization and NLP related use cases.

Hope this helps

~Ashish