Learning Contents

Conditional Formatting and Sparklines

Preparing Datasets for Visualization

Creating Effective Charts with Design Best Practices

Creating a PivotChart

Types of Dashboard and Their Functions

Checklist for Creating a Dashboard

Step by Step Guide to Dashboarding

Interacting with your Charts

Progress so far

Learning Contents

Introduction to Statistical Data Analysis

One Categorical Variable - One Way Table & Pivot Table

One Categorical Variable - Pie Chart, Bar Chart & Application

One Numerical Variable - Central Tendency, Median, Mean, Mode & Application

One Numerical Variable - Dispersion, Variability, Range, Percentile, IQR, Outlier, Variance & Standard Deviation

One Numerical Variable - Boxplot, Histogram & Application

Examining Relationship - Two Categorical Variables (C->C) with Pivot Table

Examining Relationship - Two Categorical Variables (C->C) with Charts

Examining Relationship - Two Numerical Variable (Q->Q) with Pivot Table

Examining Relationship - Two Numerical Variable (Q->Q) with Pearson’s Correlation Coefficient

Examining Relationship - Two Numerical Variable (Q->Q) with Charts

Steps to Create Bar Chart, Pie Chart and Line Chart with Time Series

Conditional Formatting & Its Techniques

Types of Dashboard and Their Functions

Chart Tools & Their Functions

Excel Interface and Essentials

Types of Data

Steps to Create a Pivot Table

Welcome Notes & Learning Goals

Learning Contents

Welcome Notes & Learning Goals

Learning Goals

Learning Contents

Examples of Poor Storytelling

The Data Storytelling Process - Who

The Data Storytelling Process - What

The Data Storytelling Process - How

Storyboarding

Welcome Back!

Learning Goals

Delta

Learning Contents

Graphical Perception

Choosing a Visual

Making a Visual from Good to Great