All your presentations are clear, easy to understand, well paced and aesthetically pleasing. Also, I really like how you explain every requirement and every step of your logic so nothing is overlooked or unclear. You are doing a great job in helping to learn so many important concepts! 👍🏻👍🏻👍🏻 liked and subscribed ❤
Sir please give me solution, I have to fact table , how to filter data in both table alternatively , in the data two dates 1 is dos date and another is pros date. How to create relationship in between two tables.
i have watched many vedios and with lot of confusion found your vedio. the explnation about fact table and dimension table cleared all my doubts in one go. please do more detailed vedios thank you
Hi! Thanks for the video! I had a couple of doubts 1. Can there be multiple fact tables when doing any analysis? 2. In this example, why can’t reviews/ payments be fact tables, these are also populated almost daily, new reviews/ payments keep coming in. Thanks!
Bravo. Awesome tutorial on data modelling in PBI. Concise and crystal clear. I wish you had a context evaluation tutorial at the very same level of detail and clarity. Keep it Up, Sir!
well explained however you didn't explain how to download the final outcome to our report with explanation in order to complete our task for presentation.
Hey, thanks for creating such great content, with such clarity and easy explanations!! Had all my doubts cleared and learnt something additional as well :)
Thank you sir!! It's really Helpful to understand Data modelling Concepts in Detailed.I have subscribed Your Channel,Keep Educating us and Hatt'soff for ur Efforts!!
The columns order_delivered_carrier_date, order_delivered_customer_date & order_estimated_delivery_date have their datatypes and format as "Text". I attempted to change it to "Date/Time" as shown in your demonstration between 10:05 and 10:10, but it kept returning some columns as error. The columns were also initially labelled column1, column2, column3, column4, column5. I was able to change this to the right column labels. but the datatype modification returned error some rows. kindly assist with this
Once we creating a relationship btw two tables, we can access every columns from both tables right? Then adding another inactive relationship is for what the reason? I cant get it as i am a toddler in powerbi. Can anyone clarify this? Thanks.
There are scenarios where you need to join table with different keys, and power bi can have only one active relationship. The other can be made active using dax calculation. But to make it active it should be made as a inactive relationship in model first
Sir please create 3-4 videos on sql project from scratch with basic to advance query and also with database designing as you have created many video on powerBI, excel .Please create for sql project from scratch
It is still one to many. Relatioship refers to tables, not to particular fields. Some customers can have no orders, some only one, some can have many orders. The thing is each customer appears only once in customers table and MIGHT appear more times in orders table.
Bro ur explanation is really amazing u can do more vedios on real time senario based questions that will help to everyone thanks for advance
Do one video on power query editor data cleaning, if possible to yu, your video's are amazing 😊👍
Sir i request you to please make one video of circular dependancy error example and how to resolve that. Please sir...
All your presentations are clear, easy to understand, well paced and aesthetically pleasing. Also, I really like how you explain every requirement and every step of your logic so nothing is overlooked or unclear.
You are doing a great job in helping to learn so many important concepts!
👍🏻👍🏻👍🏻 liked and subscribed ❤
Sir please give me solution,
I have to fact table , how to filter data in both table alternatively , in the data two dates 1 is dos date and another is pros date. How to create relationship in between two tables.
Thankyou Sir💙finally i understand data modeling 😃📊
Sir.
Is that content enough to Justify 2 years of experience in. Power bi.
One of the best UA-cam channel I got covering PowerBI SQL
i have watched many vedios and with lot of confusion found your vedio. the explnation about fact table and dimension table cleared all my doubts in one go. please do more detailed vedios thank you
Bro your explanation is awesome.
Please make a full video on power bi DAX...
Best way to explain data modeling. Simple, short, and in brief. No hard terms, just pure basics. great job.
Thanks for making this vdo ,i see you have taken lots of effort to making this vdo. I have subscribed ur channel. Make more useful vdo like this.❤❤
This single video is enough to understand the concept of Data Modeling deeply. Thanks for your efforts.
Hi!
Thanks for the video! I had a couple of doubts
1. Can there be multiple fact tables when doing any analysis?
2. In this example, why can’t reviews/ payments be fact tables, these are also populated almost daily, new reviews/ payments keep coming in.
Thanks!
Great content.. loved the way you covered the topics in detail. Subscribed ❤
Bravo. Awesome tutorial on data modelling in PBI. Concise and crystal clear.
I wish you had a context evaluation tutorial at the very same level of detail and clarity.
Keep it Up, Sir!
Thanks for the comment
Bro please upload more power BI tutorials ❤️
Very clear and completely understandable. Hoping to receive more videos. Thank you so much.
The way you explained things, much appreciated, apart of BI we can learn some soft skill also from you....Thanks and keep making such videos....
Thanks for another great and straight explanation of Power BI aspect
Keep going bro you're really awesome and very clear and understandable. Great Thanks 👍
well explained
however you didn't explain how to download the final outcome to our report with explanation in order to complete our task for presentation.
Well explained. Thank you for your effort! Please make a dashboard with this dataset as the continuation of this video🙏🏻
Hey, thanks for creating such great content, with such clarity and easy explanations!! Had all my doubts cleared and learnt something additional as well :)
Thank you for this video, i love your work. Can you do End-to-End video on Power BI including visualization.
Thank you for making this video, a lot of questions have been answered.
Very well explain in a crisp format. Thank you.
Please make a video on ms office copilot for hr use
Amazing amount of information within a short span, very clear and crisp
Please upload the lecture of DAX function
Thank u sir for u r effort...its really superb.....
Hi, well explanation, could you create a video for row level and other securities in Power BI. Thanks!
is there any other way select the data because this is very long process of selecting each and every single file
Awesome. felt authentic. My request is pls create a dashboard for 5-10 years of any data and analyze with interactive dashboard.
Plz can u make one detailed video on incremental refresh
very good and helpful presentations. Thank you so much
Glad it was helpful!
No words to say ...Thnak you very much for your efforts.
Thanks and welcome
Really helped to understand in depth concept with root. thankyou.
watched first vedio but understood each and every point nice. Thanks for your efforts.
awsm
Great explanation of data modeling in Power BI.
Super and clear explanation , take a bow
Sir,why you have given relationship for review_id and order_id it doesn't have same column names..
The relationship is not always decided by the name of column, it depends on the value of that field
Thanks for such videos where we are able to learn withour any cost.
What a wonderful explanation 👏 Thank you so much . u r doing a great job ☺️ continue doing it 👏👏 each and every video of yours is a masterpiece 💓
Thanks for the kind words 😊
Nicely explained, keep up the good work 👍
please make video on DAX function.
Foreign key means row are duplicates
But you also mentioned that data shouldn't be repeated or duplicate before going to modeling
Please give me the answer
I appreciate your teaching style, which is very simple and easy to understand. Thank you for making the valuable video available for free.
Thank you sir!! It's really Helpful to understand Data modelling Concepts in Detailed.I have subscribed Your Channel,Keep Educating us and Hatt'soff for ur Efforts!!
The columns order_delivered_carrier_date, order_delivered_customer_date & order_estimated_delivery_date have their datatypes and format as "Text". I attempted to change it to "Date/Time" as shown in your demonstration between 10:05 and 10:10, but it kept returning some columns as error.
The columns were also initially labelled column1, column2, column3, column4, column5. I was able to change this to the right column labels. but the datatype modification returned error some rows.
kindly assist with this
Nice Explained and tutorial, One request can you make one dashboard where we can learn A to Z Power BI Dax details?
Yes, sure
An amazing amount of information and a very clear explanation. Exceptional talent
Glad it helped!
going through all your videos one by one, its clearing my concepts. thanks alot for providing quality content that too for free.
be focused in classroom 😂
May i get the PPT that u used in this video? Will be more helpful. If no. Its Fine. Thanks for sharing in the video. ❤
2/Mar - well explained 👍👍
Crystal Clear explanation , Thanks mate for explaining in detail...🔥🔥🔥🔥
Thank you for this video. I have learned a lot about Data Modelling. Well explained. Please can i get the power point slide
Your teaching style is very simple and easy to understand. Thank you so much and hope more tutorial in future.
Could you please make a video on how to deal with one large flat table? Unfortunately that's what I always get at my work
your videos are very great..thankyou for making such informative video....
way of your explain data modelling concepts really uses for beginners, they become advanced level
Covered the basics.. Good explanation :)
Once we creating a relationship btw two tables, we can access every columns from both tables right? Then adding another inactive relationship is for what the reason? I cant get it as i am a toddler in powerbi. Can anyone clarify this? Thanks.
There are scenarios where you need to join table with different keys, and power bi can have only one active relationship. The other can be made active using dax calculation. But to make it active it should be made as a inactive relationship in model first
@@datatutorials1 Rectified. Thank You❤️
Thank you for this video, please make make more videos on power bi but same topic wise.
Sure I will
Itne videos dekh li but smjh only apka aya 🙌
Glad you liked
Very well explained. Thank you very much 👏
Fact table is Transaction table.
Dim table is Master Table.
Thanks & it was great clarity in hearing this😊😊😊
Glad it was helpful!
What is a fantastic explanation. Thanks you so much.
Excellent explanation 🎉🎉🎉
yes i need to subscribe your channel ... Contents are too good
Thanks, finally found a really good tutorial 😊
Excellent video. Very rich and comprehensive presentation in Power BI Data Modeling. Thanks a lot
Hi I have an work on the same thing for my organisation con we connect.
its good for me to listening your videos pls try to post the msbi videos
Sir please create 3-4 videos on sql project from scratch with basic to advance query and also with database designing as you have created many video on powerBI, excel .Please create for sql project from scratch
As soon as possible
Awesome contents
Plz bring video's on schedule refresh,rls
Well explained Bro...super
Thank you so much 🙂
Sir please suggest some good laptops in 60k budget for data analytics course as i am going to work on python,R ,SQL and power bi etc.
Hp pavilion is the best with these range
Thank you for very clear explanation
Dimension table is know as Master table please check once Fact table definition
Dimension tables store the information of fact table and master table provides info of business as a whole
❤
please make videos on dax measure
Thanks for all this information.
Thanks for your efforts
Very nicely explained.....👏
A new customer may not have any order, thus can we have 0 to many relationship ?
It is still one to many. Relatioship refers to tables, not to particular fields. Some customers can have no orders, some only one, some can have many orders. The thing is each customer appears only once in customers table and MIGHT appear more times in orders table.
Overall you are best
kindly create dim and fact manually, nt already prepared
In realtime everything you have will be in tables, you do not do any manual entry
@@datatutorials1 what if there r no common columns between two tables then hw to build relationships between them?
@vishalmane3139 there is always an entity relationship between two tables, if not we create it as per requirements.
@@datatutorials1 bt hw can we ?
Thanks for this video
Hello, is the order_date format correct in order_dataset file. Because I am not able to convert the column to date column. I am getting error
See pinned comment
Check your csv file settings on excel
Best video of Data Modelling
thanks for sharing
Thanks a lot
Very useful
very useful
Nicely explained
Nice video!