Business Intelligence with Looker Cookbook : Create BI Solutions and Data Applications to Explore and Share Insights in Real Time / Khrystyna Grynko.

Format:

Book

Author/Creator:

Grynko, Khrystyna, author.

Language:

English

Subjects (All):

Business intelligence.

Business--Data processing.

Business.

Physical Description:

1 online resource (0 pages)

Edition:

First edition.

Place of Publication:

Birmingham, UK : Packt Publishing Ltd., [2024]

Biography/History:

Grynko Khrystyna: Khrystyna is a data analyst and Looker expert with over a decade of experience in the field. With a passion for empowering businesses through data-driven decisions, Khrystyna transitioned from her early career in digital marketing to specialize in data analysis. Graduating from Lumiere University Lyon 2 with a Master's degree in Business Intelligence, she honed her skills by working with various companies, leveraging data to tackle real-world challenges and drive strategic growth. Recognized as a thought leader in the industry, Khrystyna is a sought-after speaker at industry events and has authored numerous articles on data analytics and Looker. Beyond her professional endeavours, she dedicates her time to mentoring and coaching aspiring data professionals, sharing her expertise and insights to foster growth and innovation in the field.

Summary:

Use Looker for visualizing data, data analysis, and reporting, and learn how to connect to your data, build dashboards and reports, and share insights with your team Key Features Explore data visualization, analysis, and reporting with Looker to gain insights from your data Connect to data sources, build dashboards, and create reports to track and share key metrics Share insights with your team to make better business decisions Purchase of the print or Kindle book includes a free PDF eBook Book Description Looker is a data analytics and business intelligence platform that allows organizations to explore, analyze, and visualize their data. It provides tools for data modeling, exploration, and visualization, enabling you to gain insights from your data to make informed business decisions. You'll start with the basics, from setting up your Looker environments to configuring views and models using LookML. As you progress, you'll delve into more advanced topics, such as navigating data in Explore, tailoring dashboards to your needs, and adding dynamic elements for interactivity. Along the way, you'll gain invaluable troubleshooting skills to tackle common issues and optimize your Looker usage, ensuring a smooth and seamless experience. Furthermore, the book extends your understanding beyond the basics, equipping you with the knowledge you need to develop Looker applications and seamlessly integrate them with other tools and applications. You'll also explore advanced techniques for harnessing Looker's full potential, empowering you to establish data-driven decision-making and innovation within your organization. By the end of this BI book, you'll have gained a solid understanding of how to use Looker to find important information, make tasks easier, and derive important insights. What you will learn Understand Looker's key components, including LookML, data models, and dashboards. Explore Looker's functionality, including custom fields, calculations, and visualizations. Work with Looker dashboards using dynamic elements like links and actions. Use different types of filters for dimensions to create dashboards Develop Looker applications using essential tools and frameworks Explore additional applications for the Looker organization Integrate Looker with other tools using APIs, connectors, and data pipelines Who this book is for If you're a business analyst, data analyst, or BI developer who wants to get well-versed with the features of Looker, this book is for you. Basic knowledge of business intelligence is required to get started.

Contents:

Cover

Title Page

Copyright and Credits

Contributors

Table of Contents

Preface

Chapter 1: Getting Started with Looker

Technical requirements

Getting access to Looker

How to do it...

There's more...

Providing access to your team

See also

Connecting to data in Looker

How it works...

Building a LookML project

Getting ready

Connecting Looker to Git

Making and saving changes in views

Creating a LookML model and Explore

Building visualizations (Looks) from Explores

Creating a dashboard from a Look

Chapter 2: Configuring Views and Models in a LookML Project

Creating dimensions in views

Creating measures in views

Describing data in LookML views

Working with filters in LookML views

Joining tables in models

Adding advanced model parameters

How to do it…

Working with LookML files

Working with geodata in LookML

Reusing the LookML code

Chapter 3: Working with Data in Explores

Technical requirements.

Exploring parameters in the model

Advanced filtering in Explores

Custom fields

Pivoting and table manipulations in Explores

Editing visualizations

Merging data from multiple Explores

Sharing Explores

Chapter 4: Customizing and Serving Dashboards

Adding visualizations to dashboards

Adding text and markdown to dashboards

Working with buttons in dashboards

Filtering and cross-filtering in dashboards

Working with settings in dashboards

How it works…

Serving dashboards

Chapter 5: Making Dashboards Interactive through Dynamic Elements

Working with links

Working with HTML parameters

Working with Liquid parameters in labels

Working with dynamic SQL

Working with actions

Chapter 6: Troubleshooting Looker

Troubleshooting LookML errors

Exploring the Content Validator

See also.

Troubleshooting SQL through SQL Runner

Data tests

Other ways to solve common Looker problems

Chapter 7: Integrating Looker with Other Applications

Accessing Looker from Google Sheets

Accessing Looker from Looker Studio

Exploring other third-party integrations

Chapter 8: Organizing the Looker Environment

Exploring the Looker home page, favorites, and boards

Organizing Looker folders

Facilitate Looker exploration with Looker Marketplace applications

Organizing the LookML environment

Chapter 9: Administering and Monitoring Looker

Configuring principal settings

Managing users in a granular way

Analyzing system activity

Exploring advanced settings

Chapter 10: Preparing to Develop Looker Applications

Understanding Looker APIs

Embedding Looker

Getting ready.

How to do it...

Exploring the Looker extension framework

Exploring components

Exploring the Looker Marketplace

Index

Other Books You May Enjoy.

Notes:

Description based upon print version of record.

Getting ready

Description based on publisher supplied metadata and other sources.

Description based on print version record.

ISBN:

9781800563285

1800563280

OCLC:

1432588319