⮕ I try to respond to all DM's on instagram: instagram.com/stefanovic92 & X: www.x.com/stfnvic ⮕ Save 25% off Datacamp here: datacamp.pxf.io/WqWWXA ⮕ Learn how I tripled my income as a Data Analyst so I could escape the 9-5: learn.stfnvic.com/mastermind
Can you do a soft/base skills video possibly? As far as like what math's should you work on or be good at, it's hard for me to request the right content as an absolute beginner, however possibly practice ideas for Excel or project ideas for all required programs?
I started an excel-heavy job in finance a year ago, and have been teaching myself SQL. I dont have a relevant degree. This video is a really good guide so I'd suggest sticking to it, I will be
As a 40 yrs old trying to career shift from being a garage manager, thank you SO much for the detailed information! Everyone wants to fill videos with useless knowledge and boasting instead of actually being helpful with straight up information 🎉
are you working on it, what is your progress with it. I am a cross platform flutter developer. but the market has been stormed with free lancers working for pennies.. want to switch to data analytics.. Plus I am 40 too
“Don’t quit” is definitely one of the biggest pieces of advice for people wanting to break into the field. Took me a year and a half of that horrible trial and error learning, quitting, starting again, and networking to finally land my DA role, and I don’t regret a second of that journey.
@@Stefanovic92 I want to ask a question. In my university I have only big data analysis, but I want to be scientist.Will I get some welcome information to be more closer to my scientist?
@@KyleWilliamsMusic1 I'm self-taught. From my experience, I would start with Microsoft Excel. Almost every company uses this to do their data analysis. Many people claim they know how to use it, but I beg to differ. There is so much to learn with MS Excel. Another important aspect is your analytical and communication skills. If you master these two skills, you will thrive in any workplace and potentially increase your earnings. If your starting out, don't be afraid to make mistakes, we ALL make mistakes. The important thing is to learn from those mistakes. Don't be frustrated at it though, try to chuckle at it and think back as to why something hasn't worked (problem solving). Just work hard and never give up! Life works out in the end if you stay patient and persistent! All the best Internet friend! 🙂
Hey Mike. I just wanna ask you if it is ok be a data analyst? In my country Pakistan, the growth of this field is not so good and i'm worried if i'll get the job or not.
@@Music-xr6ir I'm curious about the same. However you don't have to have the necessary job in Pakistan because it will pay very less. You gotta apply to overseas american, european companies like google, IBM etc.
You nailed it with the don't quit tip brother. Took me more than 6 months of learning and another 6 month of job searching to land my first business analyst gig. Now, the recruiters reach out to me.
Hi, Could you please tell me how many hours a day on average you spent to learn, that it took 6 months? I know that it is not an appropriate question, and it depends on many factors, but just curious to know.
@@mindpower3922If I average it out, I'd say about 4 hours. Once I found a structured, supportive, and rigorous (beginner to advanced) training course, my training was more meaningful. I bought my own license for pbi, used real data sets, and set goals on what I could extract/ visualize. If I'd go back, I'd first get really good with excel. You'd be surprised how many companies value that. But I'm a ba, not a da. I do some etl, but very limited dev stuff. I'm more the stats and numbers guy that work with managers and stakeholders.
I have been stuck on a project and saw your video...thank you for making it, now I feel like I need to keep at it. I'm just leaning data analytics after being a bartender for 15 years. I feel confident enough to work on my resume and start putting myself out there!
@@theoguerrero2975 thank you, I actually took my CompTiaA+ Core 1 exam today because I have 3 job offers! I can't believe how much can change with hard work and positivity. I can't wait for what comes next :)
The difference between a senior and junior data analyst: how well you’re able to formulate your question on stack overflow. Perhaps I should make a video about this.
I don't think I have ever since a channel that tells its audience not to subscribe to the channel. But this shows that you don't do things because of others. Thank you so much for this, you just got a subscriber from an aspiring data analyst
Like many, I stumbled on this video half enthused half tired from researching data analysis along side current tools, jobs, 50 open tabs, cold coffee... Thank you. I really enjoyed how you summarised this and gave an overview on your experience. It helps to be given a few good choices to work with instead of all the choices and no guidance.
I currently spend most of my day in Excel, SQL, and Tableau as an Analyst. They all have their own learning curves, but it's the best feelings when you understand and conquer a new piece of the puzzle. Python is next on the list... Great Video!
Summary: Steps. 1. Learn by Doing (Tools & Languages): a. Excel, b. SQL, c. Power BI, and d. Python, 2. Practice (copy stock codes too) and Ask for help 3. Build Portfolio 4. Pimp up your LinkedIn
You are totally right. When i started serious working (22 years old) as a project leader in de pharm I discovered Excel and Access was my greatest tool to manage and track everything. I became very handy on it and I've been always asked for excel help in my jobs. Today I work as DA using SQL and Power Bi (that i learned on my job) and I see Python in my future. I love the fact that Dashboards are a mix between tech and creativity. Being able to think abstract and connect different kind of data that it doesn't look related is key too. Ik vond je video geweldig!
Thanks man just stumbled on your video and it just solved the problem i was banging my head for months. You don't even know the value you have provided. Thank you
What an amazing video. I started my career as Data Analytics with Excel, today I consider myself advanced in Power Bi. As in the video I highly recommend learning SQL and solving problems. Solving customer problems is the big deal to succeed in Data Analytics.
By far the LEAST boring video on this subject I have found yet. I loved all your "outtakes" that weren't actually taken out. I kept cracking up. Also, this is exactly the video I needed as I am in a transitional phase and scoping out options. Thanks for the great information.
I don’t think your humor is getting enough credit 😂 but that’s because there’s so much value in this video. You went out, took risks, achieved these things, and freed yourself. I can tell you don’t take yourself too seriously and that is serving you well. I’m inspired. Subscribed.
I am actually working with python but when he said "if i could go back into time" Here my heartbeat paused for a moment...&.then continued after he said "i would choose python"😂😂
i'm a data analyst/engineer even though I studied something totally different at university. Because the demand is so large right now anybody can become one
Hello guys, I'm starting today to apply this method to become a data analyst. I'll come back every month to update you guys. Wish me luck. Thank you :)
@@DeepakDhaked-oc2sk Thank for asking, after a couple of days I felt a little lost. I was learning something here and there…So I decided to learn with CodeCademy, it’s been a game changer honestly, you know what you’re doing and there’s a lot of exercises. I do use sometimes the websites mentioned to practice SQL and Python, they’re indeed good, but if you don’t have a plan you can easily give up. You can always try to see if it works for you.
Really a good video, As conveyed in the video. I have got the interdepartment transferred. And now I have every opportunity to work as a business analyst. The third suggestion is that do not quit is the golden one .
The job search has been long, painful, and dehuminizing since being laid off. Working on my excel, R, SQL skills while looking to pickup Python and it still feels like not enough while having a bachelors. Thanks for discussing this topic
There aren't nearly enough jobs in the market to keep all the people in it gainfully employed; plus all those millions graduating each year. Economy is finished.
I cannot tell you how much I appreciate this video. Nowhere else I've seen someone "telling it like it is" in such a concise way. THANK YOU! Subscribed to Luke's Channel following your recommendation as I also see data analysis as a stepping stone.
Amazing content Stefan. I’m currently a student at a university in Florida, majoring in business analytics and information systems (which yeah basically trained you to become a data analyst). I’m a senior now but i feel like i learned shit in the last 3 years (despite getting all A and paying tons of money). I learned from your videos way more than in the college classroom.
Graduated last year 3.8 gpa in IS and have nothing in my brain. Haven't had the guts to apply to any jobs because I know I don't have the knowledge or skills. Now I'm on YT learning what I should've in college.
I've been planning to switch my career to become a data analyst, but I didn't really know where to start, and then this video appeared on my recommendation, it's such a blessing! Thank you so much for the information and knowledge you share!
Thanks Stefanovic for such motivation. I am on career reviving stage after 12 years gap. Struggling so hard for last 2 years but couldn’t make it up. I am a mom of three kids but keenly passionate about my career. Hope i will be succeeded in establishing my freelancing career as a DA. Thanks once again.
I am in a similar situation after helping care for my parents, albeit I regret not spending more time with them as they are both deceased 5 years and 9 years ago respectively.
You have made a very generous gesture with this video for those who want to better understand what this profession is about. That's why I want to thank you. Greetings!
Considering I am extremely broke, this was MASSIVELY helpful bc you recommended FREE ways to learn various things, and I desperately need that. I also need to know what skills will be most useful to hiring managers and recruiters AND how to effectively prove it in my CV, so that was also very appreciated. The very structured approach to this video was extremely helpful, thank you very much!
I use to look at jobs and think I can only use excel, I'll never be able to use SQL. Had a quick look and I've got this. Yes the first bits are basic and I know it will get harder but I will start using this in my job and learn power bi which I'm not a fan of right now. Then python but this I think will be the tricky one for me. I use to think it's going to be to hard, need to be a super programmer or mega smart. Don't put your self down people! You got this, if you can use excel moderately well, SQL will come to you. I'm not amazing at excel like some but I'm sufficient.
I was already thinking of becoming a Data Analyst before discovering your channel! I'm going to my last year as an Economics student at university and will be studying data analyses as you recommended meanwhile! And yes, it will be a stepping stone, to what? I don't know yet. Once again great content, keep it up!
Thank you so much for this. A friend sent me link to a site to pick from a bunch of free video courses few weeks ago, guess what? I ended up picking Microsoft excel and even though it has been a struggle really, I consider this a good sign to carry on. Thanks again.
This hit home for me. I quit my day job to pursue a data analyst job at the beginning of the year. 1100 hours later, I am now applying for jobs and not having much luck. I guess I just need to continue at the grindstone. I learned Advanced Excel, SQL, Python, and even have the Tableau data analyst certification along with a Portfolio. This has been and will continue to be a journey.
I wish you luck, but... I already see a pattern that Data Analyst is just a buzz word, so many "job" applications end up as offers for paid "experience", courses, etc. I was following the EXACT path that was shown in the video and any entry DA job is just a smoke in the mirror for me, at least in the UK. And GOOD LUCK trying to compete in international freelancer market against thousands and thousands of competitors.
Learn PowerBi. I have used both and there is a reason it’s prefixed with Power. The data modeling capability is far superior and it’s a Microsoft product that integrates seamlessly with every other Microsoft product that companies use. Tableau is good for pretty and easy graphs, not serious data analysis.
Why did I just find this? This video is the BEST so far! Not kidding I was so confused about where to start. Awesome job explaining everything so well to a beginner like me.
Hey man. I just watched your video. Its been so helpful. Plus the way you create humor as well to is very nice. God bless you. I'm going to start from the excel practice!
Your videos show so much depth, not just in this subject. But, for life in general. What a gem to stumble upon your channel on TH-cam. Fantastic work. 💪😎
I was impressed by your video; it's the best one I've watched this month. I've seen over 10 videos since the beginning of the month to find the perfect roadmap for becoming a data analyst, and yours stands out. Thank you for sharing your insights😊
Amazing explanation of the required steps needed to achieve a Data Analyst position, but also a great transition when you mentioned that you're on a new, different path now!
The video inspired me a lot. I am a beginner in the field now and I will work on myself during this year. I want to see this comment after I get the job as a data analyst.
Awesome video! I stumbled onto bioinformatics as a field because I needed to learn how to analyze RNA-sequencing data during graduate school. I fell in love with the discipline and I'm going to look for a data science job after I graduate!
My beginning with Excel and Power BI was through some Create and Learn book series, and LinkedIn learning. material very fast to consume. Now I am doing some more advanced books like Guide to Dax and courses on linkedIn as well.
Thank goodness you're the first video i clicked when i searched for a data analysis video. Very straight forward on what to learn first. Very helpful for a learner like me .
I needed this video. I've been on the journey since the start of 2022 on becoming a Data Analyst. I would say that I'm extremely well in Excel, and I would rate myself as an intermediate in SQL (I actually enjoy using SQL). I'm actually a bit nervous about using python since I've attempted to learn using it in the past and it was just a tough language to learn. I know that a lot of jobs don't require it, but I also know that it is a preferred skill to use, and that it'll help with the job search faster. Once I'm really comfortable with SQL, Python will be my next move. Hopefully I'm able to land a job soon! I already have a couple portfolio projects done thanks to Alex and Coursera. Just needed something to kick me back into gear.
Very uplifting. I've got over thinking that I need to study a lot and was feeling rather apprehensive, but now I've cleared out that I know a lot and just need to go with more practical task!
For a long time, i thought that people who use excel are boring. And i knew i was wrong about that. But now after seeing you explaining in a fun way, i'm sure now that these jobs aren't for boring people. Thanks a lot❤
I started my career as a customer service manager, pivoting into the D.A world to increase my personal value, Thanks for your deep insight,it came in handy
*Is he an angel? He distributed the treasure of knowledge for an IT job aspirant in just 11 min for which 99% people are confused enough to leave their aspirations because they can't figure out what to do and let alone from where to do.*
Just stumbled on this channel. I'm totally new to data analysis, but im currently considering a career in it...although I studied something completely unrelated. I was really confused on what steps to take first. Thanks for this eye opening video
As an experienced BA, agree with you with a stack for the beginners but with slightly higher weight towards Tableau vs BI tools because of its popularity amongst businesses, at least in UK. Obviously it doesn't matter so much at the end because if one can get a handle on any of these tools (visualisation tools), learning and switching to the other is not so problematic as picking up new programming language. On a side note, loved how you pronounced languages "Java" & "JavaScript" at 04:07 with that eastern "J" 😅.
The way you explain everything is just beautiful! I have also worked for Heineken for 5 years as a Business Data Analyst.. wonderful company really. Quit my job like last year :)
Justo estoy aprendiendo diversas herramientas y con este vídeo veo que voy por buen camino, actualmente me encuentro perfeccionando SQL para luego avanzar con PowerBi y Tableau, muchas gracias por la información
Brate svaka ti čast. Don't quit. Najbolji savet.. ja se mučim učim HTML,CSS,JS toliko mi je teško,uzmem uspava me.. koliko mu je dosadno,i onda od jednom, postalo zanimljivo,kad sam samo malo savladao,poceo da pravim nesto sitno.. sto vise učim,sve vise volim da kreiram bilo sta.. osećam se kao umetnik koji stvara neku sliku sad.. smešno,ali tako je :) i dalje jmam sam svoju unutrašnju borbu,nekad pomislim:jq sam glup za ovo,kad ne kada da zapamtim nesto,mučim se danima,sednem opet ništa,pa sve iz početka.. nadam se da će biti rezultata Evo vec 4 meseca vredno po par sati na dan.. nadam se da ću uspeti..
really appreciate the honesty; lots of videos here romanticize the role and the journey without actually saying anything, and this helped focus my vision a lot
I am currently pursuing masters in Computer Science and engineering and now found this amazing video so from today onwards my data analyst journey starts and now i will comment on the same as soon as i land into my first job. Thanks for making such an informative video
if you are already studying computer science and are interested in data you will probably be qualified to start as a data engineer or data scientist rather than an analyst when you graduate
thank god for this video. i was just about to sign up for data analyst masters right before the deadline today, and realised i dont want that life at all! no joke that saved me. thanks for that
I understand your personal goal and it's awesome. Even if you made few videos about data analysis they're really thorough. I follow your channel for your wisdom in every aspect (life, work and ect.). I can't wait for your next video. Cheers.
This was so wholesome and so funny.😄 I was getting frustrated at my progress(almost quit)as I am learn python for data science. This helps a lot. I'll continue with python then to sql and power bi.
Excellent video, it actually represents how I got into the roll. Educated in something completely different and somehow found my way into data. I’m currently just over a year into been a junior business intelligence analyst, learning SQL and power bi as our main reporting software. Before we got bought out by a different company I created various KPI’s and datasets in excel so once we transitioned I was quickly offered a position in the BI team. Unless I missed this I think something what gives a advantage if it’s a internal position you are going after is to have good business understanding. I feel like it has helped me when querying data and has given me confidence when peers and other sectors have queried certain reports etc. I suppose this comes over time when analysing but I believe it was a massive factor for me to get further involved In the data analysis world. Keep up the great videos!
Hello sir. I am a computer science graduate. I wanted to become data analyst. Could you please guide me to have some experience. Like could you guide me to choose real time projects on data analyst.
Great video! And it appears I'm on the right track in terms of stuff to learn. I really like Enterprise DNA for learning Power BI - And if I remember correctly, their "stack" of software is almost the same as yours, except that they have a 5th system: PowerPoint - For effective communication of the analysis that you've done. And given how well PowerPoint and Power BI are now starting to integrate, I'm inclined to agree. But anyway, love what you've said and you have a new subscriber :)
I always tell people start with excel, sql, python, and statistics (using the free SAS training videos), and then power bi/Tableau. Then if you want to go further learn predictive analysis/forecasting. Definitely build your portfolio, and you only need one solid project tbh. I did all that an now work for a very flexible aerospace company.
One of the most coolest videos I have seen, enjoyed bits of fun, humor and seriousness it has, overall super informative. Passed it on to all of my friend that can benefit from it. Thanks you!
I just started my career as a QA analyst and currently trying to figure out how to become a Data Analyst for my career growth. You just showed me the path vividly. Thank you for your help. 😊
I just subscribed. I decided I want to be a Data Analyst a few months ago, but with zero experience whatsoever, and I believed it would be a fun and easy journey. I subscribed to Udemy class on Data Analyst and Data Science (I guess I had no idea of what I was doing), and they started off with Python programing language. Goodness me, I am about to lose interest in the whole thing. I am kinda discouraged, but after stumbling into this video, I would follow your recommendation. Thanks, and hope I would find it better this time
It's always confusing and frustrating when one has no cliue or directions to follow in the learning process. his video has given me a spirit of no retrent or surrender until success is achieve.
I came here not pursuing a Data Analyst job or anything like that, I just wanted to be informed of this for another job, but what a wonderful video! Thank you so much for putting this together. I actually got more information that I needed. Cheers.
Hi Stefan, thanks for making this video. I was quite curious about data analysis, but I had no idea where to start. You have now solved my biggest problem with great ease. Thankyou, once again! ❤
⮕ I try to respond to all DM's on instagram: instagram.com/stefanovic92 & X: www.x.com/stfnvic
⮕ Save 25% off Datacamp here:
datacamp.pxf.io/WqWWXA
⮕ Learn how I tripled my income as a Data Analyst so I could escape the 9-5:
learn.stfnvic.com/mastermind
Hvala brate moj! Samo napred, puna podrska! Zavidim ti na nekim uspesim!
I have messaged you there as well
You’re the sexiest data analyst I’ve ever seen… now I want to become a data analyst
@Goofy Music lbbbv
Can you do a soft/base skills video possibly? As far as like what math's should you work on or be good at, it's hard for me to request the right content as an absolute beginner, however possibly practice ideas for Excel or project ideas for all required programs?
Started my first data analyst job today 💪
Congrats mate!👊
How long does you take you to learn and master? Do you have previous experience before?
Thanks in advance
I started an excel-heavy job in finance a year ago, and have been teaching myself SQL. I dont have a relevant degree. This video is a really good guide so I'd suggest sticking to it, I will be
I still haven't mastered anything except excel, also learning and using R at the moment
@@cofi9659 what was your degree in?
As a 40 yrs old trying to career shift from being a garage manager, thank you SO much for the detailed information! Everyone wants to fill videos with useless knowledge and boasting instead of actually being helpful with straight up information 🎉
are you working on it, what is your progress with it. I am a cross platform flutter developer. but the market has been stormed with free lancers working for pennies..
want to switch to data analytics.. Plus I am 40 too
“Don’t quit” is definitely one of the biggest pieces of advice for people wanting to break into the field. Took me a year and a half of that horrible trial and error learning, quitting, starting again, and networking to finally land my DA role, and I don’t regret a second of that journey.
That's awesome man, congrats!
@@Stefanovic92 I want to ask a question. In my university I have only big data analysis, but I want to be scientist.Will I get some welcome information to be more closer to my scientist?
Congratulations! I agree, someone also told me the exact same thing and I don't regret it either.
Did you have a degree or are you completely self taught?
@@KyleWilliamsMusic1 I'm self-taught. From my experience, I would start with Microsoft Excel. Almost every company uses this to do their data analysis. Many people claim they know how to use it, but I beg to differ. There is so much to learn with MS Excel.
Another important aspect is your analytical and communication skills. If you master these two skills, you will thrive in any workplace and potentially increase your earnings.
If your starting out, don't be afraid to make mistakes, we ALL make mistakes. The important thing is to learn from those mistakes. Don't be frustrated at it though, try to chuckle at it and think back as to why something hasn't worked (problem solving).
Just work hard and never give up! Life works out in the end if you stay patient and persistent!
All the best Internet friend!
🙂
Been a data analyst for 12 years. He is right on with what skills to gain if this is the field you want to get into.
Hey Mike.
I just wanna ask you if it is ok be a data analyst? In my country Pakistan, the growth of this field is not so good and i'm worried if i'll get the job or not.
Hook a brother up
@@Music-xr6ir I'm curious about the same. However you don't have to have the necessary job in Pakistan because it will pay very less. You gotta apply to overseas american, european companies like google, IBM etc.
You nailed it with the don't quit tip brother. Took me more than 6 months of learning and another 6 month of job searching to land my first business analyst gig. Now, the recruiters reach out to me.
That’s awesome man!
Hi, Could you please tell me how many hours a day on average you spent to learn, that it took 6 months? I know that it is not an appropriate question, and it depends on many factors, but just curious to know.
@@mindpower3922If I average it out, I'd say about 4 hours. Once I found a structured, supportive, and rigorous (beginner to advanced) training course, my training was more meaningful. I bought my own license for pbi, used real data sets, and set goals on what I could extract/ visualize. If I'd go back, I'd first get really good with excel. You'd be surprised how many companies value that. But I'm a ba, not a da. I do some etl, but very limited dev stuff. I'm more the stats and numbers guy that work with managers and stakeholders.
@@joshk7051 Many thanks for the answer. Would you mind telling me the name of the training course you had?
Do they ask for python also in data analysis job is it necessary to learn python?
I have been stuck on a project and saw your video...thank you for making it, now I feel like I need to keep at it. I'm just leaning data analytics after being a bartender for 15 years. I feel confident enough to work on my resume and start putting myself out there!
Very inspiring. Yes, just keep at it.
You can do it! 🎉
Hi Diana. How long have you been learning Data Analytics
Go on. You can do it o/ trust in yourself
@@theoguerrero2975 thank you, I actually took my CompTiaA+ Core 1 exam today because I have 3 job offers! I can't believe how much can change with hard work and positivity. I can't wait for what comes next :)
The difference between a senior and junior data analyst: how well you’re able to formulate your question on stack overflow. Perhaps I should make a video about this.
Hahahaahha so true
ULTRA Senior Data Analyst: Drink beer
U had me till "on stack overflow". :)
😂😂😂😂😂😂🤣🤣🤣🤣🤣
6:13 Recommended learning resources
I don't think I have ever since a channel that tells its audience not to subscribe to the channel. But this shows that you don't do things because of others. Thank you so much for this, you just got a subscriber from an aspiring data analyst
Wax Data Anlaysi La Xiriirara Rabaa INaan Ku Weydeeyo Pio
Hadey MacquuL THy 🙏
Madaama QoF iiGa Horeyeey Aad THy
My dude, humbled by the shoutout! 🙏🏼
I disagree though... 10:29 your videos are the ones that are on a whole other level! 🙌🏼
Haha thanks bro ..but you're the real MVP when it comes to data analysis!
bruh, this is probably the best video I have ever seen when it comes to actually finding a career... omg
Like many, I stumbled on this video half enthused half tired from researching data analysis along side current tools, jobs, 50 open tabs, cold coffee... Thank you. I really enjoyed how you summarised this and gave an overview on your experience. It helps to be given a few good choices to work with instead of all the choices and no guidance.
I currently spend most of my day in Excel, SQL, and Tableau as an Analyst. They all have their own learning curves, but it's the best feelings when you understand and conquer a new piece of the puzzle. Python is next on the list... Great Video!
@AstronautElvis hi. was experience with Excel, SQL and Tableau enough to get a job as an Analyst?
Can u plzz plzzz teach me plzz🙏🏻🙏🏻🙏🏻i really wanna learn
So how are things going? Have you landed a job already?
Summary:
Steps.
1. Learn by Doing (Tools & Languages):
a. Excel,
b. SQL,
c. Power BI, and
d. Python,
2. Practice (copy stock codes too) and Ask for help
3. Build Portfolio
4. Pimp up your LinkedIn
Succinct.
Great
😘
Great comment
How deep should one go before moving on to another tool or language?
You are totally right. When i started serious working (22 years old) as a project leader in de pharm I discovered Excel and Access was my greatest tool to manage and track everything. I became very handy on it and I've been always asked for excel help in my jobs. Today I work as DA using SQL and Power Bi (that i learned on my job) and I see Python in my future. I love the fact that Dashboards are a mix between tech and creativity. Being able to think abstract and connect different kind of data that it doesn't look related is key too. Ik vond je video geweldig!
Thanks man just stumbled on your video and it just solved the problem i was banging my head for months.
You don't even know the value you have provided.
Thank you
What an amazing video. I started my career as Data Analytics with Excel, today I consider myself advanced in Power Bi. As in the video I highly recommend learning SQL and solving problems. Solving customer problems is the big deal to succeed in Data Analytics.
Not looking to be data analyst but still watched and liked the video. Quality content.
What a great video. Started with Excel and brought the idea of PowerBi to my first company. Python is the next step
Dude....this guy's humility and humor 💯💯💯!!
By far the LEAST boring video on this subject I have found yet. I loved all your "outtakes" that weren't actually taken out. I kept cracking up. Also, this is exactly the video I needed as I am in a transitional phase and scoping out options. Thanks for the great information.
The best Video EVER found about DATA ANALYSIS. ! Undoubtedly. Loads of Love for ya
Glad you liked it!
Starting my journey as Data Analist. I will do my best. Thank you for the video! it helped me a lot!
One day, I'll land a data analyst role. Needed this video for direction. Thanks so much.
I don’t think your humor is getting enough credit 😂 but that’s because there’s so much value in this video. You went out, took risks, achieved these things, and freed yourself. I can tell you don’t take yourself too seriously and that is serving you well. I’m inspired. Subscribed.
I am actually working with python but when he said "if i could go back into time" Here my heartbeat paused for a moment...&.then continued after he said "i would choose python"😂😂
I continued to watch the video till the end for one reason: The quality of the editing and the genuineness of the humour is above the roof.
i'm a data analyst/engineer even though I studied something totally different at university. Because the demand is so large right now anybody can become one
LET ME GUESS, INDUSTRIAL ENGINEERING?
Can u plzz plzz plzz help me 🙏🏻
I really wanna learn data analysis
Whats the situation today ....
coz its been 9months...
Could you please teach me
Don't quit! I've already took some certifications and i won't quit. Thanks!
Hello guys, I'm starting today to apply this method to become a data analyst. I'll come back every month to update you guys. Wish me luck. Thank you :)
how's it going ?
@@DeepakDhaked-oc2sk Thank for asking, after a couple of days I felt a little lost. I was learning something here and there…So I decided to learn with CodeCademy, it’s been a game changer honestly, you know what you’re doing and there’s a lot of exercises.
I do use sometimes the websites mentioned to practice SQL and Python, they’re indeed good, but if you don’t have a plan you can easily give up. You can always try to see if it works for you.
How did it go?
Update us , how is it going.
Hello, waiting to hear you.
Really a good video, As conveyed in the video. I have got the interdepartment transferred. And now I have every opportunity to work as a business analyst.
The third suggestion is that do not quit is the golden one .
The job search has been long, painful, and dehuminizing since being laid off. Working on my excel, R, SQL skills while looking to pickup Python and it still feels like not enough while having a bachelors. Thanks for discussing this topic
There aren't nearly enough jobs in the market to keep all the people in it gainfully employed; plus all those millions graduating each year. Economy is finished.
Covjece kako dobar video. Umira sam od smijeha na nekoliko trenutaka. Storytelling, shooting, editing. Stari moj, pa ovo je vrh!
I cannot tell you how much I appreciate this video. Nowhere else I've seen someone "telling it like it is" in such a concise way. THANK YOU!
Subscribed to Luke's Channel following your recommendation as I also see data analysis as a stepping stone.
Glad it was helpful!
Stepping stone for what?
@@realmheart3751 you’d know if you watch the video.
Amazing content Stefan. I’m currently a student at a university in Florida, majoring in business analytics and information systems (which yeah basically trained you to become a data analyst). I’m a senior now but i feel like i learned shit in the last 3 years (despite getting all A and paying tons of money). I learned from your videos way more than in the college classroom.
Lol literally same but I guess a master's degree would look good on the cv
Can you suggest me a cheap laptop for data analytics and software development
Graduated last year 3.8 gpa in IS and have nothing in my brain. Haven't had the guts to apply to any jobs because I know I don't have the knowledge or skills. Now I'm on YT learning what I should've in college.
@@petrona3049 i'm a second yr IS student too and i don't even learn a thing 😂
I am a health analyst graduate student, and know pretty much nothing. I guess I'm paying for the piece of paper.
I've been planning to switch my career to become a data analyst, but I didn't really know where to start, and then this video appeared on my recommendation, it's such a blessing! Thank you so much for the information and knowledge you share!
Thanks Stefanovic for such motivation. I am on career reviving stage after 12 years gap. Struggling so hard for last 2 years but couldn’t make it up. I am a mom of three kids but keenly passionate about my career. Hope i will be succeeded in establishing my freelancing career as a DA. Thanks once again.
Best of luck !!
Amazing !
... wishing you all the best! mom here too (of two, tho) checking out new career possibilities.
I am starting over again, too, after a long journey of caregiving for our parents. Good luck!!!
I am in a similar situation after helping care for my parents, albeit I regret not spending more time with them as they are both deceased 5 years and 9 years ago respectively.
Brilliant advice to become a data analyst. No-one give me such a clear vision on how to learn new tools. Thanks.
You have reduced lot of efforts and time of mine to find the right path and resources... Tons of Thanks 🙏
Excellent video, I've seen tons of this "starting" videos and you actually gave practical and specific tips to start. Thank you!
You have made a very generous gesture with this video for those who want to better understand what this profession is about. That's why I want to thank you. Greetings!
Considering I am extremely broke, this was MASSIVELY helpful bc you recommended FREE ways to learn various things, and I desperately need that. I also need to know what skills will be most useful to hiring managers and recruiters AND how to effectively prove it in my CV, so that was also very appreciated. The very structured approach to this video was extremely helpful, thank you very much!
How did it go?
Hi , i hope it went well . Mind sharing?
How's it going
Just learn to bake pizzas and start selling them
hey did you have any prior experience? any degree before you started!? please let me know and good look on your journey!
I'm an absolute first timer and this is soooo cohesive and comprehension. Really awesome explanation - love it! Thanks
I use to look at jobs and think I can only use excel, I'll never be able to use SQL. Had a quick look and I've got this. Yes the first bits are basic and I know it will get harder but I will start using this in my job and learn power bi which I'm not a fan of right now. Then python but this I think will be the tricky one for me. I use to think it's going to be to hard, need to be a super programmer or mega smart. Don't put your self down people! You got this, if you can use excel moderately well, SQL will come to you. I'm not amazing at excel like some but I'm sufficient.
You Opened my eyes, Man!!!!!!!!! Thanks for your Advice, Especially that Don't Quit Line.
I was already thinking of becoming a Data Analyst before discovering your channel! I'm going to my last year as an Economics student at university and will be studying data analyses as you recommended meanwhile! And yes, it will be a stepping stone, to what? I don't know yet. Once again great content, keep it up!
Haha same, I just finished my Bsc in Economics and Statistics.. Starting Msc in Econ.. But planning to opt for this
Stepping stone to a Data Scientist ?
Thank you so much for this. A friend sent me link to a site to pick from a bunch of free video courses few weeks ago, guess what? I ended up picking Microsoft excel and even though it has been a struggle really, I consider this a good sign to carry on. Thanks again.
This hit home for me. I quit my day job to pursue a data analyst job at the beginning of the year. 1100 hours later, I am now applying for jobs and not having much luck. I guess I just need to continue at the grindstone. I learned Advanced Excel, SQL, Python, and even have the Tableau data analyst certification along with a Portfolio. This has been and will continue to be a journey.
Just keep at it man💪
I wish you luck, but... I already see a pattern that Data Analyst is just a buzz word, so many "job" applications end up as offers for paid "experience", courses, etc. I was following the EXACT path that was shown in the video and any entry DA job is just a smoke in the mirror for me, at least in the UK. And GOOD LUCK trying to compete in international freelancer market against thousands and thousands of competitors.
Learn PowerBi. I have used both and there is a reason it’s prefixed with Power. The data modeling capability is far superior and it’s a Microsoft product that integrates seamlessly with every other Microsoft product that companies use. Tableau is good for pretty and easy graphs, not serious data analysis.
Why did I just find this? This video is the BEST so far! Not kidding I was so confused about where to start. Awesome job explaining everything so well to a beginner like me.
Hey man. I just watched your video. Its been so helpful. Plus the way you create humor as well to is very nice. God bless you. I'm going to start from the excel practice!
I just enrolled in a masters programme in a UK university and been thinking same. I actually want to use data analytics as a stepping stone as well
The best video I have ever watched on my journey to becoming a data analyst
Cinematography, editing, and storytelling/content on point man. Not bad🙌🏻
Love how serious and realistic, but also positive this video is
Your videos show so much depth, not just in this subject. But, for life in general. What a gem to stumble upon your channel on TH-cam. Fantastic work. 💪😎
Thanks for the kind words bro👊
I was impressed by your video; it's the best one I've watched this month. I've seen over 10 videos since the beginning of the month to find the perfect roadmap for becoming a data analyst, and yours stands out. Thank you for sharing your insights😊
Amazing explanation of the required steps needed to achieve a Data Analyst position, but also a great transition when you mentioned that you're on a new, different path now!
How well have you progressed?
The video inspired me a lot. I am a beginner in the field now and I will work on myself during this year. I want to see this comment after I get the job as a data analyst.
Much respect Stefanovic, this is a brilliant vid. You literally hit all the points from start to entry to exit...WOW! Much appreciated.
Thanks!
Awesome video! I stumbled onto bioinformatics as a field because I needed to learn how to analyze RNA-sequencing data during graduate school. I fell in love with the discipline and I'm going to look for a data science job after I graduate!
This is the exact path I’m following I’m currently taking excel then next semester I’m taking sql. Nice video.
You got this Christian!
My beginning with Excel and Power BI was through some Create and Learn book series, and LinkedIn learning. material very fast to consume. Now I am doing some more advanced books like Guide to Dax and courses on linkedIn as well.
Thank goodness you're the first video i clicked when i searched for a data analysis video. Very straight forward on what to learn first. Very helpful for a learner like me .
I needed this video. I've been on the journey since the start of 2022 on becoming a Data Analyst. I would say that I'm extremely well in Excel, and I would rate myself as an intermediate in SQL (I actually enjoy using SQL). I'm actually a bit nervous about using python since I've attempted to learn using it in the past and it was just a tough language to learn. I know that a lot of jobs don't require it, but I also know that it is a preferred skill to use, and that it'll help with the job search faster. Once I'm really comfortable with SQL, Python will be my next move. Hopefully I'm able to land a job soon! I already have a couple portfolio projects done thanks to Alex and Coursera. Just needed something to kick me back into gear.
Good to hear this from you, I would like to seek more guidance on data analysis from you if you don't mind .
Hey,hows it going with your studies?did you get job as da?
you are most genuine youtube i have ever seen , love from india
Very uplifting. I've got over thinking that I need to study a lot and was feeling rather apprehensive, but now I've cleared out that I know a lot and just need to go with more practical task!
For a long time, i thought that people who use excel are boring. And i knew i was wrong about that.
But now after seeing you explaining in a fun way, i'm sure now that these jobs aren't for boring people.
Thanks a lot❤
This is an amazing video with all the details required to a newbie in the Data Analyst Field. Thanks for this. I learned a lot from your error.
I started my career as a customer service manager, pivoting into the D.A world to increase my personal value, Thanks for your deep insight,it came in handy
*Is he an angel? He distributed the treasure of knowledge for an IT job aspirant in just 11 min for which 99% people are confused enough to leave their aspirations because they can't figure out what to do and let alone from where to do.*
You read my mind and you sent your message before mine. I was just watching everything step by step and it all clicked.
Can we just take a sec to appreciate the amazing video editing! Great content!
Just stumbled on this channel. I'm totally new to data analysis, but im currently considering a career in it...although I studied something completely unrelated. I was really confused on what steps to take first. Thanks for this eye opening video
Wow this might be the best video i saw related to data analytics. This guy is too honest😂
As an experienced BA, agree with you with a stack for the beginners but with slightly higher weight towards Tableau vs BI tools because of its popularity amongst businesses, at least in UK. Obviously it doesn't matter so much at the end because if one can get a handle on any of these tools (visualisation tools), learning and switching to the other is not so problematic as picking up new programming language. On a side note, loved how you pronounced languages "Java" & "JavaScript" at 04:07 with that eastern "J" 😅.
Haha I'm not the only one who noticed his special pronunciation.. I wondered why and you explained it. Thanks lol
@@jathebest2835hes dutch. J is pronounced like that in dutch.
The way you explain everything is just beautiful! I have also worked for Heineken for 5 years as a Business Data Analyst.. wonderful company really. Quit my job like last year :)
Justo estoy aprendiendo diversas herramientas y con este vídeo veo que voy por buen camino, actualmente me encuentro perfeccionando SQL para luego avanzar con PowerBi y Tableau, muchas gracias por la información
Brate svaka ti čast. Don't quit. Najbolji savet.. ja se mučim učim HTML,CSS,JS toliko mi je teško,uzmem uspava me.. koliko mu je dosadno,i onda od jednom, postalo zanimljivo,kad sam samo malo savladao,poceo da pravim nesto sitno.. sto vise učim,sve vise volim da kreiram bilo sta.. osećam se kao umetnik koji stvara neku sliku sad.. smešno,ali tako je :) i dalje jmam sam svoju unutrašnju borbu,nekad pomislim:jq sam glup za ovo,kad ne kada da zapamtim nesto,mučim se danima,sednem opet ništa,pa sve iz početka.. nadam se da će biti rezultata
Evo vec 4 meseca vredno po par sati na dan.. nadam se da ću uspeti..
really appreciate the honesty; lots of videos here romanticize the role and the journey without actually saying anything, and this helped focus my vision a lot
This is the most straight forward video about this context
I am currently pursuing masters in Computer Science and engineering and now found this amazing video so from today onwards my data analyst journey starts and now i will comment on the same as soon as i land into my first job. Thanks for making such an informative video
Good luck mate!
if you are already studying computer science and are interested in data you will probably be qualified to start as a data engineer or data scientist rather than an analyst when you graduate
Good, can we start the journey together as a way of encouraging and motivating each other on the journey.
thank god for this video. i was just about to sign up for data analyst masters right before the deadline today, and realised i dont want that life at all! no joke that saved me. thanks for that
I understand your personal goal and it's awesome. Even if you made few videos about data analysis they're really thorough.
I follow your channel for your wisdom in every aspect (life, work and ect.).
I can't wait for your next video.
Cheers.
Your videos are a big inspiration! just started out my own youtube (from my experience as a data analyst) All the best!
Im watching this video, because I know few guys that literally play games for half the work day and make more than me.
This comment is so accurate... even for data scientists bro.
Haha same here with my frontendfriends
I am watching you from Uzbekistan and you took the video perfectly thank you. I got good news for myself. Thanks.
This was so wholesome and so funny.😄 I was getting frustrated at my progress(almost quit)as I am learn python for data science. This helps a lot. I'll continue with python then to sql and power bi.
going through the same thing and I'm blessed to have seen this video on TH-cam tonight
bro you have earned a subscriber weather you like it or not i love it seriously keep it up.
Excellent video, it actually represents how I got into the roll. Educated in something completely different and somehow found my way into data. I’m currently just over a year into been a junior business intelligence analyst, learning SQL and power bi as our main reporting software. Before we got bought out by a different company I created various KPI’s and datasets in excel so once we transitioned I was quickly offered a position in the BI team. Unless I missed this I think something what gives a advantage if it’s a internal position you are going after is to have good business understanding. I feel like it has helped me when querying data and has given me confidence when peers and other sectors have queried certain reports etc. I suppose this comes over time when analysing but I believe it was a massive factor for me to get further involved In the data analysis world. Keep up the great videos!
Hello sir. I am a computer science graduate. I wanted to become data analyst. Could you please guide me to have some experience. Like could you guide me to choose real time projects on data analyst.
@@KNOWLEDEANDCHILL find something you are interested in and the rest will follow. Clearly qualified so no doubt you will succeed
@@Marshy45123 Thank you sir.
Odlican klip razmisljam da krenem da ucim excel , i jos je moja predpostavka sa pocetka da si sa balkana bila tacna lepo se primeti po pricanju ;)
Great video! And it appears I'm on the right track in terms of stuff to learn.
I really like Enterprise DNA for learning Power BI - And if I remember correctly, their "stack" of software is almost the same as yours, except that they have a 5th system: PowerPoint - For effective communication of the analysis that you've done. And given how well PowerPoint and Power BI are now starting to integrate, I'm inclined to agree.
But anyway, love what you've said and you have a new subscriber :)
Odličan video bratski 🥂
I always tell people start with excel, sql, python, and statistics (using the free SAS training videos), and then power bi/Tableau. Then if you want to go further learn predictive analysis/forecasting. Definitely build your portfolio, and you only need one solid project tbh. I did all that an now work for a very flexible aerospace company.
How much time does it take to finish all of that?? If I'm slow learner?
@@gunnersinvincible1390 It really depends. 5 hours a day for 4-6months straight is a good indicator
Sir, can you suggest some good resources for learning Power BI ? Also, where does one find a "solid" project from ?
One of the most coolest videos I have seen, enjoyed bits of fun, humor and seriousness it has, overall super informative.
Passed it on to all of my friend that can benefit from it.
Thanks you!
I just started my career as a QA analyst and currently trying to figure out how to become a Data Analyst for my career growth.
You just showed me the path vividly.
Thank you for your help. 😊
I am not sure why TH-cam threw this video for me to watch while searching for recipes BUT I really enjoyed it and wanna learn more!!
You are an incredible content creator. Thanks for this helpful and still entertaining video!
dont quit.
thanks,
very helpful
I just subscribed. I decided I want to be a Data Analyst a few months ago, but with zero experience whatsoever, and I believed it would be a fun and easy journey. I subscribed to Udemy class on Data Analyst and Data Science (I guess I had no idea of what I was doing), and they started off with Python programing language. Goodness me, I am about to lose interest in the whole thing. I am kinda discouraged, but after stumbling into this video, I would follow your recommendation. Thanks, and hope I would find it better this time
It's always confusing and frustrating when one has no cliue or directions to follow in the learning process.
his video has given me a spirit of no retrent or surrender until success is achieve.
I came here not pursuing a Data Analyst job or anything like that, I just wanted to be informed of this for another job, but what a wonderful video! Thank you so much for putting this together. I actually got more information that I needed.
Cheers.
Hi Stefan, thanks for making this video. I was quite curious about data analysis, but I had no idea where to start. You have now solved my biggest problem with great ease. Thankyou, once again! ❤