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

[@arjundev4908]

Can't thank enough sir. Your teaching skills as always Wow :)

[@chandoo_]

My pleasure!

[@flammabledoge811]

Indians best educators. Thanks from Philippines!

[@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]

I've watched several videos in the past about this and only now do i feel confident about it. Keep it up!

[@sanwar1]

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_]

Thanks Sanwar.. I have a few "watch next" recommendations in the video description. Do check them out.

[@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]

Only passionate people can teach like this ❤

[@mansijswarnkar4389]

That's an innovative way to teach! A great example of design thinking!

[@chandoo_]

Thanks Mansij...

[@sohjuvitus447]

Much much respect and appreciation for this. Delivering this couldn't be better than it is

[@holla4691]

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]

Thank you so much chandoo. I have learnt alot from you.much love from 🇳🇬

[@petecardona8203]

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]

I love your teaching style and use your videos as additional resources for my intro to Power BI students. THANK YOU!

[@chandoo_]

You're very welcome!

[@interest2006]

The Best explanation of ONE to MANY!

[@miteshyelke4454]

I have created star schema on excel for tracking my monthly expense and I will start working on BI… thanx chandooo..

[@chandoo_]

Aweoms Mitesh.. 😀😀😀

[@vijayarjunwadkar]

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]

You are truly King of explaining thing easily, I am your big fan 😃

[@chandoo_]

So nice of you

[@aleenathomas2717]

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]

Thank you !! The way you expained it's amazing.

[@jepherdselloria7379]

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_]

Great to hear!

[@sofiadassi8352]

Very good explanation, congrats and thank you!

[@kpieceemmry3387]

So this concept is so simple and straight forward. You already have one more subscriber

[@umeshlangade9231]

just amazed with the simplification sir, thank you so much 😇

[@chandoo_]

Glad to hear that

[@chidinmaezinwa5308]

Thanks Chando. Your teaching style is awesome. I keep following you up.

[@zorawarmodi19]

Thank you so much Sir for this tutorial.

[@kumargunjan428]

Can’t get better than this ❤

[@shiffamohammed5818]

Thanks a lot for an amazing tutorial, Chandoo.

[@chandoo_]

You are welcome!

[@sadhanababu6177]

Thank you sir, such an awesome demonstration.

[@ram_qr]

just an amazing way to explain the concept

[@mosesakwagiobe4438]

i think i found my perfect teacher :D. thank you for sharing

[@ishaqkhan8653]

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_]

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]

Ohoho... you just nailed it Chandoo!

[@edwarddelgado9654]

Wow, this channel has great vibes!

[@hlulaniwinners7076]

Learning made easy and fun....thank you

[@dineshgandhi3169]

Hello chandoo, after listening your video about ⭐ scheme concept felt happy and please make videos on daxs pls

[@EsraaElmeniawiwy]

What an exceptional teaching skills :)

[@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]

Another wonderful video!! Please also make video on sensitivity and scenario analysis.

[@monishnagarajan5917]

Best teacher ever

[@NovaPrista]

Thank you chandoo, I like your explaining it. now, iam understanding my focus career between DA or BA. And i choice DA.😊

[@israeledoki1027]

Amazing teacher waw thank you I remain your fan

[@EcongeniusAI]

what's a clear and simple explanation!

[@chandoo_]

Thanks Mr.E

[@hari60700]

As usual chandoo storms again with a superb video.Waiting for another stormful video

[@chandoo_]

Thank you so much 😀

[@wayneedmondson1065]

Great tutorial! Thanks Chandoo. Thumbs up!!

[@chandoo_]

Thanks Wayne... 😎

[@mada881010789]

😅😅😅😅thank you for the visual explanation!!!

[@michaelchantraine9190]

Well explained, thank you

[@brpawankumariyengar4227]

Great Video …. Very well explained ….. Thank you very much

[@abdelrhimeltijani1778]

It is even far better than Corsera's explanation

[@ManishVaity-ns1sj]

really nice explanation.

[@sim9955]

great video as usual! would love to see more data modling videos from you! also, small typo in the title "Start".... :)

[@chandoo_]

Thanks Solo. I fixed the typo now :)

[@rukhanzakaria]

Wow outstanding video learning, thank you

[@nanikatta6163]

awesome explanation

[@sushichef40]

Nicely explained

[@viratcharyraghavapuram1602]

Hello Chandoo. I'm excited to watch the video.

[@chandoo_]

You are welcome Virat...

[@chrism9037]

Thanks Chandoo, nice video!

[@chandoo_]

You are welcome Chris.. 😀

[@canirmalchoudhary8173]

Amazing tutorial

[@chandoo_]

Thank you! Cheers!

[@ketankhandebharad4605]

Sir please upload some theory part like this for data analyst.....this video explains schema very easily ❤️❤️

[@chandoo_]

Thanks Ketan. Do check out the other videos in this playlist - kzbin.info/www/bejne/nYfVaplnfK-XkMU

[@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]

Many Thanks

[@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]

YES Sir 🙏💕

[@chandoo_]

😀

[@lukendrak1581]

Simply superb

[@chandoo_]

Thanks a lot

[@ayubkhankalwad]

Sir appreciate your work

[@chandoo_]

So nice of you

[@surabhijagadish5210]

Excellent💯

[@datafuture556]

kindly make a video on measure and calculated column ,where we use measures and where we use calculated column

[@chandoo_]

It is already made here - kzbin.info/www/bejne/oZixk4qFeNqFeac

[@bhawnachoudhary9869]

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_]

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]

Wow man doing such a nice hob for us . Thanks 3000x

[@chandoo_]

Any time!

[@hodaamz2952]

Thank you

[@dra.talwar4592]

Nicely explained, please share something on M language

[@chandoo_]

I have a full video on Power Query here - You should certainly watch it. kzbin.info/www/bejne/hpqpcpSVn8-Ue6s

[@tinnymanmeet]

Very nice presentation

[@chandoo_]

You are welcome Manmeet.

[@giridharsaireddy]

Can you please create and explain the example of snowflake schema in the same way by exporting excel

[@NaynishBalasahebLadkat]

minion fell down when sales target was brought into the picture

[@AliMz-q3u]

Thanks alot

[@shivamtomar7378]

Hi Chandooo.... You will provide any Excel Course.

[@UPlusPlus]

thanku 💕💕💕💕💕💕

[@judithegyes]

Brilliant!🤩

[@Vikas-b6n8q]

ee video telugu explanation available undhaa mastaru.....

[@FunNFury]

Excellent...!

[@JustMe-yq7hp]

Hi bro is there integrated schema exist in Power BI?

[@eng.aymanahmed6006]

Amazing

[@hanhnguyenhong3039]

thanks

[@Faisal63045]

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_]

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]

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_]

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]

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_]

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]

Refreshed !

[@chandoo_]

Thanks Ash...

[@rajipraveenishani]

Can I get the sample data file used in this video ?

[@deepakgautam8958]

Its same as one to many Relationships!

[@chandoo_]

Yes, that is the foundational idea.

[@swapnilbarve5585]

can you make a video on DAX Please

[@vandebharat5921]

❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️ 🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳 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]

What is the best course or career after bba in IT. ?

[@chandoo_]

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]

@@chandoo_ I love you Sir Thank you i will take a screenshot of it. And adopt it for my lifestyle Thank you

[@eswar418]

Plzzz sir could you explain realtime work in office and project level

[@chandoo_]

Thanks Eswar. Most of my videos are based on realtime situations. Do you have any specific suggestions.

[@lord_voldemort44]

that thread looks delicious

[@tanweerabbasabbas649]

lovely youuu😘

[@vishalmane3139]

hoow to do in real datset

[@deepakgautam8958]

Or many to one relationships.

[@nelithhansindu9702]

Damnnn

[@RakeshKumar-r7w5b]

omg

[@khushbooshah3407]

Hi sir awesome video.can you give me your contacts