Capital One Data Analyst Interview Guide: The Data OA, Technical Screen and Power Day
Prepare for Capital One data analyst interviews with reported assessment patterns, interview questions, and preparation advice.
On this page
Last reviewed November 16, 2026.
For data analysts.
Built by the Codinzhub team from Capital One interview experiences that candidates shared. Each experience is one person's interview, and Capital One changes its process by team and level, so use this as a map, not a promise.
The 30-second version. If you are applying as a data analyst, expect a recruiter call, a timed data OA where you answer about 11 questions from a spreadsheet (plus short written explanations), then a technical screen that mixes SQL with a business problem, and a Power Day of business cases after a data challenge. The OA rewards careful reading more than advanced maths; the cases reward clear profit thinking.
How this guide was built. Codinzhub has only a few first-hand reports for this exact role. Where they were thin, the Codinzhub team researched how Capital One runs this role and its sister roles, and we say clearly which parts come from that research. Treat those parts as the usual pattern, and confirm the details with your recruiter.
Looking for a different analyst role? Senior data analyst · Business analyst · Product analyst
Round-by-round breakdown
Stage 1: Application and recruiter call
What to expect. You apply on the careers site or a recruiter contacts you. The call covers your background, sponsorship, start date and why Capital One. No technical questions.
Stage 2: Online assessment
At a glance
- Length: timed; plan for about an hour
- Questions per round: 12, but the first is only an acknowledgment, so 11 real questions
- What was asked: rates, averages by group, a one-variable equation, choosing the best option, a short written reason
- Most common: one themed dataset (it was superheroes in older versions and cruises in the latest) with the same steps every time
What to expect. You get a dataset about missions or trips and answer questions in order. The theme changes, but the steps do not, so practising the pattern works. Older versions from 2024 are out of date.
What candidates were asked, in order:
| Step | Question (our summary) | How to solve it |
|---|---|---|
| 1 | Acknowledge the instructions | Nothing to solve |
| 2 | Win rate for each team | Wins divided by total missions |
| 3 | A target number over future days | Solve one equation, then divide by the number of days |
| 4 | Average win rate by rest time | Group, then average |
| 5 | Which three to send | Pick the three with the highest average |
| 6 | Assign one to each of three locations for the best total | Compare each combination |
| 7 | The most common value | Find the mode, then return the first row of that group |
| 8 | Cover the start and end of a route | Judgment; explain your choice in writing |
| 9 | A new team's win rate | Solve a ratio such as 572 × r = 422 |
More questions: Browse Capital One questions.
Stage 3: Technical screen
What to expect. A round that mixes SQL with a business problem. Candidates described it as more applied than the OA. From our research: analyst SQL questions at Capital One usually test joins, group-by and window functions on transaction-style tables.
Stage 4: Data challenge
What to expect. A take-home dataset to clean, analyse and turn into a recommendation, which you present at the Power Day. From our research: candidates usually get one to two weeks.
Stage 5: The Power Day
At a glance
- Length: about four rounds of 45 minutes
- Questions per round: one case, one behavioral set, or your data challenge
- What was asked: profitability cases, your data challenge, behavioral
- Most common: a final business case
What to expect. Cases ask you to build a profit equation, run the numbers aloud and recommend. Behavioral questions follow the STAR format. For worked case examples, the business analyst guide and data scientist guide list the cases candidates saw, with their numbers.
More questions: Browse Capital One questions.
The Codinzhub Next-Round Playbook
What Capital One data analyst candidates who moved on did. Put together by the Codinzhub team from the experiences in this guide.
- Practise the nine OA steps above on any small dataset until each takes a minute or two.
- Write the written answers in two plain sentences: what you chose and why.
- Rehearse joins, group-by and window functions in SQL.
- Before every case, write revenue minus costs on paper and fill it in as numbers arrive.
About this guide
This guide is researched and written by the Codinzhub team. We read every Capital One interview experience we could find, kept only what candidates actually described, and rewrote it in our own words. Questions are our own short summaries; the practice links point to similar problems, not the exact interview questions. Found something out of date? Share your own experience on Codinzhub and we will update the guide.
Keep track of what you’ve learned.