book

Business Intelligence with Looker Cookbook

by Khrystyna Grynko

May 2024

Beginner

256 pages

5h 20m

English

Packt Publishing

Read now

Unlock full access

ContributorsAbout the authorAbout the reviewers
Who this book is forWhat this book coversTo get the most out of this bookDownload the example code filesConventions usedGet in touchShare Your ThoughtsDownload a free PDF copy of this book
Technical requirementsGetting access to LookerHow to do it...There’s more...Providing access to your teamHow to do it...See alsoConnecting to data in LookerHow to do it...How it works...See alsoBuilding a LookML projectGetting readyHow to do it...How it works...See alsoConnecting Looker to GitGetting readyHow to do it...How it works...There’s more...Making and saving changes in viewsGetting readyHow to do it...How it works...Creating a LookML model and ExploreGetting readyHow to do it...How it works...See alsoBuilding visualizations (Looks) from ExploresGetting readyHow to do it...How it works...Creating a dashboard from a LookHow to do it...How it works...See also
Technical requirementsCreating dimensions in viewsGetting readyHow to do it...How it works...There’s more...Creating measures in viewsGetting readyHow to do it...How it works...There’s more...See alsoDescribing data in LookML viewsGetting readyHow to do it...Working with filters in LookML viewsGetting readyHow to do it...Joining tables in modelsGetting readyHow to do it...See alsoAdding advanced model parametersHow to do it…There’s more...See alsoWorking with LookML filesGetting readyHow to do it...See alsoWorking with geodata in LookMLGetting readyHow to do it...Reusing the LookML codeGetting readyHow to do it...
Technical requirementsExploring parameters in the modelGetting readyHow to do it...See alsoAdvanced filtering in ExploresHow to do it...See alsoCustom fieldsHow to do it...See alsoPivoting and table manipulations in ExploresHow to do it...See alsoEditing visualizationsGetting readyHow to do it...There’s more...See alsoMerging data from multiple ExploresGetting readyHow to do it...How it works...See alsoSharing ExploresHow to do it...There’s more...See also
Technical requirementsAdding visualizations to dashboardsGetting readyHow to do it...There’s more...See alsoAdding text and markdown to dashboardsGetting readyHow to do it...See alsoWorking with buttons in dashboardsGetting readyHow to do it...Filtering and cross-filtering in dashboardsGetting readyHow to do it...See alsoWorking with settings in dashboardsHow to do it...How it works…See alsoServing dashboardsGetting readyHow to do it...See also
Technical requirementsWorking with linksGetting readyHow to do it...See alsoWorking with HTML parametersGetting readyHow to do it...See alsoWorking with Liquid parameters in labelsHow to do it...See alsoWorking with dynamic SQLHow to do it...There’s more...Working with actionsHow to do it...How it works...There’s more...See also
Technical requirementsTroubleshooting LookML errorsGetting readyHow to do it...See alsoExploring the Content ValidatorGetting readyHow to do it...How it works...See alsoTroubleshooting SQL through SQL RunnerGetting readyHow to do it...There’s more...See alsoData testsGetting readyHow to do it...There’s more...See alsoOther ways to solve common Looker problemsHow to do it...See also
Accessing Looker from Google SheetsGetting readyHow to do it...How it works...There’s more...See alsoAccessing Looker from Looker StudioGetting readyHow to do it...How it works...There’s more...See alsoExploring other third-party integrationsGetting readyHow to do it...How it works...There’s more...See also
Technical requirementsExploring the Looker home page, favorites, and boardsGetting readyHow to do it...How it works...See alsoOrganizing Looker foldersGetting readyHow to do it...There’s more...See alsoFacilitate Looker exploration with Looker Marketplace applicationsGetting readyHow to do it...There’s more...See alsoOrganizing the LookML environmentGetting readyHow to do it...See also

Technical requirementsConfiguring principal settingsGetting readyHow to do it...There’s more...See alsoManaging users in a granular wayGetting readyHow to do it...How it works...There’s more...See alsoAnalyzing system activityGetting readyHow to do it...How it works...See alsoExploring advanced settingsSee also
Understanding Looker APIsGetting readyHow to do it...How it works...There’s more...See alsoEmbedding LookerGetting readyHow to do it...How it works...There’s more...See alsoExploring the Looker extension frameworkGetting readyHow to do it...There’s more...See alsoExploring componentsGetting readyHow to do it...See alsoExploring the Looker MarketplaceGetting readyHow to do it...There’s more...See also
Other Books You May EnjoyPackt is searching for authors like youShare Your ThoughtsDownload a free PDF copy of this book

Content preview from Business Intelligence with Looker Cookbook

2 Configuring Views and Models in a LookML Project

As discussed in the previous chapter, the key components of a LookML project are model files and view files. Views contain dimensions and measures that represent the columns in the tables. One view equals one table (or a virtual table known as a database or data warehouse view). In the views, you can define the fields (dimensions and measures) that are available to users from each table, specify the labels and descriptions for each field, set default values for filters and other parameters, define custom calculations for measures, filter, and sort the data.

LookML model files are the foundation of any Looker application. They define the data that users can access and explore. By carefully designing ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

Publisher Resources

ISBN: 9781800560956Supplemental Content

Business Intelligence with Looker Cookbook

by Khrystyna Grynko

2

Configuring Views and Models in a LookML Project

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

You might also like

AI-Powered Business Intelligence

Data Science for Business

Analytical Skills for AI and Data Science

Modern Business Analytics

Publisher Resources

2

Configuring Views and Models in a LookML Project

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,and much more.

You might also like

AI-Powered Business Intelligence

Data Science for Business

Analytical Skills for AI and Data Science

Modern Business Analytics

Publisher Resources

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.