Nielsen SIP Final Report
Nielsen SIP Final Report
Nielsen SIP Final Report
TABLE OF CONTENT
I. Acknowledgement .................................................................................................3
II. Executive Summary................................................................................................4
III. Profile of Organization .........................................................................................5
Regional Leadership
Global Leadership
Company Overview
7S Model
General Learnings
VII. References........................................................................................................... 27
3|Page
ACKNOWLEDGEMENT
It gives me immense pleasure to present this Summer Internship Project Report. It has truly been a
knowledgeable experience for me to work at Nielsen (India) Pvt. Ltd., which was possible because of the
backing and goodwill of the authorities around. As a student of Goa Institute of Management, I want to
extend my gratitude to Mr. Arjun Vashishtha (Associate Director, Consumer Insights), Mrs.Dibiya
Chatterjee (Senior Manager, Consumer Insights) and Mr. Karthik Narayanan (Senior Manager, Consumer
Insights) for giving time and energy to clarify doubts and include me in the everyday operations. My
thankfulness also goes out to my associates of the Consumer Insights, PEIT Team for their generous help
at all times. Lastly, this Internship’s successful completion would not have been conceivable without the
guidance of my mentor, Professor Neeraj Amarnani (Faculty, Goa Institute of Management) who guided
me through this corporate stretch. It was because of their help and support that this project has reached
this state.
4|Page
EXECUTIVE SUMMARY
This report consists the record of all of the work that was done by me during my Summer Internship at
Nielsen (India) Pvt. Ltd. During this Internship Project, I was not allotted one complete Project on which I
would work for two months, instead my experience involves working on different phases of projects
through diverse work in multiple projects. Projects that I worked on were at a different stage in their life,
and hence the learning was enriching since all projects had something new to offer.
It started with the opportunity to analyze the Information/Data available from the previous and new
studies ordered by Individuals or organizations, so as to give me a clear understanding of how descriptive
statistics is used in researches and how Data is interpreted using tested Nielsen models. Data, an
important and significant component of any business-big or small, is used extensively by firms, business.
Owners regularly conduct research for many reasons like- Identifying potential customers, understand
their target audience, measure the Brand Awareness, measure Brand Equity, Brand Health measurement,
which helps them to generate more sales and better understand their position in the market, Competition
mapping, to check feasibility, etc.
But due to reasons unaccounted for, the client failed to deliver certain requirements on time. I was then
shifted to other projects such as Tabulation of verbatim responses, Brand Health Studies, Vendor
satisfaction surveys, secondary research, Proposal making, Data analysis and Final reporting.
For every study I was involved in, my skills and proficiency in Microsoft Excel developed. Each project
involved a different type of analysis depending on the type of study that was being undertaken. And
consequently, the types of graphs and charts that were used also differed accordingly. In addition to
office work, I was also involved in field work for the vendor satisfaction study, in areas of North and
Central Mumbai. Other interactions with clients and field team briefings mostly took place through
conference calls. In most of the cases Nielsen had its templates and structured formats but in some cases
I was asked to come up with new ideas of representing data in the PowerPoint presentations and Final
reports. I can say that exposure to industries such as that of Real Estate, Paints, Fertilizers, Cement,
Education, and Travel expanded my horizons and gave me an in-depth knowledge of the trends existing in
the market place of these industries today, from both, the customers’ side as well as the companies’.
The senior managers and colleagues were satisfied with my work and used much of it in the final
reporting and presentations to the clients. This internship changed my perception towards “Market
Research”. In the end, the team was content with my work and having realized the amount of learning I
encountered, made for a perfect finish to the internship.
5|Page
PROFILE OF ORGANIZATION
Hierarchy
David L. Calhoun is Nielsen's Executive Chairman and Mitch Barns is Nielsen's Chief Executive Officer.
Piyush Mathur is President, India for Nielsen. Appointed to this position in May 2010, he is responsible for
Nielsen’s business activities and provides oversight for adjacent countries within the region. Mr. Prashant
Singh is the MD, Nielsen India.
Regional Leadership
Global Leadership
6|Page
Company Overview
History
The Nielsen Corporation,- previously known as AC Nielsen is a worldwide advertising examine firm, with-
overall home office in New York City, United States. Local base camp for North America are situated in the
Chicago suburb of Schaumburg, Illinois. As of May 2010, it is a piece of Nielsen Holdings.
This organization was established in 1923 in Chicago, by Arthur C. Nielsen, Sr., keeping in mind the end goal
to give advertisers solid and target data on the effect of promoting and deals programs. ACNielsen started
extending globally in 1939, and now works in more than 100 nations. Nielsen is a main worldwide data and
estimation organization that empowers organizations to comprehend purchasers and shopper conduct.-
Nielsen measures and screens what buyers watch (programming, publicizing) and what customers purchase
(classifications, brands, items)- on a worldwide and neighborhood premise.
7|Page
a) Marketing Performance research: For getting achievement in today's business sector organizations must
start with an attention on interest by decoding the flow dormant and developing requests in the business
sector. Nielsen screens and examinations the buy conduct of shopper, their mentality and use data,
demographic profiles of purchasers, gage the business capability of new Products that are yet to be
dispatched in the business sector, give organizations buyer understanding, promoting research-
demographic data, advertising programming and so forth.
b) Growth and Demand Strategy : For any Brand to scale the stepping stool, one needs to figure out where
customer interest is heading towards i.e. what are the administrations and items will set customer yearning
years to descend the line. Nielsen's interest system alongside their restrictive apparatuses mixed with the
Cambridge gathering's study, which is the pioneer in making sense of the interest standards, permits its
customers to position their items and benefits and exploit buyer request. The propelled Nielsen instruments
and procedures translates which purchaser base and fragments has the most noteworthy development
prospect and procuring potential. It understands the condition of shutting crevices v/s the interest to
enhance the open door, apportion assets wisely crosswise over classes and make a reasonable guide for
transformational development.
c) Segmentation and Market arrangement: To decide the best fitting territory for your business and the
purchaser base which is ready to spin the development is exceptionally crucial for each firm. Nielsen, by
utilizing its retail databases and demographics, allot its customers with the comprehension of the business
sector structure and make sense of their brands' most encouraging prospects. It distinguishes the
customers most benefit giving and significant client section, Optimize the customer's advertising blend,
Integrate their enormous business sector and media database with customer's own particular client
information to deliver bits of knowledge for any showcasing move to be made.
d) Retail Measurement Services and Shopper Marketing: Nielsen decides the ideal mix of Pricing, Packaging
and presentation to summon the development of its customers. The in-store situations and retail channels
encourages the producers and retailers with a serene scene of business sector with customers eyes. Nielsen
investigations customer blend keeping in mind the end goal to make sense of the most esteem creating
customers alongside their shopping destinations, fathoming customer unwaveringness and maintenance,
sorting out general administration of the class, cost, assortment, in store situations, and deals advancement
to expand the extent of customer’s utility bushel
e) Advertisement adequacy: Nielsen grasps includes a way that guides customers to cut by means of the
jumble, upgrade their image perceivability and spin its development. It takes after the Reach, reverberation
(sway) and reaction of the shopper on seeing a promotion and recommend bits of knowledge to customers
besides. Through the assistance of neuro-center, which is world's pioneer organization in measuring
neuroscience firm, Nielsen offers answers to inquiries that are far excessively troublesome, making it
impossible to decode by plain measurements.
f) Pricing and Sales Promotion methodologies: Nielsen, with its retail database and customer bits of
knowledge streamlines the customers estimating and advancement system in accordance with the brand
and objectives. Its reproduction apparatuses can predict how diverse valuing and deals advancement will
influence deals and pick up.
8|Page
The company has a presence in approximately 100 countries spread across Africa, Asia, Australia, Europe,
Middle East, North America, South America and Russia. Nielsen India has about 40,000 employees and it
has its Corporate HO at Mumbai apart from its regional offices at Delhi, Baroda, and Bangalore.
Client Service – Value realization: Align; Sell & Service : Owns clients, anticipates, identifies needs
Product Leadership – Value proposition : Define & design services Establishes product priorities and
requirements
GBS – Value delivery : Implement & deliver – DA; Operations; Technology, Engineering and Measurement
Science
Support – Value Enablers
Utilization of 7-S outline work to break down the distinctive parts of the association
The McKinsey 7-S structure was created by Tom Peters and Robert Waterman, experts at the McKinsey and
Company counseling firm and is a well-known model utilized as a part of associations to examine the earth
to research if the organization is accomplishing its proposed targets. The model proposes 7 reliant
components – 3 hard "S" i.e. technique, structure, frameworks; and 4 delicate "S" i.e. shared qualities,
aptitudes, style and staff.
Source: https://www.mindtools.com/pages/article/newSTR_91.htm
9|Page
'The hard "S" are more substantial, effectively to characterize and simple to impact than the delicate 'S'.
Strategy – It alludes to the expected succession of moves made by an organization to accomplish its
objectives and goals. It manages asset portion and incorporates rivalry, clients and the earth.
Structure – It alludes to how the different specialty units are organized and how they speak with each
other. An organization's structure might be brought together or decentralized or may take numerous
different structures relying upon the organization's way of life and qualities.
Systems – This incorporates a large group of frameworks inside an association that characterize its
procedures and schedules. It incorporates execution evaluation framework, money related frameworks,
IT frameworks and so forth.
Shared values – These are the center estimations of the organization that associate the various 6
elements. These are the central thoughts or directing rule that establish the framework of organizations.
Skills – These characterize the center abilities of the workers.
Style – This traverses the center convictions, standards and administration style in the association.
Staff – It alludes to the number and kind of workers in the association. It is critical for an association to
deal with its human money to make upper hand.
The 7 S of NIELSEN:
System: Dynamic business environment requests realignment and rebuilding to keep pace with the business
sector substances. The business system of Nielsen begins with the estimation of business sectors media and
purchaser conduct crosswise over commercial ventures and around the globe, incorporate data from
crosswise over business, change crude information and concentrate vital bits of knowledge alongside
proposal to customers and break down and exhort the customers about complex deals and showcasing
issues for winning business choices
Structure: Nielsen has a nearness in more than 100 nations. The aggregate association quality of Nielsen
Pvt. Ltd. Is around 40000 representatives.David L. Calhoun is Nielsen's Executive Chairman and Mitch Barns
is Nielsen's Chief Executive Officer. Piyush Mathur is President, India for Nielsen. Appointed to this position
in May 2010, Piyush is responsible for Nielsen’s business activities and provides oversight for adjacent
countries within the region. Mr. Prashant Singh is the MD, Nielsen India.
10 | P a g e
Style: Style alludes to the representative's shared and dull state of mind and carrying on unwritten
standards of conduct and thought. It is equivalent to the sort of Leadership Style existing in the association.
Nielsen has its pioneers who dispense adequate rules, checking and inspiration according to the need and
in coupled give the opportunity to representatives to take a shot at their own particular in order to make
them independent.
Every one of the representatives display friendly nature and they give a positive work environment out and
out. All over they mirror a society as given underneath:
Shared Values: Nielsen trusts in constant learning and accomplishing brilliance by steadiness. It guarantees
everybody in an association meets their maximum capacity through dealing with their qualities and
unraveling their impediments. Nielsen stays at the exterior of following customer conduct and remains the
main global supplier of showcasing bits of knowledge, throughout the previous 90 years.
Aptitudes
Eloquence
Technical learning about Nielsen instruments.
Hard work and steadiness
Staff: The association has contracted apt individuals, prepared them well and doled out them to the right
occupations. So all the staff are splendidly fit for the employment profiles with the right state of mind to do
the exploration and investigation with a mix of promoting beginning from planning reports, adapting up to
groups of various locales making customer calls to bringing home the bacon about giving them advertising
bits of knowledge based upon its humungous database crosswise over world.
11 | P a g e
The Overall process in market research has been described below by using a schematic diagram
Data collection
Solution Data Analyzing & reporting Data processing
1) Client Problem – The client approaches the market research company with a problem, the
problem can be well defined or vague, and depending on the situation further steps are taken. If
the problem is not clear, more research is needed before proceeding further.
2) Briefing – Detailed Conversations regarding the problem are carried out in this step. Mode of
communication can be personal meetings, E-mails, conference calls, video conferences, etc. In
this step all the basic steps to be taken are decided and how the research should be designed and
executed are decided.
3) Agency Proposal - After the basic discussions Nielsen designs a Proposal. A Proposal contains in
detail all that a company has to offer to the client. It is a formal document or presentation stating
your detailed approach to how you are going to solve the client’s marketing problem. It
includes “thinking” and “offer” (Cost and Time for the rigor, sample size, etc.)
12 | P a g e
Research Design – How are you essentially going to conduct the research?
1. Brand Awareness
Consumer awareness is the connection between marketing and sales. Awareness depicts how familiar
customers are with the brand. In a brand health survey both recall and recognition are captured. Recall is
a better indicator of the brand’s health as a name that first comes to the customers’ minds is more
desirable as compared to a name that is prompted and then recognized. In the former case, customers
are also more likely to recommend the brand.
2. Brand Usage
Understanding a brand’s usage helps a company realize its standing in the market. Apart from getting an
idea about the consumers’ purchase behaviour and preferences, the study also indicates the brand’s
market share. While measuring brand usage, frequency of usage, recent of purchase and total spending
on the brand are quantified.
3. Brand Attributes
This part of the study simply checks whether the brand is coherent with the customers’ expectations and
how well their needs are fulfilled. Every brand strives to maintain a positive impression about itself in the
minds of the customers. Measuring brand attributes checks time and again whether this is true and if not,
what is the pitfalls customers associate with the brand.
4. Satisfaction
This is the supreme indicator of a brand’s health and it is a culmination of all its sub factors. Considering
the example of Walmart in the US, it does not enjoy impeccable brand health because though it is a
market leader, it has significant liabilities.
5. Purchase Intent
Measuring the likelihood of purchase is an important part of the brand health survey. Respondents should
be probed on their reason for purchase, channel and time so that a near accurate prediction of the actual
purchase decision can be made.
14 | P a g e
Corporate Equity in terms of market research is the commercial value of a company in the minds of its
stakeholders and how valuable they perceive the company on certain parameters.
As other studies it also contains certain set of parameters on which the test is conducted.
Why corporate studies are conducted? The reasons are the following:
Current positioning
What is the prevailing perception overall about Brand (company) amongst the stakeholders?
Decoding the perception of Brand (company) across the various stakeholders in a complex market
(which Target Group has what perception and why?)
What are the attributes associated with Brand (company) and why?
Brand positioning of Brand (company) vis-à-vis other large Indian conglomerates
Drivers of Equity
To evaluate the Corporate Brand Health against set parameters and understand what is driving the
brand.
Other Learnings
Proposal Making
To identify the factors that affect the purchase decisions of Consumers in Premium paints segment in
Telangana and Andhra Pradesh, study ordered by a prominent player of Indian Paint industry.
Source: http://www.mckinsey.com/business-functions/marketing-and-sales/our-insights/the-consumer-decision-
journey
1) Need recognition – The need recognition is the first and most important step in the buying process. If
there is no need, there is no purchase. This recognition happens when there is a lag between the
consumer’s actual action and the ideal or desired one.
17 | P a g e
2) Information Search – Once the need is identified, it’s time for the consumer to seek information about
possible alternatives about to the problems. He will search for more or less information depending upon
the complexities of the choices to be made but also the level of his involvement.
3) Alternative Evaluation- Once the information is collected, consumer evaluated different options that
he has in offer, and he evaluated the one most suitable to his needs and chooses one that he thinks is
best for him.
4) Purchase decision – Now that the customer has evaluated different options and solutions available to
him for his response. He will buy the product that is most suitable to his needs.
5) Post purchase behavior – After the purchase has been made and the consumer uses the product, he
evaluates the product, whether he made right choice or wrong choice in buying the product .He will feel a
sense of satisfaction or dissatisfaction and it will further help him in making a opinion about the product
that will guide his future buying decisions.
If a consumer somehow can be triggered in a loop after he buys the product he will shift to a loyal
customer or become brand loyal. But this happens only when his satisfaction level is higher than what he
expected the product to be.
Understanding of questionnaire development, how surveys are done in the real world and how
responses are recorded by the field team. Questionnaires are given to a third party programming team (in
Nielsen’s case TCS) to be coded in order to attain an online nature.
Processes that are undertaken in the real world of Market Research- Length of actual questionnaires,
show cards, CAPI/PAPI, focus group interviews, in-depth interviews, audio recordings of verbatim for
open ended questions, Qualitative and Quantitative methods of collecting data, and conversion of raw
data files of responses from absolute to percentage format before analysis.
Deep look into how Research Proposals are made for clients – including ideas offered, methodology
to be used, timelines, estimated duration and cost of projects.
Excel proficiency – Dealing with large data files of responses from prospects. Use of new formulae to
help sort and filter out relevant data which is to be used for graphing and charting trends.
Customer satisfaction survey - Live exposure to how data collection is executed and how in-depth
interviews are done in the real world. First-hand experience of how responses are recorded by the
field team, which consists of trained interviewers and a supervisor recording the responses on a device
with the help of show cards.
Client Conference Calls - Live experience of how client meetings/conference calls are conducted.
Ability to exhibit trends through Nielsen level charts – After going through to a tremendous amount
of charting work given by supervisors, was able to create own charts to showcase certain parameters
required by the client.
Field Team Briefing (Conference Call) - Live experience of how a field team briefing is conducted.
18 | P a g e
New types of charts – Introduction to different types of charting models to help showcase certain
types of comparisons.
Cleaned Questionnaires – How cleaned questionnaires look like and what purpose they serve.
PROJECT WORK
Completed Project Work
Analysis of the proposal – Study of what concept tests are in the field of Market Research. Studied
about the company.
Graphs and Analyses – For another Brand Health Study project to measure the Brand Equity Index
(BEI) of a firm), analysis of the collected data was carried out and corresponding graphing was done in
order to display the trends of the respondents over the years.
Tabulation of verbatim – For another project, listened to over 1500 audio recordings of respondents
from a field study. These open ended responses were tabulated in an excel sheet according to
question numbers of the questionnaire, ratings given, comments from respondents and the type of
brand.
Charting and Analyses – Graphing and charting for awareness, (Top of the mind awareness,
Spontaneous and aided awareness), brand imagery and brand leverage was done to display the trends
of the respondents over the years.
Worked on excel files – Used pivot tables to analyse large sets of data over multiple sheets as required
in the format given by the client.
Field Work – In order to collect responses for a vendor satisfaction study, went to a client along with a
interviewer from data acquisition team.
Secondary Research on different industries – Conducted secondary research on Indian Education, Real
Estate sector in to get a big picture of recent happenings.
Analysis Reports – Updated the Analysis Reports for the latest quarter track. Presentation was directly
shown to the Clients.
Descriptive of Verbatim – Continuation of work done in the first week. Of the verbatim that were
tabulated before, the most descriptive ones were scrutinized and filtered out to use in analysis reports
and final presentations.
19 | P a g e
1) Indian Education Sector: International Private Education Institutes had ordered a feasibility study
for the Indian education sector. Whether they should enter the market or not. What is the current
scenario in India for private institutions and what’s the scope and road ahead. What are the
Growth Drivers of Education Sector in India, Growth Prospect and opportunities for foreign
investors in Indian Education sector
2) Secondary Research for a Client who wanted to felicitate the top and best performers in the Indian
Real estate sector
• These awards are intended to recognize and felicitate outstanding professionals, organizations
and achievements within Indian Residential Real estate and property sectors.
• As the industry has grown and increased its professionalism, the Real Estate Business Awards will
reflect the evolution and maturation of the leading real estate operators and networks
1) For the final shortlisted Companies: Primary survey conducted amongst key stake holders viz.
customers, vendors, employees, etc.
Short listed Companies would be sent schedule for submission of factual data
Schedules would be sent along with a brief background on the award categories
Each Company would be chased for submission of the factual data within the stated time-frame
Rating of Identified Companies on key parameters to arrive at ranks on award categories
Integration of data
A robust algorithm would be developed to arrive at a combined rank from perception based & factual
data collection
References:
Mckinsey. Retrieved from: http://www.mckinsey.com/business-functions/marketing-and-sales/our-
insights/the-consumer-decision-journey
Nielsen (2016). Retrieved from: Client brief and Proposal for Asian Paints study