Data model with multiple sales tables

Question

Hi,&nbsp;I'm trying to build a sales data dashoboard with data that comes from our data warehouse. The issue i have is that we have multiple shopify stores. Therefore i have multiple sales tables, customer tables etc. Does anyone know the best way to model this in order to give total sales etc.&nbsp;Any help would be much appreciated.

amitchandak · Answer

Jameswh91 , If want to combine analysis better append the sales table. The customer you need to master data management, In case you can not just append and use

jameswh91 · Answer

Hi&nbsp;amitchandak&nbsp;thanks for your reply. It is much appreciated. Once the quesries have been appended, how would i then be able to differentiate the separate stores?

pauldbrown · Answer

Add a column to each store query with the store ID or name before appending them.

anonymous · Answer

Hi, i would suggest that you create a birdge table containing names of unique stores. Then add the store name column in each sales table with one to many relation. This will give you sales for all stores.&nbsp;

jameswh91 · Answer

Anonymous&nbsp;PaulDBrown&nbsp;amitchandak&nbsp;Many thanks for your help. My model is still looking odd, with no logical way of connecting the Product Orders able to the Sales Table. Unfortunately the sales table has no columns relating to the product purchased.&nbsp;I've attached an image for reference.

Forum Discussion

Data model with multiple sales tables

6 Replies

Related content

Data Modeling multiple value bridge tables

One Semantic Model for Multiple Reports

multiple or single semantic model

power bi report based on multiple semantic models

Direct Lake Model - Calculated Column/Tables