Top 20
Prep plan
Updated weekly · Last refresh Aug 30

RSG - Resource Systems Group Business Analyst Interview Questions

The questions to prepare for a RSG - Resource Systems Group Business Analyst interview. Questions from real interview reports rank first. Updated weekly.

20questions
~3htotal time
Track your progressSign up free to work through all 20 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 3 questions · ~24 min
Diagnose a Customer Satisfaction DropMedium

Investigate a sudden drop in customer satisfaction and separate leading signals from the final NPS readout.

NPSLeading IndicatorsDiagnosisRSG - Resource Systems Group
Forecasting from Historical DataHard

Tests your forecasting methodology and how you translate historical patterns into future planning.

Leading IndicatorsDiagnosisTime SeriesRSG - Resource Systems Group
More Metrics questions with a free account
2
SQL & Data Manipulation5 questions + 3 drills · ~70 min
Data Analysis Tools and MethodsEasy

Tests your practical toolkit and approach to performing data analysis effectively.

JoinsData WranglingAggregationsRSG - Resource Systems Group
Identifying Key TrendsMedium

Tests your ability to explore data, choose appropriate techniques, and extract actionable insights.

Window FunctionsData WranglingAggregationsRSG - Resource Systems Group
Top Daily Rides by VehicleMedium
Practice
Practice drill

Rank the top 3 completed rides per vehicle per day using joins, a CTE, and ROW_NUMBER.

Window FunctionsJoinsData WranglingWaymo
Deduplicate Out-of-Order Replication EventsMedium
Practice
Practice drill

Use ROW_NUMBER() to keep the earliest created_at 'Repl created' per entity and return out-of-order duplicates to delete.

Window FunctionsSubqueriesJoinsReplitQuantcast
30-Day Moving Average of BookingsMedium
Practice
Practice drill

Build a daily series and compute a 30-day trailing moving average of task bookings using window functions.

Window FunctionsData WranglingAggregationsTaskRabbitRBC
More SQL & Data Manipulation questions with a free account
3
Behavioral & Leadership8 questions · ~64 min
More Behavioral & Leadership questions with a free account
4
More topics4 questions · ~32 min
Analyze a New Product CategoryHard

Approach for analyzing whether a new product category is worth entering and how to size and frame the opportunity.

Competitive AnalysisGrowth StrategyMarket SizingRSG - Resource Systems Group
Regression and Predictive ModelingHard

Tests your statistical modeling skills and ability to build and interpret predictive models.

ExperimentationRegressionCausal InferenceRSG - Resource Systems Group
Influencing Decisions with DataMedium

Tests your ability to drive decisions using data and stakeholder alignment.

Trade-offsSuccess CriteriaRSG - Resource Systems Group
Motivation for Consulting and ResearchMedium

Evaluates your motivation and fit for RSG - Resource Systems Group's data-driven consulting work.

market researchRSG - Resource Systems Group

Sign up to see every question

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

Get my prep plan
The finish line: interview-readyComplete all 20 questions plus 3 hands-on drills to finish this plan.