Using Data Analytics in Supply Chain 

Welcome to supply chain data analyst professional certificate

Welcome to using data analytics in supply chain

Data basics and why data governance matters

How I use data analytics

Introduction to data

Data main sources

The importance of data quality

Introduction to supply chain data analysis

Supply chain data analysis process

Types of data

Organize and format

Using spreadsheets in data analysis: Functions and formulas

Using spreadsheets in data analysis: Pivot tables and macros

Introduction to data governance

Data governence framework

Adhering to data governance policies

Data ethics

Unilever positioning statement

Supply chain data analyst professional certificate syllabus

Examples of data

Dimensions of quality data

Data analysis tools

Data quality vs. data governance

Can you spot quality data?

Prosacco activity: Use spreadsheets to organize data

Supply chain data analysis and tools

Data basics and why data governance matters

Welcome to define the data objective

Identify your data analysis objectives

Identify your questions to be answered

Identify the sources of data

Define and obtain the data

Gather the data

Introduction to data preparation

Data cleansing part 1

Data cleansing part 2

Impact of bad data

Using spreadsheets to clean the data

Fill the gaps in data

Write SMART objectives

The five W's and one H

Activity exemplar: Identify your data analysis objective

How to identify the sources of data

How to define which data to obtain

Quality data vs. bad data

Prepare the clean data

Activity exemplar: Prepare the data

Prosacco activity: Identify your data analysis objective

Define the data objective

Prosacco activity: Gather the data

Gather the data

Prosacco activity: Prepare the data

Define and prepare the data

Welcome to analyze, validate, and intepret the data

How to analyze the data

How to apply calculations using spreadsheets

How to apply summarizations using spreadsheets

How to apply averages using spreadsheets

How to apply classifications of information using spreadsheets

Introduction to data validation

Types of data validation

How to perform data validation

Steps to take if errors exist

How to interpret the data

How to explain the data

Reporting the findings

Solving common challenges in data analysis

Activity exemplar: Apply calculations, summarizations, averages and classifications of information

Solving common challenges of data validation

Activity exemplar: Validate your data

Best practices for reporting

Prosacco activity: Apply calculations, summarizations, averages and classifications of information

Analyze the data

Prosacco activity: Validate your data

Data validation

Prosacco activity: Develop a quick summary or report

Analyze, validate, and intepret the data

Share if errors existed in your data and how you corrected those errors.

Welcome to data visualization

Introduction to data visualization

Charts or graphs

Tables

Dashboards

Geospatial visualization

Introduction to storytelling

How to tell a story

Define your audience

Using visualization tools in storytelling

Determine the best presentation method

Data visualization tools

Data visualization best practices

How I use storytelling with my stakeholders

Draft a story

Prosacco activity: Create data visualizations

Data visualization

Using storytelling

Prosacco activity: Draft your story

Data visualization

Presentation skills basics

Effective presentation skills: Physical

Effective presentation skills: Verbal

Create your presentation: Google Slides or PowerPoint

Create your presentation: Tableau

Create your presentation: Power BI

How to improve presentation skills

Presentation best practices and examples

Example of an analyst presenting findings to a leader

Start your portfolio

Using data analytics in supply chain summary and resources

Presentation skills

Present the data to your audience

Prosacco activity: Create your presentation