E2E and Sirval Understanding

This artwork was created using Nielsen data.

Copyright © 2017 The Nielsen Company (US), LLC. Confidential and proprietary. Do not distribute.
Education
• MBA in Human resource

Experience (18 + years)

• NIQ
Copyright © 2017 The Nielsen Company (US), LLC. Confidential and proprietary. Do not

Meet •
•
TCS
Nielsen

the Trainer
Experience in NIQ
• I have been working in NIQ for 2.5
years in IV expert role

Pujan Privately
Shah
• Cooking
IV Expert
• Table tennis
• Love to explore new places with
family
distribute.

© 2023 Nielsen Consumer LLC. All Rights Reserved.

2
Ground rules

Avoid multitasking Time and break Ask questions

This session is for you – feel free to
Copyright © 2017 The Nielsen Company (US), LLC. Confidential and proprietary. Do not

To focus on the training, please turn-off There will be short breaks between
your mobile phones and don’t work sections of the training. share your comments and ask the
upon other staff – especially mails or questions to clear your doubts
chats

Turn your camera on Mute your microphone Materials will be shared

For better training experience it’s good If not speaking, please mute your mic to After the training you will receive this
that we could see each other, especially avoid background noises presentation, so there is no need to
while speaking rewrite the slides, still you are welcome to
make your own notes
distribute.

3 3
RMS and CPS

NielenIQ divided into two section

1) RMS -Retail measurement services -data is collected from retailers itself by scanning or by audit from DA
Copyright © 2017 The Nielsen Company (US), LLC. Confidential and proprietary. Do not

team
2) CPS -Consumer panel services -Data collected from household where consumer behaviors on buying
products will be known
distribute.

© 2021 Nielsen Consumer LLC. All Rights Reserved.

4 4
Data Collection

SCANNING COOPERATING RETAILERS SALES VALUE/

Copyright © 2017 The Nielsen Company (US), LLC. Confidential and proprietary. Do not

DATA VOLUME

TRADITIONAL TRADE
HHT Audit SMALL FORMAT STOCK, PRICES,
(Field) IMAGES

CASH SLIPS NON-COOPERATING RETAILERS SALES VALUE/

VOLUME

LESS DETAILED
Feature Ads/ COOPERATING RETAILERS
Display
CAUSAL DATA
distribute.

© 2021 Nielsen Consumer LLC. All Rights Reserved.

5 5
Database Dimensions

MARKETS PRODUCTS FACTS PERIODS

Copyright © 2017 The Nielsen Company (US), LLC. Confidential and proprietary. Do not

WHERE WHAT HOW MUCH WHEN

Geographies Items Sales Weekly

Supermarket Characteristics Value 4 Weekly
Convenience Hierarchy Volume Quarterly
Grocery Unit Monthly
Pharmacy Promotion MAT
Distribution
distribute.

© 2021 Nielsen Consumer LLC. All Rights Reserved. 6

SHOPS/ FIELD (Data
Consumer Information
RETAILERS
● Sales data
Acquisition)
● Product Platform
● Shop Data Science
characteristics Retailer
● Causal data characteristics ● Market information Services

Market details
Copyright © 2017 The Nielsen Company (US), LLC. Confidential and proprietary. Do not

Exceptions Item chars

and values
Publication
SIRVAL OGRDS eClipse MADRAS
Input Validation Reference Data Client StatOps
Instruction

Validated sales Item chars Product Market

Item activity and values details details

NRSP (Client Instruction / Production Engine)

Connect
Express
i-sights, i-reports
Dashboards Inf*Act DB Report Center
distribute.

Ad Hoc Web*
(selected countries
only!)
© 2021 Nielsen Consumer LLC. All Rights Reserved.
7 7
SIRVAL Validations – Simplified process view

iBenchmark/
FOVA Data
Data Loading Cross Coding Item
Validation Salvation
Inspection
Copyright © 2017 The Nielsen Company (US), LLC. Confidential and proprietary. Do not

Data from Retailers NANKeys are attached Statistical checks are Process of estimating I-Benchmark is a
(Volumetric, Causal, to the Barcodes performed on the or adjusting data in
process that detects
Audit) is loaded into received. Exceptions stores and the case of missing
SIRVAL in the form of FOVA Report classifies inputs or incorrect and corrects multipack
are shared with
two Standard Input OGRDS. each store either as inputs. or single-pack issues in
files (SIRPAIR) DATA_GOOD or the rawdata.
Questionable. It even
provides the type of The aim of Item
error.
Inspection is to detect
and correct outliers in
volume and price.

Pre-production Processes & Surgeries

The purpose is to enrich the validated and corrected data: Qbrik, Regular
distribute.

price, Baseline, Item Activity, Extract Rawdata

© 2021 Nielsen Consumer LLC. All Rights Reserved.

8 8
SIRVAL Scanning Process Flow
PBD load Parameter
Bulk Load & PCIMDB Sample Stores & Batch
from values & Filter
Bulk Update LOAD Load management
MADRAS management

IMDB
Open Buffer Rawdata Data
Copyright © 2017 The Nielsen Company (US), LLC. Confidential and proprietary. Do not

FOVA Output FOVA Ha

Period Load Load ndling Salvation
Items

Item
Inspection
Regular Rawdata Superstore
Shelfbenchmark Rexcoding Ibenchmark
Price Corrections Adjustment
Variable
Weight Price
Validation

Shelfspace Item NRSP

Qbrik CIG Baseline Audit Store Usability
Treatment Activity Extraction

Job Class Retailer

Module FOVA Xcodes Last
& Priority Surgery LDI_Preprocess Last Activity Rawdata
Totals parameters received Date
Monitor Extraction
distribute.

Process in BAU Production job Processes which should run during the weekend Connected Processes 9
SIRVAL Audit Process Flow
Ibenchmark Bulk load Parameter
Sir-Pair PCIMDB Stores & Batch
For last & Bulk values & Filter
Files LOAD management
period update management
Copyright © 2017 The Nielsen Company (US), LLC. Confidential and proprietary. Do not

Elapsed
Open Buffer Rawdata ASTI ASTI
Days Rexcoding
Period Load Load Load Handling
check

PBD load
Sample Price Data Y-Factor
DSASI from Balancing
Load Check Salvation Calculation
MADRAS

Audit Store
Usability AFI Rawdata Item NRSP
Qbrik
(MD & LPC) Split Activity Extraction

Job Class
& Priority Surgery
Monitor
distribute.

Process in BAU Production job Processes which should run during the 1
Copyright © 2017 The Nielsen Company (US), LLC. Confidential and proprietary. Do not

SIRVAL -Tool used for validation of input data

MADRAS – Tool used for creation of market dimension instructions for database
OGRDS –A library of products and a platform used for product coding
eCLipse – Tool used for creation of product dimension instruction for a database
NRSP -Tool used for production of database
distribute.

CIP - Consumer information platform

© 2021 Nielsen Consumer LLC. All Rights Reserved.
11 1
Copyright © 2017 The Nielsen Company (US), LLC. Confidential and proprietary. Do not
distribute.

© 2021 Nielsen Consumer LLC. All Rights Reserved.

Thank You

12 1