Forum Discussion

rmcgrath's avatar
rmcgrath
Icon for Advocate III rankAdvocate III
2 years ago
Solved

Data Modeling

Hi, everyone - looking for a recommendation.  My original table is pretty wide (411 columns).  I'm creating my Fact table and realize I may have to create several Fact tables, as only one would still...
Need Help
Show and Tell
  • audreygerred's avatar
    audreygerred
    2 years ago

    Each fact table will connect to the dimension tables, then you will use the fields from your dimension tables with your measures based on your fact tables. Here is a blog I wrote about star-schema (my example only has one fact table, but it is applicable to having multiple fact tables as well). http://powerbiwithme.com/2023/07/30/the-star-schema-edition/ 

audreygerred's avatar
audreygerred
Icon for Super User rankSuper User
2 years ago

Hi! Your dimension tables would have your primary key and have the unique value and you would join that to the foreign key in your fact table which would have the many side of the join.

  • rmcgrath's avatar
    rmcgrath
    Icon for Advocate III rankAdvocate III
    2 years ago

    Yep - understand that...but what is the best way to make relationships when you have multiple Fact tables?  How do you get everything connected?  Example --> Fact Table to Fact Table

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

      Each fact table will connect to the dimension tables, then you will use the fields from your dimension tables with your measures based on your fact tables. Here is a blog I wrote about star-schema (my example only has one fact table, but it is applicable to having multiple fact tables as well). http://powerbiwithme.com/2023/07/30/the-star-schema-edition/