Classroom Sessions:
Date | Venue | Fees | |
---|---|---|---|
06 - 17 Oct 2025 | London - UK | $11,900 |
MODULES
This training course is split into two modules:
MODULE I - Data Analysis Techniques
MODULE II - Infographics & Data Analytics for Oil & Gas Reporting
Each module is structured and can be taken as a stand-alone training course; however, delegates will maximise their benefits by taking Module 1 and 2 back-to-back as a 2-week training course.
Module 1: Data Analysis Techniques
DAY 1
Logical and Reliable Data Analysis, Descriptive Statistics, and Pivot Tables
- Importing data into Excel
- Best practice when analyzing data
- Analyzing and representing coded data
- Descriptive statistics and their real meanings
- Performing a frequency analysis
- The use of pivot tables and pivot charts
- Noisy and incomplete data, statistical significance and dealing with outliers
DAY 2
Data Mode Shape Analysis
- Plotting data against time
- Generating data mode shapes
- Fitting curves to data
- Correlating mode shape to time-based events
- Interpreting time series analyses
- Moving average calculations
DAY 3
Scenario Analysis and Interactive Spreadsheets
- Representing analytical problems as multi-input, single-output (MISO) systems
- Deterministic systems analysis
- What if and visual scenario analysis
- Dynamic / interactive spreadsheets and the use of forms control
- Moving window, conditional and adaptive calculations
- Measuring the sensitivity of calculated variables
DAY 4
Regression Analysis and Correlation
- Equations of curves
- The prediction of future behavior using data shape – regression analysis
- Linear, polynomial, exponential and power curve fits
- The dangers of over-fitting
- Data end effects
- Goodness of fit (sum of square error – SSE) and R2
- Evaluating equations, solving equations, and using Solver
- Correlation and causality
DAY 5
Data Driven Methods and Analysis of Variance
- Non-deterministic system
- Data driven methods
- One step ahead future prediction using data science (multivariate correlation)
- Single factor analysis of variance (ANOVA)
- Two factor analysis of variance
- A demonstration of artificial intelligence – the travelling salesman problem
Module 2: Infographics & Data Analytics for Oil & Gas Reporting
DAY 6
Introduction and Descriptive Statistics
- What is Data Analysis?
- A reminder of elementary statistics and compensations for small sample sizes
- A Quick-start Tutorial for Excel
- Describing Data Sets using Statistics
- Representing Data Sets Graphically
- How to create Info-graphic in Excel
- How Info-graphics Data Presentation compares to the Traditional Methods
DAY 7
Frequency and Time Series Analysis
- Frequency of Occurrence
- Histograms
- Pareto Analysis
- How Excel Dashboard is Different from Infographics
- How to combine Excel and Power Point for Creating Infographics
- Time Series and Trend Analysis
- Estimation Theory and Its Relevant to Oil and Gas Data
DAY 8
Scenario Analysis, Confidence and Six Sigma
- Modelling Scenario and their Application in Oil and Gas Companies
- Interactive Spreadsheets
- Confidence Intervals
- Usefulness of Control Chart for Oil and Gas Companies
- Error Bars
- Online Tools for Creating Infographics
- Practical Creation of Infographic using real Data
DAY 9
Regression Analysis Equations and System Modeling
- Simple Regression Analysis
- Polynomial Curve Fits
- Describing Data Using Equations
- Prediction
- The Applications of Regression to Oil and Gas Companies
- Analysis Of Variance (ANOVA)
- Comparing Different Types of Infographics
DAY 10
The Infographics Creation and Critique
- Presenting Data Using Appropriate Reporting Style
- Practice Creating the Infographics and Its Presentation
- Focus on the Storytelling
- Overall Review of Concepts Learned and How they can be applied in practice
- On successful completion of this training course, GLOMACS Certificate will be awarded to the delegates
- Continuing Professional Education credits (CPE) : In accordance with the standards of the National Registry of CPE Sponsor, one CPE credit is granted per 50 minutes of attendance
Endorsed Education Provider
GLOMACS is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.NASBARegistry.org
In Association With
![PetroKnowledge](https://glomacs.com/wp-content/uploads/2023/09/180x50-logo_2.jpg)
PetroKnowledge
Our collaboration with Petroknowledge aims to provide the best training services and benefits for our valued clients
![](https://glomacs.com/wp-content/plugins/courses-listing-whatsapp/assets/images/icon-small.png?v=2)
GLOMACS Training & Consultancy
Typically replies within an hour