BID201 Production Management Dashboard

1
BID201 Production Management Dashboard
Estelle de BeerBI Product Manager South
Africaestelle_at_sybase.co.za / 27 11 202-10006
August 2003
2
(No Transcript)
3
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

4
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
  dont conform to the expected results ?

5
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

6
How do we deal with these problems ?

• Production and MIS reports
• Performance Measurement Systems
• KPIs
• Balanced Scorecards
• Budgets and Forecasts
• Data warehousing

7
Complexities around the current solutions

• Consolidating separate environments and processes
• Technical measures vs Financial measures
• Manual systems vs computerised systems
• Disparate Software applications
• Silos 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

8
The Sybase Solution

• Management need is like driving a car/plane
• Alert me only when action is required

9
(No Transcript)
10
(No Transcript)
11
(No Transcript)
12
(No Transcript)
13
(No Transcript)
14
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

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

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

17
Technical Arhitecture
Data Flow
Extract and Consolidate Data
Exception Handling
e-Promis
Consolidated Data Store
AnalyticalReporting
Simple Reporting
Flat Files
18
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

19
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, ..
Pilot Logbooks
SAP
Pl Maint
e-Promis
HR
20
(No Transcript)
21

• Everything works better when everything works
  together