Analyzing ecommerce data

Case Study: Ecommerce Analysis in Power BI

Iason Prassides

Content Developer, DataCamp

What is a case study?

  • Apply your skills
  • No new concepts
  • Solve a real-world problem

$$

Prerequisite courses:

  • DAX Functions in Power BI
  • Data Visualization in Power BI

Young female character writing code on a desktop computer

Case Study: Ecommerce Analysis in Power BI

Case study goals

  • Fictitious data from online pet supply store - Whiskique
  • Hired as a new analyst to provide insights
  • Analyze an ecommerce dataset
  • Leverage Power BI to create an engaging dashboard-style pages

A dog with food bowl

Case Study: Ecommerce Analysis in Power BI

Ecommerce operations and terminologies

Total costs of a product in supply chain

Case Study: Ecommerce Analysis in Power BI

Whiskique's business goals

Primary Business Goals

  • Serve as many customers as possible and increase sales
  • Reduce operating costs

Two Cats with Food

Case Study: Ecommerce Analysis in Power BI

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 Power BI

Shipping cost reduction strategies

Woman and child shopping for pet food

  • Shipment consolidation
  • Package dimensions or weight
  • Ship higher quantity
Case Study: Ecommerce Analysis in Power BI

Market basket analysis

  • Find products frequently bought together
  • Determine correlation coefficient between purchased items
    • Implemented as a correlation matrix
  • Out of scope for this course
  • Can identify frequency products are purchased with together

A man purchasing items at a supermarket, holding a basket with all their items

Case Study: Ecommerce Analysis in Power BI

The data source

The data dictionary

Case Study: Ecommerce Analysis in Power BI

Let's practice!

Case Study: Ecommerce Analysis in Power BI

Preparing Video For Download...