Dream Team
The month in which the majority of our team is born in
March
Dry, like the desert
(4)
arid
Rock formed from the weathered products of preexisting rocks that have been transported, deposited, and lithified
sedimentary rock
This Excel function "flips" the orientation of a given range or array
transpose
Between IFF and CASE WHEN, the one that's less expensive.
IFF
The person on our team with the most vowels in their first and last name
Aaron Gourdin
Payment to your ex
(7)
alimony
One of Earth's compositional layers. The solid rocky shell that extends from the crust to the outer core.
mantle
The two things Connie plans out in her spreadsheet
meals, outfits
This function is equivalent to grouping by every column.
DISTINCT
The name of the meeting room where we have our weekly Analytics meeting
Grizzly
Catching fish using hook, line & sinker
(7)
angling
Fixed mantle plume that underlies Yellowstone and Hawaii, or a public place with wi-fi.
hot spot
If match_type is this value, MATCH finds the smallest value that is greater than or equal to
-1
According to Ilan's SQL style guide, all subqueries should have this many additional indentation spaces.
4
The creator of our Slack channel #analytics-summit
Connie
Handy with both hands
(12)
ambidextrous
A rapidly cooled rock that contains no minerals
glass
This Excel function counts the number of cells that are not empty in a range
COUNTA
The function that merges the contents of two structurally-compatible tables into a single combined table
UNION
In our team meeting slides, it's the existential question that is posed on the Team Norming slide.
What is the meaning of life?
Herschel or Sagan
(10)
astronomer
The geologic era in which we currently live
Cenozoic
The maximum number of spreadsheet rows and columns supported by the latest versions of Excel
1,048,576 rows by 16,384 columns
The order in which SQL directives (i.e. FROM, GROUP BY, HAVING, ORDER BY, SELECT, WHERE) get executed.
FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY