Module 1: Infographics & Data Analytics for Oil & Gas Reporting
Day 1
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 2
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 3
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 4
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 5
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
Module 2: Financial Analysis, Modelling & Forecasting
Day 6
The Competitive Challenge in the 21st Century
- Identifying and Managing Stakeholder Needs
- Business Models and How They are Disrupted
- An Integrated Approach to Risk Management
- The Essentials of Business Performance Management
Fundamentals of Financial Modelling
- Financial Statements Basics
- Fundamentals of Financial Modelling
Day 7
Mastering Financial Analysis
- Building a Financial Ratio Database in Excel
- Practical Modelling: The Cost-Volume-Profit Relationship
- Measuring and Improving Return On Investment
- Measuring and Improving Asset Management Efficiency
- Measuring and Managing Capital Structure and Risk
- Practical Modelling: The Effect of Gearing on Shareholders’ Earnings
Day 8
Improving Financial Forecasting
- Practical Modelling: Using Excel Statistical Analysis Tools
- Avoiding Common Forecasting Problems
- Using Moving Averages to Analyse Time Series Data
- Using Linear Regression for Sales Trend Analysis
- Using Excel Solver to Minimise Forecasting Error
- Using Regression and Correlation to Forecast Costs
- Practical Modelling: Cash Flow Forecasting
Day 9
Financial Models to Improve Investment Decision-making
- Principles of Capital Investment Decision-making
- Sources and Cost of Business Finance
- Practical Modelling: Using Excel Discounted Cash Flow Tools
- Practical Modelling: Capital Investment Analysis
- Essentials of Business Valuation
- Practical Modelling: Business Valuation Based on Shareholder Value Added
Day 10
Managing Risk and Uncertainty
- Identifying and Analysing Business Risk
- Probability Based Approach to Decision-making
- Monte Carlo Simulation
- Sensitivity Analysis and “what-if” Forecasting
- Identifying the Key Drivers of Financial Performance
- Practical Modelling: Key Driver “what-if” Forecast