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
@LearnitTraining
6 ай бұрын
Thank you much for the kind words!
@alinaqvi6203
2 жыл бұрын
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
@LearnitTraining
2 жыл бұрын
Thank so much for the kind word Ali!
@engineerraj1662
Жыл бұрын
I can very well agree with it. I learned a lot in the first two videos.
@LaxmikantMaheshjiKabra
4 ай бұрын
The best tutorial for Power BI on KZitem. 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!
@LearnitTraining
4 ай бұрын
Glad you liked it!
@ehsanreghabi
Жыл бұрын
i can't believe this is FREE ! great job... it's simple yet complex. perfectly balanced ! thank you !
@LearnitTraining
Жыл бұрын
You're welcome!
@LosoIAm
6 ай бұрын
This is the most comprehensive and free tutorial - Gold, THANK YOU!
@LearnitTraining
6 ай бұрын
Glad it was helpful!
@oluwaseunshogbamu6437
Жыл бұрын
Thank you for taking the time to explain and demonstrate how it works
@LearnitTraining
Жыл бұрын
Glad it was helpful!
@liaroy7346
Ай бұрын
Trish, you're absolutely amazing. Thank you for all the efforts !
@LearnitTraining
Ай бұрын
You are very welcome!
@RobiyaAxmedova-f3h
Ай бұрын
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.
@LearnitTraining
Ай бұрын
Our pleasure!
@writerconnect1596
2 ай бұрын
been watching the videos from the first one that you had posted. this is eloquent and really nice
@LearnitTraining
2 ай бұрын
We appreciate that!
@harryanderson863
Жыл бұрын
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
@LearnitTraining
Жыл бұрын
Thanks for the tip!
@jaitiwari241
2 жыл бұрын
I want to give one suggestion .please zoom the screen while explaining the concept..Amazing tutorial
@LearnitTraining
2 жыл бұрын
Noted!
@manishnaik3689
7 ай бұрын
God Bless such content creators who put so much efforts and put it out there for free .... typical king/Queen behavior 👑
@LearnitTraining
7 ай бұрын
You are very welcome!
@joseernestosabatercalvet1810
Жыл бұрын
Thank you Trish for the tutorial. I really like the way you explained it all. Moving to Advanced now!
@LearnitTraining
Жыл бұрын
You are so welcome!
@Somya_bhardwaj01
14 күн бұрын
Thanks for the video ❤..Is there any online platform like leetcode where i can practice power bi .
@diaashaaban-j3x
7 ай бұрын
there`s no words can describe how is this useful to me, thank you so much ♥
@LearnitTraining
6 ай бұрын
You're very welcome!
@ameneebadi206
Жыл бұрын
That was amazing. thank you. How can I get the certificate of this course ?
@LearnitTraining
Жыл бұрын
You are welcome! You can earn certificates of completion at Learnit Anytime - www.learnitanytime.com
@newtestamentharp1847
Жыл бұрын
Excellent, this is the best Power BI tutorial I have ever seen, great job!!!!!
@LearnitTraining
Жыл бұрын
Thank you for the kind words!
@purplestars8159
8 ай бұрын
Awesome 😇,Thanks for sharing your knowledge. how can i get powerpoint presentation?
@giftkay
Жыл бұрын
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:*.
@tomkovach2057
5 ай бұрын
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?
@LearnitTraining
5 ай бұрын
Exercise Files: bit.ly/2W9iMvZ
@mfundokhumalo3933
Жыл бұрын
You're the best!. You try by all means to make it simple for us. Thank you very much !
@LearnitTraining
Жыл бұрын
You are welcome!
@graciousgeorgea8678
Жыл бұрын
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.
@LearnitTraining
Жыл бұрын
Hello Gracious George A! You can get your question answered by our instructors at Offsite, our online community - www.offsitebylearnit.com
@AhmedGamal-mi1ns
Жыл бұрын
Awesome Trish. Thank you for providing such great content.
@LearnitTraining
Жыл бұрын
Thank you for the continued support!
@TrangNguyen-yo3ny
2 жыл бұрын
best ever Power bi trainning, thanks so much
@LearnitTraining
2 жыл бұрын
Glad you enjoy it!
@kietnguyenxuan1201
13 күн бұрын
Can you let me know how do we know which columns should we remove? At 7:29. Thank you.
@unpatel1
2 жыл бұрын
Thank you for this nice beginner friendly tutorial! You explain each and every smallest step.
@LearnitTraining
2 жыл бұрын
You're very welcome!
@enencheokoh3743
2 жыл бұрын
Quite clear. Pls how can I get the previous lesson (part 1)?
@LearnitTraining
2 жыл бұрын
Here you go: kzitem.info/news/bejne/x6R3k5OffYiQf44
@stephaniewoodend8267
9 ай бұрын
Such a great teacher Thank you so much for this
@LearnitTraining
9 ай бұрын
You are welcome!
@farzadsaedi1954
2 жыл бұрын
Thanks for this tutorial, why you didn't remove duplicate values in Dim tables?
@LearnitTraining
2 жыл бұрын
Great suggestion!
@mykingisJesus.
3 жыл бұрын
Dear Learnit thanks for your continous videos on various topics, best and useful presentation!!
@LearnitTraining
3 жыл бұрын
You are most welcome!
@anthony67889
2 жыл бұрын
Thank you for this tutorial. please how can i access the data you used for this tutorial. eg the three major tables.
@LearnitTraining
2 жыл бұрын
Exercise Files: bit.ly/2W9iMvZ
@TlholoN
7 ай бұрын
Enjoyed this tutorial😍. Thank you.
@LearnitTraining
7 ай бұрын
You’re welcome 😊
@harshiniadusumilli3181
4 ай бұрын
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.
@elmahdy1241980
2 жыл бұрын
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
@LearnitTraining
2 жыл бұрын
Hi Mohamed! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com
@AppleSiru
5 ай бұрын
I had the same issue. I resolved by removing duplicates from customer ID from DimCustomers
@cvreddy369
2 жыл бұрын
This series hands-on is enough to get a job in power bi?
@LearnitTraining
2 жыл бұрын
Hi Venkatesh! This is series was built on the Microsoft course DA-100 which will help you get certified in Power BI
@T1kursew
2 жыл бұрын
what an amazing POWER BI tutorial. Thank you very much.
@LearnitTraining
2 жыл бұрын
You're very welcome!
@srmchinni3
Жыл бұрын
Great course. I learnt a lot from this.
@LearnitTraining
Жыл бұрын
You are welcome!
@2took
Жыл бұрын
21:40 - can't filter out null in Returns.Status column, there's only one value in that filter - Returned.
@anjaliunnikrishnan5814
Жыл бұрын
same for me
@RehmanSadaqat
4 ай бұрын
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
@thesenate8268
3 ай бұрын
Same thing happens to me, when I try to create the missing relationship it gives an error message.
@arditsaliasi6515
10 ай бұрын
Thank you very much, this means a lot to me! Best wishes and may God bless you! :D
@LearnitTraining
10 ай бұрын
You're very welcome!
@tinmaunghtwe6090
3 жыл бұрын
Great! I would like to study power bi for human resource management,thanks!!!!!
@LearnitTraining
3 жыл бұрын
Best of luck!
@farzoq1
2 жыл бұрын
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
@jorelemes
2 жыл бұрын
Apparently you gotta have a Work email to use Power BI Service.
@LearnitTraining
2 жыл бұрын
To publish you will need a Power BI account
@diamondsandlipgloss
Жыл бұрын
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
@judechidozieezenyi9493
Жыл бұрын
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.)
@judechidozieezenyi9493
Жыл бұрын
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".
@LearnitTraining
Жыл бұрын
Hello Jude! We were all on a holiday break, sorry about the late replies. Our instructors should be replying soon!
@judechidozieezenyi9493
Жыл бұрын
@@LearnitTraining My bad, actually. I should have realised that. Welcome back! 😊 Happy New Year.
@marcocr228
Жыл бұрын
Thanks a lot for the tip, I spent a whole night troubleshooting XD
@wendyswellness-ok9rk
Жыл бұрын
@@judechidozieezenyi9493 I did this and it showed 6 of 529 rows from the list table, please is this correct?
@diamondsandlipgloss
Жыл бұрын
TIP: at 21:43 on our 1st independent merge exercise, select "Order ID" as the matching columns.
@LearnitTraining
Жыл бұрын
Thanks for the tip!
@judechidozieezenyi9493
Жыл бұрын
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 🙏
@anjaliunnikrishnan5814
Жыл бұрын
@@judechidozieezenyi9493 Same question I have.
@Maks-u5e3k
Жыл бұрын
Thank you, the video was very helpful👍
@LearnitTraining
Жыл бұрын
Thanks!
@kalamay
Ай бұрын
There are some inconsistencies in the "Reviewing the Model Interface" part. That should be fixed
@LearnitTraining
Ай бұрын
Noted, we have new Power BI videos coming soon!
@Eternal_Truth8
2 жыл бұрын
thanks for the tutorial. 56:00 restrict user's views
@not_amanullah
7 ай бұрын
This course is helpful ❤
@LearnitTraining
7 ай бұрын
Thanks for the kind words!
@nuribrahimdhaqane654
6 ай бұрын
exciting and step forward thank you learn-it
@LearnitTraining
6 ай бұрын
You are welcome!
@ChristopherEbhotemen
2 ай бұрын
Great teaching but some of this information dose match. Is it because it is an old video?
@LearnitTraining
2 ай бұрын
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.
@kalamay
Ай бұрын
@@LearnitTraining May I ask when are the updated tutorials coming later this year?
@deepaligarg594
Жыл бұрын
Amazing content, Can anyone help me with the manuals ,cannot find for Power BI
@zeinabhosseini-w6r
Ай бұрын
fantastic!
@LearnitTraining
Ай бұрын
Thank you! Cheers!
@AbuyounesNuha
Ай бұрын
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.
@kanwalhemant
8 ай бұрын
Great teaching & course❣️
@LearnitTraining
8 ай бұрын
Thanks so much!
@cs-kw4pl
2 жыл бұрын
It's very helpful ! thank you very much!
@LearnitTraining
2 жыл бұрын
You are welcome!
@ITCS
Жыл бұрын
please access me to download exercise file please i am very enthusiastic to start this course please
@LearnitTraining
Жыл бұрын
We just tested the links and files and they are currently working
@TheFrancisChowdhury
2 жыл бұрын
Thank you so much for this tutorial.
@LearnitTraining
2 жыл бұрын
You are so welcome!
@glaucedaeirabarros8390
3 жыл бұрын
Amazing! I Can't wait for another training!!!
@LearnitTraining
3 жыл бұрын
Thank you so much Glauce! Part 3 is coming this upcoming Friday!
@NAGULMEERASHAIK-m8u
7 ай бұрын
Thank you
@LearnitTraining
7 ай бұрын
You're welcome
@mohammadbagheri8238
2 жыл бұрын
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
@LearnitTraining
2 жыл бұрын
Hello Mohammad! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
@inigoaguilera3178
Жыл бұрын
Hi how did you get around this problem?
@suryapratapchauhan2506
Жыл бұрын
@@inigoaguilera3178 hey i am same problem. Did you find anything.
@danielgranjaconejeros6355
Жыл бұрын
Same problem!
@excelatonline
Жыл бұрын
@@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.
@karnarajrathod1656
3 ай бұрын
@Learnit Training where are the ppt? pls let me know and provide the link to resources
@jmora7101
9 ай бұрын
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?
@megabigman19
2 ай бұрын
I have same problem
@inigoaguilera3178
Жыл бұрын
For some reason my DimCustomers is not related/linked to orders when looking at model view. Any idea why this could be?
@LearnitTraining
Жыл бұрын
You can get help directly our instructors at Offsite, our online community - www.offsitebylearnit.com
@ricardoandresaldana02
Жыл бұрын
amazing thank you.
@LearnitTraining
Жыл бұрын
You are welcome!
@fungsweewong3774
2 жыл бұрын
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.
@LearnitTraining
2 жыл бұрын
Thank you for the tip!
@alpstinger5083
2 жыл бұрын
Thank you so much. This was so so so good!!!
@LearnitTraining
2 жыл бұрын
You're so welcome!
@bhimreddyramakrishna5131
2 жыл бұрын
Hi, Under returned status while merging tables which column from orders table need to be merged with status column from returns table.
@bhimreddyramakrishna5131
2 жыл бұрын
Is it order ID from Orders and Order ID from Returns . Correct me if i am wrong
@aloziedaberechi1929
2 жыл бұрын
I’m having the same issue. I’ve tried everything but I still couldn’t get it right
@domingosnhamussua3070
Жыл бұрын
On my way to Advanced tutorial ✈
@LearnitTraining
Жыл бұрын
✈✈✈✈✈✈
@ajaysingh6140
3 жыл бұрын
very knowledgeable session.
@LearnitTraining
3 жыл бұрын
Thank you again Ajay!
@KellieClemmer
2 ай бұрын
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?
@deepaponnusamy7514
2 жыл бұрын
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.
@LearnitTraining
2 жыл бұрын
Hello Deepa! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
@longbach3983
Жыл бұрын
In the Order ID collumn, just click on the filter and remove the null value
@joshuagabriel9752
Жыл бұрын
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
@joshuagabriel9752
Жыл бұрын
Where you able to find a solution cos i am stocked there right now
@AppleSiru
5 ай бұрын
@@joshuagabriel9752 I had the same issue. I resolved by removing duplicates from customer ID from DimCustomers
@prasadparadkar8750
2 ай бұрын
I'm not able to see a relationship between DimCustomers and Orders. Can anyone explain what mistake I did? 48:17
@TheBodehReport
2 жыл бұрын
Thanks, a lot.
@LearnitTraining
2 жыл бұрын
Always welcome!
@ismaspain22
9 ай бұрын
brilliant !
@LearnitTraining
9 ай бұрын
Thanks!
@ahmadmostafa3675
Жыл бұрын
i need the exercise files as long as I downloaded the videos.
@LearnitTraining
Жыл бұрын
Exercise Files: bit.ly/2W9iMvZ
@a8liothtes
3 жыл бұрын
There are no PowerBI files at the manual link
@philbrooks1919
8 ай бұрын
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
@LearnitTraining
8 ай бұрын
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.
@foreverhumanpodcast
8 ай бұрын
@@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.
@bb.5151
2 ай бұрын
I can't create new relationships, the ok button is not visible
@klarawijs
3 жыл бұрын
Thank you, what an interesting and useful tutorial! 🥰🥰🥰
@LearnitTraining
3 жыл бұрын
You’re welcome 😊
@shilpaachandrasekar8680
8 ай бұрын
Anyone mind explaining why we selected the discount column as a part of the Customer Info Dimension Query?
@Shreenath-f3t
Жыл бұрын
Hi, I am not getting the 'Merged1' separate query after merging but it all gets merged into the orders query. Please help.
@LearnitTraining
Жыл бұрын
Hello Shreenath! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
@aloziedaberechi1929
2 жыл бұрын
You asked us to merge orders and return tables together but I don’t know what column to select in the orders table ☹️☹️☹️
@LearnitTraining
2 жыл бұрын
Hello Alozie! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
@sagarshelar3927
3 жыл бұрын
Mam please make new series of Excel VBA
@LearnitTraining
3 жыл бұрын
Hi Sagar! A new Excel VBA class is definitely on our list to record
@carlosmagraso2292
2 ай бұрын
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.
@bb.5151
2 ай бұрын
Same for me
@2took
Жыл бұрын
Looks like there's no way to sign up for PBi Service without "work" email. Microsoft sure makes this a rabbit hole.
@LearnitTraining
Жыл бұрын
You can sign up for Power BI Pro with any email address. You will have to create an account as well.
@paul.t.akin-omorodion581
Жыл бұрын
I am having an issue when tried merging queries orders and returns to create return date i keep getting errors like out of memory
@LearnitTraining
Жыл бұрын
Hello Paul! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
@muonkret7817
3 жыл бұрын
Very good
@LearnitTraining
3 жыл бұрын
Thanks!
@ahmedsaieed__
8 ай бұрын
Thank you for the amazing efforts, is it possible to have lifetime free Microsoft 365 account in order to publish projects for free?
@LearnitTraining
8 ай бұрын
Unfortunately Microsoft does require a paid subscription to Power BI to publish.
@mathieux2101
9 ай бұрын
49:09 Why didn't my Orders and DimCustomers have a relationship?
@mdminhajalamdip4372
Ай бұрын
43:27
@LearnitTraining
26 күн бұрын
👍
@firozkabir6102
2 жыл бұрын
Exercise file location not working !
@LearnitTraining
2 жыл бұрын
Hi Firoz! We just tested the link and it is currently working!
@firozkabir6102
2 жыл бұрын
@@LearnitTraining can you help me please for getting this dataset.
@dsgsvdf
Жыл бұрын
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.
@LearnitTraining
Жыл бұрын
Thanks?!
@dsgsvdf
Жыл бұрын
I'm sorry, I love these tutorials. Thanks a lot :) @@LearnitTraining
@ahmadaltaweel4981
3 жыл бұрын
third comment
@LearnitTraining
3 жыл бұрын
Hi Hannington! Thank you for watching and we always try to use real world situations for our trainings
Пікірлер: 203