Top 28
Prep plan
Updated weekly · Last refresh Oct 17

Shell Data Analyst Interview Questions

The questions to prepare for a Shell Data Analyst interview. Questions from real interview reports rank first. Updated daily.

28questions
~4htotal time
Track your progressSign up free to work through all 28 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 8 questions + 2 drills · ~87 min
Rolling 7-Day Average in SQLMedium

Tests SQL windowing and time-series aggregation for energy trading analytics.

Window FunctionsDate FunctionsRunning TotalsShell
Handling Duplicates and Nulls in SQLEasy

Explain practical SQL approaches for identifying, removing, and preventing duplicates and NULL-related data quality issues.

Data WranglingGroup ByCase WhenShell
Customer Orders: LEFT vs INNER JOINEasy

Explain how INNER JOIN and LEFT JOIN differ, and when to use each for matched-only versus all-left-row analysis.

JoinsData WranglingGroup ByShell
SQL Concepts OverviewEasy

Assesses foundational understanding of SQL concepts used in data analysis.

Shell
SQL Topics: Joins, CTE, DDL, DAXHard

Tests breadth of core SQL and BI skills used to build and model analytics.

JoinssqlShell
Window Functions for Top AssetsMedium
Practice

Rank Shell energy assets within each region by total production, returning the highest-performing assets and ties.

Window FunctionsJoinsData ManipulationShell
Window Functions for RankingHard
Practice
Practice drill

Rank Whova attendees by total engagement and calculate each user's chronological running engagement total.

Window FunctionsRankingRunning TotalsWhovaTTTRhombus Power
Second Highest Without AggregatesHard
Practice
Practice drill

Find the second highest salary in each department without using aggregate functions.

SubqueriesRankingSelf-JoinsCredit GenieDevoteamCisco Restaurant + Bar
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership19 questions · ~160 min
Background and Role MotivationEasy

Tests how clearly you connect your background, motivation, and role fit into a focused, credible narrative.

company fitself introductionmotivationShell
More Behavioral & Leadership questions with a free account
3
More topics1 question · ~8 min
The finish line: interview-readyComplete all 28 questions plus 2 hands-on drills to finish this plan.