How to create data model with limited dimensions but multiple fact tables

[Anonymous]

I need to create a dashboard using multiple excel files that are coming thru automated workflows. Each file is a fact file but the fields are all different except 3 columns. Each of the 3 columns have a dimension related table in Data warehouse. 

So when I load all fact tables and dimension tables, I am looking at 5-6 fact tables with common columns connected to each of the dimension table. 

How do I create a star schema (or) any other alternative to have a clean data model? 

[Anonymous]

Thank you ! Initially i was skeptical about the data model as I was always thinking the model should be star / snowflake type but the model I work is kind of exactly opposite to star model. However, I tried to create dashboard based on your tips above. So far so good 🙂 

[MisterFry · Accepted solution]

Hi Poova, 

You've kinda answered your own question here. 

You would create one-way relationships between each of the dimensions, and each of the facts, where relevant. Because you're using one-way relationships, you won't run into circular references.

In the case of many to many relationships, you can still specify a single cross filter direction though the default is 'both'.