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

CGI Business Analyst Interview Questions

The questions to prepare for a CGI 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. 20 questions · ~160 min
Conflicting Stakeholders on Critical LaunchMedium

Explain how you handled a project where stakeholders wanted different outcomes and you had to align them without losing delivery momentum.

Trade-offsRisk AssessmentScope ManagementCGI
Disagreeing on Safety-Critical TradeoffsEasy

Describe how you handled a disagreement with an engineer or safety expert when the decision involved delivery pressure and safety tradeoffs.

Trade-offsRisk AssessmentScope ManagementCGI
More Execution questions with a free account
2
Product Sense3 questions · ~24 min
Break Down Objectives into StoriesEasy

Tests ability to translate business goals into clear, actionable user stories and requirements.

User NeedsMVPUse CasesCGI
Write User Stories and Acceptance CriteriaMedium

Assesses ability to translate business needs into testable user stories and acceptance criteria.

CGI
More Product Sense questions with a free account
3
SQL & Data Manipulation3 questions + 3 drills · ~54 min
SQL for Top Sales RegionsMedium

Tests SQL query-writing skills for ranking and extracting top performance regions from raw data.

RankingGroup ByAggregationsCGI
Debug SQL CodeMedium

Evaluates practical SQL debugging skills and structured troubleshooting.

DebuggingsqlCGI
Top Customers by Sales RevenueEasy
Practice
Practice drill

Use GROUP BY and SUM to rank the top 10 customers by total revenue from a single sales table.

RankingGroup ByAggregationsHousecall ProEquifaxXYZ
Top 5 Products Per MonthMedium
Practice
Practice drill

Rank completed product sales by month using joins, aggregation, date truncation, and ROW_NUMBER().

sqlCGICgi NederlandCGI Group
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
More SQL & Data Manipulation questions with a free account
4
Behavioral & Leadership22 questions · ~176 min
More Behavioral & Leadership questions with a free account
5
More topics2 questions · ~16 min
Dashboard for Operational EfficiencyMedium

Tests KPI selection, data modeling considerations, and dashboard design for operational performance tracking.

KPIsLeading IndicatorsDiagnosisCGI
Use Metrics to Influence DirectionEasy

Tests data-driven communication and stakeholder influence using metrics.

KPIsData WranglingDiagnosisCGI

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 50 questions plus 3 hands-on drills to finish this plan.