slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Name : Maurice Hancock Date : 7 th February 2008 PowerPoint Presentation
Download Presentation
Name : Maurice Hancock Date : 7 th February 2008

Loading in 2 Seconds...

play fullscreen
1 / 24

Name : Maurice Hancock Date : 7 th February 2008 - PowerPoint PPT Presentation

  • Uploaded on

Name : Maurice Hancock Date : 7 th February 2008. Microsoft Business I n telligence —Empower Everyone in Your Organisation. The Execution Gap …. 95% of a typical workforce does not understand how the organisational goals and objectives relate to their jobs

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Name : Maurice Hancock Date : 7 th February 2008' - stesha

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

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

Name : Maurice Hancock

  • Date : 7th February 2008
the execution gap
The Execution Gap…
  • 95% of a typical workforce does not understand how the organisational goals and objectives relate to their jobs
  • 90% of organisations fail to execute their strategies successfully
  • 86% of team spend less than one hour per month discussing strategy
  • 60% of organisations do not link their strategies to their plans and budgets

Source: Palladium Group/BSCOL

why is that
Why is that…
  • Complex Tools delivered to Business Users
  • Business / Casual Users need training courses
  • High License price.
  • Multiple products for IT to administer

Business Analysts


How Business Performance Management is addressed today

Many moving parts

Manual consolidation

Linked Spreadsheets



Is any of this still relevant?

Information Workers

differentiating the offering
Differentiating the offering
  • Integration
  • Economics
  • Complexity / Functionality
functionality through familiar interfaces
Functionality through familiar interfaces

Personal BI

Team BI

Organisational BI

Spreadsheet Analysis

Data entry and report viewing

Publish and Share Information

Aggregate Plans and Forecasts


KPI Analysis

Ad-hoc reporting


Executives and Managers

  • £1,000 +

Functional Employees

Knowledge Workers

high average user costs force you to decide who will go un served or underserved
High Average User Costs Force You To Decide Who Will Go Un-served Or Underserved

Executives and Managers

  • The Un-served and Underserved

Functional Employees

Knowledge Workers


Microsoft Business Intelligence

Improving organisationsby providing business insights to all employees leading to better, faster, more relevant decisions

  • Complete and integrated BI and Performance Management offering
  • Widespread delivery of intelligence through Microsoft Office
  • Enterprise grade and affordable
media entertainment
Media & Entertainment

Driving Business Performance

in Print & Publishing Companies

media entertainment challenges
Media & Entertainment Challenges
  • New Business Models
    • New partnerships
    • New revenue mechanisms
    • Traditional revenues subsiding
  • Maximise customer relationships & profitability
    • Recruiting new customers is more costly than growing existing relationships
    • Need to deliver the most relevant content to customers and audience segments.
  • Complex Infrastructure through M&A
  • Regulatoryreporting – (e.gOffcom)
people divided by disparate systems
People Divided by Disparate Systems…


& Management

Operations & production

Customer Care & Sales

Editorial & Content


Driving Business Performance

Business Intelligence for

Telecommunications Companies

current business performance landscape
Current Business Performance Landscape
  • Slow and inflexible
    • Only 20% of firms update budgets within the fiscal cycle.
    • Average firms wait 11 days from month end to get reports.
  • Fragmented
      • Average $B+ firm has 10 GLs, 12 budget, 13 report systems.
      • Only 26% have integrated planning and reporting processes.
  • Labor intensive
      • Average time for annual budget process is 4-5 months.
      • Budgeting process takes up 20-30% of managers time.
      • Finance staffs spend 79% of time on “low-value” activities.
  • Costly and ineffective
      • Cost to budget is 23,000+ person days per $B in revenue.
    • 60% of firms fail to align actions & strategy.

* Best Practices in Planning and Management Reporting by David A. J. Axson.

microsoft s bi solution core components for service providers
Microsoft’s BI solution Core components for Service Providers


  • Microsoft solution to analyse, plan, monitor, scorecard, budget and model business processes
  • Powerful analytical tools for enterprise-ready businesses
  • Flexible workflow integration
  • Standardisation of existing tools using Microsoft Office



Business Process Management

Data Integration

Content Management

business intelligence module solutions for service providers
Business Intelligence Module Solutions for Service Providers

Profitability Management

Churn Analysis

Customer Segmentation

Revenue Management

Increase marketing efficiencies by identifying customer segments and expected buying behavior

Identify revenue leakage areas and concerns. Plan actions and view trends in order to increase revenue

Identification and analysis of customer accounts by most and least profitable or ARPU

Identify, reduce and prevent voluntary customer attrition through proactive and reactive measures

  • Interactive data mining with trend reports
  • Drill-down reports for discovery of customer patterns
  • Ad-hoc queries enable identification of new or changing buying patterns
  • Visibility into customer churn analysis
  • Explore revenue predictive analytics and trend reports
  • Uses familiar MS Office interfaces
  • Detail summary reports of top & bottom accounts
  • Drill-down reports on causes of non-profitable customers
  • Workflow-enabled to interactive with existing CRM systems
  • Root cause analysis of voluntary customer attrition
  • Assess existing customer churn score
  • Explore customer clustering and what-if scenarios to determine course of action
case study customer profitability
Case study: Customer Profitability

Large telecommunications company in the US, with over 61 million subscribers and the nation's largest digital voice and data network

Customer Results/Benefits

Customer Business Challenge


  • End-to-end Customer Profitability solution based on Enterprise Cube framework and Microsoft SQL Server 2005
  • Near real-time access to customer profitability analysis
  • Challenges identifying current premium and non-profitable customers
  • Process is error prone and consistently exceeds their 16 day SLA
  • No in-depth visibility/analysis on customers profitability
  • Difficulties tracking customers profitability history
  • Potential savings of US 1 million per month
  • Better customer service by reducing customer misclassification errors
  • Significant reduction on manual effort
  • Automate report generation
  • Dashboards and analytical drill-down tools on portal
  • Single Portal view
  • Differentiate on Integration, Functionality and Economics
  • Experienced in applications for Media and Entertainment
  • Microsoft Enterprise Cube for Telco