7.6. Visualizing Relationship

In this lesson, we'll explore how to tell a story about the relationships between different metrics and dimensions using various chart types.

Scatter Charts

Scatter charts are useful for visualizing relationships between two metrics across a single dimension category. In a scatter chart, you have a number on the X-axis, another metric on the Y-axis, and points representing the relationship between these two metrics for each category of the dimension. This chart type makes it easy to identify outliers and trends in the relationship between the two metrics.

Bubble Charts

A variation of the scatter chart, the bubble chart displays three metrics and one category. The bubble chart positions dots based on two metrics, just like in a scatter chart, but the size of the dot represents a third metric. This allows you to visualize the relationship between three metrics at once. However, bubble charts can be difficult to interpret for some audiences, especially if they are not familiar with this format.

Time Series with Bubble Charts

As of now, bubble charts cannot be animated with time series data. Although animated bubble charts can be visually appealing and informative, they are not yet available in most data visualization tools.

Table Visualizations

Sometimes, a simple table can be the best way to present data and convey insights, especially when dealing with the relationship between multiple metrics and a single dimension. Tables are often easier to read and interpret for people who are not familiar with complex chart types.

In a table, you can display numbers or use bars to represent the relationship between the metrics. If you have a target value, you can include it in the table as a fixed number. Tables offer a clear and accessible way to convey information, making them a valuable tool in your data visualization arsenal.

When visualizing relationships between metrics and dimensions, consider using scatter charts, bubble charts, or tables, depending on your audience's familiarity and preferences. Remember that sometimes a simple table can be the most effective way to tell a story and present data.

Enroll in Looker Studio Masterclass →

📩 Receive my weekly Looker Studio tips

🖇 Connect with me on LinkedIn