What I *actually* do as a data analyst | salary, job, harsh reality

Day in the life of a data analyst in 2024 including data analyst skills, the workflow, the data analyst role and responsibilities, what is a data analyst, and whether it's a right career for you. As a business intelligence engineer, my role is very similar to a mix of a business analyst, data engineer, and a data analyst. Use this video as a reference to start your data analyst career path, learn what data analysis is, and what a data analytics career is like.

📚 Resources

🖥️ My Desk Setup

🙆🏻‍♀️ Connect

📄 ABOUT ME:
My mission is to help you grow your career, especially in the world of data analysis. Switching careers to become a data analyst from a non-tech background was overwhelming. I made a lot of mistakes and wasted time trying to figure it out. But having been a manager of data analytics and now a senior business intelligence engineer in tech (FAANG), I've learned a lot and I'm excited to use my experiences to help you navigate your career path. I hope this channel gives you the clarity and motivation to get started!

⌚️Timestamps
00:00 - Intro
00:19 - What is a Data Analyst?
01:25 - What do I do?
02:12 - What is the Workflow?
04:07 - What does a Data Analyst team look like?
04:47 - What is the realistic life of a Data Analyst?
06:22 - Why am I a Data Analyst?
07:35 - Should you be a Data Analyst?
08:35 - Outro

Content is for educational and entertainment purposes only. Some links are affiliate links that support the channel at no cost to you. As an Amazon Associate I earn from qualifying purchases. Thanks for your support!

[Rebellionrider]

Data analyst: part detective, part magician, turning numbers into trends and coffee into insights!

[transplantman]

Honestly, managing other people's unrealistic expectations and lack of direct clarity in their communication (often not even knowing what they themselves want) and presenting layered and complex patterns and hypotheticals as simple, "user-friendly" concepts is already my full-time job as an autistic person just living in society, so tbh I feel like I'm built for this. 😅

[newenglandnomad]

Having jumped into learn data analysis to change careers I have noticed something. Learning the tools is fine. Understanding the hypothesis or problem question makes sense.

Maybe you've done it already, but I haven't really seen anyone make a portfolio project showing a problem, and how their dashboards solves it. I think it's hard when practicing with kaggle data to find a problem and solve it.

When learning I practiced the usual orders customers shipping type queries, but they never really explain what they would do in the office with the results. Maybe those get emailed in a report? I don't really know. I finally get that they are practicing with 20 lines to teach us the basics, when in reality it might be 100, 000 rows.

Thank you for your videos, honest insight, and resume template. I really appreciate your work!!!

[firetawgc]

I'm a data analysis and just making 60k and my work has me on 6 different projects. I rarely have any energy left at the end of the day. Not all employers are made equal...

[WillC]

I similarly have 10 years as an analyst and now Business Intelligence Manager -- I found this incredibly helpful in articulating what I do. I've always struggled with my elevator pitch, "What do you do?". Thanks for the assist!

[crenshaw]

The Design Document was interesting. I’m learning SQL and Tableau to make a shift into Data and this was very informative. Thanks

[businessman]

Thanks for the video. I'm 38 just finished Google data analytics certificate. I was thinking of taking the more advanced courses but after watching your video I believe it isn't worth it and I should go down another road.

Thank you so much! I feel like you saved me a lot of time.

[miguelmaal]

Agatha, thank you for your videos and the time you put on them. As someone who is currently working on changing careers you paint a pretty good picture of what to expect.

Would love to see a video about ways in which you have improved your soft skills.

[aaravbamba]

I’m an aspiring data analyst currently learning skills and this video was incredible! You have cleared up all my doubts about the work a data analyst does 😊

[hamadzahra]

We need the video of the differences between data analysis data engineering and data science.
Thanks for your effort really great video!

[Madhu._.]

awesome video💓 U r sharing real life experience that actually feels real 😅. watching your videos makes me feel like getting advice from a close friend in person, someone who shares every nooks and corners. please share about how you manage everything in life in the aspects of planning

[donaldclark]

Learning how to train stakeholders to explain what they're trying to accomplish versus telling me what they want was huge for me. Great video!

[countmindlos]

Hi Agatha, can you put together a video that explains the knowledge a junior data analyst should have in terms of statistics. I did an assessment which totally wrecked my confidence in my skills. I didnt know much about P-value and methods of doing analytics, and what are the most common metrics that are used to measure performance. please help :(

[anapslima]

I love being a data analyst! I couldn’t think of a better profession. I’ve never have problem with urgent tasks, my bosses always set the boundaries to protect the team, so WLB was amazing since the beginning

[christopheraryo]

hi Agatha, nice content, I'm also a Data Analyst from Indonesia and what you tell in this video is very similar with my work, thankyou for sharing this 👍

[Adrian.adrian]

Thanks for this video. I’m currently a Revenue Cycle analyst and want to transition into a healthcare or data analyst. But you’re right, the work life balance is the best part plus a good income.

[elsieakpan]

Thanks for sharing your experiences... I'll like to know more about the payscale for a data analyst!

[julievu]

Thank u so much for ur helpful sharing ♥️ happy new year wish u all the best Alaga 🍓

[bvcb]

very insightful as an aspiring data analyst. thank you agatha!

[vanessalewis]

Thank you for this video! I am on the path of becoming a data professional. My goal is to switch over from tech support specialist roles! Your videos help me gauge how to further my growth and development. I love the part where you including design documentation. Thank you again!