it was just regular interview process, asking about the past experience, interest in the field. Ask for excel skills. I interviewed for the technology department, so I was asked about my interest in technology and some related questions--trend technology
I applied through university. I interviewed at Nielsen in Feb 2021
Interview
The have three selection rounds.
1. General Aptitude and Advanced Excel Test
(30 to 45 mins test, MCQs only)
2. Advanced Excel Round
(This round is particularly difficult and needs a strong knowledge in Advance Excel, cannot be learnt in a week)
3. Excel plus PowerPoint Presentation Round
Interview questions [1]
Question 1
ROUND 2
(They will give a set of questions and an Excel workbook filled with data for 3 different case studies, 2 hours prior to the 1 on 1 interview. It tests the candidates knowledge and skills on advance excel functions and how they use INDEX, INDIRECT, VLOOKUP, OFFSET, SLICER and DATA VALIDATION, etc. to fill in gaps in the datasheet. During the interview they will ask to click on specific cells to check the formulas and functions used by the candidate. It the interviewer doubt the candidate's skills, they might give random data and test the candidate on spot).
ROUND 3
(They will give a case study and a Excel data sheet 12 hours prior tp the interview to test their analyzing and presentation skills. During the interview they will ask question based on the results derived and cross- question the candidate's choice for a particular method for deriving results and choice of presentation tools. They will also ask basic interview questions like "Tell us about yourself', "walk us through your past internships' etc.)
Was given a task and interview. Expect a brief based on a supplied dataset, then a presentation in person. Good process, straightforward, would recommend. Need to fill word limit to submit this review.
Interview questions [1]
Question 1
Why did I recommend x option in task and explain rationale
I applied online. The process took 4 weeks. I interviewed at Nielsen (New York, NY)
Interview
Screening interview, followed by 3-member panel interview, which consisted of some introductory/background questions and a qualitatitive research exercise. Was given about 30 minutes to prepare answer for exercise, then had to explain to panel members.