Forum Discussion

XY_Z's avatar
XY_Z
Regular Visitor
2 years ago

Modeling with multiple facts table

Hi everyone, I need some guidance/best practice on improving the following data model. There are multiple hierarchies from the least granular at level 1 to the most granular at level 3.  There is a d...
Need Help
XY_Z's avatar
XY_Z
Regular Visitor
2 years ago

Thank you Anonymous for your input! The tables are already in import mode. Some additional concern for combining dimension tables is that the relationship to level 1/2 fact table will become many-many which may not be ideal.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi XY_Z 

     

    For your question, you may want to consider data cleansing to reduce redundant fields in your tables.

     

    Reduce the size of the data model and remove duplicate values through data cleansing.

     

    We recommend that you design your model with the required columns based on your reporting requirements.

     

    Remove unnecessary rows by removing duplicate values.

     

    Grouped aggregation operations on fact tables, which can be used to increase the granularity of fact type tables.

     

    You can view the link below for more details:

    Data reduction techniques for Import modeling - Power BI | Microsoft Learn

     

    Best Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.