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

Data Analyst

KollegeApply

1 rounds | 1 Coding problems

Niharika Rasania

Experienced | Sep 2025

Rejected

Interview preparation journey

Journey

I approached my preparation with a balance of technical tools and business understanding. I started by mastering Excel and Google Sheets for quick data analysis, focusing on formulas, pivot tables, and automation features. Next, I strengthened my SQL skills, practicing queries to handle joins, aggregations, and subqueries for extracting meaningful insights from databases.

Preparation

Topics: Excel, SQL

Application process

Where: Coding Ninjas Placement Cell

Eligibility: Any graduate

Interview rounds

Round

Easy

Online Coding Interview

Duration

Interview date6 Sep 2025

Coding problem1

1. Excel, SQL, Projects, and Self-Introduction

What technical skills do you have, and can you share examples of where you’ve applied them in real-time?
Tell me about your projects — what was the aim, why did you do them, and what insights did you gain?
Here’s some Excel data: can you use VLOOKUP and INDEX-MATCH on it?
From the same Excel data, can you calculate the total sales and also identify the earliest date?
You’re given two tables in our SQL server — can you write a query to join them, find the total sales, and also determine the earliest date?