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.
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
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 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!
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
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:*.
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
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.
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
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?
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.
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.
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".
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?
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.
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.
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.
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!
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!
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.
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!
This is the best power Bi video i have come across
Thanks!
This is the most comprehensive and free tutorial - Gold, THANK YOU!
Glad it was helpful!
i can't believe this is FREE ! great job... it's simple yet complex. perfectly balanced ! thank you !
You're 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!
Thank you for taking the time to explain and demonstrate how it works
Glad it was helpful!
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!
Trish, you're absolutely amazing. Thank you for all the efforts !
You are 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!
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?
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:*.
I want to give one suggestion .please zoom the screen while explaining the concept..Amazing tutorial
Noted!
been watching the videos from the first one that you had posted. this is eloquent and really nice
We appreciate that!
there`s no words can describe how is this useful to me, thank you so much ♥
You're very welcome!
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!
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.
Excellent, this is the best Power BI tutorial I have ever seen, great job!!!!!
Thank you for the kind words!
You're the best!. You try by all means to make it simple for us. Thank you very much !
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
Awesome 😇,Thanks for sharing your knowledge. how can i get powerpoint presentation?
Thanks a lot for your crystal traing.
Always welcome
Quite clear. Pls how can I get the previous lesson (part 1)?
Here you go: ruclips.net/video/fnA-_iDV_LY/видео.html
Thanks for the video ❤..Is there any online platform like leetcode where i can practice power bi .
Such a great teacher Thank you so much for this
You are welcome!
Thank you for this video, great tutorial!
You're very welcome!
thanks for the tutorial. 56:00 restrict user's views
what an amazing POWER BI tutorial. Thank you very much.
You're very welcome!
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
Can you let me know how do we know which columns should we remove? At 7:29. Thank you.
Awesome Trish. Thank you for providing such great content.
Thank you for the continued support!
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.
There are some inconsistencies in the "Reviewing the Model Interface" part. That should be fixed
Noted, we have new Power BI videos coming soon!
Enjoyed this tutorial😍. Thank you.
You’re welcome 😊
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
Great course. I learnt a lot from this.
You are welcome!
Thanks for this tutorial, why you didn't remove duplicate values in Dim tables?
Great suggestion!
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
Great! I would like to study power bi for human resource management,thanks!!!!!
Best of luck!
Dear Learnit thanks for your continous videos on various topics, best and useful presentation!!
You are most welcome!
Amazing content,
Can anyone help me with the manuals ,cannot find for Power BI
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
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, this means a lot to me!
Best wishes and may God bless you! :D
You're very welcome!
Thank you for this nice beginner friendly tutorial! You explain each and every smallest step.
You're very welcome!
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
This course is helpful ❤
Thanks for the kind words!
Amazing! I Can't wait for another training!!!
Thank you so much Glauce! Part 3 is coming this upcoming Friday!
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
Thank you, the video was very helpful👍
Thanks!
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?
On my way to Advanced tutorial ✈
✈✈✈✈✈✈
exciting and step forward thank you learn-it
You are welcome!
Great teaching & course❣️
Thanks so much!
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!
Thank you so much for this tutorial.
You are so welcome!
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
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.
21:40 - can't filter out null in Returns.Status column, there's only one value in that filter - Returned.
same for me
I can't create new relationships, the ok button is not visible
@Learnit Training where are the ppt? pls let me know and provide the link to resources
It's very helpful ! thank you very much!
You are welcome!
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?
i need the exercise files as long as I downloaded the videos.
Exercise Files: bit.ly/2W9iMvZ
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?
Anyone mind explaining why we selected the discount column as a part of the Customer Info Dimension Query?
Thank you so much. This was so so so good!!!
You're so welcome!
fantastic!
Thank you! Cheers!
Thank you
You're welcome
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'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.
very knowledgeable session.
Thank you again Ajay!
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
amazing thank you.
You are welcome!
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.
I'm not able to see a relationship between DimCustomers and Orders. Can anyone explain what mistake I did? 48:17
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/
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.
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
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
There are no PowerBI files at the manual link
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.
brilliant !
Thanks!
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 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/
Thanks, a lot.
Always welcome!
Mam please make new series of Excel VBA
Hi Sagar! A new Excel VBA class is definitely on our list to record
Thank you, what an interesting and useful tutorial! 🥰🥰🥰
You’re welcome 😊
Thank you for the amazing efforts,
is it possible to have lifetime free Microsoft 365 account in order to publish projects for free?
Unfortunately Microsoft does require a paid subscription to Power BI to publish.
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.
Very good
Thanks!
49:09 Why didn't my Orders and DimCustomers have a relationship?
43:27
👍
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.
Thanks?!
I'm sorry, I love these tutorials. Thanks a lot :) @@LearnitTraining
third comment
Hi Hannington! Thank you for watching and we always try to use real world situations for our trainings
please help
Exercise Files: bit.ly/2W9iMvZ
hurry up, I'm in rush