Certificate in Data Analysis and Reporting

Day 1

Session 1: Fundamentals of Data Analysis

• Challenges in Data Analysis; 
• Data behaviour understanding

Session 2: Data cleaning and preparation

• Excel set-up; 
• Using ID variable; 
• Consolidating data from different sources;
• Cell management: size, decimals, and orientation;
• Data accuracy;
• Data completeness.

Session 3: Outliers

• Normalization of data; 
• Transposing data from a row to a column (and vice versa);
• Converting formulae to values (and why you should do this); 
• Using advanced filters to perform more complex analysis

Day 2:

Session 4: Statistical analysis

• Statistical tools: mean, median and mode; 
• Trend analysis: variance and standard deviation; 
• Relationship analysis: correlations; 
• Comparison analysis: frequencies and percentages; 
• Univariate and multivariate analysis.

Session 5: Chart and Table Design

• Tables vs. Charts vs. Graphs;
• Presenting data graphically;
• Choosing the correct chart to display your findings.

Session 6: Decision making

• Defining focal points. 
• Justify decision making from data results.

Nizar Baidoun

Learning and Development

Nizar Baidoun is a professional trainer, equipped with more than 5500 training hours in 16 different industries, since 1999. Mr. Nizar has developed vast practical and first-hand experience as a result of training various reputable organizations, to optimize the efficiency and effectiveness of their employees and operations, through tailored interventions that best suit clients’ challenges and needs; aligned to local and organizational culture, to ensure harmony and applicability.

As a professional, Nizar has held senior managerial positions in a number of reputable organizations. He was the Training Manager in the Commercial Bank of Kuwait, where he managed and supervised the entire training and development functions for the entire bank. Prior to that, he held the position of the Commercial Manager in a wholesale company, where he managed and supervised a 2-million $ sales portfolio.

Nizar has an MBA (Kuwait), BCom and DCS (Canada) and pursue his PhD (UK). In addition, he is a certified speaker by the International Academy of Human Resources Management.