TPC Database & Tables

TPC data, which is public, will be used for this workshop. These data represent transactions data for thousands of products along with customer information, demographics, household details, inventory, web sales, promotions and returns. The following diagram represents their relations for online sales: Entity Diagram For this workshop, we will focus on the following tables from the TPC database:
  • web_sales
  • web_page
  • promotion
  • item
  • customer
  • customer_address
  • household_demographics
  • income_band

Entire TPC data dictionary is available here.