Looker is a business intelligence and data analytics platform that allows users to perform table calculations. Table calculations are mathematical operations performed on columns in a data table to calculate…
Bucketing can be very useful for creating custom grouping dimensions in Looker. There are 3 ways to create buckets in Looker: Using the tier dimension type Using the case parameter Using a SQL CASE WHEN statement in the SQL parameter…
These best practices reflect recommendations that were shared by a cross-functional team of seasoned Lookers. These insights come from years of experience working with Looker customers from implementation to long-term…
It’s a comm interview question on how to find the second highest salary, second highest salary, or nth highest salary in SQL. In this article, we will provide four ways…
When it comes to Business Intelligence (BI) and Business Analytics (BA), you may have come across software which uses a semantic layer in order to run business reports. A semantic layer…
1. How do I reference a derived table within the SQL of another derived table? You can use ${view_name.SQL_TABLE_NAME} in the SQL of a derived table to reference the PDT…
Case enables you to bucket results with case logic. While you can write raw SQL CASE statements instead, using case will create a drop-down menu for your users in the Looker UI. These are primary…
Churn is nothing but lost money or lost customers Customer churn — the number of people you have lost. Revenue churn — the amount of revenue you have lost. i.e.…
SaaS growth metrics are designed to analyse the "momentum" of the business and the ability to grow .SaaS metrics provide answers to important questions: How can we increase customer acquisition? …
What are JOINS? Joins help retrieving data from two or more database tables. The tables are mutually related using primary and foreign keys. Types of joins Cross JOIN, INNER JOIN ,Outer…