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.
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.😊
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 !!!!
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
Infact ever since i started watching your turorials in data analysis my sugar level has increased in this course 😂 so so sweet..... THANKS FROM NIGERIA
Please now that digital health transformation system is gaining more awareness i would be happy to and aporeciate it of you would run a data Analytic course on health related. Thanks
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.
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.
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.
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
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.
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.
❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️ 🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳 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.
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.
![I.N "HALLUCINATION" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/n5B5q1Hwt_U/mqdefault.jpg)
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!
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.
That's an innovative way to teach! A great example of design thinking!
Thanks Mansij...
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
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!
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 !!!!
The Best explanation of ONE to MANY!
So this concept is so simple and straight forward. You already have one more subscriber
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! 😊👍
Thanks Chando. Your teaching style is awesome. I keep following you up.
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!
Infact ever since i started watching your turorials in data analysis my sugar level has increased in this course 😂 so so sweet..... THANKS FROM NIGERIA
Please now that digital health transformation system is gaining more awareness i would be happy to and aporeciate it of you would run a data Analytic course on health related. Thanks
i think i found my perfect teacher :D. thank you for sharing
You are truly King of explaining thing easily, I am your big fan 😃
So nice of you
Very good explanation, congrats and thank you!
I have created star schema on excel for tracking my monthly expense and I will start working on BI… thanx chandooo..
Aweoms Mitesh.. 😀😀😀
Thanks a lot for an amazing tutorial, Chandoo.
You are welcome!
I like the cool way of your teaching : )
Ohoho... you just nailed it Chandoo!
Only passionate people can teach like this ❤
Wow, this channel has great vibes!
Thank you !! The way you expained it's amazing.
Great video! Very helpful
Can’t get better than this ❤
I'm late to the party here, but absolutely brilliant video
As usual chandoo storms again with a superb video.Waiting for another stormful video
Thank you so much 😀
What an exceptional teaching skills :)
Great tutorial! Thanks Chandoo. Thumbs up!!
Thanks Wayne... 😎
just amazed with the simplification sir, thank you so much 😇
Glad to hear that
Beautiful presentation ❤
Best teacher ever
what's a clear and simple explanation!
Thanks Mr.E
Thank you so much Sir for this tutorial.
Amazing teacher waw thank you I remain your fan
Thank you sir, such an awesome demonstration.
just an amazing way to explain the concept
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.
Hello Chandoo.
I'm excited to watch the video.
You are welcome Virat...
😅😅😅😅thank you for the visual explanation!!!
Learning made easy and fun....thank you
Another wonderful video!! Please also make video on sensitivity and scenario analysis.
Thanks Chandoo, nice video!
You are welcome Chris.. 😀
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 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 :)
Thank you chandoo, I like your explaining it.
now, iam understanding my focus career between DA or BA.
And i choice DA.😊
Great Video …. Very well explained ….. Thank you very much
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.
It is even far better than Corsera's explanation
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, after listening your video about ⭐ scheme concept felt happy and please make videos on daxs pls
Can you please create and explain the example of snowflake schema in the same way by exporting excel
Wow outstanding video learning, thank you
Well explained, thank you
Amazing tutorial
Thank you! Cheers!
really nice explanation.
Hi Chandooo....
You will provide any Excel Course.
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 man doing such a nice hob for us . Thanks 3000x
Any time!
Nicely explained
awesome explanation
Hi bro is there integrated schema exist in Power BI?
Brilliant!🤩
Sir appreciate your work
So nice of you
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.
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 -
ruclips.net/video/gVr9f1GJdZc/видео.html
Nicely explained, please share something on M language
I have a full video on Power Query here - You should certainly watch it. ruclips.net/video/PiFAa_jjaEI/видео.html
Simply superb
Thanks a lot
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.
Very nice presentation
You are welcome Manmeet.
Excellent💯
kindly make a video on measure and calculated column ,where we use measures and where we use calculated column
It is already made here - ruclips.net/video/kgNbWOCuRCE/видео.html
Can I get the sample data file used in this video ?
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.
ee video telugu explanation available undhaa mastaru.....
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
YES Sir 🙏💕
😀
Many Thanks
Excellent...!
❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️
🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳
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.
can you make a video on DAX Please
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.
Thank you
thanku 💕💕💕💕💕💕
minion fell down when sales target was brought into the picture
Thanks alot
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.
Amazing
lovely youuu😘
Refreshed !
Thanks Ash...
Its same as one to many Relationships!
Yes, that is the foundational idea.
thanks
hoow to do in real datset
that thread looks delicious
Or many to one relationships.