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?
Solved! Go to 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'.
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 🙂
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'.
User | Count |
---|---|
129 | |
61 | |
55 | |
54 | |
43 |
User | Count |
---|---|
127 | |
60 | |
57 | |
56 | |
50 |