Role track
Data Analyst
SQL, grain, a BI tool, and the nerve to say the number is wrong.
115 questions · SQL · Metrics · BI · Behavioral
Suggested sequence
1. SQL you can defend
Joins, grain, and windows. The pad opens every analyst loop.
Analyst coding →2. The flowchart
Check off SQL, BI, and the story you will tell.
Analyst roadmap →3. The warehouse dialect
Credits or slots — know who pays for the extract.
Warehouse bank →4. Story and challenge
A time the dashboard lied. What you changed.
Behavioral →
Stacks in this loop
Sample questions
hard · SQL · Stripe
Deduplicate to the latest customer row. Why not filter the window in WHERE?
Practice →medium · SQL · Capital One
A join exploded revenue. How do you find the grain mismatch in five minutes?
Practice →medium · SQL · Meta
Running total of daily revenue. Why is SUM(SUM(amount)) OVER (...) valid?
Practice →hard · SQL · Google
NULL = NULL is unknown. How does that bite a MERGE or an anti-join?
Practice →hard · SQL · LinkedIn
When do you use a covering index / clustering key versus rewriting the query?
Practice →medium · SQL · Snowflake
QUALIFY vs a CTE for window filters — when do you use each?
Practice →