A question - we duplicated the fact table to create the dimension table. I remember from another video that creating a reference (instead of duplicate) could be more dynamic so that any changes in the source file will update the dimension automatically. Could you please review this and advise. Thanks.
Hi Bart, Chris used zoomit for the lines and boxes. For all videos on the channel, we don't record the live session but make a separate recording. - Mark
Hey great video.... My db has huge table with more than 30 columns and table size 1 million... When i take 3-4 columns to create index the no of rows arent reducing...however when i take single column create index i can c huge differnce so do i have to create 30 index?
Why are you duplicating instead of refencing? If this is data the changes all the the would it not be better to reference because to new data gets tricked through each query?
Hi Chris/London Business Analytics Group, it would be highly appreciated if you can point me to a valid place to download the transaction and date files.
Region;Region Name; Region Currency EUR;Europe;GBP EUR;Europe;ERO Can the relationship between the Region table and Sales table be set based on two columns? For example, if the Region table had two currencies for Euorpe. I guess this is a one to many based on multiple columns. Is this possible in the star schema? Thank you
Yess this is what I need as newbie in PowerBI, thank you for your easy to understand explanations.
You're very welcome!
Thanks Chris!
Appreciate this being on RUclips :)
Chris, great 👍 tutorial. Pure Gold, tidy and well delivered. Thank you sharing.
Keep it up
Thanks for this Chris and Mark!
Hi Ollie - Our pleasure!
Hello Chris, thanks for sharing this excellent video!
Thank you Chris, really good recap which I can use for future reference. Paul
Glad it was helpful!
Great video. I really enjoyed the way you explained it all. Thank you 😊
Thank you Joanne
Thanks Chris. Much appreciated
Very welcome
Best Video Ive watched so far! Brilliant
Wow thanks for this been using PBI for years but learnt a lot
thanks :) your effort is very well appreciated
It's my pleasure
Hello Chris, excellent video!
Would you be so kind as to update the files link? It says “it has expired.” Thank you in advance!
Thank You!!
Thanks Chris for this explanatory video. Could you please reupload the file. Please provide access.
Nicely explained...Could you please share the datasets...The datasets link got expired
Could you reupload the files please? The link is expired. Thanks.
Link to download dataset has been expired can you please provide new one
A question - we duplicated the fact table to create the dimension table. I remember from another video that creating a reference (instead of duplicate) could be more dynamic so that any changes in the source file will update the dimension automatically. Could you please review this and advise. Thanks.
The best way is to duplicate instead of reference.
Thanks Chris! Unable to download as the link already expired! Can you please provide access to download the files? Thanks
Thank you Chris, well explained. Was this a live performance? How do you do this with these colored lines, just as you present?
Hi Bart, Chris used zoomit for the lines and boxes. For all videos on the channel, we don't record the live session but make a separate recording. - Mark
@@LondonBusinessAnalyticsGroup Hii could you plz share the dataset link
Hello Chris I am not able to download the files Could you please provide access for that
Yeah, that would be great if he could provide the file again. The link has expired.
Great tutorial,, Could you share the datasets again please ?? ...The datasets link got expired
need this data set
Hey great video.... My db has huge table with more than 30 columns and table size 1 million... When i take 3-4 columns to create index the no of rows arent reducing...however when i take single column create index i can c huge differnce so do i have to create 30 index?
Why are you duplicating instead of refencing? If this is data the changes all the the would it not be better to reference because to new data gets tricked through each query?
Hi Chris/London Business Analytics Group, it would be highly appreciated if you can point me to a valid place to download the transaction and date files.
could you reshare the date spreadsheet!
Can someone please share the dataset file
Region;Region Name; Region Currency
EUR;Europe;GBP
EUR;Europe;ERO
Can the relationship between the Region table and Sales table be set based on two columns? For example, if the Region table had two currencies for Euorpe. I guess this is a one to many based on multiple columns. Is this possible in the star schema? Thank you
I would recommend you to look into normalization
Remove dupa from region currency
The file download link is expired. Can you please provide the link again? Thanks
Can you please share the source files as the link has expired
file download link has been expired
Too complicated)) There is no need in such things.