Client: A Telecom
Company
|
 |
Client Context |
| |
- Set-up of a Data warehouse and
develop a BI solution
- Create pervasive reporting
infrastructure for power users of the Company
- Project management
|
|
Hardware sizing |
|
|
Vendor identification |
|
|
Operational
procedures | |
|
Technology |
| |
- SQL Server 2005 Analysis Services
& Integration Services for Data Warehousing
- SQL Server 2005 Analysis Services
for OLAP
- SQL Server 2005 Reporting
Services for reporting and analytics
- ASP .Net with IIS Server for web
deployment
|
|
OCS Solution |
| |
- OCS designed and implemented a
data warehouse
- Definition of department wise
KPIs
- Creation of OLAP cubes using
Analysis Services
- Some of the dashboards
|
|
Service Revenue |
|
|
Average Revenue per Fixed
telephone/ GSM/ Pay Phone |
|
|
Monthly growth in New Connection/
disconnections |
|
|
Revenue analysis by Country/
Region |
|
|
Revenue Analysis by
Category |
|
|
Analysis of international calls
by "Pay Phones' / Non Pay
phones |
- Ad-hoc Queries
- Security solutions
|
|
Database level
security |
|
|
Client Level Security |
|
|
Report level security |
|
|
Access rights and privileges to
individual
users | |
| |
 |
|
Management
