AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
Cheil
India
Work with us 
Compare
Filter interviews by
Cheil India Data Analyst Interview Questions and Answers
Cheil India Data Analyst Interview Experiences
1 interview found
Anonymous
I applied via Naukri.com and was interviewed in Oct 2022. There were 4 interview rounds.
Mathematics, English and Reasoning..
(2 Questions)
- Q1. What is python? What is uses of python?
- Ans.
Python is a high-level, interpreted programming language used for web development, data analysis, artificial intelligence, and more.
Python is easy to learn and has a simple syntax.
It is used for web development with frameworks like Django and Flask.
Python is popular for data analysis and visualization with libraries like Pandas and Matplotlib.
It is used for artificial intelligence and machine learning with libraries li...
- Q2. Some coding based questions of python.
(3 Questions)
- Q1. Salary and work discussionion
- Q2. Short and long term goals.
- Q3. Work Role, post and company work.
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
(3 Questions)
- Q1. Questions were on my resume
- Q2. And also questions more on SQL and python
- Q3. Asked have you worked on any dash boards
Selected
I applied via LinkedIn and was interviewed before Aug 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Difference between union and union all in SQL?
- Q2. How to show top 5 in pandas?
- Ans.
To show top 5 in pandas, use the nlargest() function.
Use the nlargest() function with the 'n' parameter set to 5 to get the top 5 values in a pandas DataFrame.
For example: df['column_name'].nlargest(5) will return the top 5 values in the specified column.
(1 Question)
- Q1. If we have 3 numerical columns, which chart is a better representation these column?
- Ans.
A scatter plot is a better representation for 3 numerical columns.
Use a scatter plot to show the relationship between the numerical columns.
Scatter plots are effective for visualizing correlations and patterns in data.
Each point on the plot represents a data point with values from all 3 columns.
Interview Preparation Tips
- SQL Server
- Pandas
- Power Bi
Skills evaluated in this interview
Interview Questionnaire
2 Questions
- Q1. Little discussion on my project
- Q2. Given a chessboard and the initial position of horse. If “n” is the number of steps the horse can make then what is probability that it goes out of board ?
- Ans.
Probability of a horse going out of a chessboard in 'n' steps.
The total number of possible moves for a horse is 8.
The probability of going out of the board depends on the position of the horse.
For example, if the horse is at a corner, the probability of going out of the board is higher.
The probability can be calculated using combinatorics and geometry.
Interview Preparation Tips
Experience: They did not expect any code in this round. An algo or pseudo code is fine.
1) You are given 2 vessels with capacity M liters and N liters capacity and infinite supply of water. You need to find the minimum number of steps required to get P liters. Any of the below action is considered a step
a) Filling vessel with water
b) Emptying vessel
c) Pouring water from one vessel to another vessel.
2) Given n sets each containing m integers. You need to create MinDiff set by picking exactly 1 element from each set. The difference between the maximum and minimum elements in the MinDiff set should be minimum.
eg: for the sets {30, 20, 10, 40},{ 22, 33, 44, 99},{ 16, 17, 18, 19} min diff set is {19, 20, 22}. Max and min elements in MinDiff set are 22 and 19 and their difference is 3.
Round: Technical Interview
Experience: 1) you will be given the binary representation of the numbers in the form of 2D array.eg: r1- 00001
r2- 00100
r3- 01010
r4- 00110
r5- 00111 This means the elements are 1, 4, 10 , 6 and 7.
A number “n” is given. Let us say that n can be formed by doing bitwise OR operation on rows of given matrix. What is the minimum number of rows that needs to be deleted from the matrix so that “n” can never be formed by doing the OR of the rows.
If n is 14(01110) then it can be formed by doing r2|r3 or r3|r4. You can prevent n formation either by deleting {r2,r4} or {r3}. But {r3} has least number of elements so it is the required set.2) Find the average of mid 50% of elements in the running stream of integersI have not cleared round-II so no further questions.
College Name: IIT GANDHINAGAR
Questions on SQL excel and BI tools
Technical skills deep understanding
(1 Question)
- Q1. Execution of SQL
- Ans.
Execution of SQL involves writing and running queries to retrieve, manipulate, and manage data in a database.
Write SQL queries to retrieve specific data from database tables
Use SQL functions and operators to manipulate data
Execute SQL statements to update or delete records in database
Manage database schema by creating, altering, or dropping tables
Optimize SQL queries for better performance
(1 Question)
- Q1. Fitment round and cultural
Skills evaluated in this interview
45 min very easy MCQ test on hacker rank covering aptitude , MySQL and MS Excel topics.
(1 Question)
- Q1. SQL queries,Python,Pandas,Numy,MS Excel
(1 Question)
- Q1. Behavioural questions
Interview Preparation Tips
Selected
(2 Questions)
- Q1. Prepare SQL and Pyspark well
- Q2. Prepare well on SQL Joins
(1 Question)
- Q1. Read about Programmatic advertising
abishek saju
(1 Question)
- Q1. Why do you want to work here
(1 Question)
- Q1. Explain your previous work experience
Selected
(1 Question)
- Q1. EXPLAINATION of DSP and SSP
- Ans.
DSP stands for Demand-Side Platform and SSP stands for Supply-Side Platform in the context of programmatic advertising.
DSP is a platform used by advertisers to purchase ad inventory in real-time auctions.
SSP is a platform used by publishers to sell their ad inventory to advertisers.
DSPs and SSPs work together in programmatic advertising to automate the buying and selling of ad space.
DSPs use data and algorithms to targ...
Selected
I applied via Job Portal and was interviewed before Apr 2023. There were 3 interview rounds.
Test on Hackerrank SQL
(1 Question)
- Q1. Questions on SQL, R, Case study
Detailed discussion on use cases
Cheil India Interview FAQs
Tell us how to improve this page.
Cheil India Interviews By Designations
- Cheil India Senior Manager Information Technology Interview Questions
- Cheil India Executive Accountant Interview Questions
- Cheil India Senior Officer Interview Questions
- Cheil India Project Manager Interview Questions
- Cheil India Accountant Interview Questions
- Cheil India Senior Associate Interview Questions
- Cheil India Data Analyst Interview Questions
- Cheil India Executive Trainee Interview Questions
- Show more
Overall Interview Experience Rating
based on 1 interview experience
Interview Questions from Similar Companies
Cheil India Data Analyst Reviews and Ratings
based on 7 reviews
Rating in categories
|
Associate Account Director
131
salaries
|  ₹8.1 L/yr - ₹21.1 L/yr |
|
Executive Accountant
96
salaries
| ₹1.8 L/yr - ₹9 L/yr |
|
Account Director
58
salaries
| ₹10.3 L/yr - ₹25 L/yr |
|
Assistant Manager
45
salaries
| ₹6.5 L/yr - ₹15 L/yr |
|
Accounts Supervisor
44
salaries
| ₹6 L/yr - ₹15.6 L/yr |
Denave
Smollan Group
CPM India Sales & Marketing
ReachLocal Services
- Home >
- Interviews >
- Cheil India Interview Questions
