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

v-menakakota's avatar
v-menakakota
Community Support
1 year ago

Hi KunalKawale ,

I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

 

Thank you.

v-menakakota's avatar
v-menakakota
Community Support
1 year ago

Hi KunalKawale ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Thank you.