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

1 Getting Started with Looker

“Just as Google’s mission is to organize the world’s information and make it universally accessible and useful, Looker’s is to do the same for your business data so that you can build insight-powered workflows and applications.”

This is how the Welcome to Looker page greets you. Looker is one of the products of the Google Cloud BI family. The Google Cloud BI family also includes Looker Studio (Free and Pro versions), which was created by Google in 2016 and used to be called Google Data Studio. This book focuses on Looker, and Looker Studio won't be covered.

Looker is an advanced business intelligence (BI) solution acquired by Google in 2019. It is part of Google Cloud Platform. In order to start using it, you need ...