Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by DesignCafe Team. If you also belong to the team, you can get access from here

DesignCafe Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

DesignCafe Data Analyst Interview Questions and Answers

Updated 26 Aug 2024

DesignCafe Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 26 Aug 2024

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

I applied via Naukri.com and was interviewed before Aug 2023. There were 2 interview rounds.

Round 1 - Assignment 

A project was assigned which I was supposed to complete

Round 2 - HR 

(2 Questions)

  • Q1. Where do u see yourself in 5 years
  • Ans. 

    In 5 years, I see myself as a senior data analyst leading a team and implementing advanced analytics solutions.

    • Leading a team of data analysts

    • Implementing advanced analytics solutions

    • Continuing to learn and grow in the field

    • Possibly pursuing further education or certifications

  • Answered by AI
  • Q2. Why do u want to join our company
  • Ans. 

    I am impressed by your company's innovative approach to data analysis and want to be a part of a team that values creativity and problem-solving.

    • Your company's reputation for cutting-edge data analysis techniques

    • Opportunities for professional growth and development

    • Positive company culture and team dynamics

  • Answered by AI

Interview questions from similar companies

I applied via Instahyre and was interviewed in Nov 2019. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Case studies , guesstimates, basic SQL and excel questions, discussion on how I handle unknown domain data

Interview Preparation Tips

Interview preparation tips for other job seekers - Just go through some basic case studies and guesstimates(just google) and revise basic SQL and Excel.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Approached by Company and was interviewed in Sep 2024. There were 4 interview rounds.

Round 1 - Coding Test 

General SQL questions, Window Functions, Agg Functions, Case statement logic building

Round 2 - Assignment 

SQL assignment, easier than 1st round

Round 3 - One-on-one 

(3 Questions)

  • Q1. Based on Past and current Experience
  • Q2. Project Discussion
  • Q3. Metrics Development
Round 4 - One-on-one 

(2 Questions)

  • Q1. Head of Analytics Round
  • Q2. Project discussion and case studies

Interview Preparation Tips

Topics to prepare for LivSpace Business Analyst interview:
  • SQL
  • Projects that you worked on
  • Excel
  • Guesstimates
Interview preparation tips for other job seekers - One of the Business Analyst Approached me for this post, I have accepted the proposal and I have sent the resume to the person they called after 2 days and scheduled a call on a Friday evening I attended the interview 1st round 7out of 7 questions were answered, next round was SQL assignment which is piece of cake for me, because i have already mastered the SQL, Excel and BI tools from my experience in past and current company, 3rd round was with the immediate manager round which was rescheduled because of bandwidth issue of that manager so it happened in the next day, I was discussing about the current role and daily routines and responsibilities throughout my career she is ok with it and she asked me where are located at and I said my place which is my hometown place where I was working remotely and she said "kya Homelane(current company) mein bhi wfh Chal rah hai kya?". I said yes and she asked me that If I send you the offer letter you should definitely join our company and then i said yes I will join you and after 2 days I got a call from HR stating that there is one more round where you will be having discussion with Head of Analytics I said yes and they scheduled a call, I was explaining about the projects that I have worked and everything he was ok with that and asked me, I can offer you the job but you have to come to office and I told him that I have a family situation where I cannot move from my place to Bengaluru and I also told him that if you have doubt on my productivity you can ask my previous and current company(with blind guts) he told that, it is not the problem and it is the policy which they follow in their company, which totally shocked me, they have 2 different answers(tongues), One of their manager said that she is working from home and this guy was telling me the company policy is working from office, which is not a good sign of a company as if you are candidate and also he asked me what is your current ctc I told him that this is the current CTC and he asked what is your expected CTC, I told him that I am holding an offer from a company as a product data analyst and they are offering certain amount and he asked me that if you are holding a job why are you searching a job I told him that it was a 6 days work job and also its a US shift job, he again said that he wanted me to come to office I politely said no to him, and he just waited for 30 seconds for my reply I didn't say anything so he left the meet......... Now moral of the story is that, I proved him that I am a confident, capable, beneficial and a perfect candidate for his requirement and I am working for his rival company already where I can bring experience which was demonstrated in my past & current role to improve the standards of the company, so from his perspective I want to be his workhorse near him and I will never get compensated as per my standards as well.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Job Fair and was interviewed before Dec 2022. 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 - Assignment 

You need to work on assignment which will be provided.

Round 3 - Technical 

(2 Questions)

  • Q1. Introduction , technical questions about SQL and Excel
  • Q2. Assignment related questions
Round 4 - Mangerial round 

(3 Questions)

  • Q1. Overall experience question , assignment related and question related to your resume
  • Q2. Linear regression
  • Q3. R2 value and prediction analysis as my assessment was related to that

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't lie in interview even if you don't know anything

I applied via Referral and was interviewed in Aug 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Tito Joseph will ask you random questions on the percentage calculation

Interview Preparation Tips

Interview preparation tips for other job seekers - The pricing part of the company products should be done during training, not during the interview.

Tito jospeh asked me to sell a pen first and then he started giving instances where i had to calculate the percentage of discount on the total package given to the customer.

Interview Questionnaire 

1 Question

  • Q1. Tell about yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident, Listen to the questions carefully

I applied via Recruitment Consultant and was interviewed in Feb 2021. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Tell about you self like job profile and family background
  • Q2. Please give answers honestly

Interview Preparation Tips

Interview preparation tips for other job seekers - Please give all question reply honestly. If you don't have knowledge regarding any subject please tell him truly.

I applied via Recruitment Consulltant and was interviewed before Aug 2021. There were 2 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. Tell me about yourself
Round 2 - One-on-one 

(1 Question)

  • Q1. Describe how would you increase current sale of company in your area.
  • Ans. 

    I would increase sales by identifying new potential customers and building strong relationships with them.

    • Conduct market research to identify potential customers

    • Develop targeted marketing campaigns to reach new customers

    • Offer promotions or discounts to incentivize new customers to try our products

    • Provide excellent customer service to build loyalty and encourage repeat business

    • Collaborate with other departments to ensur...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - 1- Answer with confidence
2- Knowledge about your area architects, builders, fabricators and dealers.
3- positive attitude.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Sep 2023. 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 - Aptitude Test 

About your positive attitude

Round 3 - One-on-one 

(1 Question)

  • Q1. About your job profile

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident about your self..

I applied via LinkedIn and was interviewed in Oct 2021. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Price negotiation part costing new parts development and QMS documents

Interview Preparation Tips

Topics to prepare for Ozone Overseas Assistant Manager interview:
  • Follow up with supplier
Interview preparation tips for other job seekers - Company is not for technical person

DesignCafe Interview FAQs

How many rounds are there in DesignCafe Data Analyst interview?
DesignCafe interview process usually has 2 rounds. The most common rounds in the DesignCafe interview process are Assignment and HR.
How to prepare for DesignCafe Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at DesignCafe. The most common topics and skills that interviewers at DesignCafe expect are Data Analysis, Excel, Data Analytics, Data Extraction and Data Visualization.

Tell us how to improve this page.

DesignCafe Data Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

LivSpace Interview Questions
3.6
 • 141 Interviews
HomeLane Interview Questions
3.5
 • 86 Interviews
Regalo Kitchens Interview Questions
4.0
 • 26 Interviews
Ozone Overseas Interview Questions
3.8
 • 26 Interviews
Decorpot Interview Questions
3.2
 • 18 Interviews
Eglo India Interview Questions
3.0
 • 16 Interviews
Della Group Interview Questions
3.6
 • 13 Interviews
Bonito Designs Interview Questions
2.6
 • 13 Interviews
Takenaka Interview Questions
4.0
 • 11 Interviews
View all
Sales Manager
87 salaries
unlock blur

₹5 L/yr - ₹8.9 L/yr

Senior Interior Designer
85 salaries
unlock blur

₹4 L/yr - ₹8.5 L/yr

Interior Designer
43 salaries
unlock blur

₹2.4 L/yr - ₹9 L/yr

Project Manager
41 salaries
unlock blur

₹3.3 L/yr - ₹7.5 L/yr

Senior Designer
28 salaries
unlock blur

₹4.2 L/yr - ₹9 L/yr

Explore more salaries
Compare DesignCafe with

LivSpace

3.6
Compare

HomeLane

3.5
Compare

Ozone Overseas

3.8
Compare

Regalo Kitchens

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