Top 13
Prep plan
Updated weekly · Last refresh Oct 17

New Soft Intelligence Data Analyst Interview Questions

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

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

Explain how to profile, clean, and standardize missing or dirty data before analysis.

Data WranglingCase WhenQualityNew Soft Intelligence
KPI Dashboard Build ProcessMedium

Assesses end-to-end dashboard design, data thinking, and KPI definition.

data visualizationNew Soft Intelligence
Visualize Correlation Between BehaviorsMedium

Assesses ability to choose appropriate visualizations for relationships in user data.

Correlationdata visualizationNew Soft Intelligence
Structure Engagement Over Time DatasetMedium

Evaluates data modeling choices for time-series user engagement analysis.

user engagementNew Soft Intelligence
Primary Key vs Foreign KeyEasy

Tests understanding of core relational database concepts and data modeling basics.

database conceptsNew Soft Intelligence
Top 5 Users by Purchase FrequencyMedium

Tests SQL skills for aggregation, time filtering, and ranking.

sql queryNew Soft Intelligence
SQL: Top Engaged Save InteractorsMedium
Practice
Practice drill

Use joins, aggregation, a CTE, and ROW_NUMBER to rank Instagram Save users by quarterly engagement within each region.

sql queryData Analysisuser engagementMeta
SQL Funnel Drop-Off AnalysisHard
Practice
Practice drill

Measure sequential Airbnb Homes funnel engagement and drop-off using CTEs, joins, aggregation, and LAG.

sql queryData Analysisuser engagementAirbnbGGetYourGuide
Handling 30% Missing Critical DataMedium
Practice
Practice drill

Audit critical-field completeness by application source and report missing-entry percentages.

missing valuesdata accuracyData WranglingAmerican Credit Acceptance
2
Behavioral & Leadership6 questions · ~48 min
Explaining a Technical Concept ClearlyEasy

Tests communication, ownership, and stakeholder management when translating technical complexity into actionable business understanding.

Problem SolvingData Structurestechnical fundamentalsNew Soft Intelligence
More Behavioral & Leadership questions with a free account
3
More topics1 question · ~8 min
The finish line: interview-readyComplete all 13 questions plus 3 hands-on drills to finish this plan.