Module 1: Foundational Data Ecosystems in Oil and Gas

• Understanding the common O&G data landscape (SCADA, historians, PPDM, financial)
• Introduction to the Python environment, virtual environments, and Jupyter Notebooks
• Core Python structures: lists, dictionaries, and functions for data processing
• Overview of essential Python libraries: NumPy for numerical operations and Pandas
• Principles of clean, tidy, and machine-readable data structures

Practical session: Installing and setting up the Python development environment, importing a simulated production dataset, and performing basic data inspection using Pandas.

Module 2: Python Fundamentals for Data Ingestion and Wrangling

• Reading and writing various data formats (CSV, Excel, SQL databases)
• Data selection, filtering, and conditional logic using Pandas DataFrames
• Handling hierarchical and multi-index data structures
• Data merging, joining, and concatenation techniques for integrating disparate tables
• Pivoting and reshaping data for analytical readiness

Practical session: Ingesting three separate data tables (e.g., well information, daily production, financial metrics) and performing a complex join operation to create a unified view.

Module 3: Specialized Data Handling (Time-Series, Well Logs, Seismic)

• Time-series indexing and resampling for production data analysis
• Handling missing and irregular time intervals in oil production history
• Introduction to the LASIO library for loading and manipulating well log data
• Extracting and visualizing key curves (e.g., Gamma Ray, Resistivity) from LAS files
• Basic concepts of seismic data organization and metadata management

Practical session: Loading a raw LAS file, cleaning the depth indices, and calculating a V-shale indicator using Python functions.

Module 4: Data Quality, Cleaning, and Feature Engineering with Pandas

• Identifying, diagnosing, and treating missing values (imputation strategies)
• Techniques for detecting and managing outliers in pressure and flow rate data
• Data validation rules and constraint enforcement (e.g., flow rate cannot be negative)
• Creating derived features (e.g., cumulative production, decline curve rates)
• Data normalization and scaling for machine learning preparation

Practical session: Cleaning and normalizing an offshore platform's historical power consumption dataset, handling missing sensor readings, and engineering a usage efficiency feature.

Module 5: Automated Reporting and Scripting with Python

• Building reusable Python functions and classes for standard O&G calculations
• Developing scripts to automate the ingestion-cleaning-processing pipeline
• Integrating simple database connections (e.g., SQLite, PostgreSQL) for data storage
• Generating automated reports (PDF or HTML) directly from Python results
• Error handling and logging for robust, production-level scripts

Practical session: Creating an automated script that loads new daily drilling data, cleans it, calculates R.O.P (Rate of Penetration), and saves the output to a designated folder.

Module 6: PowerBI Architecture and Advanced Data Modeling

• Connecting PowerBI to diverse O&G data sources using Power Query (M Language basics)
• Principles of Kimball data modeling: Fact Tables and Dimension Tables
• Implementing a robust Star Schema for optimal reporting performance
• Managing relationships and cross-filtering between complex tables
• Using Power Query to perform advanced ETL (Extract, Transform, Load) operations

Practical session: Building a Star Schema data model in PowerBI based on simulated well, reservoir, and production data tables.

Module 7: Mastering Data Analysis Expressions (DAX)

• Core DAX concepts: calculated columns versus measures and evaluation context
• Using Time Intelligence Functions (DATEADD, SAMEPERIODLASTYEAR) for year-over-year analysis
• Creating complex, dynamic measures (e.g., Rolling Averages, Accumulated Production)
• Utilizing ITERATOR functions (SUMX, AVERAGEX) for row-level calculations
• Advanced filtering using ALL, ALLEXCEPT, and CALCULATE functions

Practical session: Writing DAX measures to calculate Net Present Value (NPV) and a 30-day trailing average production rate.

Module 8: Geospatial and Visual Analytics for Petroleum Data

• Introduction to Geopandas and geospatial libraries in Python
• Plotting well locations and spatial data on maps using Matplotlib/Folium
• Integrating Python visualizations (Matplotlib, Seaborn) directly into PowerBI reports
• Utilizing PowerBI's built-in map visuals and custom visuals for location data
• Creating scatter plots and bubble charts to visualize reservoir performance trends

Practical session: Plotting the locations of all active wells in a concession area, color-coding them by current production status (on-stream, shut-in).

Module 9: Designing Interactive and Actionable Business Dashboards

• Principles of visual storytelling and information hierarchy in a dashboard
• Selecting appropriate chart types for O&G KPIs (e.g., gauges, line charts for decline)
• Implementing filtering, drill-through, and bookmarking for interactive user experience
• Optimizing dashboard layout and design for mobile and desktop consumption
• Adding conditional formatting and alerts to highlight critical performance deviations

Practical session: Developing a multi-page PowerBI dashboard focused on drilling efficiency and non-productive time (NPT) analysis.

Module 10: Deployment, Security, and Governance

• Publishing PowerBI reports to the service and understanding workspaces
• Implementing Row-Level Security (RLS) to restrict data access based on user role
• Scheduling data refresh and managing gateways for on-premises data
• Best practices for documenting Python scripts and PowerBI models
• Monitoring usage, performance, and ensuring data lineage

Practical session: Implementing Row-Level Security in the PowerBI model to ensure different hypothetical regional managers only see their assigned wells.

Requirements:

• Participants should be reasonably proficient in English.
• Applicants must live up to Armstrong Global Institute admission criteria.

Terms and Conditions

1. Discounts: Organizations sponsoring Four Participants will have the 5th attend Free

2. What is catered for by the Course Fees: Fees cater for all requirements for the training – Learning materials, Lunches, Teas, Snacks and Certification. All participants will additionally cater for their travel and accommodation expenses, visa application, insurance, and other personal expenses.

3. Certificate Awarded: Participants are awarded Certificates of Participation at the end of the training.

4. The program content shown here is for guidance purposes only. Our continuous course improvement process may lead to changes in topics and course structure.

5. Approval of Course: Our Programs are NITA Approved. Participating organizations can therefore claim reimbursement on fees paid in accordance with NITA Rules.

Booking for Training

Simply send an email to the Training Officer on training@armstrongglobalinstitute.com and we will send you a registration form. We advise you to book early to avoid missing a seat to this training.

Or call us on +254720272325 / +254725012095 / +254724452588

Payment Options

We provide 3 payment options, choose one for your convenience, and kindly make payments at least 5 days before the Training start date to reserve your seat:

1. Groups of 5 People and Above – Cheque Payments to: Armstrong Global Training & Development Center Limited should be paid in advance, 5 days to the training.

2. Invoice: We can send a bill directly to you or your company.

3. Deposit directly into Bank Account (Account details provided upon request)

Cancellation Policy

1. Payment for all courses includes a registration fee, which is non-refundable, and equals 15% of the total sum of the course fee.

2. Participants may cancel attendance 14 days or more prior to the training commencement date.

3. No refunds will be made 14 days or less before the training commencement date. However, participants who are unable to attend may opt to attend a similar training course at a later date or send a substitute participant provided the participation criteria have been met.

Tailor Made Courses

This training course can also be customized for your institution upon request for a minimum of 5 participants. You can have it conducted at our Training Centre or at a convenient location. For further inquiries, please contact us on Tel: +254720272325 / +254725012095 / +254724452588 or Email training@armstrongglobalinstitute.com

Accommodation and Airport Transfer

Accommodation and Airport Transfer is arranged upon request and at extra cost. For reservations contact the Training Officer on Email: training@armstrongglobalinstitute.com or on Tel: +254720272325 / +254725012095 / +254724452588