Multiple fact tables and multiple dim tables

[Anonymous]

Hi, 

I'm really struggling with the data model for our 3 shopify stores. The data is coming through a data warehouse so all tables are nested. Instead of just an orders table I'm getting a orders_orders, orders_fulfilment table etc. So lots and lots of tables x3 for all the stores.

Is anyone able to recommend the best way to model all the data? I am trying to merge and append the data at the moment but not sure if there's a more efficient way. I'm also struggling to link my product and orders table.

Any help would be much appreciated

Kind regards 

[EugeneLebedev]

You can use this service for extracting data from Shopify: https://vidi-corp.com/how-to-connect-shopify-to-power-bi/

It includes extracting data from multiple stores. You would essentially get a column for "Store name" in every table so you don't have to append and merge multiple tables.

[Fowmy · Accepted solution]

@Anonymous 

If you can get the table separated and stored as fact and dimensions at WH level, it will excellent. Otherwise, try to create the same in Power Query. Crating a STAR scheme is the right way to go where you will FACT tables connected to dimensions.