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

3 Working with Data in Explores

An Explore in Looker is a user-friendly interface that allows us to build queries against a data model without needing to write direct SQL code. Explore is the environment where users can build their visualizations based on one or multiple columns from one or multiple views (tables), applying custom filters, custom calculations, pivots, and so on if necessary. Explores are created in the model files in LookML and based on one or multiple views. Therefore, to create an Explore, you first need to define a view (or multiple views) using the view parameter. When created in a model file, an Explore can have additional configuration parameters, such as Description, Label, and Filters: