Forum Discussion
Data modeling suggestion
Guys, good afternoon!
All good?
I would like your opinion for a modeling issue, as I did it in a way that is bringing the correct result, but when placing the values in a matrix, the matrix gives an error due to space problems, so I don't know if I did it in the best way. correct.
I have the following model
All dimension tables are related to fact tables. Each fact table represents a stage of my funnel.
I would like to obtain the following result:
- Number of broker per project
- Quantity of broker per period between the beginning and end of the project
I can have one or more brokers for each project and one project for or more for each broker (many to many).
So I combined all the brokers that are in the 4 fact tables and the corresponding projects, creating the _projetos_corretor table.
In a matrix I put the broker, the project and the amount of sales that come from my table fact _repasses (Vendas do Mês Colunm).
When I select the project, it correctly returns the values
But when I remove the filter and it tries to return all projects and brokers the following error occurs
There is not enough memory.
How could I improve my modeling? Is there a better way to do this?
Hello kasife ,
Mainly dimension tables would have a relation one to many with the fact tables where the dim table is the one side.in your case, it's working many to many. I suggest you check the concept of star schema data modeling and build your model as it.
star schema https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
2 Replies
- IdrissshatilaSuper User
Hello kasife ,
Mainly dimension tables would have a relation one to many with the fact tables where the dim table is the one side.in your case, it's working many to many. I suggest you check the concept of star schema data modeling and build your model as it.
star schema https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
- kasifeHelper V
Idrissshatila Thanks so much