At the end of this module, you will know how to:

• Conduct, visualize and interpret Time-Series Analysis;
• Find new patterns and insights in the data;
• This module does not cover predictive modelling.

This module includes opportunities to practice and assess your skills to conduct this type of analysis.

A Time Series is a series of data points indexed over time. Time series analysis are useful to monitor business or industrial processes or to track the evolution of business metrics such as blended learning, certification level, student satisfaction or any survey data... In most cases, new patterns can be identified by smoothing the data with a Single Moving Average or Single Exponential Smoothing, or by "pivoting" the data by hours, days, weeks, month or by year.

Note: The theoretical developments in time series analysis started with the autoregressive models in the 1920s. The description and characterization of time series was suggested at the same time by the Russian statistician and economist, E. Slutsky (1927), and the British statistician G.U. Yule (1921, 1926, 1927).

SKILL PRACTICE

1. Download the attached XLS file:

• The first tab contains Sample Data;
• The second tab Time Series Analysis explains the steps to conduct a Time Series analysis together with a sample analysis;

Please practice your skills in the third tab Skill Practice: first, an easy practice then more difficult.

2. Report the outcome of your practice in the Skill Assessment quiz.

At the end of this module, you will know how to:

• Create and interpret a Density Map using Excel feature;
• Create and interpret a Hexagon Map to represent US States with equal-size hexagons.

This module includes opportunities to practice and assess your skills to conduct this type of analysis.

A Density Map is a simple way to represent and analyze where locations may be concentrated in a given geographical areas. This can be used to find the best locations for a Training Facility or Instructor to minimize travel time for students.

The Excel template includes two types of Density Maps:

1. Excel Map (US, Global, Europe, ...)

2. Hexagon Chart (US-map)

SKILL PRACTICE

1. Download the attached XLS file:

• The first tab contains Sample Data;
• The second tab 2 Types of Density Maps explains the steps to build each map type.;

Please practice your skills in the tab Skill Practice: first, an easy practice then a more difficult practice.

2. Report the outcome of your practice in the Skill Assessment quiz.