Upload Button Icon Add office photos
Engaged Employer

i

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

I Knowledge Factory Verified Tick

Compare button icon Compare button icon Compare
4.3

based on 35 Reviews

Filter interviews by

I Knowledge Factory Data Analyst Interview Questions and Answers

Updated 3 Jul 2024

1 interview found

Sort by: Popular

Data Analyst Interview Questions

user image Anonymous

posted on 3 Jul 2024

Interview experience
4
 Good
Difficulty level
 -
Duration
 -
Result
 -

1 Interview Round

1

HR Round (2 Questions)

  • Q1. Tell Me Yourself.
  • Q2. What Was Your experience

Interview questions from similar companies

Data Analyst Interview Questions

Z1 Tech user image Anonymous

posted on 31 May 2024

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

I applied via Naukri.com and was interviewed in May 2024.

2 Interview Rounds

1

Technical Round (2 Questions)

  • Q1. Questions on vlook up, h-look up, pivot and if else condition
  • Q2. You must know how to use vlook up, h-look up and if-else condition
2

Assignment Round

Excel file was give, used sumifs, countifs , index match formulas

Interview Preparation Tips

Interview preparation tips for other job seekers - Just learn the excel famous questions and concept like look up, index match, nested if, concate function etc
Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via LinkedIn and was interviewed before Aug 2023.

2 Interview Rounds

1

One-on-one Round (2 Questions)

  • Q1. Difference between union and union all in SQL?
  • Q2. How to show top 5 in pandas?
2

Technical Round (1 Question)

  • Q1. If we have 3 numerical columns, which chart is a better representation these column?

Interview Preparation Tips

Topics to prepare for Omnicom Media Group Data Analyst interview:
  • SQL Server
  • Pandas
  • Power Bi
Interview experience
3
 Average
Difficulty level
 Easy
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via Referral and was interviewed before Mar 2023.

2 Interview Rounds

1

Technical Round (2 Questions)

  • Q1. Some basic Python ETL Questions, based on list,dictionary.
  • Q2. SQL Basics Question
2

HR Round (1 Question)

  • Q1. Explain your projects

I applied via Referral and was interviewed in Nov 2021.

1 Interview Round

Interview Questions

Interview Preparation Tips

Interview preparation tips for other job seekers - The major focus was on Apache Spark.

Data Analyst Interview Questions

Z1 Tech user image Anonymous

posted on 31 May 2024

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

I applied via Naukri.com and was interviewed in May 2024.

2 Interview Rounds

1

Technical Round (2 Questions)

  • Q1. Questions on vlook up, h-look up, pivot and if else condition
  • Q2. You must know how to use vlook up, h-look up and if-else condition
2

Assignment Round

Excel file was give, used sumifs, countifs , index match formulas

Interview Preparation Tips

Interview preparation tips for other job seekers - Just learn the excel famous questions and concept like look up, index match, nested if, concate function etc
Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via LinkedIn and was interviewed before Aug 2023.

2 Interview Rounds

1

One-on-one Round (2 Questions)

  • Q1. Difference between union and union all in SQL?
  • Q2. How to show top 5 in pandas?
2

Technical Round (1 Question)

  • Q1. If we have 3 numerical columns, which chart is a better representation these column?

Interview Preparation Tips

Topics to prepare for Omnicom Media Group Data Analyst interview:
  • SQL Server
  • Pandas
  • Power Bi
Interview experience
4
 Good
Difficulty level
 Easy
Duration
 2-4 weeks
Result
 No response

I applied via Campus Placement and was interviewed before Feb 2023.

2 Interview Rounds

1

Aptitude Test Round

It want really good, aptitude test, focus on basic

2

One-on-one Round (1 Question)

  • Q1. Case study, interview, guestimates, python, SQL, power bi, Excel
Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via LinkedIn and was interviewed before Oct 2022.

4 Interview Rounds

1

Resume Shortlist Round

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
2

Coding Test Round

Basic dsa question in python and data engineering questions ,sql

3

Coding Test Round

Basic dsa question in python and data engineering questions

4

HR Round (1 Question)

  • Q1. Salary negotiation
Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 2-4 weeks
Result
Selected  Selected

I applied via LinkedIn and was interviewed before Apr 2022.

4 Interview Rounds

1

Resume Shortlist Round

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
2

HR Round (1 Question)

  • Q1. Majorly about previous work experience.
3

Technical Round (1 Question)

  • Q1. Asked me to build a dashboard in Google sheet and advance Excel test
4

HR Round (1 Question)

  • Q1. Salary and other discussions

Interview Preparation Tips

Topics to prepare for Z1 Tech Associate Data Analyst interview:
  • advance excel
  • google sheet
  • Google Analytics
  • google studio
Interview preparation tips for other job seekers - be sound with your skills.. rest will fall in place.

I Knowledge Factory Interview FAQs

How many rounds are there in I Knowledge Factory Data Analyst interview?
I Knowledge Factory interview process usually has 1 rounds. The most common rounds in the I Knowledge Factory interview process are HR.

Tell us how to improve this page.

I Knowledge Factory Data Analyst Reviews and Ratings

based on 1 review

4.0/5

Rating in categories

4.0

Skill development

4.0

Work-Life balance

3.0

Salary & Benefits

4.0

Job Security

5.0

Company culture

4.0

Promotions/Appraisal

4.0

Work Satisfaction

Explore 1 Review and Rating
Social Media Executive
6 salaries
unlock blur

₹2.4 L/yr - ₹3 L/yr

UI Developer
5 salaries
unlock blur

₹3.2 L/yr - ₹5.2 L/yr

Graphic Designer
5 salaries
unlock blur

₹3 L/yr - ₹5 L/yr

PPC Analyst
4 salaries
unlock blur

₹2 L/yr - ₹5.2 L/yr

Senior SEO Analyst
4 salaries
unlock blur

₹5.2 L/yr - ₹7 L/yr

Explore more salaries
Compare I Knowledge Factory with

IIHT Technologies

4.2
Compare

Edureka

3.3
Compare

NIIT

3.6
Compare

Manipal ProLearn

5.0
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview