KollegeApply interview experience Real time questions & tips from candidates to crack your interview

Data Analyst

KollegeApply

1 rounds | 1 Coding problems

Mohd Ali

Experienced | Sep 2025

Rejected

Interview preparation journey

Journey

I built a strong foundation in Excel, SQL, and visualization tools like Power BI/Tableau, while also revising statistics and analytical concepts. Through practice with case studies and projects, I improved my problem-solving and developed the confidence to interpret and present insights effectively as a Data Analyst.

Preparation

Topics: Excel, SQL

Application process

Where: Coding Ninjas Placement Cell

Eligibility: Any graduate

Interview rounds

Round

Easy

Online Coding Interview

Duration

Interview date3 Sep 2025

Coding problem1

1. Google Sheets and Excel Functions.

Can you show me how to split a full name into first, middle, and last name in Google Sheets using a formula?
How would you use VLOOKUP between two different Excel sheets?
What is the IMPORT RANGE function in Google Sheets, and when would you use it?
Can you explain the difference between KPI reporting and a dashboard?
Tell me a bit about yourself and walk me through your past experience.