A Day in the Life of a Data Analyst (2023)

📲 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 KZbin:
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...

[@waswarodgers]

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❤

[@RRDGamer]

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?

[@mahalnamahalkita358]

Congratulations! All the best :)

[@eleanorjpoindexter4299]

Congrats, Dude!

[@patelmilind7621]

Congratulations sir.... I'm civil engineer and looking to learn something new in tech industry....... Any suggestions or tips or advice please 😇

[@SelfimproventandDevelopment]

I just saw ur last video I think I am in the right field

[@ryn_rai]

This is by far the best "A day in a life of Data Analyst" video I've ever seen on KZbin. This video gave the proper insight of how a day look like in business. Great work and thank you for sharing, loved it!

[@careerfoundry]

Thank you so much Aryan, that's great praise indeed and very kind. Glad you enjoyed it!

[@GavinPotter]

I agree!!! By far the best. Thank you

[@tianag4627]

I thought the same. This video had enough details to get a good feel for what type of work it is.

[@aneneemmanuel7985]

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

[@fabianfriedrichs5835]

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!

[@anupkunwar1520]

Hey i an 16 how much time would it take for me to be data analysist

[@ulisesroldan2955]

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?

[@ivanmiau9280]

@@anupkunwar1520 few months to 1 year, depends how much time do you spend on it daily :)

[@ImADelicacy]

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!

[@ManaMonarch]

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.

[@KD-ro4iy]

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

[@ocarerepairlab8218]

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.

[@Chica212008]

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!

[@trongkhanhmai8662]

The best “A day in life” I’ve ever seen! Super helpful, thanks a lot ❤️

[@victorstewart395]

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

[@ElizabethObuks]

I've paused the video to say, this is the BEST day in the life video I've seen on KZbin! 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

[@YahToldMe]

This was perfect! So in-depth and detailed. As an aspiring Data Analyst, this motivated me. Thank you!

[@user-qt1bq5bw6i]

Beautifully put. Thank you for sharing this!

[@wellnesstherapyhub]

You have by far given the best definition of a Data Analyst👍

[@mwagle]

This has to be the most accurate "day in the life" of video for Data analytics I've seen.

[@mohammedsaaka2370]

Great video. Love the video a lot of insight, hope to see more of this CF

[@rosacuore15]

Thank you so much 🙏for your contents on social media!

[@seniorhugoalves2799]

This is the video I’ve been looking for!! Thank you for this.

[@utkarshaparaspatki5836]

thank you for the detailed guide, it helped me install this soft

[@starry_config]

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?

[@analog_ape]

Thanks for the detailed insights!

[@lakshaynandwani9324]

This is the best version❤Loved the video!

[@mayursabale594]

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 😃

[@shashpeiris6008]

Struggling to get into the industry as a Data Analyst, looking for a mentorship and good opportunity. This is encouraging for real. Thanks alot.

[@Tealll]

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!

[@caetano.santana]

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.

[@careerfoundry]

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!

[@davidd9707]

Best of luck to you on your journey, Caetano!

[@bibiruizor6702]

Nice Video, very professional and REAL. Thanks

[@diantyfistika8931]

Thank you. This is really a helpful video👍🏻

[@chagcha2196]

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

[@careerfoundry]

Thanks so much! Glad you enjoyed this video and stay tuned for more data analytics videos coming very soon!

[@thatsimplegirlnicole]

These videos are such good quality. Love this 🎉

[@TehzeebR]

This was detailed. Thank you

[@sisayebdi5694]

It would be great practical learning platform for new people like me who are exploring resources in joining this profession. Keep it up!

[@careerfoundry]

Absolutely! Thanks for the the feedback, we have several hands on / tutorial videos around data analytics in the works! Thanks!

[@user-yh8fu6ud3t]

I’m an aspiring data analyst, and I find this video insightful

[@juliadearaujo1242]

Your videos are incredibly helpful!

[@SalawuIbrahim]

I’m trying to switch to DA and your videos have been hella helpful

[@kukainis1338]

Thank you for explaining this thoroughly!

[@careerfoundry]

You're welcome! Glad you enjoyed the video!

[@yorha.a2]

This is perfect in every way possible

[@lolilulelagaming3213]

Thanks for sharing , nice explanation

[@nickmuli8083]

I feel motivated. Thank you

[@katerynakoltunova5266]

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!

[@MAli-mg5zg]

Very helpful.Thanks.

[@Calumrussell88]

Great video, super interesting and insightful! And those dumplings look amazing! 🎉 👏 📈

[@careerfoundry]

Thanks a lot Calum, glad you enjoyed the video! Also, the dumplings were delicious, highly recommended!

[@mohammedtahir1907]

Excellent video 👍 Thank you

[@SweetArt360]

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? 🤔

[@KingCease]

Thanks so much. Thank you! Thanks!!!!!!

[@carlupshon6810]

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.

[@careerfoundry]

Hey Carl, thanks for the kind feedback, glad you stuck with it. Oat milk isn't for everyone!

[@mattmc3856]

This has been great. Thank you!

[@careerfoundry]

You're welcome! Glad you enjoyed the content!

[@kavinyudhitia]

This is helpful!

[@phoenixrising1234]

9-5 with a lunch break 😮 🎉 Nice!

[@rajiabdulrauf4741]

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

[@luvitrbs]

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

[@dovahkiin516]

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

[@romainesantos1825]

I love it, your beste day in the life, thanks for share

[@saiwilatt4636]

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 ?

[@justinsullivan4920]

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!

[@ulisesroldan2955]

I was one too, just start talking to people. Could just be random stuff on your head, in time you’ll be comfortable enough

[@radio.silence]

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.

[@Cahangir]

Thanks for the video.

[@elvijsVEVO]

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. 🙌

[@radio.silence]

I'm pretty sure it's a silicone cover, to protect the keyboard... His is just bunched up for some reason

[@06.phamvomybinh44]

thanks for the video

[@oscheka]

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

[@jazz_hat]

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.

[@victoriadeery2081]

Thank You! whats most useful to learn dashboarding as an aspiring data analyst, Tableeau, power BI, or Looker?

[@vikkyghale4311]

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.

[@tusharlambat887]

That was the best insight!😊

[@VITORB82]

I want to double like this. Thank you for this video.

[@joaquinivanperezalvarez3045]

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

[@danielmalatji1813]

As soon as am done with the LSS BB am coming for Data Analyst then go back and do my LSS MBB

[@chazza_monttanna798]

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?

[@nguyengiau4457]

Thank for your sharing!

[@careerfoundry]

Thanks for watching!

[@malikdelaun782]

Super helpful video! :)

[@careerfoundry]

Glad it was helpful!

[@Blackronin357]

Great video. My question, where'd you get that button down shirt? I want one or two.

[@amad4154]

Great video, well explained

[@careerfoundry]

Thanks, glad you enjoyed it!

[@petrakischkewitz5076]

great Video, well done!

[@careerfoundry]

Thanks Petra, glad you liked it!

[@tamiresdasilva9019]

this is the best "A Day in the Life of a Data Analyst" video

[@careerfoundry]

Thanks a lot Tamires! Very kind feedback, we're glad you enjoyed it!

[@jimenatorres3870]

I absolutely adore this video, what is more I want to work with you!

[@hagduinithronel5160]

Great video

[@isaac-obiri]

Perfect video. Straight to the point

[@careerfoundry]

Thank you, glad you liked the video!

[@Batmanpooped]

Thank you for being so thorough with this. It has helped me determine this in not the career for me.

[@rukundoprince6179]

Waooo how I like this video , you’re an inspiration to many

[@careerfoundry]

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!

[@priyankajirvankar4816]

very nice video . I have ever seen

[@danielalutina4918]

Hello do you recommend Masterschool for someone who has no experience in Data?

[@AJ.911]

How do you work on power bi in your macbook?

[@chisomanyanwu5060]

Hoping for a hybrid work model one day

[@noemi34349]

your videos are my favorites ❤

[@careerfoundry]

Glad you like them!

[@ernestoalonso5565]

Thank You so much for this valuable content. It's really inspiring and educational!!! Just one question. What operating system do You use for task? Or what where You using during this video?

[@AM-Boluke1210]

Thank u 👍

[@renesho2232]

You go all the way to newyork city to meet other data analysts?

[@ifyzthorts40]

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?

[@IvanFreelancer]

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?

[@arielmoura4730]

the meetings happens by the Data Analyst invitation or the team?

[@TheRealJuseBeats]

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.

[@ebbiec]

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!

[@EricSikalangwe-dd7ed]

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.

[@ebbiec]

@@EricSikalangwe-dd7ed glad you were enlightened as I was 🙏🏽

[@el7075]

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

[@aj_malakai]

Nice!! 🙌

[@careerfoundry]

Thanks AJ! Glad you enjoyed it!

[@rehamroshdy6729]

You explain it so well , loved tNice tutorials tutorial.

[@MithilaKotibhaskar2806]

Gold❤🔥🔥🔥🔥

[@cosmosaic8117]

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?

[@johnramey5519]

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

[@Numbermind]

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?

[@muhammadzhafranbahaman6401]

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.

[@austincelestine1925]

I usually just connect power bi to sql, or if I'm analyzing in python connect to python to power bi.

[@rajverma8471]

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

[@tifking73]

Can all the stakeholder presentations be done as WFH? I am interested in being a data analyst, but I want to WFH 100%.

[@raghunandanr3979]

Well explained! Typical day-to-day life of data analyst.

[@careerfoundry]

Thanks! Glad you enjoyed the video!