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
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
The best tutorial for Power BI on RUclips. 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 have just finished Intermediate Tutorial. Absolutly outstanding course. Very calm and step by step work instruction. Thank you. I study now for new job.
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:*.
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.
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
I have stuck at 15:56, the primary table loads into the Merge Query as New but does not load the other tables in the table selection field for both First Table and Second Table. Help me
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?
Thanks for the great video. But at #30:45, when change discount from decimal to percentage and nearing to the whole number, any data loss from there? can we restore the decimal places when needed?
I have a little challenge at 15:56, the primary table loads into the Merge Query as New but does not load the other tables in the table selection field for both First Table and Second Table. How can I solve this?
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.
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".
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 🙏
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.
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.
Thank you very much for you detailed training. However, I found that in the DimProducts table, there are 1000 values on Product Name column, in which there are 658 distinct and only 425 unique values. So my question is, should we remove duplicate values before creating an incremental column?
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?
Thanks for the great work. Awesome video. But I have one doubt. In the video, its showing many to many relationship for managers and orders tables . But in my work, its showing 1 to many for the same which is correct. Can you please clarify the doubt?
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?
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
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
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
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.
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
Thank so much for the kind word Ali!
I can very well agree with it. I learned a lot in the first two videos.
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
Thank you much for the kind words!
The best tutorial for Power BI on RUclips. 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!
Glad you liked it!
i can't believe this is FREE ! great job... it's simple yet complex. perfectly balanced ! thank you !
You're welcome!
This is the most comprehensive and free tutorial - Gold, THANK YOU!
Glad it was helpful!
I have just finished Intermediate Tutorial. Absolutly outstanding course. Very calm and step by step work instruction. Thank you. I study now for new job.
Good luck on your job search! We are pulling for you!
This is the best power Bi video i have come across
Thanks!
Thank you for taking the time to explain and demonstrate how it works
Glad it was helpful!
Trish, you're absolutely amazing. Thank you for all the efforts !
You are very welcome!
God Bless such content creators who put so much efforts and put it out there for free .... typical king/Queen behavior 👑
You are very welcome!
been watching the videos from the first one that you had posted. this is eloquent and really nice
We appreciate that!
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:*.
Same here
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.
Our pleasure!
there`s no words can describe how is this useful to me, thank you so much ♥
You're very welcome!
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
Thanks for the tip!
Excellent, this is the best Power BI tutorial I have ever seen, great job!!!!!
Thank you for the kind words!
best ever Power bi trainning, thanks so much
Glad you enjoy it!
Thank you Trish for the tutorial. I really like the way you explained it all. Moving to Advanced now!
You are so welcome!
I have stuck at 15:56, the primary table loads into the Merge Query as New but does not load the other tables in the table selection field for both First Table and Second Table. Help me
I want to give one suggestion .please zoom the screen while explaining the concept..Amazing tutorial
Noted!
You're the best!. You try by all means to make it simple for us. Thank you very much !
You are welcome!
Thank you for this video, great tutorial!
You're very welcome!
Can you let me know how do we know which columns should we remove? At 7:29. Thank you.
Great course. I learnt a lot from this.
You are welcome!
Enjoyed this tutorial😍. Thank you.
You’re welcome 😊
Such a great teacher Thank you so much for this
You are welcome!
I'm not able to see a relationship between DimCustomers and Orders. Can anyone explain what mistake I did? 48:17
Awesome Trish. Thank you for providing such great content.
Thank you for the continued support!
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?
I have same problem
Dear Learnit thanks for your continous videos on various topics, best and useful presentation!!
You are most welcome!
Thanks for the great video. But at #30:45, when change discount from decimal to percentage and nearing to the whole number, any data loss from there? can we restore the decimal places when needed?
Thanks a lot for your crystal traing.
Always welcome
Amazing! I Can't wait for another training!!!
Thank you so much Glauce! Part 3 is coming this upcoming Friday!
what an amazing POWER BI tutorial. Thank you very much.
You're very welcome!
Thank you for this nice beginner friendly tutorial! You explain each and every smallest step.
You're very welcome!
Thank you very much, this means a lot to me!
Best wishes and may God bless you! :D
You're very welcome!
This course is helpful ❤
Thanks for the kind words!
I have a little challenge at 15:56, the primary table loads into the Merge Query as New but does not load the other tables in the table selection field for both First Table and Second Table. How can I solve this?
same here, do you find the solution?
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.
Hello Gracious George A! You can get your question answered by our instructors at Offsite, our online community - www.offsitebylearnit.com
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".
Hello Jude! We were all on a holiday break, sorry about the late replies. Our instructors should be replying soon!
@@LearnitTraining My bad, actually. I should have realised that. Welcome back! 😊
Happy New Year.
Thanks a lot for the tip, I spent a whole night troubleshooting XD
@@judechidozieezenyi9493 I did this and it showed 6 of 529 rows from the list table, please is this correct?
In 48:21, does anyone know why I can't see the relation between DimCustomers and Orders? Even if I try to create it manually, it prompts error.
Same for me
I am facing the same issue, did u solve it ? pls lmk
For some reason my DimCustomers is not related/linked to orders when looking at model view. Any idea why this could be?
You can get help directly our instructors at Offsite, our online community - www.offsitebylearnit.com
TIP: at 21:43 on our 1st independent merge exercise, select "Order ID" as the matching columns.
Thanks for the tip!
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 🙏
@@judechidozieezenyi9493 Same question I have.
21:40 - can't filter out null in Returns.Status column, there's only one value in that filter - Returned.
same for me
Hi. This course is really good. It is helping me to quickly learn Power BI. Where can i find the PPT shared in the video?
I'm not able to merge the tables, how can i solve this issue. in the window after selecting merge as new the below ok button is getting greyed out
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.
@@LearnitTraining What were the columns used in that example. I only see one status column on one table. Perhaps we are looking at it incorrectly.
Thank you, the video was very helpful👍
Thanks!
Great teaching & course❣️
Thanks so much!
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.
I am facing the same issue, did u solve it ? pls lmk
Thank you so much. This was so so so good!!!
You're so welcome!
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
Hello Mohammad! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
Hi how did you get around this problem?
@@inigoaguilera3178 hey i am same problem. Did you find anything.
Same problem!
@@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.
Thank you very much for you detailed training. However, I found that in the DimProducts table, there are 1000 values on Product Name column, in which there are 658 distinct and only 425 unique values. So my question is, should we remove duplicate values before creating an incremental column?
Great question! It's important to consider how duplicates are impacting your analysis before deciding whether to remove them.
Hi, Under returned status while merging tables which column from orders table need to be merged with status column from returns table.
Is it order ID from Orders and Order ID from Returns . Correct me if i am wrong
I’m having the same issue. I’ve tried everything but I still couldn’t get it right
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?
Thank you so much for this tutorial.
You are so welcome!
fantastic!
Thank you! Cheers!
thanks for the tutorial. 56:00 restrict user's views
Awesome 😇,Thanks for sharing your knowledge. how can i get powerpoint presentation?
That was amazing. thank you. How can I get the certificate of this course ?
You are welcome! You can earn certificates of completion at Learnit Anytime - www.learnitanytime.com
@Learnit Training where are the ppt? pls let me know and provide the link to resources
Thank you for this tutorial. please how can i access the data you used for this tutorial. eg the three major tables.
Exercise Files: bit.ly/2W9iMvZ
Thanks for the video ❤..Is there any online platform like leetcode where i can practice power bi .
Hi, I am not getting the 'Merged1' separate query after merging but it all gets merged into the orders query. Please help.
Hello Shreenath! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
Thanks for the great work. Awesome video.
But I have one doubt. In the video, its showing many to many relationship for managers and orders tables . But in my work, its showing 1 to many for the same which is correct.
Can you please clarify the doubt?
exciting and step forward thank you learn-it
You are welcome!
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?
Exercise Files: bit.ly/2W9iMvZ
Great! I would like to study power bi for human resource management,thanks!!!!!
Best of luck!
It's very helpful ! thank you very much!
You are welcome!
On my way to Advanced tutorial ✈
✈✈✈✈✈✈
Thanks for this tutorial, why you didn't remove duplicate values in Dim tables?
Great suggestion!
There are some inconsistencies in the "Reviewing the Model Interface" part. That should be fixed
Noted, we have new Power BI videos coming soon!
Just now done with Beginner tutorial, it was easy peasy apart from the last part about cloud and local, it was not working out for me.
Thank you, what an interesting and useful tutorial! 🥰🥰🥰
You’re welcome 😊
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
Same thing happens to me, when I try to create the missing relationship it gives an error message.
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
Hi Mohamed! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com
I had the same issue. I resolved by removing duplicates from customer ID from DimCustomers
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
Apparently you gotta have a Work email to use Power BI Service.
To publish you will need a Power BI account
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
Quite clear. Pls how can I get the previous lesson (part 1)?
Here you go: ruclips.net/video/fnA-_iDV_LY/видео.html
Thank you
You're welcome
Anyone mind explaining why we selected the discount column as a part of the Customer Info Dimension Query?
I am having an issue when tried merging queries orders and returns to create return date i keep getting errors like out of memory
Hello Paul! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
amazing thank you.
You are welcome!
very knowledgeable session.
Thank you again Ajay!
There are no PowerBI files at the manual link
brilliant !
Thanks!
You asked us to merge orders and return tables together but I don’t know what column to select in the orders table ☹️☹️☹️
Hello Alozie! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
Amazing content,
Can anyone help me with the manuals ,cannot find for Power BI
This series hands-on is enough to get a job in power bi?
Hi Venkatesh! This is series was built on the Microsoft course DA-100 which will help you get certified in Power BI
Thanks, a lot.
Always welcome!
Great teaching but some of this information dose match. Is it because it is an old video?
Power BI is constantly updating so some things have changed since this video was made. We do have 6 new Power BI videos coming later this year.
@@LearnitTraining May I ask when are the updated tutorials coming later this year?
I can't create new relationships, the ok button is not visible
please access me to download exercise file please i am very enthusiastic to start this course please
We just tested the links and files and they are currently working
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.
Hello Deepa! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
In the Order ID collumn, just click on the filter and remove the null value
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
Where you able to find a solution cos i am stocked there right now
@@joshuagabriel9752 I had the same issue. I resolved by removing duplicates from customer ID from 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.
Thank you for the tip!
i need the exercise files as long as I downloaded the videos.
Exercise Files: bit.ly/2W9iMvZ
Very good
Thanks!
Mam please make new series of Excel VBA
Hi Sagar! A new Excel VBA class is definitely on our list to record
Exercise file location not working !
Hi Firoz! We just tested the link and it is currently working!
@@LearnitTraining can you help me please for getting this dataset.
Looks like there's no way to sign up for PBi Service without "work" email. Microsoft sure makes this a rabbit hole.
You can sign up for Power BI Pro with any email address. You will have to create an account as well.
49:09 Why didn't my Orders and DimCustomers have a relationship?
43:27
👍