Info-Graphics: Data Analysis and Reporting Techniques


OBJECTIVES

At the end of this Data Analysis & Reporting training course, you will learn: 

  • Analytical techniques and graphical presentations using Infographics
  • The ability to recognize the types of analysis suitable for the structure of the data
  • Adequate background and theoretical knowledge to judge when a specific technique leads to misleading conclusions
  • Sufficient skills to converse with people who are experts in the areas of data analysis and able to read and comprehend common analytical report
  • Strong foundation of statistical methods and concepts
Outline

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
  • The normal distribution

 

Frequency and Time Series Analysis

  • Frequency of occurrence
  • Histograms
  • Pareto analysis
  • Pivot tables and pivot charts
  • How Excel dashboard is different from Infographics
  • Time series analysis
  • Trending data
  • Estimation theory

 

Scenario Analysis, Confidence and Six Sigma

  • Modeling scenario
  • Interactive spreadsheets
  • Confidence intervals
  • Usefulness of control chart for Oil and Gas companies
  • An introduction to Six Sigma
  • Error bars
  • Mini case studies

 

Regression Analysis Equations and System Modelling

  • Simple regression analysis/maximum likelihood estimations
  • Curve fitting
  • Polynomial curve fits
  • Describing data using equations
  • Prediction
  • Modeling single input single output systems
  • Modeling multiple input single output systems/Multivariate analysis
  • The applications of regression to Oil and Gas companies
  • Presenting data using appropriate reporting style

 

Correlation Analysis and ANOVA

  • Differences between data sets
  • Correlation analysis
  • Auto correlation functions
  • Analysis of variance (ANOVA)
  • Overall review of concepts learned and how they can be applied in practice

المواعيد المتاحة

دبى
من 20-05-2024    الى 24-05-2024
ابو ظبي
من 09-09-2024    الى 13-09-2024
دبى
من 16-12-2024    الى 20-12-2024