Accenture Data Analyst Case Interview – 360° Value Client Analytics (Interviewer-Led)

This case mirrors Accenture’s client-centric, interviewer-led style and focuses on delivering measurable 360° Value for a global subscription retailer migrating to Cloud First. You’ll be asked to: 1) Clarify the client brief and define a MECE problem structure; 2) Identify North Star KPIs (e.g., churn, conversion, LTV, NPS) and supporting diagnostics; 3) Outline data sources and a lightweight data model spanning transactions, digital channels, and service interactions; 4) Draft 2–3 SQL-style queries or Excel/Python steps to profile data quality, segment customers, and calculate KPIs; 5) Sketch a Power BI dashboard (key visuals, filters, drill-throughs) to enable executive and operational views; 6) Quantify a value case (baseline, impact levers, assumptions, quick wins vs. build) and propose a 90-day roadmap; 7) Communicate trade-offs, risks, and data governance considerations (privacy, access, lineage), and align recommendations to Accenture’s Client Value Creation and One Global Network ethos. The interviewer will guide you with targeted prompts and may share a small, simplified dataset or exhibit pages. Expect to: structure hypotheses, interpret messy data, do quick math, and translate analytics into business actions. Assessment emphasizes: problem framing under ambiguity; SQL/Excel reasoning; data quality and KPI rigor; clear storytelling and stakeholder alignment; practicality of the value roadmap; and awareness of change management and ethical use of data—all consistent with Accenture’s delivery-focused culture.