Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

What is better between Star Schema x Append?

The title is self explanatory but what is the difference? do both serve the same purpose? what are the advantages and disadvantages between them.

1 ACCEPTED SOLUTION

@Anonymous - I would append your two tables ensuring that you have a Location ID in your fact table. I would then create a Location dimension as a separate table. So:

 

Location

LocationID,Name

1,Paris

2,New York

 

Fact Table

LocationID,Date,Rainfall

1,1/1/2020,2

1,1/2/2020,3.5

...

 

You would also want a Date dimension (calendar table)


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

@Anonymous - I do not find this self-explanatory at all. A Star Schema involves a fact table and multiple dimension tables. I don't understand how this compares to an Append? Are you saying a Star Schema versus a single fact table with no dimension tables?

 

The generally accepted best practice is a star schema as performance is better, etc. etc. etc. @marcorusso and others have tons of material on this.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@Greg_Deckler 

I have 5 bases with dimensions, I can create a fact table and join the 5 dimensions. But as all dimensions are equal in the 5 bases, what changes is just the location, I can make an append

 

Example: I have 2 bases, one from each location, but they all have the same dimension.

 

Table 1 - Paris

Days and Rainfall

 

Table 2 - New York

Days and Rainfall

 

I can make a fact table with the names of New York and Paris, or I can make an append.

 

Everyone has the same purpose, but which would be better?

@Anonymous - I would append your two tables ensuring that you have a Location ID in your fact table. I would then create a Location dimension as a separate table. So:

 

Location

LocationID,Name

1,Paris

2,New York

 

Fact Table

LocationID,Date,Rainfall

1,1/1/2020,2

1,1/2/2020,3.5

...

 

You would also want a Date dimension (calendar table)


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors