Data Modelling: From Single Table To Star Schema - Chris Barber

Chris Barber starts with an overview of data modelling, looking at what data modelling is and why it is so important. He focuses on 3 specific elements: 1) Star Schema Facts and Dimensions, 2) Role Playing Dimensions, and 3) Degenerate Dimensions.
Files can be downloaded from tinyurl.com/ych6n5p8

[@allwynmendes]

Thanks Chris! Appreciate this being on KZbin :)

[@mohamadiqbalsetiawan3953]

Yess this is what I need as newbie in PowerBI, thank you for your easy to understand explanations.

[@LondonBusinessAnalyticsGroup]

You're very welcome!

[@afonsoosorio2099]

Chris, great 👍 tutorial. Pure Gold, tidy and well delivered. Thank you sharing. Keep it up

[@joanneosborne2428]

Great video. I really enjoyed the way you explained it all. Thank you 😊

[@chrisbarber639]

Thank you Joanne

[@MohamedTaha057]

Hello Chris, thanks for sharing this excellent video!

[@oliveroshea5765]

Thanks for this Chris and Mark!

[@LondonBusinessAnalyticsGroup]

Hi Ollie - Our pleasure!

[@PaulEBrownbill]

Thank you Chris, really good recap which I can use for future reference. Paul

[@LondonBusinessAnalyticsGroup]

Glad it was helpful!

[@vladx3539]

Best Video Ive watched so far! Brilliant

[@midsummer4864]

Thanks Chris. Much appreciated

[@LondonBusinessAnalyticsGroup]

Very welcome

[@Younessss_]

thanks :) your effort is very well appreciated

[@LondonBusinessAnalyticsGroup]

It's my pleasure

[@keagankemp6275]

Wow thanks for this been using PBI for years but learnt a lot

[@fadwa2413]

Thank You!!

[@kendrybautistam.8413]

Hello Chris, excellent video! Would you be so kind as to update the files link? It says “it has expired.” Thank you in advance!

[@elizabethurom6494]

Thanks Chris for this explanatory video. Could you please reupload the file. Please provide access.

[@husnabanu4370]

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?

[@Max-wo7zp]

Could you reupload the files please? The link is expired. Thanks.

[@azizquazi]

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.

[@TinyKideo]

The best way is to duplicate instead of reference.

[@barttitulaerexcelbart9400]

Thank you Chris, well explained. Was this a live performance? How do you do this with these colored lines, just as you present?

[@LondonBusinessAnalyticsGroup]

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

[@ashirbadparida3268]

@@LondonBusinessAnalyticsGroup Hii could you plz share the dataset link

[@ececphuah5868]

Thanks Chris! Unable to download as the link already expired! Can you please provide access to download the files? Thanks

[@ashirbadparida3268]

Nicely explained...Could you please share the datasets...The datasets link got expired

[@ramkrishnasingh2049]

need this data set

[@shubhambhoyar8957]

Link to download dataset has been expired can you please provide new one

[@abdulrahmanZaki100]

Great tutorial,, Could you share the datasets again please ?? ...The datasets link got expired

[@nikhilchaudhari6572]

Hello Chris I am not able to download the files Could you please provide access for that

[@jcmoscon]

Yeah, that would be great if he could provide the file again. The link has expired.

[@garyk4439]

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.

[@vladx3539]

could you reshare the date spreadsheet!

[@sik9802]

The file download link is expired. Can you please provide the link again? Thanks

[@sureshsonti8097]

Can someone please share the dataset file

[@jithinjayan4447]

Can you please share the source files as the link has expired

[@shanibpatel]

file download link has been expired

[@nicopicco]

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?

[@artieboy24]

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

[@inaammuaz2284]

I would recommend you to look into normalization

[@vishalmane3139]

Remove dupa from region currency

[@romancherevatenko5658]

Too complicated)) There is no need in such things.