bi-lookertraining.online

Looker Training
Menu

Author: Looker Training

Dimensions and fact tables

Dimensions and fact tables

Dimensions and fact tables Dimensions: Dimension table contains the descriptive attribute of the data. For Example Product Details will be there in the Product table. A dimension table contains dimensions of a fact. They are joined to a fact table via a foreign key. Ex: Product …
Full Article
No Comments

Drill down functionality in Looker

Drill down functionality is an essential feature of interactive self-service analytics. It allows end-users to gain a more in-depth insight into their data. The drill_fields parameter controls what happens when a user clicks on the value of a table cell while exploring data. When a user does this, they “drill” into the data, …
Full Article
No Comments
Creating Custom Dimensions

Creating Custom Dimensions

Custom dimensions are created using dimension parameter. The dimension name should be unique in the view. We can create custom dimensions from existing dimensions. For example if we need to create Full Name using First Name & Last Name, we should create a custom dimension as …
Full Article
No Comments

Looker Views

Looker Views represents tables in database. We can create a view with more than one table using derived tables. How to Create/Add view in Project: Navigate to Project from develop tab Click on + symbol to select view from connected database and select option Create View …
Full Article
No Comments

Datagroups in Looker

Datagroup parameter in looker used to define  different caching policies for different Explores. Datagroups in Looker is very useful when we want to defind different cache time for different explores. Details of the caching policy can be defined using one or both of these datagroup parameters: sql_trigger: …
Full Article
No Comments

bi-lookertraining.online

Looker Training
Copyright © 2023 bi-lookertraining.online
Theme by MyThemeShop.com

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh