Dimensional Modelling - Behaviour Study Groups

[bi_analyst_2024]

Hi, I hope everybody is good 😎

New to Power BI.

Does anybody have any experience of using behaviour study groups in Power BI. I need to filter my model based on a customer behaviour analysis - example: % of sales over a time period etc. The dataset is large and so my gut is to run the analysis during the refresh and then use the classifications to filter the model. However, I am not entirely certain how to model the table to constrain both the customer and date dimension? or alternatively attach it directly to the fact table? 

Any thoughts would be greatly appreciated.

[bi_analyst_2024]

Thanks for your response. Sure, I am aware of that. Interested in anyone's experience of using behaviour groups, specifically.

[Anonymous · Accepted solution]

Hi @bi_analyst_2024 ,

Regarding your question, when building a model, it is best to design it according to star architecture principles. That is, there is a one-to-many relationship between multiple dimension tables and a fact table.

I hope this article has been helpful to you.

Model relationships in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,
Wenbin Zhou