Data Storytelling with Google Looker Studio : A Hands-On Guide to Using Looker Studio for Building Compelling and Effective Dashboards / Sireesha Pulipati and Nicholas Kelly.

Format:

Book

Author/Creator:

Pulipati, Sireesha, author.

Kelly, Nicholas, author.

Language:

English

Subjects (All):

Web-based user interfaces.

Physical Description:

1 online resource (1 volume) : illustrations

Edition:

First edition.

Place of Publication:

Birmingham, England : Packt Publishing Ltd., [2022]

System Details:

Mode of access: World Wide Web.

Biography/History:

Pulipati Sireesha: Sireesha Pulipati is an experienced data analytics and data management professional. She has spent the last decade building and managing data platforms and solutions, and is passionate about enabling users to leverage data to solve business problems. Sireesha holds a master's degree in Business Administration and a bachelor's degree in Electrical Engineering. Her work history spans multiple industries healthcare, media, travel & hospitality, high-tech, and more. She is currently at Google as an analytics lead, helping with analytics strategy to support Search Knowledge Graph. Outside of work, Sireesha enjoys hiking and reading books. She currently resides in the Bay Area.

Summary:

Presenting data visually makes it easier for organizations and individuals to interpret and analyze information. Looker Studio is an easy-to-use, collaborative tool that enables you to transform your data into engaging visualizations. This allows you to build and share dashboards that help monitor key performance indicators, identify patterns, and generate insights to ultimately drive decisions and actions. Data Storytelling with Looker Studio begins by laying out the foundational design principles and guidelines that are essential to creating accurate, effective, and compelling data visualizations. Next, you'll delve into features and capabilities of Looker Studio - from basic to advanced - and explore their application with examples. The subsequent chapters walk you through building dashboards with a structured three-stage process called the 3D approach using real-world examples that'll help you understand the various design and implementation considerations. This approach involves determining the objectives and needs of the dashboard, designing its key components and layout, and developing each element of the dashboard. By the end of this book, you will have a solid understanding of the storytelling approach and be able to create data stories of your own using Looker Studio.

Contents:

Cover

Title Page

Copyright and Credits

Foreword

Contributors

Table of Contents

Preface

Part 1 - Data Storytelling Concepts

Chapter 1: Introduction to Data Storytelling

Understanding data storytelling

Structuring a data story

Presenting data stories

Data storytelling at work

Essential skills for data storytelling

Building data stories - an approach

Determine

Design

Develop

Walking through an example

Summary

Chapter 2: Principles of Data Visualization

Understanding foundational design principles

Simplicity of design

Organizing the layout

Accuracy of information presented

Reviewing Gestalt principles of visual perception

Proximity

Similarity

Continuity

Closure

Enclosure

Connectedness

Prägnanz

Figure and ground

Focal point

Using color wisely

Use fewer distinct colors

Choose an appropriate color palette and scheme

Use color consistently across the dashboard

Consider inclusive color schemes

Further reading

Chapter 3: Visualizing Data Effectively

Choosing the right visuals

Scorecards

Pie and donut charts

Bar charts

Line charts

Combo charts

Scatterplot

Tables

Heatmap (matrix)

Treemap

Geographical maps

Others

Avoiding common pitfalls

Overloading a dashboard

Designing a poor or incohesive layout

Not emphasizing key information and a message

Using color excessively or inappropriately

Using dual axes in charts without caution

Inappropriate manipulation of axes

Using inappropriate or complex chart types

Part 2 - Looker Studio Features and Capabilities

Chapter 4: Google Looker Studio Overview

Technical requirements

Getting started with Google Looker Studio

How it works

Working with data sources

Creating a data source.

Managing data freshness

Controlling data access

Editing a data source schema

Other common data source operations

Working with reports

Creating a report

Creating a report from a template

Publishing a report

Sharing a report

Other common report operations

Working with Explorer

Creating an Explorer

Exporting from Explorer

Using Explorer in an analyst workflow

Leveraging Looker Studio Gallery

Getting help with Looker Studio

Building your first Looker Studio report - creating the data source

Chapter 5: Looker Studio Report Designer

Report Designer overview

Adding charts to the canvas

Adding additional data sources

Adding and managing pages

Choosing a report theme and layout

Defining Report Settings

Working with data for charts

Adding dimensions

Adding metrics

Sorting data in the charts

Implementing filters

Understanding editor filters

Adding an editor filter

Interactive filter controls

Adding design components

Embedding external content

Styling report components

Background and Border

Text styles

Common chart style properties

Configuring style properties in report themes

Building your first Looker Studio report - creating a report from the data source

Chapter 6: Looker Studio Built-In Charts

Charts in Looker Studio - an overview

Configuring tables and pivot tables

Table with numbers

Table with bars

Table with drill down

Pivot tables

Configuring bar charts

Columnar bar chart

Horizontal bar chart

Clustered bar chart

Stacked bar chart

Configuring time series, line, and area charts

Line chart

Time series chart

Area chart

Configuring scatter charts

Configuring pie and donut charts

Configuring geographical charts.

Geo chart

Google Maps chart

Configuring scorecards

Configuring other chart types

Bullet chart

Gauge chart

Building your first Looker Studio report - adding charts

Chapter 7: Looker Studio Features, Beyond Basics

Leveraging calculated fields

Organizing dimension values into custom groups

Manipulating text with regular expressions

Using MAX and MIN across multiple fields or expressions

Displaying images and hyperlinks

Using parameters

Parameters and calculated fields

Parameters and connectors

Blending data

Blending disparate data sources

Blending charts

Reaggregating metrics using blending

Adding community visualizations

Creating report templates

Optimizing reports for performance

Optimizing data sources

Optimizing reports

Underlying dataset performance

Part 3 - Building Data Stories with Looker Studio

Chapter 8: Employee Turnover Analysis

Describing the example scenario

Building the report - Stage 1: Determine

Building the report - Stage 2: Design

Defining the metrics

Choosing the visualization types

Considering the filters and their interactions

Designing the layout

Building the report - Stage 3: Develop

Setting up the data source

Creating the report

Chapter 9: Mortgage Complaints Analysis

Introducing BigQuery

Getting started with BigQuery

Getting data into BigQuery

Analyzing data in BigQuery

Building the dashboard- Stage 1: Determine

Building the dashboard- Stage 2: Design

Choosing visualization types

Considering filters and interactions

Building the dashboard- Stage 3: Develop

Creating a report.

Summary

Chapter 10: Customer Churn Analysis

Choosing visualization types and filters

Chapter 11: Monitoring Report Usage

Usage monitoring overview

Google Analytics primer

Understanding GA reports

Monitoring Looker Studio report usage with GA4

Setting up GA4 for Looker Studio report monitoring

Creating a custom report in GA4

Visualizing in Looker Studio

Exporting GA4 data to BigQuery

Index

Other Books You May Enjoy.

Notes:

Includes index.

Includes bibliographical references and index.

OCLC-licensed vendor bibliographic record.

Description based on print version record.

ISBN:

9781800561953

1800561954

OCLC:

1350453382