| OLAP Retail Business Analytical Solution |
The OLAP Retail Business Analytical Solution is a tool which can help large consumer durables, retail and FMCG companies evaluate marketing effectiveness and marketing ROI.
|
The OLAP solution offers the following functionalities: |
|
Integrate data from trade marketing / distribution channels and modern format stores. |
|
Align data and structure and monitor performance based on: |
| |
- |
Availability |
- |
Visibility – Merchandising |
- |
Freshness etc. |
|
|
Analyse effect of trade marketing activities including promotion and merchandising, and |
|
Develop strategies to optimize sales / profitability across channels. |
|
|
|
| OLAP USP’s |
| Data can be analysed at: |
|
Store |
|
Zonal |
|
Regional or |
|
National level |
|
| |
| Solution highlight’s: |
|
Designing data collection templates, |
|
Assist in data entry and reporting, |
|
Periodic trend reports on availability, visibility and freshness and trade marketing activity, |
|
Query filtering on report, |
|
Decide on level of aggregation of report with options for all levels and granularity, |
|
Compact userfriendly GUI offering drag drop filtering interface, |
|
Decide timelines for reporting – Weekly, fortnightly / monthly, |
|
Web based interface, and |
|
Migrating daily transaction data into legacy system. |
|
| |
|
| BPTO (Brand price trade off) analysis – Utility software |
| |
| BPTO USP’s |
|
GUI simulation software which enables decision making for determining market shares of different brands, |
|
Effect of price changes for a particular brand or a set of brands, |
|
Ability to integrate primary research data, |
|
Functionality to export and import data files from commonly used formats, |
|
Ability to measure changes in brand equity through changes in attributes, |
|
Multi level usage capabilities – Administrator / Analyst and researcher levels, |
|
Measure price elasticity, |
|
Cross tabulation, |
|
User friendly charts for easy analysis, and |
|
Executive summary and custom report generation. |
|
| |
| Solution highlight’s: |
|
Custom built for clients, |
|
Integrating primary data collection templates, |
|
Assist in data entry and reporting, |
|
Query filtering on report, |
|
Decide on level of aggregation of report with options for all brand categories and extensions, |
|
Compact userfriendly GUI, and |
|
Dedicated research team at Abacus or use in-house research teams. |
|
| |
|
| Business Intelligence (BI) dashboards |
| |
Business Intelligence dashboards include the tools which Abacus provides its clients to measure the brand equity trends for it’s product portfolio. These BI dashboards provide a granular view of the marcom efficacy of the clients marketing and advertising programs. |
| |
| Retail pricing & packaging analytics
|
| |
Some of the typical packaging research problems which we can answer:
- What will happen if I change price for this SKU? What will be the impact on.
- Volume for this SKU,
- Volume for other SKUs of this brand,
- Volume for other SKUs in my portfolio,
- Competition,
- Our market share,
- Category volume, and
- Retail revenue and profit.
- What will happen if we introduce an innovative pack?
- What would happen if we decide to hold the price line and drop volumes in pack?
- What would happen if we simplify our line and drop an SKU or brand?
|
| |
| Solution features
|
| |
- Impact of new package and pricing
- Typically, a presentation of insights
- Simulator that is customised for the client
- Custom charts based on the simulator
- Brand maps & portfolio based on the simulator
|
|
Market research and marketing companies have data in different forms and sources and generating insights from them is very difficult in absence of uniform data repository. Abacus data management and reporting services combines data from different sources into a homogenous format for further processing and analyzing. Continuous management reports can be generated out of the data. The data can also be fused with other data sources like sales, retail audit, loyalty data etc.
