Book Image

Data Storytelling with Google Looker Studio

By : Sireesha Pulipati
Book Image

Data Storytelling with Google Looker Studio

By: Sireesha Pulipati

Overview of this book

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.
Table of Contents (17 chapters)
Free Chapter
1
Part 1 – Data Storytelling Concepts
5
Part 2 – Looker Studio Features and Capabilities
10
Part 3 – Building Data Stories with Looker Studio

Configuring scorecards

With scorecard charts, you can show a single metric value as text. They are useful to display key performance metrics. In this section, we will configure a scorecard to display the Call Abandonment Rate metric. The following screenshot shows the metric value for the second quarter of 2022:

Figure 6.42 – Scorecard displaying the Call Abandonment Rate metric

You can build this scorecard as follows:

  • Click on Add a chart and select the Scorecard chart type.
  • In the SETUP tab, configure the following:
    • Choose Call Center as the data source.
    • Add Call Abandonment Rate as a Metric. Set the display name to Q2 Call Abandonment Rate.
    • Set Default date range to a fixed duration of April 1, 2022, to June 30, 2022. Select the Fixed option from the top drop-down and select a Start Date and End Date. Our dataset only has the data for 6 months of 2022. For any up-to-date data source, you can choose other options such as This Quarter, This...