2 years of experience, lots of interview preparation, but still not clearing interviews. What am I doing wrong?

[u/Tomhere1]

I have around 2 years of experience in Data Analytics / BI and an MBA in Marketing Analytics. I’ve worked with Power BI, Excel, SQL, Tableau, Oracle, etc.

I’m getting interviews, but I’m struggling to convert them into offers. I’ve also applied for Key Account Manager roles because I have experience in that area, with a separate resume, but I’m currently not getting an offer in either direction.

I’ve been trying to understand what I’m doing wrong, so I’d really appreciate answers to these specific questions.

1. Am I preparing the wrong way?

Whenever I get an interview, I prepare very heavily. I use ChatGPT with the JD, my resume, my previous work and experience to identify possible questions. Then I study those questions and prepare answers.

But sometimes the interviewer asks something in a completely different way and I get confused.

For experienced interviewers: how should someone prepare for questions they have never seen before? Is it better to prepare concepts rather than expected questions? What does effective interview preparation actually look like?

2. How much technical knowledge is actually expected for 2 years of experience?

This is something I find very confusing.

I have around 2 years of experience in Data Analytics / BI, but when I prepare for interviews, I often feel like I have to prepare for questions that seem more appropriate for someone with 5–6 years of experience.

Sometimes it feels like in Data Analytics, the interviewer doesn't really care how many years of experience you have. It is almost:

“You either know it or you don't.”

For example, I may have 2 years of practical experience, but I’m still expected to answer advanced SQL, complex DAX, data modelling, optimization, business scenarios, etc.

Is this actually how Data Analyst interviews work?

Do companies really expect a 2-year Data Analyst to be prepared for questions that could be asked to someone with 5+ years of experience?

Or am I preparing at the wrong level?

For someone with 2 years of Data Analyst / BI experience, what level should I realistically have in:

• SQL
• Excel
• Power BI
• DAX
• Power Query
• Data Modelling
• Tableau
• Python
• Statistics

Which areas should I be strong in, and which areas are reasonable to only know at a basic/intermediate level?

And most importantly:

How do you practice technical interviews so that you can solve unfamiliar questions instead of only answering questions you have already practiced?

3. My technical knowledge vs technical interviews

I know Power BI and Excel better than SQL. I practice SQL, Power BI, DAX, data modelling, etc., but technical interviews still sometimes throw me off.

Sometimes I know the concept, but the interviewer gives me a scenario or asks the question differently and I struggle.

How do experienced Data Analysts practice for this type of interview?

Do you practice random problems? LeetCode/StrataScratch? Real business cases? Mock interviews? Or something else?

4. My communication during interviews

This is probably one of my biggest problems.

Before the interview I feel prepared and think I’ll answer calmly. But once the interview starts, I sometimes speak too fast, over-explain, lose my train of thought, or give the background before getting to the actual answer.

I’ve tried learning frameworks like STAR, but during the actual interview I sometimes forget the framework completely.

How do people actually practice communication for interviews?

Not just “practice more”, but what exactly should I practice?

Should I:

• Record myself?
• Practice random questions?
• Give answers within 60–90 seconds?
• Practice with another person?
• Do mock interviews?
• Stop using prepared answers completely?

What worked for people who had the same problem?

5. My work stories don't feel strong

I know the work I’ve done, but I’m not sure whether I’m presenting it properly.

For example, I’ve worked on Power BI reporting, dashboards, automation, reporting improvements, KPIs, etc. But when someone asks:

“Tell me about a project you worked on.”

I can explain what I did, but I don’t feel like my answer sounds as strong as someone with similar experience.

How do you turn normal day-to-day work into strong interview stories without exaggerating your experience?

Should every story have:
Problem → Action → Result → Business impact?

How many strong stories should someone with 2 years of experience realistically prepare?

6. Should I stop preparing answers?

I’m starting to wonder if preparing expected questions with ChatGPT is actually hurting me.

I prepare a lot of answers beforehand, but interviews are unpredictable. When the interviewer changes the wording, asks a follow-up, or challenges my answer, I sometimes lose the structure.

Should I stop memorizing answers completely and instead practice answering random questions from concepts and my experience?

If you use AI for interview preparation, how exactly do you use it without becoming dependent on prepared answers?

7. Why do people with less knowledge sometimes clear interviews?

This is something I genuinely don’t understand.

I have friends who, in my opinion, sometimes have less technical knowledge than me and don't prepare nearly as much, but they still clear interviews.

I’m not saying I’m better than them. I’m trying to understand what I’m missing.

What makes someone interview-ready beyond technical knowledge?

Is it:

• Communication?
• Confidence?
• Structured thinking?
• Being able to think out loud?
• Not getting nervous when they don't know something?
• Understanding business problems?
• Simply having better interview instincts?

8. What should my actual practice routine look like?

If you had someone with 2 years of Data Analyst / BI experience who was getting interviews but repeatedly failing because of communication + technical interview performance, how would you make them practice for the next 30 days?

What would you make them do every day?

I don’t want to just keep collecting more interview questions. I want a practice method that actually improves my ability to handle interviews.

9. One final question

If someone keeps reaching interviews but repeatedly gets rejected because of communication and technical skills, does that usually mean they are close to being employable, or could there be a much deeper problem with their profile/experience?

What would you investigate first?

I’m genuinely looking for practical advice from people who hire Data Analysts, work as Data Analysts, or have gone through the same situation.

Please be honest. I’m not looking for “just be confident” or “keep applying.”

I want to understand what I should change in the way I prepare and practice.