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 UA-cam. 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
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 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
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?
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?
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
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 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
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.
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.
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".
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 🙏
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.
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.
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 UA-cam. 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 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!
i can't believe this is FREE ! great job... it's simple yet complex. perfectly balanced ! thank you !
You're welcome!
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!
been watching the videos from the first one that you had posted. this is eloquent and really nice
We appreciate that!
Thank you for taking the time to explain and demonstrate how it works
Glad it was helpful!
This is the most comprehensive and free tutorial - Gold, THANK YOU!
Glad it was helpful!
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 Trish for the tutorial. I really like the way you explained it all. Moving to Advanced now!
You are so welcome!
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:*.
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!
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!
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!
21:40 - can't filter out null in Returns.Status column, there's only one value in that filter - Returned.
same for me
Dear Learnit thanks for your continous videos on various topics, best and useful presentation!!
You are most welcome!
what an amazing POWER BI tutorial. Thank you very much.
You're very welcome!
I want to give one suggestion .please zoom the screen while explaining the concept..Amazing tutorial
Noted!
Awesome Trish. Thank you for providing such great content.
Thank you for the continued support!
Thank you for this nice beginner friendly tutorial! You explain each and every smallest step.
You're very welcome!
Such a great teacher Thank you so much for this
You are welcome!
Great course. I learnt a lot from this.
You are welcome!
Thank you very much, this means a lot to me!
Best wishes and may God bless you! :D
You're very welcome!
thanks for the tutorial. 56:00 restrict user's views
Enjoyed this tutorial😍. Thank you.
You’re 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.
Amazing! I Can't wait for another training!!!
Thank you so much Glauce! Part 3 is coming this upcoming Friday!
fantastic!
Thank you! Cheers!
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
exciting and step forward thank you learn-it
You are welcome!
Great! I would like to study power bi for human resource management,thanks!!!!!
Best of luck!
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 can't create new relationships, the ok button is not visible
Thank you so much for this tutorial.
You are so welcome!
This course is helpful ❤
Thanks for the kind words!
Thank you so much. This was so so so good!!!
You're so 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.
brilliant !
Thanks!
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
I'm not able to see a relationship between DimCustomers and Orders. Can anyone explain what mistake I did? 48:17
Thanks for this tutorial, why you didn't remove duplicate values in Dim tables?
Great suggestion!
Thank you, the video was very helpful👍
Thanks!
Put speed to 1.25, thank me later :)
💯
I just watch it 2x 😂
It's very helpful ! thank you very much!
You are welcome!
Thank you
You're welcome
Anyone mind explaining why we selected the discount column as a part of the Customer Info Dimension Query?
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
@Learnit Training where are the ppt? pls let me know and provide the link to resources
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.
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
amazing thank you.
You are 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
Awesome 😇,Thanks for sharing your knowledge. how can i get powerpoint presentation?
Thanks, a lot.
Always welcome!
On my way to Advanced tutorial ✈
✈✈✈✈✈✈
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
Quite clear. Pls how can I get the previous lesson (part 1)?
Here you go: ua-cam.com/video/fnA-_iDV_LY/v-deo.html
Great teaching & course❣️
Thanks so much!
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
Thank you, what an interesting and useful tutorial! 🥰🥰🥰
You’re 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.
very knowledgeable session.
Thank you again Ajay!
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
Amazing content,
Can anyone help me with the manuals ,cannot find for Power BI
There are no PowerBI files at the manual link
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.
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
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
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
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/
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
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?
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
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 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/
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
49:09 Why didn't my Orders and DimCustomers have a relationship?
Mam please make new series of Excel VBA
Hi Sagar! A new Excel VBA class is definitely on our list to record
Very good
Thanks!
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.
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
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.
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.
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
please help
Exercise Files: bit.ly/2W9iMvZ
hurry up, I'm in rush
third comment
Hi Hannington! Thank you for watching and we always try to use real world situations for our trainings