Prepstellar
Get it on Google Play

Data Analyst Interview Prep · Interview Loop and Assessment Criteria

16 cards

Interview Loop and Assessment Criteria

Swipe, scroll or use ← →
  1. What the role is assessed on

    A data analyst collects, manages, explores and shares data to support organisational objectives and deliver business impact. That one sentence sets the scope of the whole loop: you are scored on the path from raw data to a decision somebody can act on, not on one tool in the middle of it.

    The published role standard breaks the level down into three habits: prepare and manage data, apply appropriate techniques and tools, and communicate data to stakeholders with different needs. Expect each of the three to appear somewhere in the interview.

    1 / 16
  2. What the role is assessed on

    Neighbouring jobs own the stages either side.

    Role Stage it owns
    Data engineering Building and running pipelines
    Data science Putting prediction models into a product
    Database administrator Backups and access requests
    Data analyst (this role) From data to a decision

    Claiming one of the other stages describes a different role, not a smaller version of this one.

    2 / 16
  3. Quick check

    An interviewer asks which part of the work you own as an analyst. Which answer matches the published role?

    1. ACollecting, managing, exploring and sharing data so the organisation can act on it.

      The role covers the whole path from data to a decision, and its purpose is business impact.

    2. BBuilding the pipelines that move data into the warehouse for the rest of the business.

      Pipelines and storage platforms are data engineering, a neighbouring role.

    3. CDeploying prediction models and keeping them running inside the product itself.

      Shipping models into a product belongs to data science and machine learning engineering.

    3 / 16

  4. Prepare from the job description

    The job description names the skills the panel will look for, so it decides which examples are worth rehearsing. Read it before you plan anything else, then pick the two or three pieces of your own work that show those exact skills.

    Preparation is evidence, not coverage. Drilling your weakest tool, reusing your freshest project or reading the employer's product news can all help later, but none of them points to the skills this role needs most.

    4 / 16
  5. Prepare from the job description

    A stage may be a technical discussion, a coding exercise, a portfolio review or a presentation of work samples. Those four need different preparation, so ask the recruiter which one you will face. A question such as "which language should I practise?" quietly assumes a format you may not get.

    The interview runs both ways: the hiring team gets to know you and you get to know the team, so bring questions about the role and the people in it.

    5 / 16
  6. Quick check

    A recruiter confirms a second stage but does not describe it. Which question helps you prepare most?

    1. AWhich programming language I should practise before the session.

      It assumes a coding exercise, which may not be the format at all.

    2. BWhether it is a discussion, a coding exercise, a portfolio review or a work sample.

      Each of the four formats needs different preparation, so the format comes first.

    3. CWhich of my past projects the panel would most like me to walk through.

      It assumes a portfolio review, so a confident answer can still send you the wrong way.

    6 / 16

  7. Show how you think

    Briefs in interviews are deliberately underspecified. When the brief is ambiguous, ask which data, which period and which audience count, and say out loud which assumptions you are making. Then agree a plan before you start to implement anything. The round is short, and the plan is what keeps it inside the time box.

    Worked example. The interviewer asks why sales fell, and you have little time. First, ask which sales measure, which period and which audience matter. State any assumption you cannot confirm. Next, compare a quick summary by month with a fuller breakdown by product. Say what each one can answer and what it leaves uncertain, then pick the one that still leaves time to check the result. If the check fails, describe the failure and narrow the conclusion instead of widening it.

    7 / 16
  8. Show how you think

    Talking through your approach, including the tools you chose and why, is what makes the problem solving observable. A correct final table shows where you arrived, not how you got there. A cross-check, a cleaner chart or a faster run all improve the delivery and still leave the reasoning hidden.

    8 / 16
  9. Quick check

    You reach the right result in silence and show a clean final table. The panel says it cannot score your problem solving. What was missing?

    1. AA second method that lands on the same number.

      A cross-check raises confidence in the number, not visibility of the reasoning.

    2. BA chart that presents the final table more clearly.

      Presentation polish does not reveal any of the choices you made.

    3. CSaying out loud which tools you chose and why.

      Naming the tool and the reason for it is what turns a result into observable reasoning.

    9 / 16

  10. Keep your progress in the app

    That’s 3 of 6 quick checks. In the app they stay answered, and every lesson remembers where you left off.

    Get it on Google Play Keep reading here
  11. Structure your examples with STAR(R)

    The STAR(R) structure covers Situation, Task, Action, Result and Reflection, and the final R is what you learned and would do differently. The first four elements are the story; the fifth is the one an interviewer cannot infer from it.

    Letter Element What the panel hears
    S Situation The context you were working in
    T Task The goal you owned
    A Action The steps you took
    R Result The outcome, with a number where you have one
    R Reflection What you learned and would change

    Keep the action in the first person. "The team migrated the report" tells the panel nothing about you; "I defined the measure and checked the duplicates" does.

    10 / 16
  12. Quick check

    You have described the situation, the task, the steps you took and the result. What still completes the structure?

    1. AMore background about the organisation and the team.

      Background belongs to the situation, which is already covered.

    2. BWhat you learned and would do differently next time.

      Reflection is the closing element, and it is the part the panel cannot infer.

    3. CA fuller account of the task you were assigned.

      More task detail repeats the second element instead of adding the missing one.

    11 / 16

  13. Work inside the constraint

    A technical round scores how you break the problem down and the methods you use, not only the final answer. Two candidates can hand in the same number and score differently: one showed the framing and the checks, the other showed only the output.

    When you finish a solution, test it before you call it done, and if a case fails, say what failed and what your conclusion still covers. An unfinished check is information the panel wants. Spending the last two minutes on a rushed fix usually ends with neither the fix nor the explanation.

    12 / 16
  14. Work inside the constraint

    Communicating data to stakeholders with different needs means leading with the decision and its limit, then going deeper for whoever asks. With a manager and an analyst in the same room and two minutes left, the plain answer and the caveat come first; the mechanism goes to the person who wants it.

    13 / 16
  15. Quick check

    Two minutes left, a manager must decide today and an analyst wants to know why a check failed. What do you say?

    1. AWalk through the failed check in full, since nobody should decide on weak evidence.

      A full technical account uses the whole slot and never reaches the decision.

    2. BRepeat the main finding and move every technical question to a later conversation.

      Repetition adds no information for either listener.

    3. CGive the decision and its limit in plain words, then the detail on request.

      Each listener gets what they need: the decision with its caveat, then the mechanism on request.

    14 / 16

  16. Review your own attempt

    A practice round that felt bad is not something you can act on. A useful self-review separates problem framing, technical correctness, validation and communication, so one hour goes to the part that failed. Score the attempt on each of the four, then spend the time on the lowest one.

    Reflection is also what you owe the next round. Repeating the whole exercise rehearses your strong parts as often as your weak ones, and polishing the opening assumes you already know where it broke.

    15 / 16
  17. Quick check

    A practice round went badly and you have one hour before the next. How do you choose what to work on?

    1. ASplit the attempt into framing, correctness, validation and communication, then fix the weakest.

      Splitting the attempt into parts turns a vague feeling into the one thing worth an hour.

    2. BRun the whole exercise again from the start until it feels smoother.

      Repetition rehearses the strong parts as often as the weak one.

    3. CRehearse the opening answer, since first impressions carry the most weight.

      The opening matters, but it may not be where this attempt broke.

    16 / 16

  18. 6 quick checks · then the test

    In the app, finishing the quick checks opens this lesson’s 10-question test, and the ones you miss come back exactly when you’re about to forget them.

    Take this lesson’s test → Get it on Google Play
← Previous Get it on Google Play Next card →

The whole course, on your phone

Lessons you can read, audio you can listen to on the way to work, and practice that remembers what you got wrong.

Get it on Google Play

“This app is the ‘One Lake’ for preparing the certification exams. Really worth it.”

Abdelhak Y. Google Play review