Dubai, UAE | +971 4 888 6787

About the Course

Name: ADVANCED DATA ANALYSIS TECHNIQUES

Code: G-AB016

Sectors: Accounting & Banking & Finance

Date Days Venue Fees
23 - 27 Aug 2020 5 Dubai, UAE $3,500 إحجز الآن
08 - 12 Nov 2020 5 Dubai, UAE $3,500 إحجز الآن

INTRODUCTION

This training course provides you with the Advanced Data Analysis skills to enable you to improve the planning, monitoring and performance of your organisation. This will strengthen your ability within the workplace, allowing you to understand, produce and evaluate data to support you in your role for the benefit of yourself and your organisation.

Delegates will work through practical case studies. With the aid of clear explanations, discussions and detailed material in both hard and soft copy it will enable you to transfer advanced skills and knowledge to your workplace. In this training course, participants will develop the following competencies:



PROGRAMME OBJECTIVES


Outline

DAY 1: – DATA COLLECTION, PRESENTATION AND ANALYSIS

  • Data and Methods of Collecting Data
  • Presentation of Data using Excel
  • Statistical Analysis of Data – Mean; Median and Mode; Variance and Standard Deviation
  • Probability – Binomial; Normal and Poisson Distribution
  • The Limitations of Data and Data Analysis
  • Confidence Iantervals and Hypothesis Testing

Day 2: – Pivot Tables and Data Analysis Tools in Excel

  • Pivot Tables – developing and using Pivot Tables to aid Decision Making
  • Cross Tabulation and Chi-squared
  • Data Analysis Tools in Excel – a detailed understanding
  • ANNOVA; t-tests and Z scores
  • Moving Average and Exponential Smoothing
  • Advanced and Applied Solver and Goal Seek

Day 3: – Advanced Correlation and Regression

  • Co-variance and Correlation
  • Linear Regression
  • Non-linear regression
  • Multiple Regression using Excel
  • Statistically Testing Results
  • Making Decisions – Project Planning, Estimating Costs; Reducing Risk

DAY 4: – PROJECT MANAGEMENT AND APPLIED DATA ANALYSIS

  • Forecasting Costs and Production levels
  • Estimating Project Duration using Statistical estimates and P.E.R.T
  • Network and Critical Path Analysis
  • Economic Quantity Order Analysis – to optimise inventory levels
  • Linear Programming and Optimisation Techniques to optimise resource allocation e.g. inventory and capital
  • Earned Value Analysis – to identify Project Cost and Schedule Variances

DAY 5: -FINANCIAL MANAGEMENT AND APPLIED DATA ANALYSIS

  • Analysing and Forecasting Volatility in the Market, e.g. Oil Prices
  • Evaluating Suppliers, Competitors and Acquisition Targets using Data Analysis
  • Developing Financial Models
  • Cost, Volume, Profit Analysis
  • Risk Management using Data Analysis
  • Evaluating the impact of decisions on Return on Investment and Return on Equity

Want to develop your team? You’re one step away!

Request In-house Training