Hey lucas, I just started my google certificate course for data analytics. I finished the first 2 courses out of the 8 in less than 24 hours. I have found the course easy so far, but I have also heard about Google's advanced course on one of your other videos. As a beginner, do you think I should power through the first course and then do the second or just drop the first video and do the advanced course?
Lots of recruiters never look at my portfolio.. I have a website and a github and ive had calls where i asked them if they looked at my portfolio and they said no, more than half the time 😒 Just a heads up for some people.. Resume is still the most important to get the call. Then portfolio you can talk about in subsequent interviews
Makes sense. Too many applicants to look through. But for someone like me with no experience, it means we have to lie on our resume just to get a foot in the door
Before your video, I was frustrated because I thought I was doing something wrong. Thank you for helping me to realize that cleaning data IS THE BULK of the WORK! I agree it's embarrassing to use 'messy data. Lazy. Other vids don't really describe the importance of cleaning & structuring data. If you do something right, most people won't realize you've done anything at all.
Hi. I am a neurobiologist (MSc, PhD) I have deep knowledge in statistics experimental, design, data analysis using R (RStudio, SPSS). I want to transition from Academy into industry as data analyst or data scientist. I don’t have a portfolio. However, I have four published papers in my field of research. In addition to creating a portfolio of a question from a random database. My question is, it is advisable to show up my papers as finished projects too? Thanks
If it's relevant to the roles your applying then yes like for eg. You are applying for data analyst/ data scientist roles related to neurobiology or biology. Plus if those papers include data analysis I guess you can add them.
@@jinaregenez6532 are you just guessing? Because thats important to always point out before giving advice. You sounded like if you are in the industry, but didnt clarify it.
@@MohamedSahith87 I think just type the question that pops into your head, try to think that chat gpt is a human being we ask for help, explain in detail what you mean
If you had to choose between LinkedIn and Wix, which option would you go for? Can you do a tutorial on how to do a project that includes a map or point me to such a video? Thanks!
Hi, I know you werent asking me, but personally I would have both. Your website should be an extension of your LinkedIn, to showcase your projects. Your Linkedin could be more cut and dry, while your website can be more robust, getting into the nitty gritty. Just my two cents!
Is the code that you were showing on Kaggle of those two data sets code that you wrote? Or is that code that you can already see when you browse the data, written by the author? Also, can you leave a link to your website or the guy's website that you mentioned?
I'm confused , you said use SQL to analysize the database. but you said you prefer to use Kaggle. but kaggle only supports Python and R. How does that work? where can I write SQL Codes?
Thanks for the great content! I made some projects in SQL including a Capstone project for Google certificate and a project in MySQL from Coursera, but as the dataset are not from Kaggle itself I had to upload them (converting sql file to sqlite to adjust it to Kaggle making it shorter because I used a free conversion tool) and the platform didn't let me to share the dataset... I also had trouble in using the notebook because it supports only Python and R, so I had to code a conversion in Python to use SQL queries I added in the qutation marks, but it just seem an unefficient way to show my queries, as well as the visualizations on Kaggle. I would really apreciate if you can make a video for uploading an external dataset to Kaggle, adding SQL queries and Tablau visualizations to show a project in Kaggle to link it to a portfolio of linkedin. :)
@@keepitshort4208 did you watch the video? You download datasets from Kaggle, then generate your own questions about the subject, then transform the data and generate visualizations to answer your questions. You make your own project.
Thanks you much for sharing so much info in such a comprehensive way. Can you plz share how can we write about the project with good writing skills I mean which factor to consider when writing
I am currently working on a SQL series which will be the first long tutorial on this channel, but it will take a lot of time to get this done. After this, I have more plans and projects will be a part of it.
@@learnwithlukas Thanks for confirming. IL be signing up, I also wanted to ask you as well. Do you have any alternatives to Learning SQL. I have been doing the SQL for Data Science on Coursera, but find it really boring and tedious. The lecturer Sadie St Lawrence is extremely boring!
Great video Thank you. How you upload SQL into Kaggle? Whats the best Practice? Is there any way to make it running like R or Python? Or just copy paste pictures of results? I found it very annoying
Depends on the type of SQL. You can upload the database for example, which users can download. All SQL code can't run on Kaggle, but you can still share the code and include explanations
Hey Lukas, I have been watching your videos for almost 5 months. I am now done with the Google Certificate program and now I am on a stage of building portfolio. Do you think making portfolio as you instructed inthis video is enough and I should apply right away? Or should I complete the Advanced Data analytics program by Google and then apply to jobs? Btw I have not touch Python yet. What is your recommendation ? I really appreciate your help.
I think applying to jobs is a good way to test the waters, but I would primarily focus on building a portfolio and not get discouraged along the way. There are many great videos by data analyst-specific channels like Alex The Analyst or Data Tutorials with portfolio projects to help you get going, and later create your own.
Quick question- I had made some interesting project and uploaded them in my gihub can i mention them in my portfolio Ps - i didn't have those project on my kaggle account
Can you make a video of how to get the website to show the info & graphs from Kaggle? Even if it's a short, I'd appreciate it. Also: Should I include an Excel project in my porfolio? Can both Kaggle and Wix support showing something in Excel?
Data Analyst Beginner Roadmap:
👉 learnwithlukas.com/da/
Hey lucas, I just started my google certificate course for data analytics. I finished the first 2 courses out of the 8 in less than 24 hours. I have found the course easy so far, but I have also heard about Google's advanced course on one of your other videos. As a beginner, do you think I should power through the first course and then do the second or just drop the first video and do the advanced course?
Your cheatsheet URL doesn't work
Thank you so much for telling me! Fixed now @@Romial34
Of the videos I've watched today about Data Analytics, this video gave me the most ideas. Thank you!
I just came across your channel and gotta tell you that your content is concise and unpretentious. It's very helpful and appreciate it.
Awesome! Thank you!
Thanks Lucas. No fluff. No filler. Informative from start to finish.
Lots of recruiters never look at my portfolio.. I have a website and a github and ive had calls where i asked them if they looked at my portfolio and they said no, more than half the time 😒
Just a heads up for some people.. Resume is still the most important to get the call. Then portfolio you can talk about in subsequent interviews
Makes sense. Too many applicants to look through. But for someone like me with no experience, it means we have to lie on our resume just to get a foot in the door
I think this is very true. But if you are building a consulting business and looking for clients, the portfolio will be much more necessary.
@@jcwynn4075 How? by stating you work at xxx?
Everything about your content is amazing. Even your website is so clear and very useful. I appreciate your videos
I appreciate that!
Such useful and straight forward content. Appreciate it.
Can you please make a video on how to clean and process the data ?
that'd be great, I agree
Before your video, I was frustrated because I thought I was doing something wrong. Thank you for helping me to realize that cleaning data IS THE BULK of the WORK! I agree it's embarrassing to use 'messy data. Lazy. Other vids don't really describe the importance of cleaning & structuring data.
If you do something right, most people won't realize you've done anything at all.
Great video -to the point
Can you please make a video of end to end project for portfolio as well.
That would be really helpful
I have a video about more projects coming soon
Amazing Job
this couldn't have come at a better time.
one of the fastest growing data channel in youtube!🎉
Thankful for every view I get!
Thank you just what I need to do right now!
I appreciate a video that gets straight to the point
Thanks a lot for portfolio site, it’s so useful, I will use it
Thanks for the proper guidance sir
Wow, love this video 😍 is there another video on imdb project? I would love to watch that too
Holy cow. You made this EASY
How do I get recruiters to look at it portfolio? The be recruiters (and their clients) only want a resume?
Please make a video on the projects!
Amazingg vid, liked subscribed !!
Those movie length x rating projects are 99% of every training course 🤣 How is that special if you can just copy paste the code..
Everything was well explained and informative 👍🏾
this is an excellent video continue doing videos specially tutorials in data analytics with steps
Thanks, will do!
Thank you sir, really useful tips
Hi. I am a neurobiologist (MSc, PhD) I have deep knowledge in statistics experimental, design, data analysis using R (RStudio, SPSS). I want to transition from Academy into industry as data analyst or data scientist. I don’t have a portfolio. However, I have four published papers in my field of research. In addition to creating a portfolio of a question from a random database. My question is, it is advisable to show up my papers as finished projects too? Thanks
If it's relevant to the roles your applying then yes like for eg. You are applying for data analyst/ data scientist roles related to neurobiology or biology. Plus if those papers include data analysis I guess you can add them.
@@jinaregenez6532 are you just guessing? Because thats important to always point out before giving advice.
You sounded like if you are in the industry, but didnt clarify it.
Make chatgpt your virtual mentor
What is the prompt for virtual mentor any suggestion@@TheKumarAshwin
@@MohamedSahith87 I think just type the question that pops into your head, try to think that chat gpt is a human being we ask for help, explain in detail what you mean
Very Interesting and Valuable Information about developing Portfolio for Data Analyst Profile.
I am inspired with u ...
Glad to hear that
A detailed video on the second project please
Please upload the second project idea with sql asap. Thanks
thnks for your saring about data analis
I love this is so direct
very interested to see a project video 😊
Thank you so much!
Glad it helped!
If you had to choose between LinkedIn and Wix, which option would you go for?
Can you do a tutorial on how to do a project that includes a map or point me to such a video?
Thanks!
Hi, I know you werent asking me, but personally I would have both. Your website should be an extension of your LinkedIn, to showcase your projects. Your Linkedin could be more cut and dry, while your website can be more robust, getting into the nitty gritty. Just my two cents!
@@jibbsautomations Thanks for the advice! I appreciate you taking the time! I really do!
Hello Lukas, would you please provide the links to the projects you are talking about in this video? Please would like to learn with you.
Could you do a video showing the cleaning process for these?
I think there are a lot of good project videos on RUclips if you look around, but I'll try to make some in the future too!
So you download a CSV/dataset off Kaggle, manipulate it, and then put it back on Kaggle later as your work?
PLEASE DO A VIDEO ON DATA CLEANING
Thank you really I was learn that at the foundation skills with alx and we well start the course after two weeks and we will do that
Thanks v useful
Please do an end to end project video
Thanks! Hopefully coming soon
@@learnwithlukas Yes and do take unique datasets like the one you discussed here. Too many projects use boring datasets
Is the code that you were showing on Kaggle of those two data sets code that you wrote? Or is that code that you can already see when you browse the data, written by the author? Also, can you leave a link to your website or the guy's website that you mentioned?
thank u so much sir
All the best
yes please, i want the project for movie rating
Does Kaggle have something similar for Cloud & Software projects?
bro we video of movie rating project with details please
thanks for this videos
Glad you like them!
I'm confused , you said use SQL to analysize the database. but you said you prefer to use Kaggle. but kaggle only supports Python and R. How does that work? where can I write SQL Codes?
You can find datasets ob Kaggle where you would run your SQL on.
@@nishipishi
Hi
Kaggle can provide Excel worksheets for you that you can import in Access and query the thing with SQL...
Hope this will be helpful
Thanks for the great content!
I made some projects in SQL including a Capstone project for Google certificate and a project in MySQL from Coursera, but as the dataset are not from Kaggle itself I had to upload them (converting sql file to sqlite to adjust it to Kaggle making it shorter because I used a free conversion tool) and the platform didn't let me to share the dataset...
I also had trouble in using the notebook because it supports only Python and R, so I had to code a conversion in Python to use SQL queries I added in the qutation marks, but it just seem an unefficient way to show my queries, as well as the visualizations on Kaggle.
I would really apreciate if you can make a video for uploading an external dataset to Kaggle, adding SQL queries and Tablau visualizations to show a project in Kaggle to link it to a portfolio of linkedin. :)
How can i make a portfolio with no experience?
Where should i start
Start with projects for learning
@@learnwithlukas which is the best place to get projects from ?
@@keepitshort4208cousera
@keepitshort4208 I saw guided projects on Coursera, and there is datacamp as well. I think we can start from there.
@@keepitshort4208 did you watch the video? You download datasets from Kaggle, then generate your own questions about the subject, then transform the data and generate visualizations to answer your questions. You make your own project.
Thanks you much for sharing so much info in such a comprehensive way. Can you plz share how can we write about the project with good writing skills I mean which factor to consider when writing
will you be making a in depth video on the imdb data set? or any other projects?
I am currently working on a SQL series which will be the first long tutorial on this channel, but it will take a lot of time to get this done. After this, I have more plans and projects will be a part of it.
We need video on projects
Can you please make walkthrough videos on these projects? It’s be really helpful 🥹
Great vid mate really considering joinging your acclerator programme. Whats the diffeence between instant access the other choice?
Thanks! They are very similar, one just comes with more coaching :)
@@learnwithlukas Thanks for confirming. IL be signing up, I also wanted to ask you as well. Do you have any alternatives to Learning SQL. I have been doing the SQL for Data Science on Coursera, but find it really boring and tedious. The lecturer Sadie St Lawrence is extremely boring!
Welcome! I recently added a practical course I highly recommend, SQL from A to Z, to the roadmap. Check it out! @@sachynwagjiani1173
@@learnwithlukas Do you have the link mate, many thanks
@@sachynwagjiani1173 learnwithlukas.com/roadmap
Quick question. Whats the different between project and portofolio?
A portfolio is a collection of your work, like your projects
@@learnwithlukas i see, thanks 🔥
Great video Thank you. How you upload SQL into Kaggle? Whats the best Practice? Is there any way to make it running like R or Python? Or just copy paste pictures of results? I found it very annoying
Depends on the type of SQL. You can upload the database for example, which users can download. All SQL code can't run on Kaggle, but you can still share the code and include explanations
@@learnwithlukas Thank you for that!
Hey Lukas, I have been watching your videos for almost 5 months. I am now done with the Google Certificate program and now I am on a stage of building portfolio. Do you think making portfolio as you instructed inthis video is enough and I should apply right away? Or should I complete the Advanced Data analytics program by Google and then apply to jobs? Btw I have not touch Python yet. What is your recommendation ? I really appreciate your help.
I think applying to jobs is a good way to test the waters, but I would primarily focus on building a portfolio and not get discouraged along the way. There are many great videos by data analyst-specific channels like Alex The Analyst or Data Tutorials with portfolio projects to help you get going, and later create your own.
Quick question-
I had made some interesting project and uploaded them in my gihub can i mention them in my portfolio
Ps - i didn't have those project on my kaggle account
Hey man I love DA but a lot of posts I see say you need a degree -- should I/we just go for it if we have no degree?
I know analysts with degrees and without degrees
that`s weird problem ever! Some companies look at your degree level 1st and 2nd your name/face.
#terrible
Can you make a video of how to get the website to show the info & graphs from Kaggle? Even if it's a short, I'd appreciate it.
Also: Should I include an Excel project in my porfolio? Can both Kaggle and Wix support showing something in Excel?
No, excel is outdated software. Get with the times
Awesome
You are a G
AI voice and video not matching so not useful
Do I really sound that robotic?
@learnwithlukas, no, you don't. If this is an AI voice, it's much better than the ones on the reddit videos.
Haha thanks. It's not an AI voice @@c.b.5535