Enqurious LogoTM

Use coupon code 'ENQSPARKS25' to get 100 credits for FREE

0
0
Days
0
0
Hours
0
0
Minutes
0
0
Seconds

Data Interpretation, Visualization and Statistics

6 Scenarios
5 Hours 20 Minutes
Beginner
masterclass poster
Industry
e-commerce
Skills
data-understanding
data-quality
data-visualization
approach
Tools
excel

Learning Objectives

Profiling with Measures of Central Tendencies
Profiling with Measures of Dispersion
Outliers lead to Skewness
Importance of Descriptive Statistics to draw the business decision
Use cases of different variety of charts in Excel

Overview

GlobalMart's Vendor Operations team has a key goal: On-Time Deliveries of orders.

In fact, GlobalMart CEO wants to run campaigns with taglines like :

  • Delivery, you can trust
  • 7 Day Guaranteed delivery

Those are pretty lofty claims!

  • What does the actual data say?
  • When do we say 7 Day delivery, how confident are we about this number?
  • Are GlobalMart vendors trustworthy?
  • Are there vendors whose delivery performance is erratic? Who all have demonstrated stability in delivery times

In order to achieve the same, they constantly track orders from the time they were placed to the time they were delivered to the end customer.

Dave, Senior Manager of the Vendor Ops team has to make a presentation to The Head of Vendor Ops to apprise him about the current situation with order deliveries. However, he has data for almost 5000 orders. He's in a fix as in how to summarize if everything's all right with delivery in brief to his boss.

He has reached out to Ryan, the Data Scientist to help him out by summarizing 5000-odd delivery data into a few lines which are easily interpretable and readily actionable.

However, Ryan himself is new to the world of analytics and has briefly heard of Descriptive Statistics as a way of summarizing data. He reached out to Senior Data Scientist Mike for help in preparing the report for Dave.

Prerequisites

  • Data Analysis using Excel