|
|
the client |
| Our client is a leading media and entertainment conglomerate based in the U.S. |
|
|
the challenge |
- To assist in decision-making processes and forecasting, including Top N Multiple System Operators (MSO), MSO ranking and MSO categorization
- Create a data integration solution for planning data, journal entries data from Affiliate Corporate Performance Management (CPM) system and actual data from Affiliate OLTP systems
- To provide an enhanced and transparent reporting environment for the Data Warehouse reporting framework, inclusive of powerful analytical and graphical reporting capabilities
- Facilitate the analysis and comparison of current versus prior revenues, inclusive of estimates, budgets, year-to-date, quarter-to-date
- To speed up ad-hoc reporting turnaround time and thereby expedite affiliate revenue analysis
- To develop a reporting landscape that caters to multiple currencies
|
|
|
the solution |
- Synthesised planning data from Affiliate CPM and actual data from Affiliate OLTP systems
- Classified reports into three unique segments: Dashboard, Analytical and Managerial
- Key subject areas included channel, brand, service, network, segment, MSO, technology, owner
- Key metrics comprised of service revenues, subscriber count, monthly subscription rate, MSO ranking
- Multi-currency reporting
|
|
|
the benefits |
- 83% cost savings achieved due to offshore involvement
- Highly optimized ETL window timings and improved report performance
- Reduction in time and effort undertaken for manual data regrouping and data integration
- Significant improvement in reporting due to shift from old reporting landscape to graphical analytic reports
|
|
| Sitemap
| Privacy Policy
| Social Media Policy