Data Analysis Techniques

An Intensive 5-Day Training Course

Data Analysis Techniques

How to Extract Powerful Information from Data

Scheduled Dates

11 - 15 Dec 2022 Dubai - UAE $4,950
12 - 16 Dec 2022 Kigali - Rwanda $5,950
09 - 13 Jan 2023 Kigali - Rwanda $5,950
20 - 24 Mar 2023 Dubai - UAE $5,950
31 Jul - 04 Aug 2023 Dubai - UAE $5,950
11 - 15 Dec 2023 Dubai - UAE $5,950
Enroll Now View Online Format In-House Options

Are the scheduled dates matching with your needs?

We provide a wider range of training options. Tailored and customized, we can deliver your organization’s training needs anytime, anywhere.

Why Choose this Training Course?

Why Choose this Training Course?

Corporate ethos which demands continual improvement in work place efficiencies and reduced operating, maintenance, support service and administration costs means that managers, analysts and their advisors are faced with ever-challenging analytical problems and performance targets. To make decisions which result in improved business performance, it is vital to base decision making on appropriate analysis and interpretation of numerical data.

What are the Goals?

What are the Goals?

This intensive 5-day PetroKnowledge training course aims to provide those involved in analysing numerical data with the understanding and practical capabilities needed to convert data into information via appropriate analysis, and then to represent these results in ways that can be readily communicated to others in the organisation. Objectives include:

  • To provide delegates with both an understanding and practical experience of a range of the more common analytical techniques and representation methods for numerical data.
  • To give delegates the ability to recognize which types of analysis are best suited to particular types of problems.
  • To give delegates sufficient background and theoretical knowledge to be able to judge when an applied technique will likely lead to incorrect conclusions.
  • To provide delegates with a working vocabulary of analytical terms to enable them to converse with people who are experts in the areas of data analysis, statistics and probability, and to be able to read and comprehend common textbooks and journal articles in this field.
  • To introduce some basic statistical methods and concepts.
  • To explore the use of Excel 2010 or 2013 for data analysis and the capabilities of the Data Analysis Tool Pack.

 It should be noted that the training course does not cover the subjects of data acquisition, databases, data management, data warehousing or the analysis of text-based information.

Who is this Training Course for?

Who is this Training Course for?

This PetroKnowledge training course has been designed for professionals whose jobs involve the manipulation, representation, interpretation and/or analysis of data. Familiarity with a PC and in particular with Microsoft Excel (2003, 2007, 2010 or 2013) is assumed.

The training course involves extensive computer-based data analysis using Excel 2010 and therefore delegates will be expected to be numerate and to enjoy working with numerical data on a computer.

How will this Training Course be Presented?

How will this Training Course be Presented?

This PetroKnowledge training course adopts a problem-based learning approach, in which delegates are presented with a series of real numerical data analysis problems drawn from the widest possible range of applications – from engineering to finance and from logistics to quality control.

Each problem presents and exemplifies the need for a different data analysis approach. For reasons of time constraint it will not be possible to develop solutions during the course to all of the problems posed. Nevertheless, all delegates will be given comprehensive solutions to all of the problems, to take away with them at the end of the course as future learning resources.

The training course is entirely applications-oriented, minimizing the time spent on the mathematics of analysis and maximizing the time spent on the use of practical methods in Excel, along with the understanding why such methods work.

Delegates will spend almost all of the time exploring Excel's data analysis and representation functionality, including the Data Analysis Tool Pack, to investigate the totally realistic data analysis problems.

Organisational Impact

Organisations that are able to make optimum decisions will enhance their ability to compete on the global stage. The participants on this training course, and therefore the teams that they work within will, as a result of their training, be better positioned to influence the organisation with recommendations based on objective data analysis that in turn produce a higher performing business.

Individuals exposed to this training will develop new insights into the use of Excel and the field of data analysis, and they will learn why the best companies in the world see data analysis as being essential to delivering the right quality products and services at the lowest costs.

Personal Impact

Participants will gain an understanding and practical experience of a range of the more common analytical techniques and data representation methods, which have direct relevance to a wide range of issues. The ability to recognize which types of analysis are best suited to particular types of issue will be addressed, and delegates will be given sufficient background and theoretical knowledge to be able to judge when an applied technique will likely lead to incorrect conclusions.

Daily Agenda

 The Basics

  • Sources of data, data sampling, data accuracy, data completeness, simple representations, dealing with practical issues

Fundamental Statistics

  • Mean, average, median, mode, rank, variance, covariance, standard deviation, “lies, more lies and statistics”, compensations for small sample sizes, descriptive statistics, insensitive measures

Basics of Data Mining and Representation

  • Single, two and multi-dimensional data visualisation, trend analysis, how to decide what it is that you want to see, box and whisker charts, common pitfalls and problems

Data Comparison

  • Correlation analysis, the auto-correlation function, practical considerations of data set dimensionality, multivariate and non-linear correlation

Histograms and Frequency of Occurrence

  • Histograms, Pareto analysis (sorted histogram), cumulative percentage analysis, the law of diminishing return, percentile analysis

Frequency Analysis

  • The Fourier transform, periodic and a-periodic data, inverse transformation, practical implications of sample rate, dynamic range and amplitude resolution

Regression Analysis and Curve Fitting

  • Linear and non-linear regression, order; best fit; minimum variance, maximum likelihood, least squares fits, curve fitting theory, linear, exponential and polynomial curve fits, predictive methods

Probability and Confidence

  • Probability theory, properties of distributions, expected values, setting confidence limits, risk and uncertainty, ANOVA (analysis of variance)

Some more advanced ideas

  • Pivot tables, the Data Analysis Tool Pack, internet-based analysis tools, macros, dynamic spread sheets, sensitivity analysis


  • On successful completion of this training course, a PetroKnowledge Certificate will be awarded to the delegates

Frequently Asked Questions

How can I register for a training course?

  • To register online through our website, please click “Enroll Now” on the course page, complete and submit the form. A confirmation e-mail and instructions will be sent to the participant’s e-mail.
  • You may also get in touch with our Registration Team on
    +971 56 222 7795 | +971 2 557 7389 or send an email to

When and how do I arrange payments?

  • Payments can be made in USD or UAE local currency AED (Arab Emirates Dirhams) either by Bank Transfer or by Credit Card. Our Bank Account details will be provided on the invoice.
  • Course fees are payable upon booking unless a valid, authorized Purchase Order is provided and accepted.
  • Invoices will be sent via email/courier to the ID/name and address provided.
  • The course fee shall be settled prior to course start date. Corporate payments with existing payment policy shall be relayed to us in advance.

When should I expect to receive confirmation of registration?

Upon successful registration online, enrolment on the respective training course will be confirmed by Registration Team by e-mail along with the invoice and joining instruction.

Is there a discount for more than one registrant/course?

For corporate fees and group registration, please send your query to

Download PDF

© 2022. Material published by PetroKnowledge shown here is copyrighted.

All rights reserved. Any unauthorized copying, distribution, use, dissemination, downloading, storing (in any medium), transmission, reproduction or reliance in whole or any part of this course outline is prohibited and will constitute an infringement of copyright.

Sending your message. Please wait...


There was a problem sending your message. Please try again.

Please complete all the fields in the form before sending.