SQL
Used to retrieve data
What is SELECT?
This looker object combines multiple visualizations into one view
What is a Dashboard?
In the 1980s, businesses started using this spreadsheet tool that turned data analysis into an everyday office skill.
What is Microsoft Excel
Main reporting tool used by the analytics team
What is Looker?
This retro host has two passports
Who is Hannah
Used to restrict number of rows
What is LIMIT?
A field that performs an aggregation, like sum, average, or count.
What is a measure?
The chess computer built by IMB that defeated Gary Kasparov in 1997
What is the deep blue computer?
Year that Kry was founded
When is 2015?
This retro host has a dachshund
Who is Viktor
Used to convert timestamp to date
What is DATE_TRUNC('date', column)::DATE?
This function transforms row values into columns
What is the pivot function?
Before computers, people used this simple device with beads on rods to add and subtract numbers
What is abacus?
I hope a non-swede gets this... Kry translates directly to ___ in English?
What is "healthy"?
This retro host celebrates dinovember
Who is Viktor
Returns records that have matching values in both tables
What is INNER_JOIN?
This is what the acronym LookML stands for
Looker Modelling Language
This 19th-century nurse used data visualisation to reform hospital sanitation.
Who is Florence Nightingale?
This is the historic number of appointments Kry has had
How much is 14 million!?
This retro host's favourite book series is the Red rising series
Who is Hannah?
A query inside of another query
What is a subquery?
When building a Looker dashboard, this feature allows a single user interaction to automatically update the filters or results shown in other tiles on the same dashboard.
What is a cross-filter?
This Greek physician used empirical observation and case recording, laying the groundwork for medical data analytics.
Who is Hippocrates?
Kry has this many physical clinics
How much is 60+?
This retro inherited cat that came with a house they moved in to
Who is Hannah?