Web based CRV Margin Analysis system for an international Retail Operation

The system allows users to select and extract data from the operational system to a ROLAP environment for CRV (cost, retail & volume) Marginal Analysis.  Access is made by the end-user through the company’s Intranet system using an Internet Browser.  The dynaSight front-end and ROLAP structure gives management visibility into the drivers of change in product margins and decision support.  The multi-dimensional structure is time (year-to-date, quarter, period, week), products (department, family, sub-family, item),
location (cluster, geo-zone, prc-zone, store), and all suppliers (summary and detail). 

 The system provides a very sophisticated array of key ratios and statistics specially designed for the retail operation.  Hierarchical displays of data are provided in an easy-to-use, point-and-click manner.

Design Features
1) SQL Server
2) DynaSight
3) Microsoft IIS web server
4) Data selection, online analysis, reporting
5) Multiple Security levels
6) Custom made
7) Intranet

 

---

This page last modified on
Email your comments to info@wpmc.com
Copyright: Williams & Partner, 2003