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

AIG PC Global Services Business Analyst Interview Questions

The questions to prepare for a AIG PC Global Services Business Analyst interview. Questions from real interview reports rank first. Updated weekly.

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
ExecutionStart here. 12 questions · ~96 min
Resolve Conflicting Stakeholder PrioritiesMedium

Explain how you align stakeholders with competing priorities, make trade-offs explicit, and keep execution on track.

Trade-offsRisk AssessmentScope ManagementAIG PC Global Services
Structure a STAR Execution StoryEasy

Explain how to deliver a clear STAR story that highlights your personal ownership and execution impact.

Trade-offsSuccess CriteriaScope ManagementAIG PC Global Services
More Execution questions with a free account
2
SQL & Data Manipulation8 questions + 3 drills · ~94 min
Pivot Analysis for Relias RevenueEasy

Explain how pivot-style aggregations help analyze large Relias datasets by summarizing metrics across dimensions like month, region, and product.

PivotData WranglingAggregationsAIG PC Global Services
VLOOKUP vs INDEX MATCH in SQLMedium

Explain VLOOKUP vs INDEX/MATCH and how lookup design maps to SQL joins and key matching.

JoinsData WranglingAggregationsAIG PC Global Services
Analyze Decision Impact by RegionEasy
Practice
Practice drill

Use joins, CASE WHEN, and date filtering to compare outcome rates before and after a decision.

Data WranglingDiagnosisAggregationsHarbourVest Partners
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
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
3
Strategy11 questions · ~88 min
Estimate Digital Product Market SizeHard

Estimate the market size for a new digital product opportunity using a structured TAM, SAM, SOM approach.

EstimationTAM/SAM/SOMMarket SizingAIG PC Global Services
More Strategy questions with a free account
4
Metrics11 questions · ~88 min
Assess Claims Process EfficiencyMedium

Evaluates how you measure claims cycle time, quality, and cost drivers to improve operations.

KPIsLeading IndicatorsDiagnosisAIG PC Global Services
Role of Data in EfficiencyEasy

Assesses understanding of how data supports process improvement and operational outcomes.

KPIsLeading IndicatorsDiagnosisAIG PC Global Services
More Metrics questions with a free account
5
Product Sense5 questions · ~40 min
Explain Business Value of AnalysisEasy

Assesses your ability to translate analytical findings into business impact for decision-makers.

User NeedsValue PropositionAIG PC Global Services
More Product Sense questions with a free account
6
Behavioral & Leadership3 questions · ~24 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 50 questions plus 3 hands-on drills to finish this plan.