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
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!
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 ❤
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!!
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!
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.
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
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 whenever we load dataset first and foremost thing is that we have to create data modelling and then clean data know..is it right sir?? Thanks for your constant effort sir❤
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.