KollegeApply interview experience Real time questions & tips from candidates to crack your interview
Data Analyst
KollegeApply
1 rounds | 1 Coding
problems
Rejected
Interview preparation journey
Journey
My preparation focused on building strong technical and analytical skills step by step. I started with Excel and Google Sheets for quick data cleaning and analysis, then moved to SQL for efficient data extraction and querying. To enhance visualization, I learned Power BI/Tableau and practiced creating dashboards that simplify decision-making.
Preparation
Topics: Excel, SQL
Application process
Where: Coding Ninjas Placement Cell
Eligibility: Any graduate
Interview rounds
01
Round
Easy
Online Coding Interview
Duration
Interview date6 Sep 2025
Coding problem1
1. Excel, SQL basics
- Can you explain what the company Kollegeapply does?
- What is VLOOKUP in Excel, and how does it differ from XLOOKUP?
- Can you walk me through the different types of SQL joins?
- What is the difference between a LEFT JOIN and a RIGHT JOIN?
- What is conditional formatting in Excel/Google Sheets, and how is it used?
- What is data validation in Excel/Google Sheets, and why is it important?
- Here are two queries—can you run them and explain the output?
Here's your problem of the day 
Solving this problem will increase your chance to get selected in this company
Skill covered: Programming
What is the purpose of the return keyword?
Choose another skill to practice
Similar interview experiences
SDE - Intern
1 rounds | 3 problems
Interviewed by Amazon
Selected 
3407 views
0 comments
0 upvotes
Data Analyst
1 rounds | 1 problems
Interviewed by KollegeApply
Rejected
206 views
0 comments
0 upvotes
Data Analyst
1 rounds | 1 problems
Interviewed by KollegeApply
Rejected
122 views
0 comments
0 upvotes
Data Analyst
1 rounds | 1 problems
Interviewed by KollegeApply
Rejected
151 views
0 comments
0 upvotes