Data Modeling Archives - DataMartIn Data Modeling Archives - DataMartIn

The Blog

Tag: Data Modeling

  • Best Practices to Handle Multiple Fact Tables in Power BI

    Scenario 1: Multiple fact tables thar are not related to each other Solution: Relate every dimension with their respective fact tables. Identify the shared dimensions. Relate them with every fact. Sometimes this model is called constellation schema, where each fact table individually is a perfect star schema design because each one is related with a…

    Read article →

  • Importance of Query folding and good practices
    ,

    Importance of Query folding and good practices

    Query Folding is the capability of Power Query to delegate some of the transformations to the source to improve performance. In this post you will see its importance and good practices guide to achieve it. According to official documentation the following data sources support query folding: – Relational databases (SQL Server, Oracle, etc.). -OData sources (including…

    Read article →