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

  Рет қаралды 35,612

London Business Analytics Group

London Business Analytics Group

Күн бұрын

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/yc...

Пікірлер: 45
@mohamadiqbalsetiawan3953
@mohamadiqbalsetiawan3953 2 жыл бұрын
Yess this is what I need as newbie in PowerBI, thank you for your easy to understand explanations.
@LondonBusinessAnalyticsGroup
@LondonBusinessAnalyticsGroup 2 жыл бұрын
You're very welcome!
@allwynmendes
@allwynmendes 4 жыл бұрын
Thanks Chris! Appreciate this being on KZfaq :)
@afonsoosorio2099
@afonsoosorio2099 2 жыл бұрын
Chris, great 👍 tutorial. Pure Gold, tidy and well delivered. Thank you sharing. Keep it up
@MohamedTaha057
@MohamedTaha057 Жыл бұрын
Hello Chris, thanks for sharing this excellent video!
@PaulEBrownbill
@PaulEBrownbill 4 жыл бұрын
Thank you Chris, really good recap which I can use for future reference. Paul
@LondonBusinessAnalyticsGroup
@LondonBusinessAnalyticsGroup 3 жыл бұрын
Glad it was helpful!
@joanneosborne2428
@joanneosborne2428 3 жыл бұрын
Great video. I really enjoyed the way you explained it all. Thank you 😊
@chrisbarber639
@chrisbarber639 3 жыл бұрын
Thank you Joanne
@oliveroshea5765
@oliveroshea5765 4 жыл бұрын
Thanks for this Chris and Mark!
@LondonBusinessAnalyticsGroup
@LondonBusinessAnalyticsGroup 4 жыл бұрын
Hi Ollie - Our pleasure!
@kendrybautistam.8413
@kendrybautistam.8413 2 жыл бұрын
Hello Chris, excellent video! Would you be so kind as to update the files link? It says “it has expired.” Thank you in advance!
@midsummer4864
@midsummer4864 4 жыл бұрын
Thanks Chris. Much appreciated
@LondonBusinessAnalyticsGroup
@LondonBusinessAnalyticsGroup 3 жыл бұрын
Very welcome
@vladx3539
@vladx3539 Жыл бұрын
Best Video Ive watched so far! Brilliant
@keagankemp6275
@keagankemp6275 Жыл бұрын
Wow thanks for this been using PBI for years but learnt a lot
@Younessss_
@Younessss_ 2 жыл бұрын
thanks :) your effort is very well appreciated
@LondonBusinessAnalyticsGroup
@LondonBusinessAnalyticsGroup 2 жыл бұрын
It's my pleasure
@elizabethurom6494
@elizabethurom6494 2 жыл бұрын
Thanks Chris for this explanatory video. Could you please reupload the file. Please provide access.
@ashirbadparida3268
@ashirbadparida3268 Жыл бұрын
Nicely explained...Could you please share the datasets...The datasets link got expired
@fadwa2413
@fadwa2413 2 жыл бұрын
Thank You!!
@Max-wo7zp
@Max-wo7zp 2 жыл бұрын
Could you reupload the files please? The link is expired. Thanks.
@abdulrahmanZaki100
@abdulrahmanZaki100 Жыл бұрын
Great tutorial,, Could you share the datasets again please ?? ...The datasets link got expired
@shubhambhoyar8957
@shubhambhoyar8957 2 жыл бұрын
Link to download dataset has been expired can you please provide new one
@ececphuah5868
@ececphuah5868 2 жыл бұрын
Thanks Chris! Unable to download as the link already expired! Can you please provide access to download the files? Thanks
@ramkrishnasingh2049
@ramkrishnasingh2049 Жыл бұрын
need this data set
@nikhilchaudhari6572
@nikhilchaudhari6572 3 жыл бұрын
Hello Chris I am not able to download the files Could you please provide access for that
@jcmoscon
@jcmoscon 2 жыл бұрын
Yeah, that would be great if he could provide the file again. The link has expired.
@azizquazi
@azizquazi 3 жыл бұрын
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
@TinyKideo 2 жыл бұрын
The best way is to duplicate instead of reference.
@husnabanu4370
@husnabanu4370 3 жыл бұрын
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?
@garyk4439
@garyk4439 2 жыл бұрын
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.
@barttitulaerexcelbart9400
@barttitulaerexcelbart9400 4 жыл бұрын
Thank you Chris, well explained. Was this a live performance? How do you do this with these colored lines, just as you present?
@LondonBusinessAnalyticsGroup
@LondonBusinessAnalyticsGroup 4 жыл бұрын
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
@ashirbadparida3268 Жыл бұрын
@@LondonBusinessAnalyticsGroup Hii could you plz share the dataset link
@nicopicco
@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?
@vladx3539
@vladx3539 Жыл бұрын
could you reshare the date spreadsheet!
@sureshsonti8097
@sureshsonti8097 3 ай бұрын
Can someone please share the dataset file
@sik9802
@sik9802 2 жыл бұрын
The file download link is expired. Can you please provide the link again? Thanks
@jithinjayan4447
@jithinjayan4447 2 жыл бұрын
Can you please share the source files as the link has expired
@artieboy24
@artieboy24 2 жыл бұрын
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
@inaammuaz2284 2 жыл бұрын
I would recommend you to look into normalization
@vishalmane3139
@vishalmane3139 Жыл бұрын
Remove dupa from region currency
@shanibpatel
@shanibpatel 2 жыл бұрын
file download link has been expired
@romancherevatenko5658
@romancherevatenko5658 9 ай бұрын
Too complicated)) There is no need in such things.
Gathering data from APIs in Power BI
25:15
London Business Analytics Group
Рет қаралды 31 М.
Power BI Masterclass: Data Modeling 101
56:54
CRG Quisitive
Рет қаралды 55 М.
👨‍🔧📐
00:43
Kan Andrey
Рет қаралды 9 МЛН
Son ❤️ #shorts by Leisi Show
00:41
Leisi Show
Рет қаралды 10 МЛН
Why Is He Unhappy…?
00:26
Alan Chikin Chow
Рет қаралды 100 МЛН
Вы чего бл….🤣🤣🙏🏽🙏🏽🙏🏽
00:18
🚨 YOU'RE VISUALIZING YOUR DATA WRONG. And Here's Why...
17:11
Adam Finer - Learn BI Online
Рет қаралды 58 М.
Dimensional Modeling - Declaring Dimensions
55:32
Pragmatic Works
Рет қаралды 24 М.
How to Move Data Automatically Between Excel Files
11:37
Kenji Explains
Рет қаралды 66 М.
Fact table and Dimension table | Data Warehousing
7:56
Kishan Mashru
Рет қаралды 69 М.
Star schema or single table in Power BI
35:54
SQLBI
Рет қаралды 37 М.
Data Modeling Tutorial: Star Schema (aka Kimball Approach)
16:34
Kahan Data Solutions
Рет қаралды 105 М.
Data Modelling - Star Schema, Snowflake Schema
47:53
Kamala - MSTR Videos D
Рет қаралды 13 М.
The Dimensional Dilemma and Power BI
19:35
Paul Turley
Рет қаралды 6 М.
Dimensional Modeling
53:54
Bryan Cafferky
Рет қаралды 166 М.
👨‍🔧📐
00:43
Kan Andrey
Рет қаралды 9 МЛН