beyond master data - blog.scicomputing.com
TRANSCRIPT
Beyond Master Data
The PPDM Data Model as Operational Data Store for Business Intelligence
PPDM Denver Q1 2015 Data Management LuncheonBy
Chris Tsouris
@ Copyright 2015 Strategic Computing, Inc.
Agenda
Evolution to the Operational Data Store (ODS)
The Data Warehouse
The Operational Data Store
Architected Environment
PPDM Traditional Roles
Master Data Management (MDM)
Functional Integration
Operational Reporting
PPDM in the Architected Environment
Solution Artifacts and Screenshots
@ Copyright 2015 Strategic Computing, Inc.
Applications Acquired
@ Copyright 2015 Strategic Computing, Inc.
Application Changes
@ Copyright 2015 Strategic Computing, Inc.
New Custom Reports
@ Copyright 2015 Strategic Computing, Inc.
Interface the applications
@ Copyright 2015 Strategic Computing, Inc.
The “Extract” Program
@ Copyright 2015 Strategic Computing, Inc.
New and Improved Applications
@ Copyright 2015 Strategic Computing, Inc.
Enter the PC
@ Copyright 2015 Strategic Computing, Inc.
Enterprise “Excel”
@ Copyright 2015 Strategic Computing, Inc.
File Sharing & Email
@ Copyright 2015 Strategic Computing, Inc.
Getting Information
Mature (or legacy) systems
Clerical orientation
Current valued
Detailed, not summarized
Unintegrated
Transaction oriented
Maintained to the point of being shopworn
Undocumented systems
@ Copyright 2015 Strategic Computing, Inc.
Change in Architecture
Separation of processing
Transactional
Operational
Decision Support Systems (DSS)
@ Copyright 2015 Strategic Computing, Inc.
Enter the Data Warehouse
@ Copyright 2015 Strategic Computing, Inc.
Star Schema
@ Copyright 2015 Strategic Computing, Inc.
Add the ODS
Comparing the DW and ODS
Data Warehouse
Subject Oriented
Integrated
Non-volatile
Historical
Summary
Operational Data Store
Subject Oriented
Integrated
Volatile
Current
Detail
Architected Environment
Master Data Management
PPDM Subject Areas
ANALYSIS
APPLICATIONS
AREAS
BUSINESS ASSOCIATE LICENSES AND AUTHORIZATIONS
BUSINESS ASSOCIATES
CATALOGUES
CLASSIFICATION SYSTEMS
CONSENTS
CONSULTATIONS AND NEGOTIATIONS
CONTESTS AND DISPUTES
CONTRACTS AND LEGAL AGREEMENTS
COORDINATE SYSTEMS
DEPRECATED TABLES
ECOZONES AND ENVIRONMENTS
ENTITLEMENTS
EQUIPMENT
FACILITIES
FIELDS
FINANCIAL SUMMARIES
FOSSILS
HEALTH, SAFETY AND ENVIROINMENT
INSTRUMENTS
INTEREST SETS AND DIVISION OF INTERESTS
LAND RIGHTS
LITHOLOGY
NOTIFICATIONS
OBLIGATIONS
PALEONTOLOGY
POOLS
PPDM DATA MANAGEMENT
PPDM UNIT OF MEASURE
PPDM VOLUME REGIMES
PRODUCTION ENTITIES
PRODUCTS
PROJECTS
RATE SCHEDULES
RECORDS, PRODUCT AND INFORMATION MANAGEMENT
REFERENCE ALIAS
REFERENCE TABLES
REPORTING HIERARCHIES
RESERVE ENTITIES AND CLASSIFICATIONS
RESTRICTIONS
SAMPLES
SEISMIC
SEISMIC LICENSES
SOURCE DOCUMENTS AND BIBLIOGRAPHIES
SPATIAL DESCRIPTIONS
STRATIGRAPHY
SUBSTANCES
SUPPORT FACILITIES
WELLS
WORK ORDERS AND REQUESTS
Architected Environment Staging
External Data Sources
Operational Data Store
PPDM Database
FTP Data
IHS
Reservoir
EngineeringDrilling
& Completions
Accounting
& Land
ArcGIS MapDashboard
Production
(Operated)
Aries
Non-Operated Production
Business Unit
Data Sources
ArcGIS
ProductionData
Warehouse
Field Direct WellView Excalibur
Production Analytics
Land Data Management
Corporate Portal
Operations
and Land
Records
Well Files
Contracts
Leases
Migration of
Paper Files
Operations & Land Records
Purchased
Data
Partner Data
OLAP
Production Fact Timeline
@ Copyright 2015 Strategic Computing, Inc.
Well Dimension
@ Copyright 2015 Strategic Computing, Inc.
Operator (Business Associate)
@ Copyright 2015 Strategic Computing, Inc.
Volume Fact
PerformancePoint Dashboards
Easy to Combine SSRS Reports With PerformancePoint Reports
Drill Down on Practically Any Dimension
Page Through Time Series Graph or View All At Once
Export Dashboards to PowerPoint or Excel
PerformancePoint and SSRS Reports Use the Same Filters
Sample PerformancePoint Dashboard“Crude Oil Production Scorecard”
Change Report Type On the Fly
Change Report Type On the Fly
Remove Data Series from the Reports Instantaneously
Subscriptions Make it Easy To Automatically Email Reports
Export Reports to PDF and Other Formats
@ Copyright 2015 Strategic Computing, Inc.
Electronic Well Files
@ Copyright 2015 Strategic Computing, Inc.
Pre-Filled Metadata
@ Copyright 2015 Strategic Computing, Inc.
Contracts
@ Copyright 2015 Strategic Computing, Inc.
Well File and Document Search
