This content has been marked as final. Show 2 replies
I would need some help to make some data modelling in tableau involving multitables.
I have following tables:
Sales transaction (Fact tables)
Sales Date (day)
Stock (Fact Table)
Stock Date (day)
Product (Dimension table)
Time Line (Dimension table)
I would need to join these tables in order to build a reporting comparing on the same time line (by week), same Client and same product ID for Sales Quantity vs Sotck Quantity.
I have no idea how to proceed in order to avoid too much data multiplication.
I have enclosed tableau file with my data model (I managed to build relationship between all tables but the stock table)
Would you have any suggestion on how I should join the stock table or any suggestion of data model in tableau when it comes to multiple fact table?