I'm very happy that I have stumbled upon the London Business Analytics Group YT channel. It has so many great power bi learning video's on all different topics. I am a big fan and would recommend that anyone learning Power BI watch all of them. I only wish I had found all these videos sooner. Thanks 😊
Thanks, this was very interesting. On Kaggle the Titanic dataset is divided into 3 parts: train, test, and hidden. The objective is to predict who in the test data is going to survive.
How do you see distribution of each column? As you are doing by just clicking the column and see the statistics below. How do you do that ? Please help.
Hi Akash, in View ribbon, enable the column distribution, column quality and column profile check boxes to see the green bars and column summary stats. - Mark
Does clicking on "Close & Apply" save all of the wok that we did if we wanted to pick up where we left off the next day after shutting down our computer? I had an issue where I saved my progress using "save as" but when I tried to open it 2 days later I kept getting error messages such as column "Pclass is not found", "name column not found", and it never loaded which forced me to do the entire tutorial all over again and I am worried that I'll lose my progress every time I log off POWER BI.
Hi KittyPistol9, Yes, close and apply closes the Query Editor window and loads all the transformed data into Power BI. Then save the .PBIX file also. You should not lose your work - Mark
Hi Mark, could you please share your machine's specifications with me? I have been searching to buy a new machine to kick start Power BI courses. My current laptop specs are terrible: Processor Intel(R) Core(TM) i3-5005U Installed Physical Memory (RAM) 4.00 GB Available Physical Memory 457 MB Thank you, Diego
@@LondonBusinessAnalyticsGroup Much appreciated Mark, I really enjoy watching your videos. Learnt a lot since I began watching LBAG channel on youtube. God bless. Diego
Thank you for the wonderful presentation, but you were a bit too fast on the executions. Kindly tone it down by a few seconds slower as i had to keep pausing and rewinding the video. Otherwise I have really learnt, kuddos
I'm very happy that I have stumbled upon the London Business Analytics Group YT channel. It has so many great power bi learning video's on all different topics. I am a big fan and would recommend that anyone learning Power BI watch all of them. I only wish I had found all these videos sooner. Thanks 😊
Hi Joanne, Thanks for the recommendation. Glad you are enjoying the channel. We'll be getting many more video out from late April onwards. - Mark
so useful! I had worked with this data set for modelling in Python, and cleaning it with Power BI is super easy comparably!
Glad you enjoyed it Arm. We have lots more Power bI videos on our channel th-cam.com/users/londonbusinessanalyticsgroup
Thanks, this was very interesting. On Kaggle the Titanic dataset is divided into 3 parts: train, test, and hidden. The objective is to predict who in the test data is going to survive.
Excellent video, very clear and helpful instructions. Thank you.
Nice course
this is awesome and very helpful. Do you have full lecture on power bi.
not able to download the data set in github
Hi Mark, great video :) My question is regarding SipSP and ParCh. Why was it necessary to add "me" or 1 in the formula?
How do you color codes for empty, missing and data? I was talking about transforming data in power query editor.
good learning .. helpful for interview
Thank you so much was on track everything was clear
Thank you.
You're welcome!
How do you see distribution of each column? As you are doing by just clicking the column and see the statistics below. How do you do that ? Please help.
Hi Akash, in View ribbon, enable the column distribution, column quality and column profile check boxes to see the green bars and column summary stats. - Mark
Very useful for me, thanks a lots
Does clicking on "Close & Apply" save all of the wok that we did if we wanted to pick up where we left off the next day after shutting down our computer? I had an issue where I saved my progress using "save as" but when I tried to open it 2 days later I kept getting error messages such as column "Pclass is not found", "name column not found", and it never loaded which forced me to do the entire tutorial all over again and I am worried that I'll lose my progress every time I log off POWER BI.
Hi KittyPistol9, Yes, close and apply closes the Query Editor window and loads all the transformed data into Power BI. Then save the .PBIX file also. You should not lose your work - Mark
@@LondonBusinessAnalyticsGroup Thank you, Mark! Such a helpful video. I learned a lot.
Hello cannot access the file. Can I have it for practice?
Good video..thanks a lot!!
Thank you for this wonderful session, one question: how did you enable Column statistics and Value distribution in the table?
HI Karuna, Switch on the three Column... checkboxes in the Query Editor ribbon. Glad you liked it. - Mark
Wonderful sir...
Many many thanks
Thank you
You're welcome
Hi Mark, could you please share your machine's specifications with me? I have been searching to buy a new machine to kick start Power BI courses. My current laptop specs are terrible:
Processor Intel(R) Core(TM) i3-5005U
Installed Physical Memory (RAM) 4.00 GB
Available Physical Memory 457 MB
Thank you,
Diego
Hi Diego, I have a 8GB RAM Surface. I think 8Gb is the minimum for Power BI Desktop to run well. - Mark
@@LondonBusinessAnalyticsGroup Much appreciated Mark, I really enjoy watching your videos. Learnt a lot since I began watching LBAG channel on youtube. God bless. Diego
Thank you for the wonderful presentation, but you were a bit too fast on the executions. Kindly tone it down by a few seconds slower as i had to keep pausing and rewinding the video. Otherwise I have really learnt, kuddos
its lovely sir but if you are chewing a toffe while lectrure please dont do it its irrritating btw its very nice content thank you
Sir you move too fast and the video is not too clear . I enjoyed it but it is hard following
thank you