Dataford
Top 26
Prep plan
Updated weekly · Last refresh Aug 30

UNC Chapel Hill Business Analyst Interview Questions

The questions to prepare for a UNC Chapel Hill Business Analyst interview. Questions from real interview reports rank first. Updated weekly.

26questions
~3htotal time
Track your progressSign up free to work through all 26 questions and resume where you left off.
Start practicing free →
1
ExecutionStart here. 16 questions · ~128 min
Choose Agile vs WaterfallMedium

Explain Agile vs Waterfall and how to choose the right delivery model based on scope, risk, and planning needs.

Trade-offsSuccess CriteriaScope ManagementUNC Chapel Hill
Managing High ExpectationsMedium

Tests stakeholder management under constraints and your ability to set realistic expectations.

Trade-offsSuccess CriteriaRisk AssessmentUNC Chapel Hill
More Execution questions with a free account
2
Product Sense4 questions · ~32 min
Working With Business OwnersEasy

Tests stakeholder engagement and your ability to translate business pain points into requirements.

User ResearchUser NeedsPain PointsUNC Chapel Hill
Techniques for Gathering InputEasy

Tests requirements elicitation methods and how you tailor them to stakeholder groups.

User ResearchPain PointsUse CasesUNC Chapel Hill
More Product Sense questions with a free account
3
More topics6 questions · ~48 min
Excel, SQL, and Process Mapping ToolsEasy

Tests practical tooling for analysis and process documentation in a business analyst role.

JoinsData WranglingAggregationsUNC Chapel Hill
Presenting Findings With Tableau or Power BIEasy

Tests data storytelling and your ability to communicate insights to senior stakeholders.

KPIsLeading IndicatorsDiagnosisUNC Chapel Hill
Resume WalkthroughEasy

Tests your ability to tell a coherent story about your background and relevance to Baird research.

EstimationUser ResearchUNC Chapel Hill
Using SQL to Validate RequirementsMedium

Tests hands-on SQL skills for validation and troubleshooting during requirements and delivery.

JoinsData WranglingAggregationsUNC Chapel Hill
More 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
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
Daily Session Funnel Conversion RatesHard
Practice
Practice drill

Calculate daily session-level funnel conversion rates using CTEs, CASE WHEN, and date functions.

User NeedsData WranglingAggregations
Top Customers by Net SalesMedium
Practice
Practice drill

Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.

SubqueriesJoinsData WranglingGain DigitalTCSZest AI
Monthly Campaign Performance SummaryEasy
Practice
Practice drill

Aggregate January 2024 campaign data by channel using GROUP BY, filtering, and ordering by total clicks.

JoinsData WranglingAggregationsDNVEversanaDiscord
The finish line: interview-readyComplete all 26 questions plus 3 hands-on drills to finish this plan.