Data Analytics and Financial Analysis for Oil and Gas

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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