How I Would Learn Data Analysis (If I Could Start Over)
HTML-код
- Опубликовано: 3 июл 2024
- Boost your Data Analysis career by learning SQL at LearnSQL.com: learnsql.com/?ref=stefanmasni...
If I could start Data Analysis over again, where would I start? Which languages would I learn and which BI tools would I learn? Learning Data Analysis is a little bit different for everyone, but hopefully this video will help you to build the necessary foundation to become a Data Analyst.
Subscribe to the best Data Analysts on RUclips:
@LukeBarousse
@KenJee_ds
@AlexTheAnalyst
IBM Course: Introduction to Data Analytics:
www.coursera.org/learn/introd...
Harvard Data Science Courses:
pll.harvard.edu/course/data-s...
pll.harvard.edu/course/data-s...
pll.harvard.edu/course/data-s...
9 Personal Data Analytics Projects:
careerfoundry.com/en/blog/dat...
Timestamps:
0:00 - Intro
0:38 - Part 1: Your mindset
0:52 - Adopt an analytical mindset
1:53 - Don't trust, verify
2:52 - Part 2: Learning programming
2:58 - Pick your first tool
3:08 - Get familiar with Data Analysis
3:34 - Pick your first tool
4:52 - How to learn SQL
6:07 - Pick your programming language
7:17 - Create a personal project
8:21 - Data Visualisation
8:47 - Pick your BI tool
9:34 - Congrats!
9:47 - Important message
#dataanalytics #dataanalysis #dataanalyst
►LEARN HOW TO USE FREELANCING AS A STEPPING STONE TO FREEDOM:
courses.stfnvic.com/freedom-f...
►FOLLOW MY JOURNEY:
Instagram: / stefanovic92
►I TWEET ABOUT TECH, CRYPTO & POLITICS (and much more):
/ stfnvic
►GEAR I USE IN MY VIDEOS:
Main Camera: amzn.to/3fW5Pf7
Cinematic Zoom Lens: amzn.to/33FULAt
Ultra Wide Lens for Vlogging: amzn.to/3rG2gzi
Microphone I use for everything: amzn.to/3fPxXRb
Fastest Laptop ever for Video Editing: amzn.to/343egTa
My Favourite Backpack That Fits My Camera AND Laptop: amzn.to/3LJfox7
►WHERE I GET MY MUSIC:
Epidemic (30 Days For Free!): epidemicsound.com/referral/cmxato
It took me 7 years of working as a Data Analyst to realise I'd rather pursue a life of creative entrepreneurship. So I quit my Data job after 7 years and am now creating a life of freedom. Follow my journey here: instagram.com/stefanovic92/ I try to answer all DM's related to creating a life of freedom
I am a bit confused on you saying location freedom. Doesn’t being a data analyst allow you to work remotely??
I’ll appreciate your help 😊
How can I get a remote data analysis job? Is it even possible?. I'm 53 and live in France (don't speak good enough french).
I understand what you're saying about a life of freedom and I applaud your goal. I am similar in that I am looking into Data Analysis as a remote job option so I can pursue my own plan of living on my farm in the Philippines and quitting my overseas work in the Middle-East. I think I can use my previous career as a stepping stone into Data Analytics and hopefully, my experience will be useful in this new field. Thanks.
SORRY, I Confused about what you say you do not choose data analytic if you return back to the past, can I ask why? 🤔
I am brazilian data analyst and I agree 100% with everything in this video. I would just recommend that people use kaggle to practice some data skills.
Please,could I communicate with you i need to ask you much questions ☺️🤗
Oi, jovem me dá uma luz na vida, quero muito trabalhar com tecnologia, mas não quero ser front end, mas sim Analista de Dados, mas quero muito me forma em ciências da computação sou novo tenho 21 anos já fiz o semestre, a minha dúvida é, sem faculdade as portas são iguais com faculdade?
@@Gabriel_Melo.F cara, em ciencia de dados acho a faculdade bem importante, ela te abre mtas portas e te coloca mto na frente dos concorrentes... e o principal é q vc vai ter a chance de estagiar, isso ajuda mto! Mas boa sorte vc ta no caminho certo
Is it any chance to people who just learn data analyst autodidact? I mean, no need such as bootcamp. Just learn via datacamp, cousera, book, ytb
@@jsunxae4822 Probably in another's countries, in Brazil having a degree is absolutely necessary. But in EUA, for example, they consider more your proficiency then a degree.
Being told by a manager to manipulate data or calculate something the wrong way to make it look good, unfortunately happens across lots of businesses. Never do it. It will fall back on you. That manager will take the credit but if anyone finds out, you will take the blame. Being accurate and interested in the truth, is your job as a data analyst, in the long term, you will be respected, trusted and rewarded for it
Thank you Stefanovic. First two tools for Data Analytics -- Excel and SQL. Honestly, I am so tired of people pushing aspiring data analysts down the R and Python route. You need to know how to use Excel and write SQL first. Then I suggest a data visualization tool such as PowerBI or Tableau. Feel free to learn R and Python alongside or shortly thereafter. But you will not get a job by not knowing Excel. You will enhance your first job with SQL. These are the building blocks. Any programming languages after that will only further enhance your viability as a flexible data analyst.
I’m a junior in college studying industrial engineer with a data analytics minor. I just had my first internship this summer, and I cannot stress how important SQL was. I learned it at my internship through online courses + my boss, and used it and tableau for my internship project. many, many companies will be looking for people who can use these tools and I would learn sql and tableau as soon as you can! they’re so useful.
Nice. Did you know Python before?
I graduated as an industrial engineer half a year ago. The skills you learn with analytics are extremely useful for industrial engineers imo, I think it is still much under the radar of institutions and students as well. Anyway, by self-learning I got my first job as a junior data analyst - unfortunately not within manufacturing industry. I hope to get there though.
@@jeroen5337 Where did you learn? I mean, I currently learn from coursea (Certification provided by google).
Oi Amanda. Seu comentário me deu esperança!
Hey Luke.
Can I have your contact?
Thank you Stefanovic 😊. Wishing you happiness, health and success
Honestly thank you for all the great suggestions
Thank you do much for the introduction! It's really useful. And it can be seen that you did hard work on this video!
great depth, clear purpose, easy to get hand on. Great video.
Thank you for all these videos!
glad i'm here to witness your journey that is filled with inspiration and adventure , and the the quality of ur videos reflect that !!!
Thanks Hamza!
Good advice! Thank you!!!
Just started as a Jr Data Analyst apprentice and your advice is always in the back of my head. Really appreciate your content!
Where at? I’m currently looking for apprenticeships!
Best video I have seen so far related to Data Analysis. Thank you! :)
This is the most honest video I have seen so far on youtube!💛
I know you told me not to subscribe but, your video was so good and inspirational that, I felt the need to go ahead and click the red button. Hell of a video, amazing info, great great great all around. I'm 42 and I'm trying to search a new career path for me. I've been on the IT support side of things for too long and data analytics keeps popping up on my radar. I'm going for it. thank you!
Thank you for the motivation 😊
thank you for the info😃
dude you changed my perspective of seeing things in a right way am greatful to stir life in this direction ,bro thanks man
What a nice video. Thank you!
A practical approach to being a data analyst. I agree with your recommendations and resources.
You have done a great job putting all this mind blowing content together ☺️
Woooow!!! That was the most impressive message I've heard from a data scientist. Thank you for being so open and honest about, thats why I think this video find an authentic interest for many of people. I've not realized about whether I can not go ahead with stay in an office cos I'm hardly a noob. So first expecting to aspire to being an analyst. THANK YOU!!!!
I am a 5+ years of experience data analyst. And I've already reached the point when it's frustrating me so hard when I remember my previous work experience. These crazy amount of tasks and attitude of colleagues.
But I have not reached my maximum skills and salary. I'm stuck with Excel and SQL, and a bit of BI. Python, statistics and all that stuff - that's what I have yet to learn and master.
Currently I am feeling the same as you - I hate corporate world and all this freaking hierarchical games. And one day I will finish this game. But before that, I want to leave with in a memory that I've learned and reached maximum potential as I could as a data analyst. I am on a half way, need to finish it completely. 💪
And, of course, new subscriber. 👍
I have completed masters in Data Analyst, but have no work experience in Data field, will you help me to get job sir?
@@renganathanumanath2729 The job seeking is the part when it's complicated for all levels, not only Juniors. Middle and Seniors too. But you'll find your place, anyway. Even junior with no previous work experience you'll find your place for sure. The crucial is to show your knowledge in hard skills, especially SQL. SQL is a 100% necessary skill and every company is interested how much good you know this language. Good knowledge of SQL will give you a very big guarantee to get your job!
Can't get no worse than working at customer service at Walmart for a low pay while customers cursing you out and your manager pushing you around.
@@BadWeatherfreak Well, it's true. Totally agree
Hi guys, can you please let me know is sql to hard to learn with zero prior experiance, I have degree in economics, but I wish to change my career, any suggestions?
Thank you, for useful video.
This is What I was looking For, i am starting out in the IT and Thank you for explaining so thoroughly with a nice design!
Fabulous!
Great tips, and great learning resources.
Thanks for such a wonderful video.
I will subscribe without a doubt.
Great video. Honest person. Greetings from Spain
Thanks man!!! I love your videos.
I appreciate that Diogo!
Love the aesthetic of your videos and the quality of the image! Btw amazing information, I started recently to study data analyst, I hope to finish all the courses soon and change my life of hurting my body in shitty jobs for small payments!
Good luck man!
Thanks for this content man... Greetings from Bolivia 🇧🇴!
Great video thnks ❤
i love you man, thank you so much
Thank you! I hope that this knowledge can help me
Too late , I already subscribed and its after I stumbled across your channel while investigating what type of computer sciencey/IT path would most suit me if I completely changed tack and pursued a different course 🤷♂️. But I can honestly say I'm glad I found your channel. Very clear and useful and informative content and great links for further study. Thank you.👍
What path or change did you take?
Great video! I signed up to learn sql long before. It has definitely helped me!
You summarized perfectly the road to follow-up, to become a data analyst, and I'm really grateful for that... I know your content won't be 100% about Data Analysis anymore, but a way to support your work -because of this well-made video- is to give you, at least, a +1 follower...
This was great!
Nice video.
Great explanation.
thanks for sharing amazing video
This video is so valuable!
Thanks you for the video
Thanks for your video, it’s so meaningful for people who want to be Data Analyst ^^
Hvala Ti za ovo.
Nema na cemu
Wowww again. Thanks🙂
Thanks for the video I'm looking forward to becoming a data analyst
Thanks man!
Wow, this video was for me so much valuable, i agree totaly with everything what you said. Congrats for the channel.
I'm a Brazilian data analyst, working in working in healthcare area.
bro awesome video
Thank you!
Stefan you are bad ass!! 💪👊
Fabulous video 🤠
Hvala Stefane
Waiting for the next data analysis video ✅
The end was nice!
Amazing video again! Loved the funny bits 🤣🤣 that swoosh to the ad is too funny.
❤️
Man, you're an authentic gent, for you to recommend Alex, Luke & KenJee just taught me how important it is to be authentic to your own personal journey...very cool
Your content bangs 🔥
thankyou ! very very helpful thank you thank you thank you you are awesome !
No thank YOU Kelly
Thank you for message and learning, ill take it as a birthday gift💖🙏
well happy bday!
@@Stefanovic92 thank you😊🙏
man youre my inspiration
Great video
Great video thanks for the Information
Appreciate it David!
Inspiring.
Good material! I am an 54 IT Consultant, that started in the area 35 ago and I really appreciated your hints! We have to balance personal life, work, studies and other goals to achieve nearly a joyful life! Congrats!
This video was way too informative. And btw sick transitions!!!
you don't know how this clip meaningful to me. thank you so much
Dude! This is great!
I'm literally trying to figure out what to do with SQL and Python, as I learned only both or as I found them both easy and interesting.
You're literally helped me out to figure a career path.
Thank You!
SQL is one of the best tools to learn in general. I would note that in addition to analytics it is also the skill required for database administration and design. Indeed, before data analytics became a buzz-word, most of the data analysts of the world were Database Administrators (DBAs) who ran things like SQL Server Analysis Services (SSAS) or SQL Server Reporting Services (SSRS) in addition to performing tradition database development and administration tasks.
Ciao Stefan. Thanks again for the great video and tons of useful information. BTW do not make exuses for the sponsors of a video, because the important content is huge as well as the little ditails (IBM course in one week ;)
I wish I had this video when I first started learning data analysis. It would have saved me so much time and frustration!
Hi there! I'm 43 and at the start point of my switch to data analysis from the lecturer at the university. Just now I'm taking a Python course for developers and trying to focus the right emphasis on what to learn after. To tell the truth, I suppose that I am familiar with Excel and I like to work with it, but macros programming still isn't my cup of tea. I like to find out new insights from your content. I just found out that I have always been inspired by analysis, data interpretation and building the dependencies "x-y".
Still believe that this step will give a good feel of a competitive salary to live in harmony with my job.
Thank you for your encouraging video, style of presentation and simple concise manner, Stefanovic.
By far, the best pitch for subscribing to the channel. :D
And yes, super-informative video :)
Thank you so much for this clear video! I am still studying, and I think it might be the perfect time to learn more about data. In my last year I can take a special course that is focused on data. I hope I can grow with the given websites and courses.
Another perfect video, man! I work in HR with a big company, and I do just a tiny bit of data analysis, mostly with turnover. I'm in the capstone module of Google Data Analytics (Coursera). My coworkers keep telling me I should stay in my lane, this won't apply because so-and-so already does that, etc. You (and Luke) keep me motivated. I like the data stuff, and if I pursue it full time in the future my coworkers can kiss my ass.
EDIT: Dude, I know that you are discouraging us from subscribing as you don't consider yourself a data analyst anymore, but in a prior video you stated that you want to get paid for your output and not your input. This resonated with me in realizing and keeping in perspective the purpose of my work. I live by that now (I was a clock watcher before). Always good advice.
I am in HR also but want to do something else but use my experience as well. Going to check out that course.
thank you!
No, thank YOU!
thanks for being straight to the point and being honest with your content, i'll definitely be able to start learning data analytics to increase my skills and here is what i've learned from your video:
1. learn to have an analytical mindset by asking the right questions
2. learn more about sql, excel, python, tableu
3. use existing real world datasets that i am interested in to start practicing
4. learn how to interpret and visualize data
5. improve my communication skills (i always stutter when i get nervous and i'm easily nervous)
Thank you
Great video as usual!
(and smooth Fiat Multipla endorsement)
I just started a new job as a data analyst intern 3 weeks ago and I'm glad I pretty much did all of the things mentioned in the video subconsciously. It's been great so far!
How can I connect with you, bro?
Thanks!
thank you kind sir!
Very good content 👏👏
Glas you like it Ruan!
It'd be fantastic to hear your recommendations for books that helped you 'think more analytically'
Great video sir love from India 🇮🇳 ❤
best tutorial with alot free course online
like y suscrito porque me identifiqué con lo que dijiste al final. Yo también llevo casi 5 años de mi vida trabajando en una oficina pequeña frente a un computador analizando datos y capacitándome todos los días en las ultimas tecnologías, vivía super estresado, reuniones van y vienen, datos por todos lados, no tenia tiempo para nada ni nadie. Además, ganaba muy poco, no tenia vacaciones ni beneficios extralegales. Este año me cansé, renuncié y ahora estoy desempleado pero contento, sin estrés, creo que voy a buscar empleo medio tiempo que me dé tiempo para realizar mis proyectos personales.
buscaba un comentario en español :v
You must be one of the most honest youtubers!
you a cool dude man idk why i subscribed but i enjoy ur content and im learning web development
Thanks Abdalla!
@@Stefanovic92 you are just honest with your subscribers and I enjoy it, can't wait for what I will learn from your entrepreneurial journey
This is exactly how I started learning Data Analytics. After analyzing D.A. courses and resorces I decided to focus on SQL, Python/Jupyter, Excel/Pivot Tables/Power Query, Dax, PowerBI, ML and your video just confirmed my choices
I'm on my last year of my Economics degree and just started scratching the world of data analysis for a possible future job to achieve a quick financial and personal freedom to pursuit other things in life. This was of great value Stefan, finally at 100k, I never doubted you, as always just wanted to leave my praise here, keep it going man!
Thanks Afonso, I always see you in the comments, appreciate it bro. And good luck with your journey!
Mate, let me tell you I'm in the same position as you are, finishing my degree in Economics and with 3 years of data analysis and science I can that we have a beautiful background with this career, It's pretty easy to get into the industry. Actually, I think that every economist needs to learn this skills!
love your content, Stefaaaaaaaanovic
Hello guys, I'm an economics graduate, learning data science from last year and now wanting to get in this field. I have always doubted that our background doesn't favour us but today I'm feeling more confident after reading your comments.
Fellow economics grad here, it would have been great for these programs to tell us that data analysis is basically a requirement for any related job in the field. So much theory and not enough working with real numbers in my experience
I started my Economics degree this November. I am very happy to know I have Data analysis route to pursue. I have my minor in CS where python is being taught and separate classes for Excel are held in my college to prepare students for their jobs . I just hope I can struggle through and land a job
Abundace of informaton out there! Well said Stef, I'm on for the journey!
Thanks Konstantinos!
Hey love from India🇮🇳 Thanks for sharing
You got it Bro
Was full-stack developer turned data engineer and analyst. The transition was natural. Knowing the technical side in much more depth and breadth allows me to produce more-refined and efficient dashboard.
Hey, can I ask what made you transition to data analysis from being a developer? I'm trying to figure out what to do?
Very informative video, Stefan.
Thank you
Glad you liked it Sobia!
Excellent video, by the way. I find everyone of your videos quite useful. A hug from Argentina
Gracias amigo!
Thank you so much! I am a fifty+ retired teacher who is changing careers. I have started a data analytics course online. This video was so informative and reassured me that I am doing the right things. Starting a whole new career this late in life is scary. Thank you for your quality information!
how is it going so far?
Data Analysis is a useful skill to have be it as a career, freelancing, or helping one figure out the
unknowns life will throw at you.
thanks for the video , I have 55 years old , and I really , really really want to reinvent my carrear , your advice are very good I agree 100% with everything on this video.
Thanks, bro. Soon I will complete the data analysis course in Google.and I was thinking about projects. Meantime I saw your new video. Thanks again
Good luck Jatila!
@Stefanovictelegramlink Thanks. Actually you are my mentor ❤️