Dataford
Dataford
Top 25
Prep plan
Updated weekly · Last refresh Oct 17

Smbc Group Business Analyst Interview Questions

The questions to prepare for a Smbc Group Business Analyst interview. Questions from real interview reports rank first. Updated daily.

25questions
~3htotal time
Track your progressSign up free to work through all 25 questions and resume where you left off.
Start practicing free →
1
ExecutionStart here. 3 questions · ~24 min
Your Strengths and WeaknessesEasy

Give a specific, self-aware account of your strengths and weaknesses, supported by relevant examples and improvement actions.

Trade-offsSuccess CriteriaExecutionSmbc Group
Designing Database Schema or Data FlowMedium

Tests requirements-to-data modeling skills and ability to document business processes clearly.

processdatabase designSmbc Group
More Execution questions with a free account
2
Finance & Accounting3 questions · ~24 min
Recent Finance NewsMedium

Evaluates your engagement with finance and ability to connect news to business implications.

Smbc Group
Debt to Equity RatioMedium

Evaluates your ability to reason about capital structure metrics used in financial analysis.

financial ratiosSmbc Group
More Finance & Accounting questions with a free account

Sign up to see every question

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

Get my prep plan
3
Strategy4 questions · ~32 min
Bank Products and Revenue ModelMedium

Tests understanding of banking products and how revenue is produced across corporate offerings.

revenue modelBusiness ModelSmbc Group
Bond vs Equity BasicsEasy

Tests core financial product knowledge relevant to investment and asset management contexts.

Market Trendsfinancial literacyBusiness AcumenSmbc Group
More Strategy questions with a free account
4
Behavioral & Leadership13 questions · ~104 min
More Behavioral & Leadership questions with a free account
5
More topics2 questions · ~16 min
SQL Window Functions for ReportingMedium

Tests SQL proficiency and ability to transform data for business reporting.

Window FunctionsAggregationsSmbc Group
SQL Window Function AggregationMedium

Tests hands-on SQL window function skills for business data aggregation.

Window FunctionssqlAggregationsSmbc Group
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
SQL Window Functions ExperienceMedium
Practice
Practice drill

Use SQL window functions to rank regions by average 2024 yield within each country.

Window FunctionsJoinsData ManipulationErnst & YoungKBRMaximus Tech
Window Functions for TrendsMedium
Practice
Practice drill

Calculate account-level running totals and three-row moving averages with PostgreSQL window functions.

Window FunctionsJoinsData ManipulationAAxtriaGGrowth IntelligenceGGrupo Astek
7-Day Rolling Average with Window FunctionsMedium
Practice
Practice drill

Calculate each user's 7-day rolling order volume average, including calendar days with no orders.

Window FunctionsDate FunctionsData ManipulationDDelivery HeroRRBC IncorporatedTTeya
The finish line: interview-readyComplete all 25 questions plus 3 hands-on drills to finish this plan.