What is the DecisionSpace® Drilling Analytics Application?
Contents
1. DecisionSpace 7 Analytics Release 500 x O N HALLIBURTON E Software ervices Part Number XXXXXXA February 2014 2014 Halliburton All Rights Reserved This publication has been provided pursuant to an agreement containing restrictions on its use The publication is also protected by Federal copyright law No part of this publication may be copied or distributed transmitted transcribed stored in a retrieval system or translated into any human or computer language in any form or by any means electronic magnetic manual or otherwise or disclosed to third parties without the express written permission of Halliburton Landmark Software amp Services 2107 CityWest Blvd Building 2 Houston Texas 77042 3051 USA P O Box 42806 Houston Texas 77242 USA Phone 713 839 2000 FAX 713 839 2015 Internet www halliburton com landmark Trademark Notice 3D Drill View 3D Drill View KM 3D Surveillance 3DFS 3D View Active Field Surveillance Activ Mesh Refining ADC Advanced Data Transfer Analysis Model Layering ARIES ARIES Decisi Decision Solutions Asset Development Center Asset Development Centre Asset Journal Ass AssetConnect Enterprise AssetConnect Enterprise Express AssetConnect Expert AssetDirect Advisor AssetLink Director AssetLink Observer AssetObserver AssetObserver Advisor Asset BLITZPAK CartoSnap CasingLife CasingSeat CDS Conn2. Color Theme Text size Bar Chart Column Chart Pie Chart Area Chart Line Chart Scatter Plot Combination Chart Polar Chart Box amp Whisker C 2 10 DecisionSpace Drilling Analytics Chapter 2 DecisionSpaceQ Drilling Analytics Application Compare Y axis Display Hide Legend Delete Group By No Selection Comment Editor Description egen and turns the chart s legend on or off command deletes the chart DecisionSpace Drilling Analytics 2 11 Chart Control Icon Compare Y Axis Zoom out Zoom in Comment Editor Legend Delete Chapter 2 DecisionSpaceQ Drilling Analytics Application Analysis Designer Controls Restart Service Save Analysis Delete Analysis Save As Sort Cube Add Fact Dimension Edit Analysis Reset Display Names Unit Selection Create Analysis igure Filters Icon Description Create Analysis The Create Analysis the available fact and di Edit Analysis The Edit A Save Save As The Save comm e currently created analysis or editing mmand is used to save a copy of the currently name Delete Analysis te Analysis command deletes the selected analysis from Reset Display Names ay Names command resets all the customized display names le analyses Sort Cube ort Cube command allows you to sort the available analyses Th
3. The Help command opens the online help document The Home command redirects you to the home page from your current page 2 8 DecisionSpace Drilling Analytics Chapter 2 DecisionSpaceQ Drilling Analytics Application Analysis Panel Controls Column Chart Basic Line Chart For EN Save Import Color Scheme Range 1 Box and Whisker Chart Filter Error bar Inverted Spline Create Pdf Text size nm Combination Bar Chart Basic Stacked i Stacked Percey olar Graph ui 555 8 Spider Area Spider Column Spider Area Spline Spider Scatter Wind Rose New Session Export Icon Save d is used to save the currently selected analysis and its saved as a shared session which is then accessible to other an be just saved as a session on your local machine New Session ew session command is used to create a new session Create Pdf e Create Pdf command converts the graph you created in DSDA into a PDF and downloads a local copy to your desktop Imp xport The Import command helps you to import sessions with extension dsda The Export command exports the sessions you wish to export with a dsda extension The Print command launches the Windows Print Setup dialog box Use this dialog box to configure the printers to be used with the DecisionSpace Drilling Analytics application The Filter command applies a filter to the selected graph in the s
4. FACT_AFEVSACTUALCOSTS FACT_BHA_OP_BY_RUN FACT_BIT_OP_BY_RUN FACT_CPR FACT_DEPTHVSDAYS FACT_DPR FACT_KICK FACT MAXACTIVITY FACT_MUD Dimensions DIM_BHA_COMP DIM_6HA_OP DIM_BHA_RUN omen DIM_BIT_IADC_DETAILS DIM_BIT_OP DIM_BIT_ROP vIM_costs DIM_CPR_AINFO on Release Notes DecisionSpace Drilling Analytics 3 3 Chapter 3 Exercises 3 Click the Edit Analysis icon Ll A list of all current Analyses displays AFE vs Actual Costs Asset Analysis BHA Analysis Bit Analysis Completions Performance Review Depth Vs Days Drilling Performance Review Kick Analysis Max Activity Analysis Mud Mud Inventory Mud Loss Analysis NPT Analysis Perforation Summary Plan vs Actual Operations Production Equipment Failure Rig Status Safety Analysis 7 40 lt For this exercise you will modify Safety Analysis 4 In the Analysis list select Safety Analysis 3 4 DecisionSpaceQ Drilling Analytics Chapter 3 Exercises 5 Take a moment to understand the available and currently displayed data In the Analysis Designer the Facts panel top left lists all the current Fact tables in the analytical database You can add new Fact tables which you will do in a later exercise The Dimensions panel bottom left lists all the current Dimensions tables in the analgitieal database The center panel shows Available Fields and the rig panel
5. shows Selected Fields default not all data is displayed This is gene Facts and Dimensions tables for each Analys HALLIBURTON NEP E Dimension List of fields inthe selected List of fields inthe selected Fact or Dimensiontable Fact or Dimensiontable that are not currently displayed that are currently displayed 6 Select FACT SAFETY from the Facts panel DecisionSpaceQ Drilling Analytics 3 5 Chapter 3 Exercises 7 Select No of fatalities and Cost from the Available Fields panel and then click the double right arrow to move the selections to the Selected Fields panel You can also remove fields that are not typically populated in OpenWells because they will always be empty 8 Select unwanted fields in the Selected Fields panel and then clic the double left arrow to move them to the Avail Fi You can remove everything except Common Well Name Cost Event End Date e Event Start Date Incident Report Date Major Injury Count Minor Injury e No of fatalities Spud Date LRRRALE LEE LI LEA You will now add and remove dimension fields 9 Select DIM_RIGOPS in the Dimension panel 10 Select Owner Contractor from the Available Fields panel and add it to the Selected Fields panel 3 6 DecisionSpace Drilling Analytics Chapter 3 Exercises 11 Select other dimensions to see what other fields can be added or removed 12 Enable EDM Tight Group security if desi
6. Drilling Analytics
7. ERRIABMEORRERIAAS Gee es ER COLUIT 2 1 What is the DecisionSpace Drillin non 2 2 The DecisionSpace Drilli and the EDM Database XE A NT 2 3 ise 1 Add Remove Fields from Existing Analyses CHEUNG Statie d cues oe eS SS oem MES Wale Ae NND E Rx NIE A ERE 3 2 Set Default Facts and Dimensions 3 8 Change Display Names Data Types and Units 3 9 SUMMALY 51s Gated c Y Sess eM SCR teu ew OC ab eM 3 12 DecisionSpaceQ Drilling Analytics 1 Contents Exercise 3 Create Completely New Analysis Using Excel Spreadsheet 3 17 Extract Data from BXCel vv do Rev std MV RE kare RC EE Create New Data Tables s sea II iUt CM AMA dat Transform Dat iini pep ie iR REI phased bane aay ede gu Prepare Time Dimensions to Enable Data to be Sliced and Diced bi Load Data into Analytical Database Transform Data in Spoon Assign New Tables as Facts Dimensions and Cr e Transform the Time and Depth IDs 3 77 Build the ETL ing Dimension Tables 3 83 Build the ETL Build the FacfWable wing xml Files ange Defaiilt Variable Displays A 2 2 DecisionSpace Drilling Analytics Chapter Introduction The Decision
8. Space Drilling Analytics application is an easy to use web based business intelligence tool for historical drilling data analysis and visualization thus pov powerful domain focused analytics tool for drilling Built to access Landmark i quickly and easily compare many attributes across large numbers of wells i forms including multiple interactive filtering without ever having to wg da promotes effective decision making and enabl ined analyze any type of information and benchmark best and wor t and process Upon completion of this course administrat d users shotld have a firm understanding of how to create a completely new analysis using ing components create a new analysis from also by a set of han exercises that attendees can use to practice the concepts learned in the course Si DecisionSpace Drilling Analytics 1 1 Chapter 1 Introduction DecisionSpace Drilling Analytics Application Overview The DecisionSpace Drilling Analytics application 5000 1 0 0 traini course is intended to provide you with the necessary knowledge to effectively interpret and analyze existing analyses as well a analyses with data in the EDM database using the Decisi Drilling Analytics application After completing this course you will be able to Navigate the DecisionSpace Drillin Display different ty 1 and filter the data set e Create a new ana from scratch using EDM database Tr
9. andheld Field Operator HHFO 1 andmark as a service Landmark as software Landmark Decision Center iNotes Iso Core IsoMap iWellFi MathPack MDS Connect y IMIC Model Builder NETool Nexus as a service Nexus as software Nexus View Object MP OneCall 0 C pnal OpenLink OpenSGM OpenVision OpenWells OpenWire OpenWire Client OpenWire Server Op evelopment Kit Pica Production Well File Node Management Suite PAL Parallel VI 9 PostStack ESP PostStack Family Power Interpretation PowerCalculator PowerExplorer Powerxplorer PowerModel PowerView PrecisionTarget Presgraf PressWorks PRIZM Production Production Asset inistrator PPoMAGIC Connect ProMAGIC Server ProMAX ProMAX 2D ProMax 3D ProMAX Family PoMAX MVA ProMAX VSP pSTAx Query Builder Quick Quick QUICKDIF Quickwell UIKSHOT QUIKVSP RAVE RAYMAP RAYMAP Real Freedom Real Time Asset Management Real Time Operations Center Real Time Production Surveillance Real Time Surveillance Real time ap SeisMapX Seismic Data Check SeisModel SeisSpace SeisVision SeisWell SeisWorks SeisWorks 2D SeisWorks isWorks PowerCalculator SeisWorks PowerJournal SeisWorks PowerSection SeisWorks PowerView SeisXchange Semblance ation and Analysis Sierra Family SigmaView SimConnect SimConvert SimDataStudio SimResults SimResults Its 3D SIVA SLAM Smart Change Smart Deploy Smart Flow Smart Skills Smart Start Smart Sustain Smart T
10. ect CGMage Builder Channel Trim COMPASS rporate Data Archiver Corporate Data Store Data Analyzer DataManager DataServer Data DecisionSpace DecisionSpace 3D Drill View DecisionSpace 3D Dril nk DecisionSpace AssetPlanner DecisionSpace AssetSolver DecisionSpace Atomic Meshing DecisionS nSpace Data Quality DecisionSpace Desktop DecisionSpace Geosciences DecisionSpace GIS Module Decisio 0 DecisionSpace Nexus DecisionSpace Reservoir DecisionSuite Deeper Knowledge Broader U ing Explorer Depth Team Express Depth Team Extreme Depth Team Interpreter DepthTeam Dept xpress DepthTeam Extreme DepthTeam Interpreter Desktop Navigator DESKTOP PVT DESKTOP Discovery 3D Discovery Asset Discovery Framebuilder Discovery PowerStation Discovery Suite DMS ility Suite Drilling Desktop DrillModel DrillNET Predict DSS Dynamic Frameworks to Fill Dynamic Reservoir Management Dynamic Surveillance System Landmark Engineer s Data Model Engineer s Desktop Engineer s Link ENGINEERING NOTES e ediction ezFault ezModel ezSurface ezTracker ezTracker2D ezValidator FastTrack Bi anner FieldPlan For Production FrameBuilder Frameworks to Fill FZAP GeoAtlas GeoDataLoad GeoGraphi ration System Geologic Interpretation Component Geometric Kernel GeoProbe GeoProbe GF DataServer G esFull GES Xplorer GMAplus GMI Imager Grid3D GRIDGENR H d Horizon Generation P Enterprise iDIMS iEnergy Infrastructure Clean H
11. ession Unit The Unit command allows you to change the default unit value set during installation You can select from the list of available unit systems DecisionSpace Drilling Analytics 2 9 Chapter 2 DecisionSpaceQ Drilling Analytics Application data points such as measured r Spline Spider Area Spline Spider Scatter Wind Rose Description The Change Theme command changes the theme from black to grey or grey to black The Text size command allows you to change the size of the text You can increase decrease the size as you prefer The Bar Chart command displays data using bars whose lengths are proportional to the values they represent In DecisionSpa e Drilli Analytics bar charts show bars plotted horizontally Varia Stacked Stacked Percent The Column Chart command displays bar charts wh The Area Chart command displa i i the area between the line and the baseline filled witha Variations Basic Stacked quantities 0 i i ecting the sequence Variations Basic center to the top Variations Spider Line Spider Area Spider Column he Box amp Whisker Chart command displays data distribution segmented into quartiles Box represents the 2nd and 3rd quartile distribution of data Whiskers extend to show the min and max values in 1st and 4th quartiles The Table command displays data values in a row column spreadsheet format Icon
12. is mmand also helps you hide the analysis from everyone or make it available st to the administrator The Map User command allows you to create a user map it to the corresponding group and assign a user or admin role The Unit Selection command displays the list of available units An administrator can hide the available units as required The Restart Service command allows you to restart the service directly from the analysis view 2 12 DecisionSpace Drilling Analytics Chapter 2 DecisionSpace Drilling Analytics Application Description The Add Fact Dimension command allows you to add the newly created fact and dimension tables into the Analysis Designer The Configure Filters command allows the administrator to set default filters that can be later used while creating a session On the left panel there are number of filters on whicf eu e graphs and charts These filters are the following Description The fields from the fact table chosen to be di selected are available when you expand t 1 You can drill Each dimension table used in the the left panel with the group name you provided while addi ion table into the analysis designer The fields i to be displayed in the analysis you selected i xpand each bar You can drill DecisionSpace Drilling Analytics 2 13 Icon Add Fact Dimension Configure Filters Filter Attribute
13. isionSpace Drilli Analytics web page provided by your system administrator The will look like one of the following http machinename 8084 zalite GuestLo n Release Notes 2 6 DecisionSpace Drilling Analytics Chapter 2 DecisionSpaceQ Drilling Analytics Application 1 To login enter your Username in this case is your machine login ID 2 Select the Analysis you want to work with Hover over an icon to see a short description Click the icon to load the Analysis 3 Use the Working with Charts Workflow to define and manip your charts Export or print plots when finished 4 Or Access the Map View to begin filtering w e Access the Analysis Designer to begi Perform other administrative task ini permissions are required for this Si DecisionSpace Drilling Analytics 2 7 Chapter 2 DecisionSpaceQ Drilling Analytics Application Navigating DecisionSpace Drilling Analytics Application The major DS Drilling Analytics features are described in the following sections After you log into the DS Drilling Analytics click on any o pre defined analysis to see these icons Global Controls Icon Wellbore Map The Analysis Designer web based interface is used to 1 create and edit analyses or 2 perform administrative tasks You must have administrative privileges to use the Analysis Designer Without administrative privileges you will not see the Analysis Designer icon
14. oubleshoot issues related to the application S DecisionSpace Drilling Analytics Chapter DecisionSpace Drilling Analytics Application Overview In this chapter you will learn to Navigate the DecisignSpace DecisionSpace Drilling Analytics 2 1 Chapter 2 DecisionSpaceQ Drilling Analytics Application What is the DecisionSpace Drilling Analytics Application DecisionSpace Drilling Analytics DSDA is a web based business intelligence tool used for historical drilling data analysis visualization It is built on the EDM and is fully custamizab be used to optimize planning of new wells benchmark DSDA 5000 1 0 0 release comes with 18 pre defined ana provides you with tools to build your own analyse DSDA includes an interactive ESRI based filtering feature Its web based interface en from anywhere DSDA provides efficient contained within EDM applications Description s its set of Analyses Each or OLAP cube which ection criteria are immediately reflected across all displayed charts ecisionSpace Drilling Analytics is fully customizable You can modify existing analyses join data from other sources such as Excel or relational databases and you can create your own analyses from the ground up using the Analysis Designer Wellbores can be interactively selected using ESRI based mapping selections and filters The map interface lets you define search area s geog
15. ppear in this manual Some states or jurisdi do not allow disclaimer of expressed or implied warranties in certain transactions therefore this statement ma Si Third Party Licenses and Attributions Halliburton acknowledges that certain third party code has been bundled with or embedded in its software The licensors of this third party code and the terms and conditions of their respective licenses may be found at the following location PathNamelninstallationDir Third Party pdf Disclaimer The programs and documentation may provide links to external web sites and access to content products and services from third parties Halliburton is not responsible for the availability of or any content provided on third party web sites You bear associated with the use of such content If you choose to purchase any products or services from a third party the relationship directly between you and the third party Halliburton is not responsible for a the quality of third party products ors fulfilling any of the terms of the agreement with the third party including delivery of products or services 4 related to purchased products or services Halliburton is not responsible for any loss or damage of any sort tha dealing with any third party Si DecisionSpace Drilling Analytics Introduction DecisionSpace Drilling Analytics Application Overview DecisionSpace Drilling Analytics Applicati OO VeEVIe Wieso RIA bpR
16. ransform Smart Vision SmartFlow smartSECTION smartSTRAT Spatializer SpecDecomp StrataMap StrataModel StratAmp StrataSim StratWorks StratWorks 3D StreamCalc StressCheck STRUCT Structure Cube Surf amp Connect SurfNet SynTool System Start for Servers SystemStart SystemStart for Clients SystemStart for Servers SystemStart for Storage Tanks amp Tubes TDQ Team Workspace TERAS T Grid The Engineer s DeskTop Total Drilling Performance TOW cs TOW cs Revenue Interface TracPlanner TracPlanner Xpress Trend Form Gridding Trimmed Grid Tubular Basic Turbo Synthetics Unconventional Essentials VESPA VESPA VIP VIP COMP VIP CORE VIPDataStudio VIP DUAL VIP ENCORE VIP EXECUTIVE VIP Local Grid Refinement VIP THERM vSpace vSpace Blueprint vSpace Onsite WavX Web Editor Well H Clean Well Seismic Fusion Wellbase Wellbore Planner Wellbore Planner Connect WELLCAT WELLPLAN WellSolver WellXchange WOW Xsection You re in Control Experience the difference ZAP ZEH ZEH Plot ZetaAnalytics Z MAP Z MAP Plus and ZPS are trademarks registered trademarks or service marks of Halliburton All other trademarks service marks and product or service names are the trademarks or names of their respective owners Note The information contained in this document is subject to change without notice and should not be construed as a commitme Halliburton Halliburton assumes no responsibility for any error that may a
17. raphic boundaries to find wellbores You can also set up one or more filters to find data based on engineering geological or equipment parameters More information about the wellbore is available via lists and pop up windows Feature Analyses Browser Based Interface Charts and Plots Customization 2 2 DecisionSpace Drilling Analytics Chapter 2 DecisionSpaceQ Drilling Analytics Application The DecisionSpace Drilling Analytics Application and the EDM Database At the core of DSDA sits Analyses Each analysis represents one Business Intelligence BI Cube OLAP Cube or Multi Dimensio Data Model or Star schema and so on These are all just dif technical terms for the same thing that s why we use ti s Analysis Each Analysis is made up of different comporte Facts and Dimensions pler te called calculated i e mins maxs averages et decision making process There is o t Table n the analytics database for each Analysis Dime on the outside of the mode There can be multiple Di Multiple Analyses can sh sion Table provided the primary key inthe dime 1 ent in the fact table to which you are trying t ble Dimensions tables are mostly string values Dimensions DecisionSpace Drilling Analytics 2 3 Chapter 2 DecisionSpaceQ Drilling Analytics Application The EDM database is a relational database and data is stored in the form of flat in
18. red Note Dimensions Tight qrov gt earch O DIM EVENT DIM_RIGOP DIM SAFE FY d to confirm whether you want to share the well Analyses If you select Yes when you filter by ell Name in the Safety Analysis for example and then ect a different Analysis the filter 15 carried over to that Analysis Confirmation Do you want to share well filter with other analysis 14 Click Yes DecisionSpace Drilling Analytics 3 7 Chapter 3 Exercises To see the updated Analysis you have to restart the services but you will make some more changes before restarting the services Set Default Facts and Dimensions You must set a default Fact and Dimension w display a graph chart One Fact and one Di Double click a Fact Dimension to make 1 ill turn red to indicate it is the default Fact Dime 1 Double click No 2 Double click Country Selectea 5 Selected Fields Common Well Nx Cost ent End Date Event Start Date Inciac eport Date Maior Injury Count ot Injury Count Basin Name Block Name Common Well Name County Customer Dmsion Customer Name Spud Date Field Name Legal Well Name 3 Click the Save icon Note No changes take effect until services restart If you want to make additional changes to the Analysis do so before restarting the service Click the Restart Service button after when finished making changes to the Analysis 3 8 DecisionSpace
19. s Dimension Table Chapter 2 DecisionSpace Drilling Analytics Application Summary In this chapter you learned how to Navigate the DecisionSpace Drilling Analytics application Identify the different components S Ss 3 ON 2 14 DecisionSpace Drilling Analytics Chapter Exercises sS DecisionSpace Drilling Analytics 3 1 Chapter 3 Exercises Exercise 1 Add Remove Fields from Existing Analyses You will extract many more fields from the EDM than you actua expose in DSDA Exposing every single potential data point wou quickly make DSDA unmanageable and the application shg easy to use as possible It is relatively simple to expose the fields in DSDA This is different from adding new data tha extracted from the EDM that has to be added separ that in a separate exercise Purpose To familiarize users with the D application In this exercise you will Launch the DS Dri e Add or re i g analysis 0 the DecisionSpace Drilling Analytics application by web browser and navigating to the following URL If you do not see this icon you do not have Administrator privileges Ask your system administrator to provide you access Getting Started 3 2 DecisionSpace Drilling Analytics Chapter 3 Exercises DecisionSpace Drilling Analytics opens Administrator vs es Facts seach
20. ter related tables This method is very efficient to store data but becomes inefficient as you try to mine this information In DecisionSpace Drilling Analytics we use a third party ETL extract transform load tool to extract the data from the EDM and convert it into analytic database In an analytic database data is arranged in the form of multi dimensional data structures known as cubes and is cente a single business question The analytic database is very efficient fo data mining The data that is converted into analyti presented in the presentation layer for analysis 2 4 DecisionSpaceQ Drilling Analytics Chapter 2 DecisionSpaceQ Drilling Analytics Application Examples of Facts and Dimensions from some of our Analyses include the following Bit Analysis Bit Fact Table Bit Dimension Table Well Dimension Table Avg Torque Bit Class Common Well Name Avg WOB Manufacturer Country Duration Model State ROP etc etc etc NPT Analysis NPT Fact Table NPT Dimension Table ion Table Failure Total Cost Contractor Name n Well Name NPT Net Time NPT Cause Code NPT Productive Time Adjustment NPT Cause Code De NPT Total Cost Net etc etc Si DecisionSpace Drilling Analytics 2 5 Chapter 2 DecisionSpaceQ Drilling Analytics Application Log into DecisionSpace Drilling Analytics Application Start a supported web browser and access the Dec
Download Pdf Manuals
Related Search