Top 23
Prep plan
Updated weekly · Last refresh Oct 17

Pagerduty Business Analyst Interview Questions

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

23questions
~3htotal time
Track your progressSign up free to work through all 23 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 3 questions · ~27 min
Define Success Metrics for FeaturesMedium

Set a clear north star, supporting KPIs, leading indicators, and guardrails for a new product feature.

North Star MetricLagging IndicatorsKPIsPagerduty
Diagnosing Weekly Active User DropHard

Tests structured incident-style troubleshooting using metrics, segmentation, and validation.

RetentionDiagnosisPagerduty
Dashboard for Churn RiskMedium

Tests metrics design, dashboard usability, and how you support Customer Success decisions.

ChurnCustomer SuccessdashboardingPagerduty
2
SQL & Data Manipulation4 questions + 1 drill · ~46 min
Customer Orders: LEFT vs INNER JOINEasy

Explain how INNER JOIN and LEFT JOIN differ, and when to use each for matched-only versus all-left-row analysis.

JoinsData WranglingGroup ByPagerduty
SQL TTR by TeamMedium
Practice

Calculate average time to resolve high-severity incidents for each team using timestamp arithmetic and aggregation.

Date FunctionsGroup ByAggregationsPagerduty
SQL Month-over-Month GrowthMedium
Practice

Calculate monthly GoFundMe campaign counts and month-over-month growth using CTEs, date functions, joins, and aggregation.

Date Functionssql queryPagerduty
Optimize Slow Multi-Join SQLHard

Tests query optimization skills for complex SQL with large joins and aggregations.

JoinsperformanceAggregationsPagerduty
SQL for Active IncidentsMedium
Practice
Practice drill

Count active PagerDuty incidents by qualifying region using multi-table joins and aggregations.

JoinsCTEsGroup ByPagerduty

Sign up to see every question

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

Get my prep plan
3
Behavioral & Leadership16 questions · ~145 min
Explaining Your Analytical ThinkingEasy

Tests structured problem solving, clear communication, and self-awareness in how you approach analytical reasoning under ambiguity.

Decision Makingsoft skillsProblem SolvingPagerduty
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 23 questions plus 1 hands-on drill to finish this plan.