A Day in the Life of a Data Analyst (2023)
ฝัง
- เผยแพร่เมื่อ 20 พ.ค. 2024
- 📲 Curious about a career in Data Analytics? Book a call with a program advisor: bit.ly/47LEBk3
Ever wondered what data analysts do day-to-day? In this video, our expert in all things data Tom gives you a rundown of an average working day, talking us through the tasks and responsibilities and giving you a proper insight into a day in the life of a data analyst!
Interested to start your own journey into data analytics? Get started today with CareerFoundry's free data analytics short course, sign up at the following link: bit.ly/DataAnalyticsShortCourse
Do you have any questions for Tom about working in the industry? Are you keen to hear more about any of the specific tasks? Let us know in the comments!
Here's a breakdown of the video's content:
(00:00) - Intro
(00:20) - What is data analytics?
(01:20) - Coffee & prep work
(02:12) - Team meeting
(03:26) - Data analysis
(05:41) - Lunch
(06:14) - Producing reports
(07:43) - Code maintenance
(09:50) - Stakeholder meetings
(11:06) - Documentation
(11:36) - Research
(12:43) - Outro and next steps
Tools and resources mentioned in the video:
- Tableau: tableau.com/
- Power BI: powerbi.microsoft.com/
- Looker: looker.com/
- Git: git-scm.com/
- Github: github.com/
- New research in data:
a) paperswithcode.com
b) arxiv.org
- General data news: medium.com
- Great math teachers on TH-cam:
a) zedstatistics: / zedstatistics
b) StatQuest with Josh Starmer: / joshstarmer
- Math learning app: brilliant.org
Check out our in-depth blog article on this topic too: bit.ly/ADayInTheLifeOfADataAn...
If you'd like to take part in live data analytics events , as well as career-change topics, check out our events page for weekly events with expert speakers: careerfoundry.com/en/events/
Thanks for watching!
#DataAnalyst #Data #ADayInTheLife
---
Want more from CareerFoundry?
Check out our other social media channels and blog:
🔍 linktr.ee/CareerFoundry
For more information on our programs, visit us at:
🖥 careerfoundry.com/
A Day in the Life of a Data Analyst (2023)
• A Day in the Life of a...
Just finished my probation period as a data analyst and was confirmed officially as a full employee. This video has given me the direction I was looking for❤
Congratulations. I am also leaving my current job and starting probation period in data science next month to pursue a career in data science. Do you have any tips for me?
Congratulations! All the best :)
Congrats, Dude!
Congratulations sir....
I'm civil engineer and looking to learn something new in tech industry....... Any suggestions or tips or advice please 😇
I just saw ur last video I think I am in the right field
This is by far the best "A day in a life of Data Analyst" video I've ever seen on TH-cam. This video gave the proper insight of how a day look like in business. Great work and thank you for sharing, loved it!
Thank you so much Aryan, that's great praise indeed and very kind. Glad you enjoyed it!
I agree!!! By far the best. Thank you
I thought the same. This video had enough details to get a good feel for what type of work it is.
I knew I'd find this comment and it's 100% spot on.
Zero BS and thank God 50% of the video wasn't spent making coffee or exercising at the gym
As a Data Analyst my self i can confirm that this is pretty much about what I do.
Usually the tasks are not as clean cut as shown here. E.g. do you sometimes realize a problem in the data while creating a report and go back to the datatransformation.
But this shows perfectly what the general tasks of a Data Analyst are!
Hey i an 16 how much time would it take for me to be data analysist
Did you go to college? And if so was it an easy transition from college work load to your actual job work load or was it different?
@@anupkunwar1520 few months to 1 year, depends how much time do you spend on it daily :)
Now THIS is the Day in the Life video I was looking for!!!! This definitely gave me much more insight on what it entails. I knew some of what was mentioned, but definitely didn't know all of this. Extremely helpful and much appreciated!
Best ‘day in the life’ video of any career ever. For a job that usually involves confidentiality so you can’t actually show what you’re working on therefore you need to explain it concisely, this was great! I’m not even a Data Analyst (yet) and I 100% understood what day to day work would look like. Thanks
Thank you for providing a proper 'day in the life of'! Other videos never go into what they actually do, work-wise, this was really great and insightful.
As others have commented, this is one of the best, if not the best, day in the life videos I’ve watched. Super helpful. Thank you!
This is by far the most simple and straightforward video i have seen about a data analyst day. I am motivated by it. Thank yiou.
This was perfect! So in-depth and detailed. As an aspiring Data Analyst, this motivated me. Thank you!
Can you just talk Normal as a data analyst? It seems like you guys speak in a way that is unnecessarily complicated. Things I would like to know tho is what is an example of the process? The business ask you what? Like do they ask “how many sales we had in October and what’s the age range?”. And you use your skill to find that out in python? What is the meaning of using these programs? Why must you use code? Why aren’t there wysiwyg programs where the business can input the data already? I’m tryna understand the reasoning.
Thank you so much! This was super helpful and definitely cleared up a lot of questions I had on what you’d actually be doing
I've paused the video to say, this is the BEST day in the life video I've seen on TH-cam! I'm actually getting into project management so would love a PM one like this but I can't find any good ones from PM professionals in the UK
The best “A day in life” I’ve ever seen! Super helpful, thanks a lot ❤️
You have by far given the best definition of a Data Analyst👍
Beautifully put. Thank you for sharing this!
I’m in the process of deciding if I want to move forward with a Data Analytics certification and wowwwwwww I had no clue it included all of this. Not very sure I can handle the coding and math lol. Thanks for the details!
I loved the details in this video and these best practices! It’s giving me some inspiration to structure my job. Your day seems much calmer than mine though… I feel like I’m frantically bouncing around multiple projects and requests daily… no chill. Is that normal or is my company just a little crazy?
Struggling to get into the industry as a Data Analyst, looking for a mentorship and good opportunity. This is encouraging for real. Thanks alot.
This has to be the most accurate "day in the life" of video for Data analytics I've seen.
thank you for the detailed guide, it helped me install this soft
Thank you so much 🙏for your contents on social media!
This is the best version❤Loved the video!
Great video. Love the video a lot of insight, hope to see more of this CF
As I'm an introvert, one thing that I'm worried about is the communicantion skill. I heard many data analysts mentioned that it is so important to have a *strong communication *. Yeah!! It's truth that a word of strong makes me nervous. In addition , as English is not my first language, and I'm not the one who can or likes using a high level words like business terms or talking sound like a professional. Therefore, how can I overcome this kind of thoughts before I graduate ?
Just take a deep breath, meditate and just tell yourself u can do this because u really can. Also, and just be confident and smile. I feel like smiling just helps eliminate the anxiety u have and helps u be more confident. Hope this helps and congrats on almost graduating u got this!
I was one too, just start talking to people. Could just be random stuff on your head, in time you’ll be comfortable enough
1) Practice. I feel your pain, but this is necessary. You won't know if your communication level is good enough if you don't talk to people.
2) When you speak, focus on getting your point across as best as you can and don't criticise yourself in the process. Don't know big words? Use the ones you know to explain what you mean. This is a skill too. The goal is to not get stuck. For me, I get stuck when I start judging my grammar or pronunciation, trying to speak perfect English.
3) Add 'English conversation' to your skill list. Treat it as just another skill, like SQL or python, that you have to improve in order to land a job or progress in your career. That's all it is!
You can absolutely have strong communication skills as an introvert. I think you can practice in your native language too - being concise, unambiguous, respectful, all that stuff.
Thanks for the detailed insights!
This is the video I’ve been looking for!! Thank you for this.
Thank you for making such an interesting video Sir 🔰
Was always curios to know about a normal day in a life of a data analyst 😃
I’m an aspiring data analyst, and I find this video insightful
Thank you. This is really a helpful video👍🏻
This was detailed. Thank you
Thank you, these videos of yours are awesome and informative! 😊
What percentage of coding would you say is generally involved in data analysis? Or about how often do you do it? 🤔
These videos are such good quality. Love this 🎉
Thank you for this video! Always nice to see Data Analysts/Data Scientists doing their job. I'm actually dedicating a lot of time and effort in order to learn as much as possible to become a Data Scientist myself in the near future. Such inspiring professions.
You're welcome! It's always great to hear inspiring stories like this. Keep it up and stay tuned for more data analytics content very soon!
Best of luck to you on your journey, Caetano!
i really love this video. the more detail u put, make this video different from the other. so turn on notification on this awesome channel
Thanks so much! Glad you enjoyed this video and stay tuned for more data analytics videos coming very soon!
It would be great practical learning platform for new people like me who are exploring resources in joining this profession. Keep it up!
Absolutely! Thanks for the the feedback, we have several hands on / tutorial videos around data analytics in the works! Thanks!
This is perfect in every way possible
I’m trying to switch to DA and your videos have been hella helpful
I'm a year into my bachelor's program for Data Analytics. This was such an insightful video! I'm learning python, sql, and statistics, and it's so cool to see I can continue learning and staying on top of new techniques. I can't wait to become a Data Analyst!
Currently taking "Bachelor of Science in Information Systems", this video really gave me a detailed insight of what I am pursuing now.
Any tips for a Freshmen like me?, thanks in Advance, it will help me a lot through my journey.
I feel motivated. Thank you
Thanks for sharing , nice explanation
Thanks so much. Thank you! Thanks!!!!!!
Your videos are incredibly helpful!
Nice Video, very professional and REAL. Thanks
Thank you for explaining this thoroughly!
You're welcome! Glad you enjoyed the video!
Very helpful.Thanks.
i have been trying to transition into tech and making choice of career path has been difficult, but after watching watching this video, i think i am going for data analytics. i hope i find a good job soon and develop myself
This is helpful!
I've knowledge of both Pandas and SQL but am still confused as to which of the above tools would be suitable for Data Analyst. Could you kindly recommend a tool to use?
Thanks
Dont know why I am addicted to watching day in the life of videos. I know this is a video to entertain more then actual avg day, but after watching several of these day in the life of data analyst videos can't help but wonder how long do actual data projects take on avg? I imagine a week maybe more? Otherwise if data projects are just 1-2 days that is close to 100-200ish projects a year. Which is a lot
Excellent video 👍 Thank you
sir, I work well on the Power query. Do I need to learn the M language as well? I am preparing for data analyst job.
9-5 with a lunch break 😮 🎉 Nice!
We have the same coffee preference, which I will take as a sign that my decision to transition from mechanical engineering to data analytics is the right one :D
I love it, your beste day in the life, thanks for share
I'm just finishing up my studies for accountancy and always thought being a data analyst would be a perfect career based on my personal traits and skills. although remembering code and digital formulas is not my strongest skill, of course I can improve but how important is this?
I think that data analysis is one of the best careers right now, personally I love the combination of subjects that make it unique, the problem that I am encountering after almost a year as a data analysis trainee is the job search, I am from Peru
Thank You! whats most useful to learn dashboarding as an aspiring data analyst, Tableeau, power BI, or Looker?
Great video, super interesting and insightful! And those dumplings look amazing! 🎉 👏 📈
Thanks a lot Calum, glad you enjoyed the video! Also, the dumplings were delicious, highly recommended!
Thanks for the video.
As soon as am done with the LSS BB am coming for Data Analyst then go back and do my LSS MBB
thanks for the video
This has been great. Thank you!
You're welcome! Glad you enjoyed the content!
Great video showing what you do in detail. I will be honest I almost turned it off when you said "latte with oat milk" but I gritted my teeth and pushed on through. I am glad I did.
Hey Carl, thanks for the kind feedback, glad you stuck with it. Oat milk isn't for everyone!
Would a software engineer be able to do a smooth transition to data analyst? Seems like there is some cross over in the set of skills needed, for example problem solving and programming, I didn’t expect for data analysts to share quite several things with SWEs
That was the best insight!😊
Great video. My question, where'd you get that button down shirt? I want one or two.
Thank for your sharing!
Thanks for watching!
This is the life. I have got to be data analyst at least for starters. Does anyone have a link for an entry role into data analyst role, I badly need support into an entry role?
Great video
Excellent video, this is by far best version of "working day life". One important question - what is up with laptop keyboard? Signs of experience there. 🙌
I'm pretty sure it's a silicone cover, to protect the keyboard... His is just bunched up for some reason
I can manage storyteller and business consultant because I work as copywriter in consulting company. My problem lies in math and coding. I wonder how deep we have to master these two?
I want to double like this. Thank you for this video.
Hello do you recommend Masterschool for someone who has no experience in Data?
Daamn! This is more like an ad for data analysts. Looks sooo easy, so chill and without any chaos that i have as a developer.
I do strongly disagree with the code language aspect. If you still have managed to learn 3 code languages, and speak several languages on top of that, you shouldn't be obliged to learn new ones. There are plenty of companies here that will be more than happy to hire you, especially if these 3 languages are well-known and widely used. Companies should definitely stop asking too much to their employees.
In my experience its not about how it "should be" but rather what it takes to make things possible
I can barely learn one bro 😢
@@unemployedgringo Please, can I learn data analysis without learning the code language?
Thank u 👍
Thank you for this information on your day in the life!!! I've decided that this would not be the most ideal role for me!
Failed to comment like that because I thought I would be labeled.. Am glad am not alone.. I have been busy singing about this career option but not knowing what is really involved is actually complex.
@@EricSikalangwe-dd7ed glad you were enlightened as I was 🙏🏽
Hi I was just curious is a Laptop or Desktop a requirement for this line of work? Or is one able to do this job from an iPhone or Tablet and use SQL, Excel and various other programs in the forms of apps?
Hoping for a hybrid work model one day
your videos are my favorites ❤
Glad you like them!
If i have a bachelors in supply chain management, should i go to a bootcamp for data analysis to learn python/sql? I want to get an entry level role for data analysis, but dont know if i need to be a full on computer engineer
Got a question for ya. Do you think companies would hire someone new to the data analytics field, if all they had was a certification? I’m going through a massive career shift from education to data analytics. And I’m currently enrolled in the Google Analytics program. So, do you think simply understanding basics at beginner levels such as simple SQL, queries, spreadsheets, and basic coding functions and formulas could land you a junior position?
I'm leaving education for data analytics too! From what I've heard (online & from data analysts I've met in person) is you definitely need to know Excel, a good deal of SQL, and then one way of showing visuals of what you've learned -- Power BI, Tableau, R, etc. The thing they care about is seeing what you can do. So before you apply put together a project showing your skills. You don't need to know everything, but they need to see you've got a good foundation to learn for whatever role you're going to fill.
@@hs63 Thank you! I’ve been trying to figure out what to do in terms of sending out resumes and applications once I get done with my certification. I’ve been taking time to learn SQL, I’m about to start learning R and Python, and then I’ll be getting into visualization.
My mentality is teach myself as much as I can and get a company to give me a shot and help me learn more.
I'm also going through a career change and I'm new to the Data Analytics world also. I'm sure we will all be able to get jobs once we learn the skills mentioned above. Python, SQL, Tableu, R, etc. I'm excited for us all to begin our new careers! Best wishes to all! Let's do this
@@dianacollins6732 Awesome! And Congratulations! I’m
Almost done with my certification and I’m looking to start applying by the beginning of the new year. Just practicing my skills and keeps making projects!
I wish you all the best of luck on your transition and career path! Wish I could see everyone’s growth along the way but all I can do is wish you the best.
@@frothylube491 I think by now you already received the certificate right? If yes, congrats 🎉. Btw may I know, did you succeed on landing a job as data analyst?
How do you work on power bi in your macbook?
Gold❤🔥🔥🔥🔥
Perfect video. Straight to the point
Thank you, glad you liked the video!
Great video, well explained
Thanks, glad you enjoyed it!
Hello! I belongs to non technical background, should I learn coding before starting data analyst course or I can learn coding with data analyst course?
Can anyone please suggest me.
Thank you
Can all the stakeholder presentations be done as WFH? I am interested in being a data analyst, but I want to WFH 100%.
Thank you for being so thorough with this. It has helped me determine this in not the career for me.
great Video, well done!
Thanks Petra, glad you liked it!
You go all the way to newyork city to meet other data analysts?
Super helpful video! :)
Glad it was helpful!
You explain it so well , loved tNice tutorials tutorial.
the meetings happens by the Data Analyst invitation or the team?
very nice video . I have ever seen
Do you think someone who has zero experience in data analytics can become a data analyst? Asking because I’m interested in “data” and I’m looking to jump industries
Nice!! 🙌
Thanks AJ! Glad you enjoyed it!
Waooo how I like this video , you’re an inspiration to many
Thanks! Appreciate your kind words! The idea of this video was to showcase the day of a data analyst and inspire everyone interested in the field to go for it since it's such an amazing career!
Awesome video, just subscribed! But I have one question: After you import data via SQL and analyze with Python, how do you import data into PowerBI? Do you also use SQL to import data directly to PowerBI, or do you export the clean and analysed data from python to an excel file, and then open that file in PowerBI?
You can do both. It also depends on your objective.
A better approach is to connect directly to the database source and extract the data using SQL. At times you may need to extract data from multiple tables using SQL and run the data in a Python code for more complex data processing and transformation.
I usually just connect power bi to sql, or if I'm analyzing in python connect to python to power bi.