Data Analyst
Interview Date
September 2024
Result
Selected
Difficulty
Medium
Rounds
3 rounds
Drive Type
Not Specified
Topics asked
Detailed experience
College: Not Specified
Interview Date: September 2024
Interview Type: Not Specified
Result: Selected
Difficulty: Medium
Rounds: 3 rounds
Topics Asked: Tableau, SQL, Puzzles, Behavioral Questions
The candidate interviewed for a Data Analyst role with 2 years of experience.
Round 1: Technical
This round focused on Tableau and SQL. Tableau questions included: "How to publish a dataset in Tableau?", "How to blend different datasources?", and "How to pivot the data?". For SQL, the candidate was given a dataset and asked to show the difference between RANK and DENSE_RANK. They were also asked how to optimize a query.
Round 2: Managerial/Behavioural
Questions in this round covered past company experience and challenges faced. The interviewer also asked a few puzzles, such as "moving a square to make it a rhombus type".
Round 3: HR Round
The HR round included questions about the reason for leaving the previous company and salary expectations.
Overall Experience: The candidate was selected as a Data Analyst.