When you first log in to Pecan, there’s a demo data connection that is already configured in your account called “demodata”.
This connection allows you to test Pecan and train some models even without connecting your data.
In this article, you can see the demo data schema and table samples.
You can also view the tables in your notebook by creating a new SQL cell and running:
select * from demodata.TABLE_NAME
And replacing the TABLE_NAME with one of the following table names.
Tables overview
Table name | Description |
data related to the customer | |
customer purchases | |
customer became VIP (tier) | |
promotions sent to the customer | |
customer calls received by the call center | |
customer subscription plans history |
customers table sample
transactions table sample
operating_department - The department that works on the order
service_id - Where the customer received service
quantity - Quantity purchased in the order
vip_members table sample
status_change_date - the date a customer converted to become a VIP
sales_channel - the channel the customer upgraded through
campaigns table sample
support_calls table sample
subscriptions table sample
