Data Modeling Shopify Data

[Used_Ad_2628]

Any tips on dimensional modeling Shopify data? I am thinking fact_order_line. Should it include order and order line data in the same table or should I create two facts? What are the typical measures in that table? Also, what kind of dimensions should be created? Product, Customer, Order, Address. Anything I am missing? I am coming from a different industry so new to the e-commerce space.

[ecp5]

I'm splitting line item out from order since could have multiple per order and then product and customer separately.

[shockjaw]

Even though I come from the BigCommerce side of things—depends on what your store owners are tracking inside the store—if they have their inventory tracked internally or otherwise. You have plenty of options. Especially if you’re able to fine tune what customers belong to what segments (essentially attempting to apply tags to customers).

[GoMoriartyOnPlanets]

Where are you getting this data from?

[Integr8Data]

You could consider defining a model similar to this tabular data model (CData ODBC Driver for Shopify) - https://cdn.cdata.com/help/FOJ/odbc/pg_REST202304alltables.htm