Certificate in Data Analysis and Reporting
Introduction
Supporting a business based on quantitative evidence is critical for (communicative) success. Noting this importance, this course presents business statistics techniques to analyse business data for making sound conclusions and decisions. To do so, this course covers descriptive statistics in addition to univariate and multivariate analysis approaches to data analysis and understanding.
Key business benefits
- Increase participants’ proficiency in number manipulation and analysis;
- Reading the data from decision making perfective;
- Practice several Descriptive Statistical analysis:
- Statistical tools: mean, median and mode;
- Trend analysis: variance and standard deviation;
- Relationship analysis: correlations;
- Comparison analysis: frequencies and percentages
Skills Acquired
- Analytical skills;
- Data handling skills.
Learning objectives
- Understand the principles of data analysis and reporting;
- Explore Challenges in Data Analysis;
- Identify Data Relationships;
- Learn different tools to perform data analysis;
- Learn how to conduct data cleaning and preparation for analysis;
- Consider when to use charts and tables.
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.
Online Purchasing Instructions
Choose a product and add it to the cart
Add more products or proceed to checkout
Fill in all the information and finalize the order
Check your email for confirmation and details