Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Data Modelling - MS Dynamics CRM onprem OData-Feed

Hi Guys,

 

We import our CRM data from MS Dynamics CRM to Power Bi via Odata Feed.
I'm currently trying to create a general template in which users should be provided with a finished data model. I read that the star schema is preferred for a data model.

The main problem here, however, is that I don't know which entity I should use as a fact table or which information in the fact table is suitable, for example, to sensibly link entities such as opportunities, quotes, orders, accounts... with each other. In MS Dynamics CRM there are a lot of relationships between the individual entities.

 

Unfortunately, I can't get this amount of relationships represented in PBI.

 

I would appreciate some help/tips.

 

Thanks in advance.

Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    Anonymous , while account will be dimension and orders will be a fact.

     

    but opportunity and quote will act as dimensions as well as facts. also, they will merge with another fact to make the self suffcient so that do not have to join with another fact say opportunity

     

    opportunity dim -> opportunity 

     

    opportunity fact -> opportunity 

     

    quote dim -> quote

     

    quote fact - opportunity + quote

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

    Anonymous , while account will be dimension and orders will be a fact.

     

    but opportunity and quote will act as dimensions as well as facts. also, they will merge with another fact to make the self suffcient so that do not have to join with another fact say opportunity

     

    opportunity dim -> opportunity 

     

    opportunity fact -> opportunity 

     

    quote dim -> quote

     

    quote fact - opportunity + quote