Media and Telecom
Case Studies
Industry:
Media - Music
Solution name:
Sales Channel and Financial Management
Pain Description
Inadequate Sales Tracking Based in London, this company is the world’s largest independent music company, operating directly in 50 countries. Around the world the company supports a roster of current pop, classical and jazz stars plus a back catalogue of 150,000 recordings. A key management requirement is next-day sales data from the company’s 45 operating companies around the world; however the legacy system was stretched to capacity and could only support a single metric ― physical units sold. These limitations slowed and complicated such crucial operations as sales analysis, customer analysis and marketing campaign analysis. In such a fast moving industry ― where new products succeed or fail within a few days of release ― this made it difficult to quickly fix campaigns that weren’t working, or make the most of ones that were.
Mobiltel
Wireless Telecommunications Operator Builds a Business Intelligence System
With 3.3 million customers Bulgarian Mobiltel is the biggest telecommunications network in Bulgaria and one of the most successful mobile operators in Europe. The penetration rate for mobile communications in Bulgaria is 62.4 percent and rising, where Mobiltel’s installed base is more than 60 percent and the revenues in 2004 were €486.3 million.
The company decided to implement a data warehouse and business intelligence (BI) project based on Microsoft® SQL Server™ 2000 to more efficiently analyze traffic and revenue data. Prior to this, the company’s IT division had to generate each report requested by users by pulling data from various systems. As a result, there were often conflicts in the data, as different systems accounted for some data in slightly different ways. Mobiltel wanted a system that would unify the data and allow business analysts to prepare their own reports.




