Forum Discussion

KunalKawale's avatar
KunalKawale
New Member
1 year ago
Solved

Opportunity Estimate Sales Order Data Modelling Question

I am working on a data model where the business requirements is to deep dive into the Opportunities, Estimates and Sales Order. Then conversion rates the turnaround time. Price Levels performance ...
data warehouse
  • lbendlin's avatar
    lbendlin
    1 year ago

    Power BI likes its data organized in facts and dimensions. It's not a hard requirement, but often leads to better performance.  In your case you will have to accept that the pristine 1:* relationships are not possible, and you have to carefully curate the direction of the *:* relationships to emulate a dimension -> fact hierarchy.

     

    Bridge tables are dimension tables that weren't invited to the party.  They are usually a design red flag. Instead, use TREATAS

lbendlin's avatar
lbendlin
Super User
1 year ago

Power BI likes its data organized in facts and dimensions. It's not a hard requirement, but often leads to better performance.  In your case you will have to accept that the pristine 1:* relationships are not possible, and you have to carefully curate the direction of the *:* relationships to emulate a dimension -> fact hierarchy.

 

Bridge tables are dimension tables that weren't invited to the party.  They are usually a design red flag. Instead, use TREATAS