| BI
Application based on Operational Data |
 |
Client: A Water Distribution
Company
|
 |
Client Context |
| |
- Create a customer database for
individual, corporate and partners
- Capture transaction data of
deliveries made to the customers
- Generate intelligence on the
profitability of different roots the company
operates
- Customer segmentation
- Capture exceptions
|
|
Technology |
| |
- ASP.NET
- SQL Server 2005 BI Platform,
including SSAS, SSIS, SSRS
- IIS, Crystal reports
|
|
OCS Solution |
| |
- OCS designed and implemented a
web based application
- The operational data was
converted into a data store specific to distribution
management
- Creation of customers data with
customer specific prices, segmentation
- Creation of transaction
data
- Some of the dashboards
|
|
Route-wise
revenue |
|
|
Custom-type wise revenue |
|
|
Region-wise
revenue |
- BI Reporting
|
|
Exception
report |
|
|
Six monthly comparison
report |
|
|
Route-wise sales report |
|
|
Customer-type wise
sale | |
| |
|
|
|
Management
