1 / 27

Dashboard & Scorecard Case Study

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

matia
Download Presentation

Dashboard & Scorecard Case Study

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Dashboard & ScorecardCase Study

  2. AGENDA • Introduction • Hagemeyer Case Study • Background • Situation • Strategic CPM Vision • Solution • Benefits • Assimil8 Overview • Key Values • Consultancy • Solutions

  3. 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

  4. 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

  5. BACKGROUND

  6. AGENDA • Introduction • Hagemeyer Case Study • Background • Situation • Strategic CPM Vision • Solution • Benefits • Assimil8 Overview • Who we are • Consultancy • Solutions

  7. BACKGROUND 7

  8. 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

  9. 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

  10. 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 £

  11. SITUATION – Movex Configuration Company 001 Division Division Division Division OpCo Facility Facility Facility Facility Facility Facility Branch Region Warehouse Warehouse Warehouse Warehouse Warehouse Warehouse

  12. 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

  13. Single Platform for Decision Making STRATEGIC – CPM Vision

  14. STRATEGIC – CPM Vision

  15. 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

  16. 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!

  17. SOLUTION – Dashboard £1,000.00 £1,000.00 £1,000.00 100%

  18. SOLUTION – Dashboard • Charts • Revs • Scorecards • Tables • Graphs • Spark Lines • Highly Intuitive • Driving Business Insight • Effectively monitor performance

  19. 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

  20. SOLUTION – Dashboard

  21. SOLUTION – Scorecard

  22. 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

  23. 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

  24. ASSIMIL8

  25. 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

  26. ASSIMIL8 - Consultancy • Cognos Partner • Business Intelligence • Enterprise Planning • BPW Data Warehousing • Movex • StreamServe Support Sector Cognos BPW Data Warehousing Movex

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

More Related