Case Studies: Retail & Marketing

Managing reporting data overload across the supply chain

Growing volumes of retail point-of-sale (POS) scanner, customer, point-of-sale and geo-locational/RFID supply chain data are becoming overwhelming. Omniscope's ability to integrate diverse data sources, help visualise, filter, manage, present and report on vast quantities of data, detect patterns and exceptions, pinpoint geographical locations and refresh data directly from back-end systems leads to many successful Omniscope solutions for retail & marketing. In the UK, Omniscope is already emerging as the standard for sharing highly-visible, interactive, branded reports among retailers, service bureaus, analysts and manufacturers/brandholders.

Special features available in Omniscope help with many aspects of increasingly data-intensive retail & marketing analyses:

• Basket analysis - Omniscope's Halo function permits multiple column filtering based on shared values. This special function  allows analysts to isolate all sales of a specific item, together with all other items purchased in the same transaction. For more information, see using the Halo function.
• Outlet/channel comparisons - Omniscope's special De-query option (2.6+) allows comparative records from other channels to be selectively re-introduced into the analysis to facilitate comparative benchmarking analysis and visualisations. For more information, see using the De-query option.
• Store-check surveys - Omniscope is used to combine the data gathered in-store with images taken on the sceeen, with floorplan mapping as well
• Customer list analysis/name scrubbing - Omniscope's ability to group and edit text fields with variable spellings, match lists of names with external lists, manage duplicates and other data management features add tremendous value to the quality of data used for segmentation and other data-intensive analyses and reports.
• DataManager and Enterprise Editions connect directly to Microsoft SSAS and other MDX-compatible multi-dimensional 'cubes' often used to store retail POS data

Featured Case Studies:

• Category Management - for a top UK supermarket chain
• Out-of-Stock/Field Analysis Tool - for a leading FMCG manufacturer
• Sourcing Decision Support - for a leading UK own-label food manufacturer
• Availability Management -  for a European hardware/home improvement retailer

Partner Case Studies & White Papers

• Atheon Colgate-Palmolive Case Study

Sample Files

	Retail & Marketing Intro (.IOK) 1.0 MB	Illustrates typical retailing analyses, reporting and presentation
	Basket Analysis Demo (.IOK) 5.0 MB	Illustrates Halo function basket/promotion analysis (225,000 records)
	Category Management (.IOK) 2.0 MB	A typical category management file for retailers, example of coffee