Upload Button Icon Add office photos

Filter interviews by

Utsav Fashion Senior Data Analyst Interview Questions and Answers

Updated 3 Apr 2023

Utsav Fashion Senior Data Analyst Interview Experiences

1 interview found

Senior Data Analyst Interview Questions & Answers

user image Aviram Samanta

posted on 3 Apr 2023

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Mar 2023. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(1 Question)

  • Q1. Introduction about past work and experience
Round 3 - Technical 

(1 Question)

  • Q1. Google sheets , SQL, Tableau
  • Ans. They don't know how to set questions for a technical round. They are confused itself and not able to convey questions to the interviewee.
  • Answered by Aviram Samanta
Round 4 - HR 

(1 Question)

  • Q1. General introduction

Interview Preparation Tips

Interview preparation tips for other job seekers - They don't know how to take technical round of interview. They are confused and making candidate confused too. Asking VLookup but with no lookup value. Like find VLookup from top 10 month wise product? Like seriously what is the value i want to look from the data using VLookup?
Asking SQL query but not defining the query based on SQL. Asking find the VLookup columns using SQL. It totally doesn't make any sense of their questions.

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Upgrad and was interviewed in Dec 2024. There were 3 interview rounds.

Round 1 - Coding Test 

Formulating SQL queries based on the data presented by the interviewer during the screen sharing session.

Round 2 - One-on-one 

(2 Questions)

  • Q1. Tell me about yourself
  • Q2. Questions based on past experiences
Round 3 - One-on-one 

(2 Questions)

  • Q1. Tell me about yourself and questions about past experiences
  • Q2. Salary discussion

Interview Preparation Tips

Topics to prepare for Ketto Senior Data Analyst interview:
  • SQL Queries
  • Fetching data and joins

Senior Data Analyst Interview Questions & Answers

Droom user image Shubham Chaudhary

posted on 23 Jul 2023

Interview experience
4
Good
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Job Portal and was interviewed before Jul 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - HR 

(1 Question)

  • Q1. About your job how much do you expect as a compensation
Round 3 - Technical 

(1 Question)

  • Q1. Sql and power bi joins , filters and slicer
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Recruitment Consulltant and was interviewed in Dec 2024. There were 3 interview rounds.

Round 1 - Assignment 

The assignment involved analyzing sample data from Inshorts to extract valuable insights.

Round 2 - Technical 

(2 Questions)

  • Q1. Can you elaborate on the projects that you have worked on?
  • Ans. 

    I have worked on projects involving predictive modeling, natural language processing, and machine learning algorithms.

    • Developed a predictive model to forecast customer churn for a telecommunications company

    • Implemented sentiment analysis using natural language processing techniques on social media data

    • Utilized machine learning algorithms to classify fraudulent transactions for a financial institution

  • Answered by AI
  • Q2. What were the key discussion points regarding the assignment?
  • Ans. 

    Key discussion points regarding the assignment

    • The methodology used to analyze the data

    • The key findings and insights derived from the analysis

    • Any challenges faced during the assignment and how they were overcome

    • Recommendations for future improvements or further analysis

  • Answered by AI
Round 3 - One-on-one 

(1 Question)

  • Q1. Statistics, ML models, Assignment, Case Study
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Referral and was interviewed in Jun 2024. There were 2 interview rounds.

Round 1 - Coding Test 

The assessment consists of a dataset for which we are required to build a machine learning model and submit the results along with code and detailed documentation

Round 2 - Technical 

(3 Questions)

  • Q1. What are ensemble models
  • Ans. 

    Ensemble models are machine learning models that combine multiple individual models to improve predictive performance.

    • Ensemble models work by aggregating predictions from multiple models to make a final prediction.

    • Common types of ensemble models include Random Forest, Gradient Boosting, and AdaBoost.

    • Ensemble models are often more accurate and robust than individual models.

    • They can reduce overfitting and increase genera...

  • Answered by AI
  • Q2. Difference between bagging and boosting
  • Ans. 

    Bagging and boosting are ensemble learning techniques used to improve the performance of machine learning models by combining multiple weak learners.

    • Bagging (Bootstrap Aggregating) involves training multiple models independently on different subsets of the training data and then combining their predictions through averaging or voting.

    • Boosting involves training multiple models sequentially, where each subsequent model c...

  • Answered by AI
  • Q3. A lot of tree based questions

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - Group Discussion 

Asked a few questions regarding my experience

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Mar 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Excel and SQL based questions
Round 3 - Technical 

(1 Question)

  • Q1. Python and project based questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Took 2 interviews over the course of 2 weeks and then 1 hour before my scheduled final / HR round declined to hire me as they decided that they don't want to.
Utter disregard for a candidate's time and work. The humiliating level of such degraded professionalism that they cannot decide before posting an interview that they don't want to hire.
But they have the audacity to expect 7 days and open-ended work schedule from the candidates.
DO NOT APPLY.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Jul 2023. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Tell me About yourself
  • Q2. Excel formula sum if countif
  • Ans. 

    Using Excel formula SUMIF and COUNTIF to calculate a sum based on a condition.

    • SUMIF function adds the values in a range that meet a specified condition.

    • COUNTIF function counts the number of cells in a range that meet a specified condition.

    • Combine both functions to calculate the sum based on a condition.

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Apr 2023. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Why data? Why Tokopedia? Talk about bachelor's thesis?
  • Ans. 

    Data analysis is crucial for making informed decisions. Tokopedia's vast data provides a great opportunity for analysis. My bachelor's thesis focused on data-driven insights.

    • Data allows for informed decision-making and insights.

    • Tokopedia's extensive data provides a valuable opportunity for analysis.

    • My bachelor's thesis delved into data-driven insights and analysis.

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. Walkthrough bachelor's thesis

Interview Preparation Tips

Topics to prepare for Tokopedia Data Analyst interview:
  • SQL
  • Python
  • Data Analysis
Interview preparation tips for other job seekers - Good place to start your career, office politics is tricky tho.

I applied via Indeed and was interviewed before Jun 2019. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Business problems and case studies
  • Q2. Guesstimates
  • Q3. Experience to date

Interview Preparation Tips

Interview preparation tips for other job seekers - Use your basic aptitude.

Utsav Fashion Interview FAQs

How many rounds are there in Utsav Fashion Senior Data Analyst interview?
Utsav Fashion interview process usually has 4 rounds. The most common rounds in the Utsav Fashion interview process are Resume Shortlist, One-on-one Round and Technical.
What are the top questions asked in Utsav Fashion Senior Data Analyst interview?

Some of the top questions asked at the Utsav Fashion Senior Data Analyst interview -

  1. Google sheets , SQL, Tabl...read more
  2. General introduct...read more

Tell us how to improve this page.

Utsav Fashion Senior Data Analyst Interview Process

based on 1 interview

Interview experience

1
  
Bad
View more

Interview Questions from Similar Companies

Fabindia Interview Questions
4.0
 • 52 Interviews
MagicPin Interview Questions
3.0
 • 48 Interviews
Biba Apparels Interview Questions
3.7
 • 38 Interviews
Tokopedia Interview Questions
4.0
 • 27 Interviews
Shaadi.com Interview Questions
3.3
 • 27 Interviews
HealthKart Interview Questions
3.9
 • 25 Interviews
Meritto Interview Questions
3.7
 • 22 Interviews
Furlenco Interview Questions
3.3
 • 20 Interviews
Vedant Fashions Interview Questions
4.0
 • 19 Interviews
View all
Senior Executive
18 salaries
unlock blur

₹2 L/yr - ₹3.5 L/yr

Fashion Designer
7 salaries
unlock blur

₹2.5 L/yr - ₹3.2 L/yr

SME
7 salaries
unlock blur

₹3.9 L/yr - ₹4.5 L/yr

Buyer
6 salaries
unlock blur

₹6.5 L/yr - ₹8.1 L/yr

Graphic Designer
5 salaries
unlock blur

₹2.3 L/yr - ₹6.4 L/yr

Explore more salaries
Compare Utsav Fashion with

Peachmode

2.6
Compare

Biba Apparels

3.7
Compare

Fabindia

4.0
Compare

Vedant Fashions

4.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview