EMI tunes data management

Music firm overhauls information systems to keep up with soaring digital sales

Written by Dave Friedlos

EMI Music last month posted a 13 per cent rise in pre-tax profits, partly attributed to a doubling of digital music sales.

The announcement is further evidence that the music industry is in the throes of a digital revolution, with downloads increasing and sales of recorded music declining.

Technology is a key part of strategies intended to capitalise on the digital market while combating a growth in piracy.

EMI has recently overhauled its systems and improved its business intelligence and management information. Previously the company’s data warehouse used business intelligence tools from Hyperion, and contained only sales data.

‘We collected data in a Microsoft SQL Server 2000 database and exported information into a Microsoft Excel document,’ said global programme director Richard Piercy.

‘From there, employees had to build pivot tables manually to organise that information, create slides presenting the trends and then send them out. The whole process took two days.’

The growth in digital business meant EMI needed automated reporting to provide up-to-date information and to make local information available globally.

Working with IM Group, EMI has installed a data warehouse and front-end applications, including business intelligence, analytics and reporting, collaboration, document management and a portal.

It brings together the Microsoft business intelligence framework and uses SQL Server, Analysis Services, Reporting Services and SharePoint Server.

‘It was part of an overall change that began three years ago,’ said Piercy. ‘We needed a management information capability that could support and respond to new market pressures.’

The platform, called Pulse, delivers information on market and consumer research, sales figures, airplay details, charts and financial performance.

EMI employees can use the sales analysis functions to access detailed sales data from around the world and run customised reports. For example, all 6,000 corporate intranet users can compare physical and digital sales performance data from individual acts such as Robbie Williams or Coldplay. This can be broken down by geography, retailer, artist or by release.

The near real-time view of the information allows EMI to monitor the performance of campaigns worldwide.

This in turn allows EMI to meet release date deadlines, optimise sales and save management and analytical time.

Piercy says staff have welcomed the system, primarily because it is easy to use and requires no training. Pulse also unites structured and unstructured management information.

‘There is now a lot of management information rich text. It is not all just grids and numbers, so we needed a single portal that presented all data in a consistent manner,’ said Piercy. ‘A lot of people are talking about it, but no one is actually doing it.’

EMI digital… in 30 seconds

* EMI represents more than 1,000 artists, operates in 50 countries and licenses its music in a further 20 countries.

* Digital music sales have more than doubled in the past year, generating more than £112m compared with £46.9m last year. The strong demand for downloads helped EMI boost pre-tax profits by 13 per cent.

* Previously, its data warehouse contained only sales data and reporting on the status of the supply chain was semi-manual. It could take up to two days to access critical information on sales and performance.

* EMI has implemented Pulse, a management information and business intelligence system. Everything from airplay to sales data and chart position can be accessed by 6,000 corporate intranet users.

* Access to more information in real time allows EMI to meet release deadlines, optimise sales and save management time.

Further reading:

EMI streamlines music process

EMI opens portal to higher sales

reader comments

related articles

 

No new coal without CCS in the UK, says government

Ed Miliband announces that all new coal plants will have to demonstrate carbon capture capabilities 23 Apr 2009

Clean industrial revolution promises £70bn economic boost

But only if government abandons "technology neutrality" and steps up support for offshore wind and marine energy 02 Jul 2009

YMCA starts IT transformation

Charity creates role of head of information systems ahead of complete technology revamp 17 Dec 2008

related whitepapers

today's top stories

What does Windows 7 mean for Microsoft?

With the sting of Vista still fresh, Redmond has to make next Windows work 10 Jul 2009

A smarter way to use BI

Getting the most from business intelligence systems requires not only careful management on the part of IT leaders, but also the committed involvement of decision-makers across the organisation 08 Jul 2009

Quenching a thirst for IT modernisation

A substantial restructure at soft drink supplier Nichols -­ purveyor of Vimto - ­led the company to update its software to Sage 1000 to replace its in-house application. This resulted in the streamlining of the IT department and an opportunity to customise the system 08 Jul 2009

How Satyam cleaned up its act

Chief executive CP Gurnani tells Angelica Mari why Tech Mahindra opted to keep the Satyam brand after it bought the scandal-hit services firm, and explains what the deal means for existing and prospective customers 09 Jul 2009

Lack of enterprise appeal takes shine off Chrome OS

Enterprise buyers unlikely to ditch Windows for Chrome OS in the near term, say experts 09 Jul 2009

Advertisement

Newsletter signup

Sign up for our range of FREE newsletters:

More available - click 'submit' to view

Existing User

Newsletter user login:

Advertisement

Jobs

Related jobs

Job of the week

Job alerts

Sign up here

Find your next job

IT Salary Checker

Check salary here

Advertisement

White papers

Search white papers

Top categories

VPN, Extranet and Intranet Solutions

WAN/ LAN Solutions

Network Security

Interoperability-Connectivity

Grid/ Utility Computing

Latest poll

Will Google Chrome OS be a genuine alternative to Windows?

Will Google Chrome OS be a genuine alternative to Windows?

Tell us your views on the new operating system rivalry

View poll results

Latest audio and video articles

network cablesVideo

How to maximise the value of your IT networking investment

A panel of experts discuss networking strategies that deliver real value to business 03 Jul 2009

green footprintsVideo

How to manage enterprise energy use - and the role IT can play

A panel of experts explore how firms can get to grips with their carbon footprint and make smarter use of energy 01 Jul 2009

Latest in-depth articles

Google ChromeAnalysis

Lack of enterprise appeal takes shine off Chrome OS

Enterprise buyers unlikely to ditch Windows for Chrome OS in the near term, say experts 09 Jul 2009

Satyam CEO CP GurnaniNews

How Satyam cleaned up its act

Chief executive CP Gurnani tells Angelica Mari why Tech Mahindra opted to keep the Satyam brand after it bought the scandal-hit services firm, and explains what the deal means for existing and prospective customers 09 Jul 2009

Advertisement

Primary Navigation