AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Adglobal360 Digital Data Analyst Interview Questions and Answers
Adglobal360 Digital Data Analyst Interview Experiences
1 interview found
Anonymous
I applied via Naukri.com and was interviewed in Dec 2021. There were 3 interview rounds.
Interview Questionnaire
3 Questions
- Q1. About pre job responsibilities
- Q2. Know about excel
- Q3. Why do you want to job change
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
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
Mayur Sharma
(2 Questions)
- Q1. Where do see yourself in 5 years?
- Ans.
In 5 years, I see myself as a senior business analyst leading a team and contributing to strategic decision-making.
Leading a team of analysts
Contributing to strategic decision-making
Continuing professional development and certifications
Possibly pursuing a management role
Enhancing industry knowledge and expertise
- Q2. Why Epsilon? And why are you leaving your current organisation?
- Ans.
I am interested in Epsilon's innovative approach to data analytics and leaving my current organization for career growth opportunities.
Epsilon's reputation for cutting-edge data analytics solutions
Opportunity for career growth and development at Epsilon
Excited about working with a new team and learning new skills
(2 Questions)
- Q1. What is rank in sql .. kind of scenario based
- Q2. Examples of with/ sub query in sql
- Ans.
Using subqueries in SQL allows for more complex queries by nesting queries within other queries.
Subquery in SELECT statement: SELECT column_name FROM table_name WHERE column_name = (SELECT column_name FROM table_name)
Subquery in WHERE clause: SELECT column_name FROM table_name WHERE column_name IN (SELECT column_name FROM table_name)
Subquery in FROM clause: SELECT column_name FROM (SELECT column_name FROM table_name) A
(2 Questions)
- Q1. Tell about work experience
- Q2. Details about skill set
Skills evaluated in this interview
Selected
I applied via Campus Placement and was interviewed in Sep 2023. There were 5 interview rounds.
Simple aptitude questions
One easy leetcode problem and few MCQ on SQL/SAS/R/Python
(1 Question)
- Q1. Interview on statistics, probability
(1 Question)
- Q1. Behavioural questions
Interview Preparation Tips
prepare statistics concepts well. Coding will be easy
Selected
I applied via Campus Placement and was interviewed before Mar 2023. There were 4 interview rounds.
30 mins, Aptitude questions
SQL queries and bascis Python questions
(1 Question)
- Q1. Questions on my resume, my projects, basic python questions
(1 Question)
- Q1. Behavioural questions
I applied via Naukri.com and was interviewed in Jan 2022. There was 1 interview round.
(2 Questions)
- Q1. All questions were related to SQL and Context of the role
- Q2. Joins, Unions and case scenario
Interview Preparation Tips
I applied via LinkedIn and was interviewed in May 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Details of current Role & responsibilities and usual BA questions
Interview Preparation Tips
Native editor
I applied via Campus Placement
Basic aptitude question, 50mins 50Qs
1 easy leetcode problem in 30mins and few MCQs based on SQL and SAS
(1 Question)
- Q1. Conceptual questions on machine learning and statisitcs
(1 Question)
- Q1. Behavioural questions
Interview Preparation Tips
Selected
I applied via Campus Placement and was interviewed before Mar 2023. There were 3 interview rounds.
SQL, python, Java, logical, quant and basic English test
(1 Question)
- Q1. Correlation between one or two lists, basic ques on application of ML, questions based on projects etc
(1 Question)
- Q1. What would you do if you recieve a better offer, what would you do if you are assigned a harsh deadline, etc
Tell us how to improve this page.
Adglobal360 Interviews By Designations
- Adglobal360 Group Head Interview Questions
- Adglobal360 Accounts Manager Interview Questions
- Adglobal360 Senior Developer Interview Questions
- Adglobal360 Assistant Manager Interview Questions
- Adglobal360 Senior Content Writer Interview Questions
- Adglobal360 Business Analyst Interview Questions
- Adglobal360 Senior Data Analyst Interview Questions
- Adglobal360 Search Engine Marketing/SEM Specialist Interview Questions
- Show more
Interview Questions for Popular Designations
- Digital Marketing Executive Interview Questions
- Digital Marketing Manager Interview Questions
- Digital Marketer Interview Questions
- Digital Marketing Intern Interview Questions
- Digital Marketing Analyst Interview Questions
- Digital Marketing Specialist Interview Questions
- Senior Digital Marketing Executive Interview Questions
- Digital Design Engineer Interview Questions
- Show more
Interview Questions from Similar Companies
Adglobal360 Digital Data Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Data Analyst
58
salaries
|  ₹3 L/yr - ₹9.2 L/yr |
|
Business Analyst
52
salaries
| ₹4.4 L/yr - ₹12 L/yr |
|
SEO Executive
44
salaries
| ₹2 L/yr - ₹5 L/yr |
|
Assistant Manager
41
salaries
| ₹4 L/yr - ₹10.5 L/yr |
|
Accounts Manager
40
salaries
| ₹4.5 L/yr - ₹9.6 L/yr |
Epsilon
Denave
Smollan Group
ChannelPlay
- Home >
- Interviews >
- Adglobal360 Interview Questions >
- Adglobal360 Digital Data Analyst Interview Questions
