Dataford
Top 30
Prep plan
Updated weekly · Last refresh Nov 12

Morgan Stanley Data Analyst Interview Questions

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

30questions
~5htotal time
Track your progressSign up free to work through all 30 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 3 questions + 1 drill · ~38 min
Find Qualifying January Trade RequestsMedium
Practice

Join analyst and trade request records, then return active analysts with qualifying pending requests.

null handlingJoinsData ManipulationMorgan Stanley
Top Clients by Region SQLMedium
Practice
Recently asked

Find the top three spending clients in each region during the previous calendar quarter.

Window FunctionsDate Functionsfinancial dataMorgan Stanley
Join vs Union in AnalyticsEasy
Recently asked

Explain how JOIN combines columns across related tables while UNION stacks rows from compatible queries in analytics workflows.

JoinsData WranglingUnionsMorgan Stanley
Optimizing Monthly Site Metrics QueryMedium
Practice
Recently asked
Practice drill

Rewrite a slow PostgreSQL reporting query to reduce scanned rows, avoid join multiplication, and return accurate monthly site metrics.

Subqueriesdatabase optimizationJoinsContinental FinanceCapgeminiDISH
2
Statistics & Probability5 questions · ~46 min
Expected Flips for Two HeadsMedium
Recently asked

Compute the expected waiting time to see two consecutive heads when flipping a fair coin.

DistributionsExpected ValueConditional ProbabilityMorgan Stanley
Martingale and Stock ModelingHard
Recently asked

Explain martingales, derive the discounted-stock condition, and distinguish risk-neutral pricing from real-world stock-price modeling.

modelingrisk modelingTime SeriesMorgan Stanley
Covariance and Correlation for CommitteesHard
Recently asked

Calculate covariance and correlation for two asset classes and explain their implications for diversification and portfolio risk.

CorrelationVariancerisk modelingMorgan Stanley
More Statistics & Probability questions with a free account
3
Behavioral & Leadership21 questions · ~193 min
Walk Through Your Data WorkEasy

Tests how clearly a candidate can present their data analysis experience, achievements, and ownership of results.

achievementanalytical skillsexperienceMorgan Stanley
More Behavioral & Leadership questions with a free account
4
More topics1 question · ~9 min
Handling Missing Values in a DatasetMedium

Choose an appropriate missing-value strategy while preserving metric accuracy and identifying whether missingness is systematic.

analyticsMorgan Stanley

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 30 questions plus 1 hands-on drill to finish this plan.