How to create a star schema in Power BI and Tableau
ฝัง
- เผยแพร่เมื่อ 25 ส.ค. 2024
- This is an intro video on creating star schemas in power bi and tableau.
Microsoft resources:
docs.microsoft...
docs.microsoft...
docs.microsoft...
Tableau Resources:
help.tableau.c...
![[LIVE] : ONE ลุมพินี 76 | คู่เอก "ผึ้งหลวง vs สมิงดำ"](http://i.ytimg.com/vi/9SBshmGQOIM/mqdefault.jpg)
Thank you. Highlighting that the fact table should be the source of the many to one relationships helped me create a star schema. 😂 I think some people didn't like the video because this was implied but not heavily emphasized.
Awesome! And yeah good point lol
pl provide the sample tables
Great video. What about have two fact tables with common dimensions? How would you do it in Tableau?
Thanks for watching! So it's a limitiation right now but it was announced at the tableau conference that shared dimensions should be released soon. I haven't seen it yet but it's on their road map! www.tableau.com/blog/power-your-analytics-advantage-tableau-product-innovations#:~:text=Shared%20Dimensions%20allow%20for%20more,handle%20more%20complex%20data%20models.
@@SQLSekou Thank you for the information.
@@SQLSekouthanks for the video and for this link, the information is super valuable.
What would be the workaround in Tableau when the model consists of two fact tables and two shared dimension tables?
@@ignaciobavastro1023 great question! They are supposed to be releasing a shared dimension feature, but it looks like Tableau Pulse is taking priority. They announced shared dimension at Tableau Conference 2023, but we will havent seen anything
Here is a link that has some limted information on it www.tableau.com/blog/data-innovations-tableau-conference-2023?_ga=2.262844172.1829051671.1707245646-GA1.2.GA1.2.1415132684.1647282749&_gl=1*1tuea6r*_ga*R0ExLjIuR0ExLjIuMTQxNTEzMjY4NC4xNjQ3MjgyNzQ5*_ga_8YLN0SNXVS*MTcwNzI0NTY0Ni4xMTMuMS4xNzA3MjQ1Nzg0LjAuMC4w
@@SQLSekou but with the current capabilities (I don't think my company will upgrade to a new version right away) the only workaround you know is duplicating tables? or is there a more efficient/elegant way to model simple data?
Not helpful you are not showing how to actually create the fact tables etc
Thank you for watching!
As far not showing how to create the tables. Best practice is for that to be created in the source. I wouldn’t expect Tableau, Power BI or any BI tool to be place where that manipulation happens 😀
Useless
Thanks for watching!!!!