Top 13
Prep plan
Updated weekly · Last refresh Aug 30

NTT DATA Business Intelligence Analyst Interview Questions

The questions to prepare for a NTT DATA Business Intelligence Analyst interview. Questions from real interview reports rank first. Updated weekly.

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. 8 questions + 3 drills · ~94 min
Explain SQL Join TypesEasy

Explain INNER, LEFT, RIGHT, FULL OUTER, CROSS, and SELF JOINs with examples and when to use each.

JoinsData WranglingGroup ByNTT DATA
Window Functions in BI ReportingMedium

Evaluates your ability to use advanced SQL to produce accurate BI metrics.

Window FunctionssqlNTT DATA
Optimizing Slow SQL QueriesHard

Tests SQL performance tuning skills such as indexing, query plans, and rewriting logic.

Performance Tuningquery optimizationsqlNTT DATA
Ensuring Data Accuracy Across SourcesMedium

Evaluates your approach to data quality, reconciliation, and trustworthy reporting.

aggregationdata accuracydata integrityNTT DATA
Top Customers QueryMedium

Assesses your SQL skills for common BI analytics tasks.

sqlNTT DATA
Handling Null Values in DatasetsMedium

Assesses your data preparation skills to avoid misleading analytics.

null handlingsqldata integrityNTT DATA
Monthly Revenue Running Totals by RegionMedium
Practice
Practice drill

Use joins, monthly aggregation, and window functions to compute running revenue totals and customer rank by region.

Window FunctionsRankingRunning TotalsNTT DATAAppfolio
Second Highest Without AggregatesHard
Practice
Practice drill

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

SubqueriesRankingSelf-JoinsCredit GenieDevoteamCisco Restaurant + Bar
Advanced SQL With PartitionsHard
Practice
Practice drill

Use CTEs, aggregations, and window functions to compare gender pay and find each department's second-highest salary.

Window FunctionsJoinssqlMeesho
More SQL & Data Manipulation 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
2
Behavioral & Leadership5 questions · ~40 min
Explaining Analysis to Non-Technical StakeholdersEasy

Tests communication of complex data to non-technical stakeholders, including clarity, stakeholder management, and actionable storytelling.

Influence Without AuthorityStakeholder ManagementCommunicationNTT DATA
Reconciling Competing Client RequirementsMedium

Tests conflict resolution across stakeholders, especially how you prioritize competing requirements and drive alignment to a clear outcome.

Stakeholder Managementclient managementconflicting requirementsNTT DATA
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 13 questions plus 3 hands-on drills to finish this plan.