Index
As this ebook edition doesn't have fixed pagination, the page numbers below are hyperlinked for reference only, based on the printed edition of this book.
A
Advanced filter control 159, 160
aggregation functions 246
American Community Survey (ACS) 350
analytical dashboards 339
analytics
business analytics 9
manage up/down 9
people analytics 9
project/program analytics 9
Aristotle’s arc 4
arithmetic functions 246
B
benefits 423
features 347
GA4 data, exporting to 423-427
web user interface 342
BigQuery datasets 341
BigQuery ML 347
BigQuery Omni 347
BigQuery sandbox
blends 276
benefits 276
creating 276
reaggregation of metrics, allowing 287, 288
bubble chart 218
bullet chart 235
building 236
configuring 236
versus gauge chart 236
Business-to-Business (B2B) 370
Business-to-Consumer (B2C) 370
C
calculated fields 245
categorical data 52
character classes 251
charts
adding, to canvas 131
area chart 213
bullet chart 235
data configurations 138
gauge chart 236
geographical chart 221
heatmaps 69
pivot tables 191
reference link 72
scatter chart 216
time series chart 209
types 52
chart style properties
chart headers properties 173, 174
grid properties 171
legend properties 172
Checkbox 161
collection 414
color 41
best practices 41
color palette, selecting 43-46
fewer distinct colors, using 41, 42
inclusive color schemes, considering 48
colorblind-friendly palettes 48
color vision deficiency (CVD) 48
Colour Contrast Analyser (CCA)
reference link 48
columnar bar chart 194
configurations 195
common pitfalls, while designing dashboards and visuals
community visualizations
conditional expressions 246
Consumer Complaint Database references 338, 348
Consumer Financial Protection Bureau (CFPB) 338, 339
content security policy (CSP) 290
continuous data 52
customer acquisition retention
blog, reference link 370
customer churn 369
causes 370
customer churn analysis
Design stage, of dashboard building approach 373
Determine stage, of dashboard building approach 371, 372
Develop stage, of dashboard building approach 376
custom groups
dimension values, organizing into 249-251
custom report
D
dashboard 106
creating, in Looker Studio 421-423
versus report 8
data
analyzing, in BigQuery 346, 347
obtaining, into BigQuery 343-346
data access
data blending 276
data freshness
data literacy 9
components 9
data manipulation
performing, outside Looker Studio 295, 296
data report 106
dataset 85
underlying dataset performance 297
copying 101
embedded data source, creating 87-90
modeling 292
operations 101
optimizing 291
ownership, transferring 103-105
reusable data source, creating 91
reusing 106
working with 86
data source schema
data story 5
considerations 6
example 13
purpose 5
stages, for building 11
structuring 4
essential skills 10
stages 303
Looker Studio
charts 180
Looker Studio Explorer
working with 118
Looker Studio Gallery
Looker Studio report
creating, from data source 175-177
embedding 115
Looker Studio Report Gallery 8
Looker Studio report usage
custom report, creating in GA4 414-421
data visualization 6
data.world 302
design components
adding 164
Design stage of dashboard building approach, customer churn analysis
visualization types and filters, selecting 375
Design stage of dashboard building approach, mortgage complaints analysis 350, 351
filters, considering 352
interactions, considering 352
visualization types, selecting 351, 352
Design stage of report building approach, employee turnover analysis 305
filters interactions, considering 308, 309
visualization types, selecting 308
Determine stage of dashboard building approach, customer churn analysis 371, 372
Determine stage of dashboard building approach, mortgage complaints analysis 348-350
Determine stage of report building approach, employee turnover analysis 303-305
Develop stage of dashboard building approach, customer churn analysis
data source, setting up 376-379
Develop stage of dashboard building approach, mortgage complaints analysis 353
data source, setting up 353-359
Develop stage of report building approach, employee turnover analysis
data source, setting up 311-319
dimension 139
adding 139
data type and format, modifying 139, 140
dimension values
organizing, into custom groups 249-251
discrete value 52
disparate data sources
diversity, equity, and inclusion (DEI) 9
drill down 188
Drop-down list control 155-157
E
embedded data source 86
converting, into reusable data source 92
embedded report 115
employee turnover analysis
Design stage, of report building approach 305, 306
Determine stage, of report building approach 303-305
Develop stage, of report building approach 311
example scenario 302
Essential Elements of Employee Retention
reference link 302
exploration
versus report 119
Explorer
creating 119
creating, from data source 120
creating, from home page 119
creating, from report 121
report, exporting from 121
using, in analyst workflow 122, 123
external content
embedding, into Looker Studio report 165-167
external table 345
F
filters
adding, to group of charts 153
implementing 150
interactive filter controls 154
Fixed-size list control 157, 158
Flood-It 407
reference link 407
foundational design principles 20
accuracy, of information presented 26
layout, organizing 25
G
GA4 405
custom report, creating 414-421
hierarchy 405
setting up, for Looker Studio report monitoring 411-413
GA4 data
exporting, to BigQuery 423-427
GA4 properties
Flood-It 407
Google Merchandise Store 407
GA4 reports
acquisition 406
engagement 406
monetization 406
retention 406
tech 406
user demographics 406
GA 360 405
gauge chart 236
building 238
configuring 238
versus bullet chart 236
GCP account
creating 340
geographical chart 221
dimensions 222
Geospatial analysis 347
Gestalt 26
Gestalt principles, of visual perception
closure 32
enclosure 33
Google Analytics (GA) 403
explorations 410
reference link, for help documentation 407
Google Analytics primer 405
Google Cloud Project 341
Google Looker Studio 82, 83, 124
with filled areas layer 225
Google Merchandise Store 407
reference link 407
H
heatmaps 69
histogram 58
horizontal bar chart 56, 57, 196
building 197
hyperlinks
I
images
displaying 256
interactive filter controls 154, 155
Advanced filter control 159, 160
Checkbox control 161
Drop-down list control 155-157
Fixed-size list control 157, 158
metric sliders 163
K
Kaggle 302
Key Performance Indicator (KPI) 25, 53, 308
L
building 206
combination chart, with bars 207
combination chart, with grouped bars 208
with breakdown dimension 209
M
machine learning (ML) 408
Max function
using, across multiple fields or expressions 254, 255
metacharacter 252
metrics 143
adding 143
calculations, running 147
optional metrics 147
Metric sliders 163
Min function
using, across multiple fields or expressions 254, 255
mortgage complaints analysis
Design stage, of dashboard building approach 350, 351
Determine stage, of dashboard building approach 348-350
Develop stage, of dashboard building approach 353
N
NARY functions 256
native table 345
news story
structure 4
nominal values 52
non-subscription-based business 370
numerical data 52
O
Online Analytical Processing (OLAP) 340
Online Transactional Processing (OLTP) 340
operational dashboard 339
optimal data freshness frequency
setting 295
ordinal values 52
P
parameters
cardinality 271
using 260
using, with connectors 266
using, within calculated fields 260-266
values, modifying 260
personally identifiable information (PII) 411
configurations 193
creating 191
Project 341
R
radar chart 77
Recurly Research
URL 370
regular expressions (regex) 251
text, manipulating with 251
additional data sources, adding 132, 133
copying 117
creating, from template 109, 110
downloading 116
exploring, conditions 121
fewer calculated fields, using 296
operations 117
optimizing 296
optimizing, for performance 291
ownership, transferring 116
publishing 110
refraining, from overloading 296
versus dashboard 8
versus exploration 119
working with 106
report components
background and border 168
chart style properties 170
styling 167
text styles 169
report, customer churn analysis
report data
refreshing 117
report designer
components 131
overview 130
report, employee turnover analysis
Employee demographics & perceptions page 331-335
Job characteristics page 327-331
Report Gallery 123
Report Settings
report templates 290
report themes
style properties, configuring 174, 175
report view link
obtaining 138
reusable data source 86
creating 91
S
Sankey chart 351
scatter chart 216
bubble chart 219
building 230
secondary dimensions 406
service-level agreements (SLAs) 405
shapes 165
creating 213
with scorecard 213
spider chart 77
with absolute values 216
stacked bar chart 59-61, 201-203
static images 165
stories 3
strategic dashboards 339
style properties
configuring, in report themes 174, 175
subscription-based business 370
T
tables, with numbers 182
filtering 185
resizing 186
sorting 185
style configurations 186
table, with bars 186
table, with drill down 188
configurations 189
text
manipulating, with regular expressions (regex) 251
text component 165
three-dimensional (3D) effects 20
advantages 209
cumulative values, displaying 213
missing data handling 211
traditional story
structure 4
building 235
U
usage monitoring 404
V
visuals
selecting 51