dashboard scorecard case study n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Dashboard & Scorecard Case Study PowerPoint Presentation
Download Presentation
Dashboard & Scorecard Case Study

Loading in 2 Seconds...

play fullscreen
1 / 27

Dashboard & Scorecard Case Study - PowerPoint PPT Presentation


  • 111 Views
  • Uploaded on

Dashboard & Scorecard Case Study. AGENDA. Introduction Hagemeyer Case Study Background Situation Strategic CPM Vision Solution Benefits Assimil8 Overview Key Values Consultancy Solutions. INTRODUCTION – Industry Pressures. Movex skills Cognos 8 skills ERP Consultancy skills

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

PowerPoint Slideshow about 'Dashboard & Scorecard Case Study' - matia


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
agenda
AGENDA
  • Introduction
  • Hagemeyer Case Study
    • Background
    • Situation
    • Strategic CPM Vision
    • Solution
    • Benefits
  • Assimil8 Overview
    • Key Values
    • Consultancy
    • Solutions
introduction industry pressures
INTRODUCTION – Industry Pressures
  • Movex skills
  • Cognos 8 skills
  • ERP Consultancy skills
  • Skill Availability
    • Clients shortage of full time employees with C8
    • Consultancy Skills
  • BPW
  • Support
    • Lawson Cognos Support
  • BI roadmap  New Cognos Technology
  • BI Strategy  Business Plan/Objectives
introduction working relationships
INTRODUCTION – Working Relationships
  • Hagemeyer initiatives
    • Strategic CPM roadmap
    • Migrate from Cognos v6 to C8
    • EP
    • Metrics
    • Knowledge Gap
  • Resource constraints to delivering on-going initiatives
  • Assimil8 Helped with
      • Metric scorecard
      • Dashboard
      • EP
      • Cognos 8 & BPW Training
agenda1
AGENDA
  • Introduction
  • Hagemeyer Case Study
    • Background
    • Situation
    • Strategic CPM Vision
    • Solution
    • Benefits
  • Assimil8 Overview
    • Who we are
    • Consultancy
    • Solutions
background environment
BACKGROUND - Environment

IS TEAM

Various parts of the

Business

Additional Data

Movex

v11.3 rpg

AS400 Query

BPW

v2.3

Data Dumps

MS

Access

Query

Studio

Report

Studio

Impromptu

Web v6

PowerPlay

Web v6.0

MS

Excel

Analysis

Studio

Metric

Studio

Cognos V6 + V8

Excel

Reporting information to the business

situation
SITUATION
  • No timely, consistent information, multiple versions of the truth, multiple sources of data
  • No business ownership or accountability of Information provided to the users – distrust in information provided
  • No clear KPI’s, metrics or trends, timely exercise to get reports
  • Significant reconciliation required as multiple data sources have to be validated.
  • No single collaborative toolset used across the business, mixture of Excel, Access and Cognos
  • Current reliance on IS to write Cognos reports
situation movex configuration
SITUATION – Movex Configuration

Customers

Suppliers

Products

Master Files

Single Ledger

Single B/S

Single P+L

No OpCo Identity

Financials

Division

Division

UK

Ireland

Costing /

Inter Branch

One Std Cost

Inter branch

transactions

are not possible

Virtual RDC

Virtual

Branches

Virtual Branches

Inventory

Planning

Not fully

configured

RDC

Warehouse

Warehouse

Branch

Branch

Warehouse

Warehouse

Warehouse

Warehouse

Warehouse

Warehouse

Warehouse

Warehouse

Company 001

£

situation movex configuration1
SITUATION – Movex Configuration

Company 001

Division

Division

Division

Division

OpCo

Facility

Facility

Facility

Facility

Facility

Facility

Branch

Region

Warehouse

Warehouse

Warehouse

Warehouse

Warehouse

Warehouse

strategic long term strategic plan
STRATEGIC – Long Term Strategic Plan

IS WHOLESALE TEAM

BUSINESS RETAIL TEAM

Adhoc/Canned Reporting

Data Mining

Statistical Analysis

Prototyping

Additional Data

Movex

DW

Query

Studio

Report

Studio

Analysis

Studio

Metric

Studio

EP

Data Management & Preparation,

DW/BI Architecture and Security

Cognos V8

Reporting information to the business

slide13

Single Platform for Decision Making

STRATEGIC – CPM Vision

slide15

STRATEGIC – CPM Vision

  • Corporate Planning
  • EPS, market share, quality, growth…
  • Corporate Reporting and Analysis

ENTERPRISE

OPERATIONAL

Sales & Marketing

HR

Finance

Operations

  • Sales Forecasting
  • Qualification/close
  • Discount Analysis
  • Headcount Planning
  • Attrition rate
  • Resource effectiveness analysis
  • Receivable Modeling
  • DSO
  • Material cost analysis
  • Demand Planning
  • Stock-outs
  • Throughput analysis
slide16

SOLUTION – Dashboard

  • Dashboard (Report Studio)
    • Order Life Cycle Value
    • Daily, Weekly, Yearly
    • All Business Areas
    • Drill through capability
    • High Impact vision of performance against Target and Budgets

Dashboards – Offer the capability to present data from various business areas and data sources in a single view in highly intuitive formats including graphics, maps, charts and gauges for the purpose of driving business insight needed to effectively monitor business performance!

slide17

SOLUTION – Dashboard

£1,000.00

£1,000.00

£1,000.00

100%

slide18

SOLUTION – Dashboard

  • Charts
  • Revs
  • Scorecards
  • Tables
  • Graphs
  • Spark Lines
  • Highly Intuitive
  • Driving Business Insight
  • Effectively monitor performance
slide19

SOLUTION – Scorecard

  • Scorecard (Metric & Report Studio)
    • Daily and Monthly Scorecards
    • Drillable Hierarchies
      • Company
      • Division
      • Area
      • Branch
      • Sales person
    • Metrics Cover
      • Sales
      • OPEX
      • HR
    • 6wks and 2 yrs trend analysis
    • 30 key business metrics
    • Targets loaded into BPW
    • Integrated Security
slide22

SOLUTION - Resource

  • Assimil8 Consultants
  • 16 weeks
  • Skill sets covered
    • Movex
    • BPW
    • Cognos 8
      • Metric Studio
      • Report Studio
      • Analysis Studio
      • Query Studio
      • Enterprise Planning
  • Training
  • Considering Support for all the above
benefits
BENEFITS

Delivery of information – Benefits

Single version of the truth

  • Business ownership & accountability of information provided by the IS wholesale team and delivered by the business retail team
  • Focus on KPI’s, metrics & trends and the timely delivery of consistent information
  • Significantly reduce reconciliation through the consolidation of data to a single source
  • Collaborative toolset used consistently throughout the business
  • User Empowerment
  • Delivery of information – Medium term ….
  • On-Demand exception management
  • Daily visibility of KPI performance
  • Timely, accurate business information across all business functional areas
  • Visibility of actual verses forecast/budgets
  • Business information available 24/7 & 365 days
  • A business retail team that have the facility to perform information analysis without the need for data preparation
assimil8 key values
ASSIMIL8 – Key Values
  • Devoted to the Movex market place
  • Cognos 8 resources
  • Unique skills
  • Applicable knowledge and experience
  • Partnership with Cognos
  • European full life cycle project implementation experience
  • Code of conduct
  • Big 6 professionalism
  • Competitive with Contractors rate
  • Track record of successful projects
assimil8 consultancy
ASSIMIL8 - Consultancy
  • Cognos Partner
  • Business Intelligence
  • Enterprise Planning
  • BPW Data Warehousing
  • Movex
  • StreamServe

Support

Sector

Cognos

BPW

Data

Warehousing

Movex

assimil8 solutions
ASSIMIL8 - Solutions
  • Solution Support (Helpdesk)
  • BI In-Source & Outsourcing
  • Cognos Documentation Tools
  • Blueprints and Templates
  • Health Checks
  • Performance Tuning