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

Overview

Discover the power of Looker for Business Intelligence and data visualization in this comprehensive cookbook. This book serves as your guide to mastering Looker's tools and features, enabling you to transform data into actionable insights.

What this Book will help me do

Understand Looker's key components, including LookML and dashboards.
Explore advanced Looker capabilities, including data modeling and interactivity.
Create dynamic dashboards to monitor and present critical metrics effectively.
Integrate Looker with additional tools and systems to extend its capabilities.
Leverage Looker's tools for fostering data-driven decision-making within your team.

Author(s)

Khrystyna Grynko is a seasoned data professional with extensive experience in Business Intelligence and analytics. She brings practical insights into how to effectively utilize Looker for real-world applications. Khrystyna is known for her clear, instructional writing style that makes complex topics approachable.

Who is it for?

This book is an essential resource for business analysts, data analysts, or BI developers looking to expand their expertise in Looker. Suitable for readers with a basic understanding of business intelligence concepts. Ideal for professionals who aim to leverage Looker for creating insightful and interactive data applications to inform business strategy.