12 questions. Score 70% or more to pass this rank's quiz.
Blue means discrete and produces headers; green means continuous and produces an axis.
In 2026 Google renamed Looker Studio back to its original name, Data Studio.
A FIXED level-of-detail expression computes at the level you name (customer), independent of the dimensions in the view.
ETL pulls data from sources, cleans and reshapes it, then loads it into a warehouse or model; ELT loads first and transforms inside the warehouse.
Line charts show change over continuous time clearly; pie charts and treemaps are for parts of a whole.
OLTP systems run day-to-day transactions; a warehouse combines sources and keeps history so analytical queries run fast.
Apache Superset is an Apache Software Foundation open-source project; the others are commercial products (Power BI Desktop is free but not open source).
LookML is Looker's semantic modeling layer, so metrics are defined once in code and reused across reports.
Incremental refresh partitions data by date so only recent partitions are reloaded, making large refreshes faster.
People compare angles poorly, so pies only work with a few slices of one total; bars are better for many categories.
Readers of left-to-right languages scan from the top-left, so headline numbers go there and detail goes below.
Tableau Prep builds visual data-prep flows (joins, unions, cleaning), similar in role to Power Query.