Analyzing ecommerce data in Tableau

Case Study: Ecommerce Analysis in Tableau

Dev Bhosale

Head of Business Intelligence

What is a case study?

  • Apply your skills
  • No new concepts
  • Solve a real-world problem
  • Fictitious data from online pet supply store - Munchy's

$$

Prerequisite courses:

  • Connecting Data in Tableau
  • Analyzing Data in Tableau
  • Calculations in Tableau

A dog with food bowl

Case Study: Ecommerce Analysis in Tableau

How is this course structured?

This case study consists of three chapters.

  • Chapter 1 - Build data sources and find sales growth opportunities
  • Chapter 2 - Save shipping expenses and improve profitability
  • Chapter 3 - Build an executive dashboard and communicate your insights

the course structure and chapters

Case Study: Ecommerce Analysis in Tableau

E-commerce operations and terminologies

total costs of a product in supply chain

Case Study: Ecommerce Analysis in Tableau

The data source

The data dictionary

Case Study: Ecommerce Analysis in Tableau

Munchy's business goals

Muncy's Business Goals

Two Cats with Food

Case Study: Ecommerce Analysis in Tableau

Increase sales

  • Cross-sell - promote a relevant product at the point of purchase
  • Upsell - promote a higher priced alternative or a higher quantity of a product

Dog eating food

Case Study: Ecommerce Analysis in Tableau

Shipping expense reduction strategies

woman and child shopping for pet food

  • Shipment consolidation
  • Shipping distance
  • Package dimensions or weight
  • Ship higher quantity
Case Study: Ecommerce Analysis in Tableau

Market basket analysis

  • Find products frequently bought together
  • Implemented as a correlation matrix
  • Value indicates the strength of the linear relationship

correlation between purchased quantity

Case Study: Ecommerce Analysis in Tableau

Let's practice!

Case Study: Ecommerce Analysis in Tableau

Preparing Video For Download...