Forum Discussion

Jameswh91's avatar
Jameswh91
Helper III
3 years ago

Shopify Data Modelling

Hi,    Has anyone built a data model using to shopify tables. Should i merge the tables or use relationships for them. I've not used a data model like this prior so any help would be much appreci...
Need Help
Show and Tell
Tips and Tricks
Shubham_rai955's avatar
Shubham_rai955
Super User
8 months ago

Use relationships to build a star schema data model for Shopify tables—do not merge them.​

Recommended Star Schema

Fact Table: Orders (or Order Line Items) with measures like Revenue, Quantity, containing foreign keys.​
Dimension Tables:

  • Customers (CustomerID → Orders)

  • Products (ProductID → Order Line Items)

  • Date (OrderDate → Orders)

  • Locations/Shipping (if available)​

Setup Steps

  • Import Shopify tables via Web connector (Orders, Products, Customers, Line Items).​

  • Create 1:many relationships: Products[ID] → LineItems[ProductID], Customers[ID] → Orders[CustomerID], Orders[ID] → LineItems[OrderID].​

  • Hide redundant columns (IDs in fact tables), mark Date table, set filter directions from dimensions to facts.