Navi Data Analyst Interview Questions

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

18questions

~3htotal time

Track your progressSign up free to work through all 18 questions and resume where you left off.

SQL & Data ManipulationStart here. 6 questions · ~65 min

Find the top 3 customers in each region by transaction volume using joins, aggregation, and window ranking.

Window Functions vs GROUP BYEasy

Explain how window functions differ from GROUP BY and when to use each in Splice product analysis.

Window FunctionsGroup ByAggregations

Navi

Optimizing Slow Queries at ScaleHard

Explain how to diagnose and optimize a slow PostgreSQL query on large Apidel Technologies datasets.

SubqueriesJoinsData Wrangling

Navi

Window Functions and Churn SQLMedium

Practice

Calculate monthly Navi lending customer churn rates by comparing each customer's current and previous activity status.

Window FunctionsLag/LeadDate Functions

Navi

More SQL & Data Manipulation questions with a free account

Behavioral & Leadership9 questions · ~98 min

Interest in AnalyticsEasy

Tests motivation for analytics and machine learning, including curiosity, analytical judgment, and connection to practical impact.

AIanalytical mindsetbehavioral

Navi

More Behavioral & Leadership questions with a free account

More topics3 questions · ~33 min

State Bayes theorem and solve the probability problem supplied by the interviewer.

Estimate UPI TransactionsHard

Estimate monthly and annual UPI transaction volume using a bottom-up model, scenario analysis, and sensitivity testing.

Estimationscenario analysisSampling

Navi

Regression Knowledge and UseMedium

Assesses your understanding of regression and its practical use in analytics.

Regression

Navi

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

The finish line: interview-readyComplete all 18 questions to finish this plan.