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

Data Analyst

Circle k

1 rounds | 2 Coding problems

Deepak chaudhary

Experienced | May 2025

Rejected

Interview preparation journey

Journey

My preparation journey with Coding Ninjas as a Data Analyst began with revising the fundamentals of SQL, Excel, and Python for data analysis. I practiced solving case studies and real-world datasets to strengthen my skills in data cleaning, visualization, and reporting. Through guided sessions, I learned how to approach analytical problems, interpret business requirements, and present insights effectively. I also explored tools like Power BI and Tableau, which helped me in building dashboards and creating impactful visualizations. Mock interviews and mentorship sessions further enhanced my ability to structure answers within time and boosted my confidence for assessments and interviews.

Preparation

Topics: SQL, Excel

Application process

Where: Coding Ninjas Placement Cell

Eligibility: Master’s OR Bachelor’s degree

Interview rounds

Round

Medium

Face to Face

Duration

Interview date19 May 2025

Coding problem2

1. Using ROW_NUMBER, RANK, and DENSE_RANK in SQL

Write SQL queries to demonstrate the use of ROW_NUMBER(), RANK(), and DENSE_RANK() window functions on an employee dataset. The queries should assign rankings to employees within their department based on salary, highlighting the differences between these functions in handling duplicate values.

Problem approach

SELECT
name,
salary,
ROW_NUMBER() OVER (ORDER BY salary ASC) AS row_num,
RANK() OVER (ORDER BY salary ASC) AS rank,
DENSE_RANK() OVER (ORDER BY salary ASC) AS dense_rank
FROM Employees;

2. Calculate Running Total of Budget in DAX

Write a DAX formula to calculate the cumulative (running) total of the Budget column in a table. The running total should sum all budget values up to the current row’s date, allowing analysis of budget accumulation over time.