In my current dashboard I have a complex data model where multiple fact tables have connected to dimension tables and then sub dimension tables, due to this I'm getting severe performance issues. Attached data model for reference
I want to simplify the data model by creating the link table and then connect all the dimension and fact tables to link table so that performance is improved.
I have attached both current and required data model images for reference.
Could you please someone take a look and help me on this.
A link-table model is rather not suitable if there are already performance-issues. Recommended as best compromise between efforts, simplicity and performance is to use a star-scheme model. Means merging all facts into a single fact-table which also avoids most of the association trouble.
