1 / 21

BID201 Production Management Dashboard

BID201 Production Management Dashboard. Estelle de Beer BI Product Manager – South Africa estelle@sybase.co.za / +27 11 202-1000 6 August 2003. AGENDA. How healthy is your company ? Business problems How do we deal with these problems ? Complexities around the current solutions

lee-chan
Download Presentation

BID201 Production Management Dashboard

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. BID201 Production Management Dashboard Estelle de BeerBI Product Manager – South Africaestelle@sybase.co.za / +27 11 202-10006 August 2003

  2. AGENDA • How healthy is your company ? • Business problems • How do we deal with these problems ? • Complexities around the current solutions • The Sybase solution • Addressing the Business and Technical issues • Where does the data come from ? • Technical architecture • Business benefits • The Final Frontier

  3. How healthy is your company ? • What are the key measurements that you use to run your company on ? • How do you perform these measures ? • How frequently do you perform these measures ? • What data are they based on ? • What are the expected outcomes ? • What actions will be taken when these measures don’t conform to the expected results ?

  4. Business Problems • Measuring success and failure • Standardising these measures • Complying to legislative requirements • Management view (and understanding) of operational data • Reporting operational data in a consolidated format

  5. How do we deal with these problems ? • Production and MIS reports • Performance Measurement Systems • KPI’s • Balanced Scorecards • Budgets and Forecasts • Data warehousing

  6. Complexities around the current solutions • Consolidating separate environments and processes • Technical measures vs Financial measures • Manual systems vs computerised systems • Disparate Software applications • Silo’s of data feeding each system • Financial reporting cycle vs Production reporting cycle • No consolidated view of a production facility • Internal tension between management and operational staff • Hidden landmines

  7. The Sybase Solution • Management need is like driving a car/plane • Alert me only when action is required

  8. Addressing the business and technical challenges • Consolidation data related to financial and production cycles • Consolidating the silos of data • Disparate hardware platforms • Disparate Computer systems storing data • Manual data capture processes • Data Security • Change management • No off-the-shelf software available • IT Skills shortage • Fully automated • Zero IT admin required

  9. Where does the data come from ? • Applications • Scada systems (Azon, Adroit, Citect) • HR • Stores • General Ledger • Planned Maintenance • Vehicle Monitoring • Power Management • Pilot logbooks • Mineral Reserves • Leave, time & attendance • Safety • Environment • ….. • Oracle • DB2/AS400 • SAP • Informix • Microsoft SQL Server • Sybase • Flat files • Manual capture • …..

  10. Technical Arhitecture • Hardware • Microsoft or Unix • Software • Data modeling : Sybase Powerdesigner • ETL (Data Extract, Transform, Load) : Ascential DataStage • Data Storage : Sybase IQ • Application : written in ACUGT from Accucorp • Ad Hoc Reporting : Crystal, Business Objects, Infomaker, Cognos, ….

  11. Technical Arhitecture Data Flow Extract andConsolidate Data Exception Handling e-Promis Consolidated Data Store AnalyticalReporting Simple Reporting Flat Files

  12. Business Benefits • Consolidated Operational Management environment • Instant access to all data • Accurate and timely information • Integrated scorecard application • Open technology • Fully automated, near zero-admin environment • Huge volumes of transactional (operational) data online • Added value : Birth of the data warehouse

  13. Meta-dataRepository Portal Management Content Management Process Workflow ContentOrganization Security The Final Frontier : Enterprise Management Dashboard Personalize Security Publish Load Balancing Transparent Client Failover Clusters Clusters HA Service HA Service Data Applications Events Clusters Integration Adapters Share price, Exchange rates, .. e-Promis SAP HR Pl Maint Pilot Logbooks

  14. Everything works better when everything works together

More Related