thanks for this video! Excited to begin this new journey. :)
@rinuxaesh6316 сағат бұрын
It's 30th May 2024. it's my goal to be a Data Analytics in 3 month
@worldoflove62718 сағат бұрын
Can u do a roadmap?
@bushmaster7520 сағат бұрын
Good Suggestions and Motivational ...Thanks
@krarhyderabad476223 сағат бұрын
Im from iraq Is it possible to land a world wide job after this
@deimanterepsaite9014Күн бұрын
Great Video Thank You q
@mansigupta3829Күн бұрын
Very true, here i got laid off with just a month ago and in a month i could only appeared in one interview and i got rejected.
@sperorebecca57922 күн бұрын
Thanks
@helalchowdhury2 күн бұрын
You blink too many times.
@MHHM97Күн бұрын
😂😂😂
@vaidehipandey68632 күн бұрын
I really appreciate you making this video its really Insightful and helped me in way❤
@GameboyMufti2 күн бұрын
I tend to disagree with you, Excel is very important as google sheets cant do what Excel can do and using a cloud system is not always an option.
@forratedrstuff3 күн бұрын
One thing I would be worried about is facing competition from freelance workers from let’s say india or the Philippines because they would charge far lower rates.
@sirus23273 күн бұрын
Your pay totally depends on what you do the quality of work you do
@forratedrstuff3 күн бұрын
@@sirus2327 not so clear cut, people will also look for the cheapest rates. I’m sure people from lower cost of living countries can make a good dashboard as well.
@yagndabhi21783 күн бұрын
Please make one video about the bare minimum topics we need to know to get an entry-level data analyst job. It would be very very helpful, like what I need to know in SQL, Excel, statistics, and Python (and anything we need to know).
@deusvult12683 күн бұрын
That depends a lot on a lot of factors. Don't think it is that easy to say. I would look at job ads in your local area and then learn the skills they mention or are necessary to do what they mention.
@rahimhussain87273 күн бұрын
great video, thanks
@mithunmahaadevan4633 күн бұрын
Thanks man, really informative
@enemartha29884 күн бұрын
I honestly appreciate this video, thanks.
@mokkaplayers90704 күн бұрын
Hi brother i am living in dubai and working at taxi industry as operations assistant i want to upgrade my career as data analysis is it possible anyway to have you as my mentor!!
@RishuRaj-kq9wb4 күн бұрын
Bhai hum B. A IN HISTORY SA H KYA KER सकता हु plz reply
@electricalbatross57975 күн бұрын
#1 competition hits the nail on the head. As SOON as Google started advertising their Data Analytics Certificate on KZfaq (in actual pre-video ads), I knew it was already too late.
@AdarshSahaniAD5 күн бұрын
What i have to do to differ from the crowed, should i have to focus on DSA more or make some very fancy projects
@AdarshSahaniAD5 күн бұрын
What i have to do to differ from the crowed, should i have to focus on DSA more or make some very fancy projects
@AdarshSahaniAD5 күн бұрын
What i have to do to differ from the crowed, should i have to focus on DSA more or make some very fancy projects
@AdarshSahaniAD6 күн бұрын
so in conclusion what i have to do to differ from the crowed, should i have to focus on DSA more or make some very fancy projects
@Ytpre-gb1ud7 күн бұрын
I am starting my journey of a data analyst. As of now I am learning Data Science using Python and Tableau. I plan to complete it and increase my understanding overtime. Ask me where I am in Aug 2024. I plan to build two personal projects either in insurance domain or Healthcare. Keep Liking so that I can stay on track
@asiftalukder35147 күн бұрын
you are just awesome man
@fidhafathima1957 күн бұрын
Hi Rohan I did my post graduation in economics. Can I switch my career into data analytics domain? Please answering 😊
@newenglandnomad94059 күн бұрын
This is an excellent video. Having good questions, and your critical thinking comments were very helpful. My original mental hang up was why if people are using a website login, which verifies with the database, was there a need for a data analyst.I now better understand it's for internal use questions. I know that sounds simplistic but test datasets look horrible and aren't insightful. This data set looks real world useful. Thanks for our real world insights. I like your short videos too. I'm at the point of making projects that used to look terrible, to ones I hope are interview worthy. Thanks for your efforts and education.
@IVANTRADESGOLD9 күн бұрын
I want to start but dont know where from? Can you help me go in right direction?
@iman57939 күн бұрын
rohan, the stats course you recommended is no longer offered on coursera. I don't think stanford offers that course anymore. any other recc?
@veditor0710 күн бұрын
I am going to break in the industry by august 2024 end!!
@SixLoMein10 күн бұрын
Not gonna lie bro, when I first clicked on this I thought this was just gonna be another fear bait video feeding off the whole lay-off anxiety going round, but I'm impressed! You put this video together well, and gave MANY useful tips that I've noted moving forward. Keep it up:)
@taha575410 күн бұрын
Hi @rohan thank you for the video was waiting for it, but a bit disappointed the video seems rushed. Would like a more in-depth EDA, and advise on what is the industry practice when data seems misleading (e.g, avg student deposit) or insufficient (e.g. contact channels types) that data analyst adopts in such scenarios. This dataset taken from Kaggle is obvs limiting and wouldn't showcase skillset of dealing with industry-level datasets to an employer.
@rohanadus10 күн бұрын
Thanks for the feedback! I'll work on a more in depth EDA before releasing part 3. Regarding industry practice you'd want to check in with the Data Engineering teams, if it's a problem with the ETL or data collection. You would pause the analysis unless you have another "source of truth" table you can refer to. More than happy to expand on this in a video.
@taha575410 күн бұрын
@@rohanadus Thanks for addressing, would be looking forward to it in another video.
@xeno_plays293010 күн бұрын
Understanding orde of execution is important i got to know that recently when I was studying subqueries....i had a doubt that if we give the subquery an alias in the select statement why can't we use the alias instead of writing the whole subquery again in the where clause condition.
@waqarkhanpisces10 күн бұрын
Is it possible to learn in 3 month for people who r not coming from cs background
@tarun384710 күн бұрын
Adjust your mic
@Sunny-hg5oe11 күн бұрын
This was hell of a video, damn straight forward one, Thank you. Now I got motivated to set up my priorities well.
@sameershaik577811 күн бұрын
I completed my btech now i want to learn data analytics. So many people say it's difficult to get job as fresher in data analytics. Is it that much difficult
@MrsMarinaAllen11 күн бұрын
Thats good to know! Thanks for sharing!
@shimulbiswas212911 күн бұрын
Thanks for sharing your thoughts
@doyouwantsli968011 күн бұрын
It does have a significant impact on speed even in the worst case. Sending data from db to app takes a long time, sometimes longer than the query, so limiting to 100 results instead of 100'000 makes a huge difference. Now of course if you do some novel SORT, for example, that will be done for every row before the limit, but also after the WHERE. Where will be the biggest factor in performance usually, since it reduces the number of rows being worked on, hopefully using an index which will be faster than o(n). There is a point that could be made that limit doesn't always save you, but it almost always helps. I conclusion, your video is quite misleading.
@rohanadus11 күн бұрын
Thanks for your feedback! You make some excellent points. In the video, I was specifically talking about how LIMIT affects the query execution speed within the database itself. You're right that LIMIT can significantly reduce the data transfer time between the database and the application, which is definitely important, especially with large datasets. However, when it comes to the internal execution of the query, if the query involves operations like sorting, the database still needs to process all the qualifying rows before applying the LIMIT. That was the main focus of my discussion. But I totally agree that LIMIT helps in reducing the amount of data sent over the network, which can improve overall performance from an end-to-end perspective. I appreciate you bringing this up, and I'll make sure to clarify these points better in future videos. Thanks for helping me improve!
@anjumhiba793012 күн бұрын
Today is 19th of may, i will start from 20th may, that is monday. Will start sql and oython side by side tho. Will update you in a month. Lets do it together guys ⚔️
@eyobassefa129512 күн бұрын
Just finished IBM data analytics on coursera. Im plannig to take tableau next. I have MS in public health. Do you think i can be a freelancer especially on health related areas??
@ellioni588312 күн бұрын
Hi, congrats :) I am a nursing 1st year (prev year in business). It"s not hitting for me in some areas (healthcare pressures can be rough). My mind veered to health informatics- and a careers guide directed me to my uni"s free access to LinkedIn Learning. I"m doing "Learning Data Analytics: 1 Foundations". It"s good and want to approach SQL next, or similar! Your encouragement was v helpful and I noted the resources. I don"t understand making a portfolio, as I don"t work with company data. Did you use a software, if so how (I believe you touched on it)? Another question is- many courses aren"t free...how can I learn but provide learning proof without a certificate? Good luck to our futures
@beastboyaishh414512 күн бұрын
Indeed👍
@krantikumarm270513 күн бұрын
:)
@krantikumarm270513 күн бұрын
how much is your bootcamp fee?
@grateful990713 күн бұрын
It can also perform data analysis, do you think this ai is gonna replace human analysts?
@kavya960513 күн бұрын
How to prepare a personalised resume. Give me some suggestion. Which ATS reader i need to use before sending to the recruiter?
@taha575413 күн бұрын
When is SQL project part 2 gonna be uploaded?
@Chrisbit114 күн бұрын
I have a question, between Excel and Google Sheets, which one should I practice with ?