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

Data Analyst

KollegeApply

1 rounds | 1 Coding problems

Priyanka Sharma

Experienced | Sep 2025

Rejected

Interview preparation journey

Journey

My preparation journey for the MIS Executive role focused on strengthening my technical and reporting skills. I began with Excel and Google Sheets, practicing advanced formulas, pivot tables, charts, conditional formatting, and data validation to handle and analyze large datasets efficiently. I also worked on automating repetitive tasks and ensuring accuracy in reporting.

Preparation

Topics: Excel, SQL

Application process

Where: Coding Ninjas Placement Cell

Eligibility: Any graduate

Interview rounds

Round

Easy

Online Coding Interview

Duration

Interview date11 Sep 2025

Coding problem1

1. Python, SQL, and Excel

Tell me what you know about our company?
What is the syntax of a for loop and a while loop in Python?
Can you write an SQL query using aggregate functions, for example to calculate totals or averages?
How would you use a lookup function in Excel? Can you explain with an example?
Can you create a Pivot Table in Excel and walk me through how you would use it to analyze data?