Top 16
Prep plan
Updated weekly · Last refresh Oct 17
M

Marshmallow Data Analyst Interview Questions

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

16questions
~2htotal time
Track your progressSign up free to work through all 16 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 3 drills · ~78 min
Review Dashboard FindingsMedium

Tests your ability to interpret BI metrics quickly and communicate clear insights.

dashboard analysisMMarshmallow
Join Types for Insurance DataMedium

Evaluates your SQL join reasoning and correctness when integrating insurance data.

join typesMMarshmallow
Data Modeling for New FeatureMedium

Assesses how you design data models that support new product analytics needs.

sqlData ModelingMMarshmallow
Root Cause for Dropping MetricMedium

Assesses your ability to diagnose metric changes using structured data investigation.

root cause analysisMMarshmallow
Anomaly Detection Under Time PressureMedium

Tests your troubleshooting workflow for detecting data anomalies quickly.

time managementData Analysisanomaly detectionMMarshmallow
SQL Window Functions Moving AverageMedium
Practice
Practice drill

Calculate a three-day moving average of active-client revenue using aggregation and SQL window functions.

Window FunctionsData AnalysissqlEEvalueserveSShyena Tech YarnsAATB Financial
Running Average With Window FunctionsEasy
Practice
Practice drill

Calculate each Hinge user's 30-day rolling average of daily interactions using CTEs and window functions.

Window FunctionsData AnalysissqlHingeCCatalyst Operations & AnalyticsAAlight Solutions
Using SQL Window FunctionsMedium
Practice
Practice drill

Calculate three-day rolling passenger entry averages for TfL stations using aggregation and window functions.

Window FunctionsData AnalysissqlTransport for LondonThe Trade DeskMercari
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership8 questions · ~64 min
Owning a High-Stakes Priority ShiftEasy

Tests ownership and prioritization when you must reframe a plan, align stakeholders, and protect delivery under pressure.

CommunicationLeadershipOwnershipMMarshmallow
More Behavioral & Leadership questions with a free account
3
More topics2 questions · ~16 min
Metrics for New Product LaunchMedium

Choose a metric hierarchy for a new product launch that covers adoption, customer value, and financial performance.

KPIsLeading IndicatorsDiagnosisMMarshmallow
Ensuring Dashboard AdoptionMedium

Assesses your approach to driving adoption and impact of BI dashboards.

Stakeholder ManagementMMarshmallow

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
The finish line: interview-readyComplete all 16 questions plus 3 hands-on drills to finish this plan.