Edirae
Start learning free

Interview Prep Builder

Turn any job post into a prep plan.

Paste the job description and Edirae builds a track for that exact role, with the interview questions as the checkpoints you have to pass before the real thing.

Start learning freeSee it work

Northwind·Data Analyst·12 days to go

Readiness64%
Start Mock Interview
Interview

Northwind Data Analyst prep

  • Joins and aggregation under time pressureTechnical Screen Strong area ~25 min
  • Window functions for cohort analysisTechnical Screen Biggest gap ~30 min
  • 3Designing a daily metrics pipelineSystem Design Biggest gap ~40 min
  • 4Telling a data story to non-analystsBehavioral Moderate gap ~20 min
72OUT OF 100 ATS fit reviewPromising, with room to tuneYour CV shows the SQL. It undersells the stakeholder work this role asks for.

Built from the job post

Paste the job description, add the company, the role and your interview date. Add your CV and it is checked against the role too.
  • Topics taken from the job description
  • Each section marked by interview round
  • Your biggest gaps put first

Prepare for an Interview

Tell Edirae about the role. We'll build a learning track tuned to the job, with interview questions as the gates.

Company name

Northwind

Role / job title

Data Analyst

Job description

We are hiring a Data Analyst to own our product metrics. You will write SQL daily, build cohort and retention analyses, design reliable reporting pipelines, and explain what the numbers mean to teams who do not live in spreadsheets. Strong SQL (window functions, CTEs) required...

Interview date (optional)

Oct 19, 2026

Your CV / resume (optional)

Upload my-resume.pdf
Generate Interview Build

Interview questions as gates

You move on by answering the kind of question the interviewer will ask. Each answer is scored against what a strong answer shows, and the gap is named.
  • Scored on each part of a strong answer
  • The one gap to fix, in plain words
  • Resubmit until it passes
Article Flashcard Gates Mock

Interview question

Monthly active users dipped 8% in March. Walk me through the query you would write to find which signup cohort drove it.

What We're Looking For

  • · Groups users by signup month and compares retention month over month
  • · Uses a window function rather than a self join
  • · Says what the result means for the product team

Dimension Scores

  • Correct use of window functions82%
  • Explains the business meaning74%
  • Handles edge cases (ties, NULLs)41%

Primary Gap: say how you break ties and treat users with no activity, then resubmit.

Practice out loud

Say your answer instead of typing it. Speaking is how you will answer on the day, so it is how you practise.
  • Answer gates by voice
  • Your words become your submission
  • Rehearse until it sounds like you

Behavioral · Gate 2

Tell me about a time your analysis changed a decision someone had already made.

Your Submission

Our team was about to cut the free plan. I split churn by signup source and found free users from referrals upgraded at twice the rate, so we kept the plan and changed who saw it
Listening… tap to stop

Walk in ready

Finish with a mock round scored question by question, and a readiness score you can trust on the morning of the interview.
  • A full mock round for the role
  • Feedback on every answer
  • Readiness that counts down to the day

Northwind·Data Analyst·2 days to go

Readiness100%
Start Mock Interview

Technical Screen · Readiness

78%

Strong mock, you cleared the bar.

  • How would you find the top three products by revenue in each region?

    Clear use of RANK with PARTITION BY. Mentioned ties.

  • A dashboard shows conversion up 30% overnight. What do you check first?

    Good instinct to check tracking changes before celebrating.

  • Explain a p-value to a product manager.

    Accurate, but too technical. Lead with what it means for the decision.

Everything you learn, kept and brought back before you forget.

Start learning free

Explore other features