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.
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 !!!!
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.
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.😊
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! 😊👍
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
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.
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
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.
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.
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
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.
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?
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.
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
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
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.
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.
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.
❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️ 🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳 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.
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.
Can't thank enough sir. Your teaching skills as always Wow :)
My pleasure!
Indians best educators. Thanks from Philippines!
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.
I've watched several videos in the past about this and only now do i feel confident about it. Keep it up!
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 !!!!
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!
Thanks Sanwar.. I have a few "watch next" recommendations in the video description. Do check them out.
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.
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.😊
Much much respect and appreciation for this. Delivering this couldn't be better than it is
Only passionate people can teach like this ❤
The Best explanation of ONE to MANY!
You are truly King of explaining thing easily, I am your big fan 😃
So nice of you
That's an innovative way to teach! A great example of design thinking!
Thanks Mansij...
Thank you so much chandoo.
I have learnt alot from you.much love from 🇳🇬
I love your teaching style and use your videos as additional resources for my intro to Power BI students. THANK YOU!
You're very welcome!
i think i found my perfect teacher :D. thank you for sharing
I have created star schema on excel for tracking my monthly expense and I will start working on BI… thanx chandooo..
Aweoms Mitesh.. 😀😀😀
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! 😊👍
So this concept is so simple and straight forward. You already have one more subscriber
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
Great to hear!
Thanks Chando. Your teaching style is awesome. I keep following you up.
Very good explanation, congrats and thank you!
just amazed with the simplification sir, thank you so much 😇
Glad to hear that
Best teacher ever
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.
Can’t get better than this ❤
Thank you so much Sir for this tutorial.
Thank you !! The way you expained it's amazing.
Ohoho... you just nailed it Chandoo!
Thanks a lot for an amazing tutorial, Chandoo.
You are welcome!
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
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.
just an amazing way to explain the concept
What an exceptional teaching skills :)
Learning made easy and fun....thank you
Thank you sir, such an awesome demonstration.
It is even far better than Corsera's explanation
As usual chandoo storms again with a superb video.Waiting for another stormful video
Thank you so much 😀
Wow, this channel has great vibes!
Amazing teacher waw thank you I remain your fan
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.
what's a clear and simple explanation!
Thanks Mr.E
Thank you chandoo, I like your explaining it.
now, iam understanding my focus career between DA or BA.
And i choice DA.😊
😅😅😅😅thank you for the visual explanation!!!
Great tutorial! Thanks Chandoo. Thumbs up!!
Thanks Wayne... 😎
minion fell down when sales target was brought into the picture
Well explained, thank you
Another wonderful video!! Please also make video on sensitivity and scenario analysis.
Great Video …. Very well explained ….. Thank you very much
Hello chandoo, after listening your video about ⭐ scheme concept felt happy and please make videos on daxs pls
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
really nice explanation.
Hello Chandoo.
I'm excited to watch the video.
You are welcome Virat...
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.
Wow outstanding video learning, thank you
Nicely explained
awesome explanation
Amazing tutorial
Thank you! Cheers!
Sir please upload some theory part like this for data analyst.....this video explains schema very easily ❤️❤️
Thanks Ketan. Do check out the other videos in this playlist -
th-cam.com/video/gVr9f1GJdZc/w-d-xo.html
Many Thanks
Can you please create and explain the example of snowflake schema in the same way by exporting excel
Thanks Chandoo, nice video!
You are welcome Chris.. 😀
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?
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.
great video as usual! would love to see more data modling videos from you!
also, small typo in the title "Start".... :)
Thanks Solo. I fixed the typo now :)
ee video telugu explanation available undhaa mastaru.....
Simply superb
Thanks a lot
Excellent💯
Hi Chandooo....
You will provide any Excel Course.
Wow man doing such a nice hob for us . Thanks 3000x
Any time!
YES Sir 🙏💕
😀
Sir appreciate your work
So nice of you
Brilliant!🤩
Hi bro is there integrated schema exist in Power BI?
Thank you
Nicely explained, please share something on M language
I have a full video on Power Query here - You should certainly watch it. th-cam.com/video/PiFAa_jjaEI/w-d-xo.html
Can I get the sample data file used in this video ?
kindly make a video on measure and calculated column ,where we use measures and where we use calculated column
It is already made here - th-cam.com/video/kgNbWOCuRCE/w-d-xo.html
Very nice presentation
You are welcome Manmeet.
Excellent...!
Thanks alot
thanku 💕💕💕💕💕💕
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
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.
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
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.
can you make a video on DAX Please
Amazing
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.
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.
❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️
🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳
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.
What is the best course or career after bba in IT. ?
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.
@@chandoo_ I love you Sir
Thank you i will take a screenshot of it.
And adopt it for my lifestyle
Thank you
Its same as one to many Relationships!
Yes, that is the foundational idea.
thanks
Refreshed !
Thanks Ash...
lovely youuu😘
Plzzz sir could you explain realtime work in office and project level
Thanks Eswar. Most of my videos are based on realtime situations. Do you have any specific suggestions.
that thread looks delicious
hoow to do in real datset
Or many to one relationships.
Damnnn
omg
Hi sir awesome video.can you give me your contacts