Amazing, I have complete the beginner and intermediate PBi tutorial, and now heading toward the Advance, best PBi course ever came a cross, very clear accent and structured instruction. Well done Trish
The best tutorial for Power BI on RU-vid. I watched the series between 1.75x to 2x speed and the instructions were clear. Topics covered are well planned and this being free is a positive step to open learning. Thanks!
I will watch all 8 hours of this, Trish is so eloquent and informative, thank you Learnit Training for these amazing insightful videos and I express my gratitude for keeping these videos free, I would highly recommend these videos to anyone who wants to learn PowerBI, onto the Advanced Tutorial! Cheers
At 47:20 where the relationships were created by pbi. I dont know why my relationships and the ones in the video are not same. example my order to managers relationship line is 1:*.
First, I'm grateful for this free course. However, I've just spot an issue in 40:11. You need to remove duplicate first before assigning index for the primary key or there'll be different index with the same product name
This is really amazing 🤩🤩🤩. I am absolutely grateful for the Learnit, thank the Learnit team and Trish. I have just finished the Intermediate course, and I am ready to dive into the next course.
at 20:00 I really dont get why use right outer join to later filter the null values, I think that applying left outer join make the same results or not?
Truly great lessons: good pace and very clear guidance - WELL DONE. Can anyone tell me how I can get the tutorial downloads so that I can follow along and try the examples?
Hi @diamondsandlipgloss Thank you very much for the tip. However, is it that we just select any column from the "Orders" table that has a column title matching one in the "Returns" table we're working with? Cos we were supposed to merge the "Status" column, per the assignment. Appreciate your help 🙏
I am having trouble merging the order and returns qry. When I select the order and status to make the column change from table to returned every column except my Returns.Order ID turns to Null what am I doing wrong?
To merge tables in Power BI, you can follow these steps: Load all source tables into Power BI. Select the 'Join' option from the 'Home' tab to open the 'Join' dialog box. Select the primary table that you want to merge other tables into. Select the column (s) used to join the tables. Choose the type of join you want to use, such as Inner Join or Left Outer Join. Click "OK" to apply the join and create a new table with the combined data.
48:37 I have only one relationship between DimCustomers and Manger but there is no relationship between DimCustomers and orders, is there sometging wrong I did can u fighure this out?? Thanks for helping.
This is one of the brilliant playlist i have come across.Altho I am having an issue that there is a difference between the relationships that this video shows in the model view and what I get. Idk why that is happening, i copied every step of the EDA we have done uptil now. Also your offline community or whatever that is, is not working so I would appreciate if someone could guide me on this. Much thanks x
Amazing tutorial ! But Can you help with one question? Why did we do a right join @17:30 ? Based on what I understand we want to get all the rows from orders and matching rows from Managers table right? so shouldn't it be Left outer Join? Please correct me if I am wrong.
I've been working on the "Superstore" file while watching the video and I've done precisely everything described in the video. Still, my Power BI doesn't recognise the Many-Many relationship between "DimCustomers" and "Orders" queries. When I tried to make the relationship manually it showed the following ERROR: "This relationship has cardinality many-many." I tried some tricks but nothing worked so I truly appreciate it if someone could help me
@@suryapratapchauhan2506 In DIMCustomers you have duplicate CustomerID. I duplicated the DIMCustomers table in transform data and removed the duplicate customerIDs. I was then able to create a relationship between the Orders table and the DIMCustomers.
Good insight into using Power BI. But I have comment. During the process of creating DimProducts Table, the dulplicated of Product Name should be removed before creating the Index column such that each Product Name had it own unique Product ID.
Thanks a lot for the training. I am following it step by step but in model view there is no automatic relationship between Orders and DimCustomers. I have a screenshots I can send to you
hey thanks for the informative video... can u please guide me how to sign in to the power bi service as when i need to publish it .. it requires me to sign in
the most updated version of Power BI requires that you sign in w/ work/school account...which I'm not able to do for this practice since I'm not sure if it's okay w/my employer. Guess I'll just take notes for this section
Thank you very much for this lesson. However, at 21:40, is it that we just select any column from the "Orders" table that has a column title matching one in the "Returns" table we're working with? Cos we were supposed to merge the "Status" column, per the assignment. Appreciate your help 🙏 (P.S.: I'm getting no response on the offsite online website.)
Seems like we have to use "Order Id" as the matching columns, and use "left outer" this time as the join kind. And when "Returns" column is created, uncheck "order id" 1st (then ok), then in the new Returns.Status column, uncheck "null".
Can you give the steps to merging Orders and Returns? I was having difficulty with null values. I use the right outer join, but not sure that's what you did.
I have thesame issue, the problem is, there is noting line null in the filters. Can you please tell me what you chose under 'orders" and what you chose under 'returns'? please @longbach3983
Your videos are amazing but i don't why it puts me to sleep every time i listen to your voice. Don't get me wrong, these are very informative, just your delivery speech is really slow.