Download
corporate performance management analytics n.
Skip this Video
Loading SlideShow in 5 Seconds..
Corporate Performance Management & Analytics PowerPoint Presentation
Download Presentation
Corporate Performance Management & Analytics

Corporate Performance Management & Analytics

93 Views Download Presentation
Download Presentation

Corporate Performance Management & Analytics

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Corporate Performance Management & Analytics Communications Richard Lewis, Senior Consultant, IMGROUP

  2. Agenda • Introduction • Microsoft Performance Management • CPM for Print & Publishing • Overview • IMGROUP Case Studies • CPM for Television & Radio • Overview • IMGROUP Case Studies • Summary

  3. Integrated Performance Management Technology Stack DELIVERY COLLABORATION CONTENT MANAGEMENT SharePoint Server SEARCH Reports Dashboards Excel Workbooks Analytic Views Scorecards Plans END USER TOOLS and PERFORMANCE MANAGEMENT APPS Excel PerformancePoint Server BI PLATFORM SQL Server Reporting Services SQL Server Analysis Services SQL Server DBMS SQL Server Integration Services

  4. Print & Publishing Corporate Performance Management

  5. Print & Publishing The Drivers

  6. Print & Publishing Analytics

  7. Analytics Summary Readers=10 .5m Ad revenue= £7.5mCosts= £3.75m ROI=200% Incidences=23m Time Slot Analysis Shares Regional Analysis Key figures Reader’s Demography Analysis

  8. Print & Publishing Some IMGROUP Customers

  9. Reuters Business Intelligence

  10. Reuters Challenge ‘Drowning’ In Data, but Where is the Valuable Information?

  11. Reuters Vision “Empower the business user to make better decisions, by realising the key asset Information”

  12. Reuters Solution Architecture Legacy MIS Data Integration (Extract, Transform, Load) Key Performance Indicators Customer and Product Data META DATA Product insight & profitability PPD Integrated consistent view Permissions Infranet Customer insight & profitability Transaction data • Definition data • Business data Sales & Revenue Reporting Siebel • Business Needs Analysis • Data Source Analysis • Data Mapping • Data Quality • Business Rules Implementation Support, sales & marketing data Financial Reporting Oracle Apps Financials HR Learning loop

  13. Reuters Benefit points

  14. Hallmark Performance Management

  15. Hallmark Challenge

  16. Hallmark Vision

  17. Hallmark Solution

  18. Hallmark Benefit points

  19. Television & Radio Corporate Performance Management

  20. Television & Radio The Drivers (I)

  21. Television & Radio The Drivers (II) ...and Platforms

  22. Technical Architecture Logical diagram Programme Return On Investment BARB – ATR – AGB Nielsen Viewer Data Channel Performance Analysis Internal Finance Apps Broadcast Data Warehouse Viewer Profile Segmentation Programme Schedule Apps Cross Platform Analysis Ads/spots Sales Apps Hypothetical Schedule Modelling Competitor Programme Analysis

  23. Technical Architecture Sales Costs Viewers Programmes Physical diagram Microsoft SQL Server 2000/2005 BARB / ATR/ AGB Viewing Data (Test Files) Operational Data Store Temporary Staging Area Data Warehouse SSIS SSIS Programme Schedules (Ingres) SSIS SSIS SSIS SSIS Finance (Oracle) SSIS SSIS SSIS SSIS Advert Sales (Ingres) Microsoft Analysis Services 2005Unified Dimensional Model SSIS SSIS Data Sources

  24. Television & Radio Some IMGROUP Customers

  25. EMI Music Business Intelligence

  26. EMI Challenge

  27. EMI Vision

  28. EMI Solution

  29. EMI Best Practices

  30. Ministry of Sound Corporate Performance Management

  31. Ministry of Sound Challenge

  32. Ministry of Sound Vision

  33. Ministry of Sound The Dynamic Enterprise Employees Email Internet External Data Competitors Television External Data Knowledge Core (Enterprise Data Warehouse) Government Radio What ? Financial Systems Mobile Messages Sales Applications Customers Call Centres Human Resources How ? Distributors Tours Logistics Text Messages Suppliers Marketing Systems In Store Shareholders Live Events

  34. Ministry of Sound Interactions Customer Genre Opt In Activity Date Product Interaction Source The Customer Intelligence Solution Knowledge Core (Enterprise Data Warehouse) Web Membership Customer Registration Data Club Membership Forums Primary Product Sales Data Competitions Generic Data Sources Secondary Product Sales Data Web Shop Interaction ValueInteraction CountCustomer CountProduct Count Product Registrations Customer Genre Preference Data Tours Artists Customer Survey Data Ring Tones Recordings

  35. Ministry of Sound The Customer Intelligence Solution Web Membership Customer Behaviour Profile Club Membership Customer Life Time Value Forums Knowledge Core (Customer Intelligence Data Warehouse) Competitions Product Sales Profile Generic Data Sources Customer Sales Profile Web Shop Product Registrations Top/Bottom n Customers Artists Top/Bottom n Products Ring Tones Recordings All other standard analyses Tours

  36. Summary Integrated Performance Management DELIVERY COLLABORATION CONTENT MANAGEMENT SharePoint Server SEARCH Reports Dashboards Excel Workbooks Analytic Views Scorecards Plans END USER TOOLS and PERFORMANCE MANAGEMENT APPS Excel PerformancePoint Server BI PLATFORM SQL Server Reporting Services SQL Server Analysis Services SQL Server DBMS SQL Server Integration Services