Download - Corporate Performance Management & Analytics
![Page 1: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/1.jpg)
Corporate Performance Management & Analytics
Communications
Richard Lewis, Senior Consultant, IMGROUP
![Page 2: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/2.jpg)
• Introduction• Microsoft Performance Management• CPM for Print & Publishing
• Overview• IMGROUP Case Studies
• CPM for Television & Radio• Overview• IMGROUP Case Studies
• Summary
Agenda
![Page 3: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/3.jpg)
Integrated Performance ManagementTechnology Stack
END USER TOOLS and PERFORMANCE MANAGEMENT APPSExcel PerformancePoint Server
BI PLATFORMSQL Server
Reporting ServicesSQL Server
Analysis ServicesSQL Server DBMS
SQL Server Integration Services
SharePoint Server
DELIVERY
Reports Dashboards Excel Workbooks
AnalyticViews Scorecards Plans
![Page 4: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/4.jpg)
Print & PublishingCorporate Performance Management
![Page 5: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/5.jpg)
The Drivers
KPIs•Pages•CCMs•Incidences•Rate Card•Market Share•Year on Year•Actual Diff•% Diff
Analysed Across
•Page Type – Normal, Loose Inserts, Bound Inserts•Months•Advertisers/Category•Publication•Brands
Print & Publishing
![Page 6: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/6.jpg)
Analytics
Readership Analysis
•Demographics•Geography•Publication Type•Page Type•Brands•Time
Revenue Analysis
•Customer Geography•Advertiser Geography•Publication Type•Page Type•Brands•Time
Print & Publishing
![Page 7: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/7.jpg)
Analytics Summary
ExternalReaders Incidences
InternalRevenue Costs ROI
Readers=10 .5m Ad revenue= £7.5m
Costs= £3.75mROI=200%
Incidences=23m
Key figures
up upper-mid
mid downmarket
Shares Regional Analysis
06:0
007
:00
08:0
009
:00
10:0
011
:00
12:0
013
:00
14:0
016
:00
17:0
018
:00
19:0
020
:00
21:0
022
:00
23:0
024
:00
25:0
026
:00
27:0
028
:00
29:0
0
Off-peak Peak Post-Peak
020406080
100
Time Slot Analysis
Adults
Adults ABC1
Men
Women
Housewive
s
Children
0
50
100
Reader’s Demography Analysis
![Page 8: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/8.jpg)
Some IMGROUP CustomersPrint & Publishing
![Page 9: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/9.jpg)
ReutersBusiness Intelligence
![Page 10: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/10.jpg)
‘Drowning’ In Data, but Where is the Valuable Information?
ReutersChallenge
![Page 11: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/11.jpg)
“Empower the business user to make better decisions, by realising the key asset
Information”
ReutersVision
![Page 12: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/12.jpg)
ReutersSolution Architecture
Data
Integration
(Extract,Transform,
Load)• Definition data• Business data
• Business Needs Analysis • Data Source Analysis• Data Mapping• Data Quality• Business Rules Implementation
Oracle Apps
FinancialsHR
Legacy MIS
Customer and Product Data
Siebel
Support, sales& marketing
data
PPD
Permissions
Infranet
Transactiondata
Key PerformanceIndicators
Product insight& profitability
Customer insight& profitability
Sales & Revenue Reporting
Financial Reporting
Learning loop
Data Information Knowledge Decisions
Integratedconsistent
view
META DATA
![Page 13: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/13.jpg)
Support fact based decision making framework• B
ut not without behavioural & process changes as well !
ReutersBenefit points
![Page 14: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/14.jpg)
HallmarkPerformance Management
![Page 15: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/15.jpg)
HallmarkChallenge
Background•Multi-faceted global organisation•HQ USA•Personal expression products•30 languages•100 countries•Growth through M&A•UK operation •8000 products, •3500 employees, •4 separate sites
Business Problem
•Product performance previously analysed through analysis of product deliveries•This was insufficient to give real insight.•Needed to be able to collect and analyse consumer sales data
![Page 16: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/16.jpg)
Implement Business Intelligence Model to provide analysis
capability to assist in decision-making, maximising space
allocation and minimising stock exposure.
HallmarkVision
![Page 17: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/17.jpg)
Collect consumer sales information via EPoS enabling analysis of performance in-store against competitors
Seamless integration with Hallmark project team using existing standards and processes
Thorough understanding of user requirements before handing to technical team
HallmarkSolution
![Page 18: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/18.jpg)
Skilled and experienced project managers in both technical and business-
related aspects of Business Intelligence
Technical expertise enables the quick assessment of
feasibility or requirements
Deep understanding of business issues facilitates
communicates between the business user and technical
teams
HallmarkBenefit points
![Page 19: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/19.jpg)
Television & RadioCorporate Performance Management
![Page 20: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/20.jpg)
The Drivers (I)
External Internal
Programme ROI
Programme Costs
Ad Revenue
Platform Drift
Ad Viewing
Programme Viewing
Television & Radio
![Page 21: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/21.jpg)
The Drivers (II)
KPIs•Number of Viewers•Share of Total TV Viewing•Share of Commercial TV Viewing•Commercial Impacts•Share of Commercial Impacts•Ad Revenue•Ad Revenue per Hour of Programming•Ad Revenue per Minute of Commercials
Analysed Across
•Stations (own and competitors)•Audience Demographics•Regions•Day Parts•Dates•Time Slots•Programmes (and related attributes e.g. Genres, production types etc)
Television & Radio
...and Platforms
![Page 22: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/22.jpg)
Technical ArchitectureLogical diagram
BARB – ATR – AGB Nielsen Viewer Data
Internal Finance Apps
Programme Schedule Apps
Ads/spots Sales Apps
Broadcast Data Warehouse
Programme Return On Investment
Channel Performance Analysis
Viewer Profile Segmentation
Cross Platform Analysis
Hypothetical Schedule Modelling
Competitor Programme Analysis
![Page 23: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/23.jpg)
Technical ArchitecturePhysical diagram
BARB / ATR/ AGB Viewing Data
(Test Files)
Programme Schedules
(Ingres)
Finance(Oracle)
Advert Sales(Ingres)
TemporaryStaging Area
OperationalDataStore
DataWarehouse
SSIS
SSIS
SSIS
SSIS
SSIS
SSIS
SSIS
SSIS
DataSources
SSIS
SSIS
SSIS
SSISMicrosoft Analysis Services
2005Unified Dimensional Model
Viewers
Costs
Sales
Programmes
Microsoft SQL Server 2000/2005
![Page 24: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/24.jpg)
Some IMGROUP CustomersTelevision & Radio
![Page 25: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/25.jpg)
EMI MusicBusiness Intelligence
![Page 26: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/26.jpg)
EMIChallenge
Business•Digital challenges•Emerging product standards•Fragmented metadata•Immature supply chain processes•General data issues •Changing product metadata•Decentralised business•Differing data definitions•Differing financial processes •Driving adoption•Turning off manual reporting•Communication & training
Technical•Digital challenges•Product data explosion•Operational •Narrow batch windows to build daily sales “cubes”
•Functional•Most reporting is “Top n”•Networks•Some “thin” WAN links•Long latency •Decentralised systems•High cost of change•Large # dependencies
![Page 27: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/27.jpg)
Exploit all music content related
revenues
Develop recording artists and
songwriters for the long-term
Maximise revenue through local
development and global exploitation
Aggressively pursue the opportunities of
digital music and new uses
Disciplined management focused on increasing
effectiveness and profitability
Develop better understanding of consumer
EMIVision
![Page 28: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/28.jpg)
Two phased approach
Phase I• Overhaul of global sales system• Usage statistics exceeded expectations • Significant burden of manual reporting retired
Phase II• Integrated global MI System• Information structured around business entities [not IT systems]• Driving migration toward common data definitions• Central point to feed other global systems
EMISolution
![Page 29: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/29.jpg)
EMIBest Practices
•Global MI tools are a key element in delivering the EMI business strategy
•A “user focussed” MI strategy is essential to reap benefits from investment
•Performance, usability & data quality are cornerstones of success
•Small iterative delivery steps optimise delivery of business value
![Page 30: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/30.jpg)
Ministry of SoundCorporate Performance Management
![Page 31: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/31.jpg)
Know your customer
• Understand customer behaviour and value (CLTV)• Target new customers (Targeted Campaigns)• Retain existing customers (Relationship Management)• Sell more to existing customers (Cross-selling)
Know your products
• Manage product performance (Sales Performance Analysis)• Product Trends and Seasonality• Product Purchase Patterns across customer groups
Despite
• No direct sales relationship• Many data repositories• Inaccessible tools
Ministry of SoundChallenge
![Page 32: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/32.jpg)
Ministry of SoundVision
![Page 33: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/33.jpg)
Ministry of Sound The Dynamic Enterprise
What ?
How ?
Knowledge Core
(Enterprise Data
Warehouse)
Logistics
External Data
Sales Applications
Financial Systems
External Data
Marketing Systems
Human Resources
Competitors
Government
Customers
Distributors
Suppliers
Shareholders
EmployeesEmail
Internet
Television
Radio
Mobile Messages
Text Messages
Call Centres
In Store
Live Events
Tours
![Page 34: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/34.jpg)
Customer RegistrationData
Web Shop
Club Membership
Recordings
Competitions
Forums
Web Membership
Ring Tones
Tours
Product Registrations
Artists
Generic Data Sources
Ministry of Sound The Customer Intelligence Solution
Primary Product Sales Data
Secondary Product Sales Data
Customer Genre Preference Data
Customer Survey Data
Interactions
Source
Interaction
Product
Date
ActivityOpt InGenre
Customer
Interaction ValueInteraction CountCustomer CountProduct Count
Knowledge Core
(Enterprise Data
Warehouse)
![Page 35: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/35.jpg)
Knowledge Core
(Customer Intelligence
Data Warehouse)
Web Shop
Club Membership
Recordings
Competitions
Forums
Web Membership
Ring Tones
Tours
Product Registrations
Artists
Generic Data Sources
Customer Behaviour Profile
Customer Life Time Value
Product Sales Profile
Customer Sales Profile
Top/Bottom n Customers
Top/Bottom n Products
All other standard analyses
Ministry of SoundThe Customer Intelligence Solution
![Page 36: Corporate Performance Management & Analytics](https://reader034.vdocuments.us/reader034/viewer/2022051402/56816024550346895dcf2996/html5/thumbnails/36.jpg)
SummaryIntegrated Performance Management
END USER TOOLS and PERFORMANCE MANAGEMENT APPSExcel PerformancePoint Server
BI PLATFORMSQL Server
Reporting ServicesSQL Server
Analysis ServicesSQL Server DBMS
SQL Server Integration Services
SharePoint Server
DELIVERY
Reports Dashboards Excel Workbooks
AnalyticViews Scorecards Plans