How to setup a Star Schema Data Model in Power BI - Easy guide

  Рет қаралды 85,395

Chandoo

Chandoo

Күн бұрын

Пікірлер: 132
@arjundev4908
@arjundev4908 2 жыл бұрын
Can't thank enough sir. Your teaching skills as always Wow :)
@chandoo_
@chandoo_ 2 жыл бұрын
My pleasure!
@flammabledoge811
@flammabledoge811 Жыл бұрын
Indians best educators. Thanks from Philippines!
@cartrack1553
@cartrack1553 Ай бұрын
Sir, Don't know how to thank you. Your way of teaching is world apart. I have learned all the concepts from you, and your videos never disappoint. (Less time and complete knowledge) Many thanks for creating such videos. Would love to see more videos on Data Engineering topic, though there are many videos out there, but would love to see it in your way of teaching. Lots of love and well wishes for your health.
@Dragz672
@Dragz672 Жыл бұрын
I've watched several videos in the past about this and only now do i feel confident about it. Keep it up!
@sanwar1
@sanwar1 2 жыл бұрын
What a refreshing tutorial. So easy to grasp these concepts when they are laid out visually like this. Please make other videos such as this one!
@chandoo_
@chandoo_ 2 жыл бұрын
Thanks Sanwar.. I have a few "watch next" recommendations in the video description. Do check them out.
@prakashvantamutte159
@prakashvantamutte159 Ай бұрын
Sir You are just simply Away some by name n tagline....I just thank enough Sir.. your explanation with practical example , it just came out Wow from inside.. great !!!!
@navinkrish8741
@navinkrish8741 21 күн бұрын
Only passionate people can teach like this ❤
@mansijswarnkar4389
@mansijswarnkar4389 2 жыл бұрын
That's an innovative way to teach! A great example of design thinking!
@chandoo_
@chandoo_ 2 жыл бұрын
Thanks Mansij...
@sohjuvitus447
@sohjuvitus447 10 ай бұрын
Much much respect and appreciation for this. Delivering this couldn't be better than it is
@holla4691
@holla4691 9 ай бұрын
You are such an amazing teacher! The illustration with the tables and strings was very cleverly done. Thank you so much for teaching me how to understand Star Schemas. Everything is so clear now.
@RaphaelNweke-g2v
@RaphaelNweke-g2v 9 ай бұрын
Thank you so much chandoo. I have learnt alot from you.much love from 🇳🇬
@petecardona8203
@petecardona8203 2 жыл бұрын
This is just the explanation that I get. I guess is the child inside reminding me of my prep school day's teachers. Thank you so much Chandoo. I really, really enjoy your teachings.😊
@ivytech-khatton20
@ivytech-khatton20 Жыл бұрын
I love your teaching style and use your videos as additional resources for my intro to Power BI students. THANK YOU!
@chandoo_
@chandoo_ Жыл бұрын
You're very welcome!
@interest2006
@interest2006 Жыл бұрын
The Best explanation of ONE to MANY!
@miteshyelke4454
@miteshyelke4454 2 жыл бұрын
I have created star schema on excel for tracking my monthly expense and I will start working on BI… thanx chandooo..
@chandoo_
@chandoo_ 2 жыл бұрын
Aweoms Mitesh.. 😀😀😀
@vijayarjunwadkar
@vijayarjunwadkar 2 жыл бұрын
Wow, very innovative way to explain the concept! The manual method you used to explain "Star Schema" is just enough to understand it so well and Power BI demo is just a confirmation! Thanks Chandoo, you are an amazing teacher! 😊👍
@Deeps88
@Deeps88 Жыл бұрын
You are truly King of explaining thing easily, I am your big fan 😃
@chandoo_
@chandoo_ Жыл бұрын
So nice of you
@aleenathomas2717
@aleenathomas2717 5 ай бұрын
Hi Chando, All your tutorials are very helpful to me. Love the way you explain. Could you upload tutorial for creating Income statement in Power BI from TB as source? Am currently stuck on establishing relationship between the measures and the matrix from data model. I would like to know more on it.
@nagarjunmadda4703
@nagarjunmadda4703 Жыл бұрын
Thank you !! The way you expained it's amazing.
@jepherdselloria7379
@jepherdselloria7379 5 ай бұрын
Wow! very very informative and easy to understand! I've been watching your videos lately and it really helped me a lot! thank you Chandoooo! ~ from Philippines
@chandoo_
@chandoo_ 5 ай бұрын
Great to hear!
@sofiadassi8352
@sofiadassi8352 10 ай бұрын
Very good explanation, congrats and thank you!
@kpieceemmry3387
@kpieceemmry3387 11 ай бұрын
So this concept is so simple and straight forward. You already have one more subscriber
@umeshlangade9231
@umeshlangade9231 2 жыл бұрын
just amazed with the simplification sir, thank you so much 😇
@chandoo_
@chandoo_ 2 жыл бұрын
Glad to hear that
@chidinmaezinwa5308
@chidinmaezinwa5308 Жыл бұрын
Thanks Chando. Your teaching style is awesome. I keep following you up.
@zorawarmodi19
@zorawarmodi19 2 ай бұрын
Thank you so much Sir for this tutorial.
@kumargunjan428
@kumargunjan428 Жыл бұрын
Can’t get better than this ❤
@shiffamohammed5818
@shiffamohammed5818 2 жыл бұрын
Thanks a lot for an amazing tutorial, Chandoo.
@chandoo_
@chandoo_ 2 жыл бұрын
You are welcome!
@sadhanababu6177
@sadhanababu6177 Жыл бұрын
Thank you sir, such an awesome demonstration.
@ram_qr
@ram_qr 11 ай бұрын
just an amazing way to explain the concept
@mosesakwagiobe4438
@mosesakwagiobe4438 Жыл бұрын
i think i found my perfect teacher :D. thank you for sharing
@ishaqkhan8653
@ishaqkhan8653 5 ай бұрын
HI Chandoo, Thank you for the video, It gave me a good understanding. I am using Power BI reports for my organisation and I am pondering which schema should I use Star or Snowflake? I have mostly dimensions table only, user, userlogin, points earned and points redeemed few others and for all the tables the users are focal point ( in the sense I create relationships using usernames). There are just a couple of basic calculation that has to be done in each dimension for example: unique login counts, total points earned, etc. nothing complex. I do have an orders table which gives me the order details like product, price, purchase date and so on but here, let me put it this way, if there are 100 users, only 80 would have logged in and out of that 80 , only 70 would have earned points, out of 70 only 50 would have redeemed their points and it is only for those 50 users who have ordered products will the data get filled in the orders table. so in this case should I create a star schema with the order table as center or a snowflake schema. Right i dont think my model mimics either star or snowflake schema. My report is mostly used to get the aggregated details of each user, Would like to know your input regarding this
@chandoo_
@chandoo_ 4 ай бұрын
You don't need to have either star or snow-flake all the time. Design your schema based on the tables (and real world concepts) you have. As you need user centric reporting, user would the dimension and link whatever else you need to it. Whatever you do, don't create overly complicated schemas like network.
@arunrai2909
@arunrai2909 2 жыл бұрын
Ohoho... you just nailed it Chandoo!
@edwarddelgado9654
@edwarddelgado9654 Жыл бұрын
Wow, this channel has great vibes!
@hlulaniwinners7076
@hlulaniwinners7076 4 ай бұрын
Learning made easy and fun....thank you
@dineshgandhi3169
@dineshgandhi3169 2 жыл бұрын
Hello chandoo, after listening your video about ⭐ scheme concept felt happy and please make videos on daxs pls
@EsraaElmeniawiwy
@EsraaElmeniawiwy Жыл бұрын
What an exceptional teaching skills :)
@namrataghosh111
@namrataghosh111 Жыл бұрын
This is really easiest way you have helped to understand data modelling in Power BI. thank you so much . Just a request am unable to download the dataset used from link provided can you provide once again if possible Sir to use it for my own understanding.
@richaagrawal376
@richaagrawal376 2 жыл бұрын
Another wonderful video!! Please also make video on sensitivity and scenario analysis.
@monishnagarajan5917
@monishnagarajan5917 2 жыл бұрын
Best teacher ever
@NovaPrista
@NovaPrista Жыл бұрын
Thank you chandoo, I like your explaining it. now, iam understanding my focus career between DA or BA. And i choice DA.😊
@israeledoki1027
@israeledoki1027 8 ай бұрын
Amazing teacher waw thank you I remain your fan
@EcongeniusAI
@EcongeniusAI 2 жыл бұрын
what's a clear and simple explanation!
@chandoo_
@chandoo_ 2 жыл бұрын
Thanks Mr.E
@hari60700
@hari60700 2 жыл бұрын
As usual chandoo storms again with a superb video.Waiting for another stormful video
@chandoo_
@chandoo_ 2 жыл бұрын
Thank you so much 😀
@wayneedmondson1065
@wayneedmondson1065 2 жыл бұрын
Great tutorial! Thanks Chandoo. Thumbs up!!
@chandoo_
@chandoo_ 2 жыл бұрын
Thanks Wayne... 😎
@mada881010789
@mada881010789 2 жыл бұрын
😅😅😅😅thank you for the visual explanation!!!
@michaelchantraine9190
@michaelchantraine9190 4 ай бұрын
Well explained, thank you
@brpawankumariyengar4227
@brpawankumariyengar4227 2 жыл бұрын
Great Video …. Very well explained ….. Thank you very much
@abdelrhimeltijani1778
@abdelrhimeltijani1778 Жыл бұрын
It is even far better than Corsera's explanation
@ManishVaity-ns1sj
@ManishVaity-ns1sj Жыл бұрын
really nice explanation.
@sim9955
@sim9955 2 жыл бұрын
great video as usual! would love to see more data modling videos from you! also, small typo in the title "Start".... :)
@chandoo_
@chandoo_ 2 жыл бұрын
Thanks Solo. I fixed the typo now :)
@rukhanzakaria
@rukhanzakaria 2 жыл бұрын
Wow outstanding video learning, thank you
@nanikatta6163
@nanikatta6163 2 жыл бұрын
awesome explanation
@sushichef40
@sushichef40 8 ай бұрын
Nicely explained
@viratcharyraghavapuram1602
@viratcharyraghavapuram1602 2 жыл бұрын
Hello Chandoo. I'm excited to watch the video.
@chandoo_
@chandoo_ 2 жыл бұрын
You are welcome Virat...
@chrism9037
@chrism9037 2 жыл бұрын
Thanks Chandoo, nice video!
@chandoo_
@chandoo_ 2 жыл бұрын
You are welcome Chris.. 😀
@canirmalchoudhary8173
@canirmalchoudhary8173 2 жыл бұрын
Amazing tutorial
@chandoo_
@chandoo_ 2 жыл бұрын
Thank you! Cheers!
@ketankhandebharad4605
@ketankhandebharad4605 2 жыл бұрын
Sir please upload some theory part like this for data analyst.....this video explains schema very easily ❤️❤️
@chandoo_
@chandoo_ 2 жыл бұрын
Thanks Ketan. Do check out the other videos in this playlist - kzbin.info/www/bejne/nYfVaplnfK-XkMU
@indradutta4136
@indradutta4136 Жыл бұрын
Hello Chandoo.. Thanks for sharing this. It's a great help however I am not able to apply any one of the two schema's in my data modeling. I have three tables where I have redundant data. Should I add one non redundant data set which will be used to connect all the above tables or any other approach will suits this better to define the data model. If you suggest something on this that would be a great help.
@arahadshaikh
@arahadshaikh 4 ай бұрын
Many Thanks
@sunilrawat-se4xr
@sunilrawat-se4xr Жыл бұрын
Great sir, but one ques here is, if we have the TGt in the table then how can again built the relationship with facts table, bcz hera also have the date range... Pls guide
@jagatkrishna1543
@jagatkrishna1543 2 жыл бұрын
YES Sir 🙏💕
@chandoo_
@chandoo_ 2 жыл бұрын
😀
@lukendrak1581
@lukendrak1581 2 жыл бұрын
Simply superb
@chandoo_
@chandoo_ 2 жыл бұрын
Thanks a lot
@ayubkhankalwad
@ayubkhankalwad 2 жыл бұрын
Sir appreciate your work
@chandoo_
@chandoo_ 2 жыл бұрын
So nice of you
@surabhijagadish5210
@surabhijagadish5210 9 ай бұрын
Excellent💯
@datafuture556
@datafuture556 2 жыл бұрын
kindly make a video on measure and calculated column ,where we use measures and where we use calculated column
@chandoo_
@chandoo_ 2 жыл бұрын
It is already made here - kzbin.info/www/bejne/oZixk4qFeNqFeac
@bhawnachoudhary9869
@bhawnachoudhary9869 2 жыл бұрын
Hello Chandoo, I like the way how you explain complete excel tricks It helps alot to learn the excel in easy way. Actually I had experience in customer service from last 7 years and in this career period, I had worked experience in Excel reporting. Now I am planning to switch the career as a Data Analyst, I am doing self learning MySQL, Oracle SQL, Excel , Statistics Analysis, Data Visualization using Power BI, Tableau and Basic knowledge of Python. I applied on multiple companies from last 2 months no such responses come yet. Can you please help me or suggest how can enhance my skills?
@chandoo_
@chandoo_ 2 жыл бұрын
Hi Bhawna... That is a whole bunch of technologies right there. If I were you, I would position myself as an expert in one or two key areas when applying for a job. While you are _expected_ to use multiple techs in the job, at the time of application you have a better chance of getting a call if you narrow down and write a strong resume with 1-2 focus areas.
@aashishmalhotra
@aashishmalhotra 2 жыл бұрын
Wow man doing such a nice hob for us . Thanks 3000x
@chandoo_
@chandoo_ 2 жыл бұрын
Any time!
@hodaamz2952
@hodaamz2952 2 ай бұрын
Thank you
@dra.talwar4592
@dra.talwar4592 2 жыл бұрын
Nicely explained, please share something on M language
@chandoo_
@chandoo_ 2 жыл бұрын
I have a full video on Power Query here - You should certainly watch it. kzbin.info/www/bejne/hpqpcpSVn8-Ue6s
@tinnymanmeet
@tinnymanmeet 2 жыл бұрын
Very nice presentation
@chandoo_
@chandoo_ 2 жыл бұрын
You are welcome Manmeet.
@giridharsaireddy
@giridharsaireddy Жыл бұрын
Can you please create and explain the example of snowflake schema in the same way by exporting excel
@NaynishBalasahebLadkat
@NaynishBalasahebLadkat 3 ай бұрын
minion fell down when sales target was brought into the picture
@AliMz-q3u
@AliMz-q3u 5 ай бұрын
Thanks alot
@shivamtomar7378
@shivamtomar7378 2 жыл бұрын
Hi Chandooo.... You will provide any Excel Course.
@UPlusPlus
@UPlusPlus 8 ай бұрын
thanku 💕💕💕💕💕💕
@judithegyes
@judithegyes 7 ай бұрын
Brilliant!🤩
@Vikas-b6n8q
@Vikas-b6n8q Жыл бұрын
ee video telugu explanation available undhaa mastaru.....
@FunNFury
@FunNFury 2 жыл бұрын
Excellent...!
@JustMe-yq7hp
@JustMe-yq7hp 9 ай бұрын
Hi bro is there integrated schema exist in Power BI?
@eng.aymanahmed6006
@eng.aymanahmed6006 3 ай бұрын
Amazing
@hanhnguyenhong3039
@hanhnguyenhong3039 11 ай бұрын
thanks
@Faisal63045
@Faisal63045 2 жыл бұрын
Hi I’ve PQ challenge The daily business hours: Start from 8:00:00 AM End time 10:00:00 PM The challenge 1- is to change any transaction that comes between 10:00:00 PM and 11:59:59 PM to the start of work hours (Next Day-Date) 8:00:00 AM 2- is to change any transaction that comes between 12:00:00 AM and 7:59:59 AM to be 8:00:00 AM the reason I want to evaluate the number in business Hour also don't missing any transaction that comes after or before
@chandoo_
@chandoo_ 2 жыл бұрын
Hi Faisal... you can use PQ conditional columns to do this stuff. Firs extract time portion alone to a column and then do what you want. If you have trouble, post these questions in a forum or stackoverflow for help.
@xyz_1943
@xyz_1943 2 жыл бұрын
One question dear chandoo sir In star schema we use dimensions to filter facts tables. Let think we have created snow flake schema Then all dimensions tables which forming snow flake schema can filter facts tables same like it filter in star schema? Or we get different results? Please I'm confused
@chandoo_
@chandoo_ 2 жыл бұрын
The filters will propagate thru the connections. So if you filter an outer dimension in the snow-flake, the fact in the middle gets filtered too.
@user-xm7fi3ts6o
@user-xm7fi3ts6o 2 жыл бұрын
Hello, I am planning for Msc business analytics in university of Edinburgh next year. Can you please give some advice what qualities and skills do they look in candidates ? So I can prepare for that and get admission there.
@chandoo_
@chandoo_ 2 жыл бұрын
Hi Zaid... I am sorry, but I am not the person for answering this question. I suggest asking the uni directly or asking some of the alumni / current students. All the best.
@ashwinponnappan9721
@ashwinponnappan9721 2 жыл бұрын
Refreshed !
@chandoo_
@chandoo_ 2 жыл бұрын
Thanks Ash...
@rajipraveenishani
@rajipraveenishani 4 ай бұрын
Can I get the sample data file used in this video ?
@deepakgautam8958
@deepakgautam8958 2 жыл бұрын
Its same as one to many Relationships!
@chandoo_
@chandoo_ 2 жыл бұрын
Yes, that is the foundational idea.
@swapnilbarve5585
@swapnilbarve5585 7 ай бұрын
can you make a video on DAX Please
@vandebharat5921
@vandebharat5921 10 ай бұрын
❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️ 🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳 Sir, very beautifully and easily explained. Your tutorials are awesome! You make concepts make very easy to understand. Huge thanks for your efforts to bring these ideas to explain us. Actually I was searching for this concept but your explanation gave complete information thank you very much sir. Sir any idea if I want to apply for jobs in new Zealand or Australia or any abroad location ❓any tips.
@nigyaent4989
@nigyaent4989 2 жыл бұрын
What is the best course or career after bba in IT. ?
@chandoo_
@chandoo_ 2 жыл бұрын
There is no such thing as "BEST" in these things. You have to figure things out and be willing to experiment and fail. Instead of thinking, "what should I do for rest of my life", think of "what can I learn and achieve in next 2-5 years" and do those. Once you reach a milestone or find yourself not learning enough or not nearly happy, just pivot and choose something else. All the best for the journey my friend.
@nigyaent4989
@nigyaent4989 2 жыл бұрын
@@chandoo_ I love you Sir Thank you i will take a screenshot of it. And adopt it for my lifestyle Thank you
@eswar418
@eswar418 2 жыл бұрын
Plzzz sir could you explain realtime work in office and project level
@chandoo_
@chandoo_ 2 жыл бұрын
Thanks Eswar. Most of my videos are based on realtime situations. Do you have any specific suggestions.
@lord_voldemort44
@lord_voldemort44 6 ай бұрын
that thread looks delicious
@tanweerabbasabbas649
@tanweerabbasabbas649 Жыл бұрын
lovely youuu😘
@vishalmane3139
@vishalmane3139 Жыл бұрын
hoow to do in real datset
@deepakgautam8958
@deepakgautam8958 2 жыл бұрын
Or many to one relationships.
@nelithhansindu9702
@nelithhansindu9702 5 ай бұрын
Damnnn
@RakeshKumar-r7w5b
@RakeshKumar-r7w5b 9 ай бұрын
omg
@khushbooshah3407
@khushbooshah3407 5 ай бұрын
Hi sir awesome video.can you give me your contacts
The truth about Data Analyst job ads (I review 3 of them)
14:16
这是自救的好办法 #路飞#海贼王
00:43
路飞与唐舞桐
Рет қаралды 60 МЛН
SISTER EXPOSED MY MAGIC @Whoispelagheya
00:45
MasomkaMagic
Рет қаралды 19 МЛН
Top 20 Data & BI terms every data analyst *should* know
12:21
Data Modeling (Star Schema 🌟) in Power BI - Creating Dimension Tables
24:54
Learn Power Query & Automate Boring Data Tasks in 15 Minutes!
18:45
Star schema or single table in Power BI
35:54
SQLBI
Рет қаралды 38 М.
🚨 YOU'RE VISUALIZING YOUR DATA WRONG. And Here's Why...
17:11
Adam Finer - Learn BI Online
Рет қаралды 220 М.
How to Model and Analyze Data in EXCEL using POWER PIVOT
22:23
Fact & Dimension tables in Power BI | Data Modelling
15:07
The Power BI Guy
Рет қаралды 74 М.