Accenture Data Analyst interview preparation and practice

For analyst hiring Accenture usually starts with an online assessment covering aptitude, verbal ability and a data-interpretation block, and often a communication check. Depending on the role level and whether it is campus or lateral, a technical screen on SQL, Excel and basic statistics follows, then a technical interview and an HR round.

What they are really testing is whether you can turn a vague business question into a query, sanity-check the result, and communicate it. Analysts at Accenture sit close to clients, so clear explanation carries as much weight as the query itself.

SQL is the core. Be ready to write, aloud or on a shared screen, queries using JOINs, GROUP BY with HAVING, window functions (ROW_NUMBER, RANK, running totals), and subqueries. A classic archetype: find the top three products by revenue per region, or the second-highest value per group. Explain your logic as you build the query. Most Accenture Data Analyst / Data Science Jobs at this level assume fluency in exactly the SQL and case-reasoning patterns above, so drilling them pays off directly.

Excel questions probe VLOOKUP/XLOOKUP, INDEX-MATCH, pivot tables, conditional aggregation (SUMIFS, COUNTIFS) and how you would clean a messy sheet with duplicates and inconsistent formats.

Statistics stays applied: mean versus median and when each misleads, what a percentile tells you, correlation versus causation, and how you would detect and handle outliers. You may be asked how you would investigate a metric that dropped 20 percent week on week.

• Strong answer: states an assumption, structures the query or approach, and names one way the result could be wrong.
• Weak answer: jumps to a chart without checking the data, or recites a definition without an example.

Expect a light case: you are given a scenario (declining sales, a spike in support tickets, a marketing spend question) and asked how you would analyse it. Interviewers want structure. Frame the question, list the data you would pull, propose the metric, and state what a good versus bad result would look like. Talk through segmentation, before-after comparison, and confounders.

The technical interview also revisits your projects: which dashboards you built, in which tool (Power BI, Tableau, Excel), what decision the analysis drove, and one insight that surprised the stakeholder.

The HR round covers why Accenture, relocation and shift flexibility, and a behavioural story or two. Prepare a two-minute introduction and one example of explaining a technical finding to a non-technical audience, that is exactly the skill the role needs.

Prep sequence

• Solve 30-40 SQL problems across joins, aggregation and window functions.
• Rebuild two portfolio dashboards you can narrate end to end.
• Practise three business-case walkthroughs aloud, each under three minutes.

Analysts are hired on how they reason aloud, not just what they know. InterviewPrep offers a free AI voice mock interview: give it your CV and an Accenture Data Analyst job description and it runs a realistic technical-and-behavioural mock, then scores your answers, pace and filler words. It is the fastest way to hear whether your case walkthroughs sound structured or rambling before the real panel does.