Project Analyst Interview Questions UK: 8 Real Questions and What Interviewers Want

Applying for a Project Analyst job in the UK? Here is what you are likely to be asked. These questions come from our Project Analyst question bank of 16 questions, written for UK employers at junior level.

Eight Project Analyst interview questions, and what the interviewer is thinking

1. How would you use Excel to analyse project data, and which functions and features do you rely on most?

Why they ask: Excel proficiency is the central tool for a project analyst.

2. What is earned value analysis in simple terms, and how would you calculate the key metrics?

Why they ask: Project analysts are often asked to produce schedule and cost performance measures.

3. How would you build a dashboard or report for a project board, and which tools would you use?

Why they ask: Analysts translate data into decision-ready information.

4. How do you carry out quantitative risk analysis or schedule analysis, such as critical path or three-point estimating?

Why they ask: Analysts support quantification of uncertainty and schedule.

5. What are project benefits, and how would you help track them after delivery?

Why they ask: Benefits realisation increasingly sits with project analysts and PMOs.

6. You are preparing the monthly report and notice the project manager's spend forecast doesn't reconcile with the finance system. What would you do?

Why they ask: Data integrity and honest reporting are core analyst values.

7. Tell me about a time your analysis uncovered something that wasn't obvious, and what you did with it.

Why they ask: Analysts add value by insight, not just data processing.

8. Why do you want to work as a project analyst rather than a project manager?

Why they ask: Interviewers explore your motivation and understanding of the distinctions.

A sample answer to question 1

How would you use Excel to analyse project data, and which functions and features do you rely on most?

I use Excel daily for tracking, forecasting and reporting. For lookups I rely on XLOOKUP or INDEX and MATCH to join data from the schedule, finance and resource sheets. SUMIFS and COUNTIFS help me summarise spend by work package or count open risks by owner, and pivot tables let me slice data quickly, with slicers for interactive reporting. I use conditional formatting to highlight overdue milestones, data validation to keep trackers clean, and Power Query to refresh imports from the finance system without manual copying. For forecasting I might build a simple S-curve of planned against actual spend. I always keep raw data on separate tabs from calculations, document formulas and add reconciliation checks so totals match source systems. If the analysis becomes repetitive, I would automate it with Power Query or Power BI rather than rebuilding it each month.

Common mistake to avoid: Listing only basic SUM and filters; building unreviewed spreadsheets

Want the rest?

Full model answers, key points and common mistakes for all 16 questions are on the Project Analyst interview questions page. The first five are free, no sign-up needed.