Hang tight while we fetch the video data and transcripts. This only takes a moment.
Connecting to YouTube player…
Fetching transcript data…
We’ll display the transcript, summary, and all view options as soon as everything loads.
Next steps
Loading transcript tools…
What I *actually* do as a data analyst | salary, job, harsh reality | Agatha | YouTubeToText
YouTube Transcript: What I *actually* do as a data analyst | salary, job, harsh reality
Skip watching entire videos - get the full transcript, search for keywords, and copy with one click.
Share:
Video Transcript
here's what I do as a data analyst I
have over 10 years experience as a data
analyst manager of data analytics and
now as a business intelligence engineer
and after all these experiences I want
to give you a realistic picture of what
a data analyst does so let's get started
the first is what is a data analyst a
data analyst is just someone that
gathers data studies it and then makes a
decision so think about when you're
buying a car you're going to want to
compare prices look at the different
features decide whether it makes sense
to lease a car versus buy it and after
all that analysis you'll then go ahead
and buy the car that's best for you so
that's basically what a data analyst
does they're going to assess all the
data points and then make a decision
based off of it and there's many
different types of data analyst I know
it's very confusing there's business
analysts there's finan financial analyst
Healthcare analyst they all
fundamentally do the same data analysis
but the biggest difference will be their
domain so a financial analyst will be
working on financial reports whereas a
business analyst is going to be working
closer with the business and business
decisions and also some of the roles
will be more technical than the other so
what do I do as a data analyst my role
is a mix of of business analyst data
engineer and data analyst like a
business analyst I work really closely
with the business to determine what are
the metrics that impact the business and
like a data engineer I then work on
ingesting the data building the various
data pipelines and then like a data
analyst I'll then analyze the data and
presented so you can already tell
there's a lot of overlap between all of
these data roles when you you say data
analyst versus data engineer versus data
scientist and if you want a video
specifically on what the differences
between all of these let me know in the
comments and I'd be happy to do it what
is the workflow of a data analyst a data
analyst works on the problem then the
data and then reporting starting with
the problem the problem statement is
like a blueprint for a data analyst it
really tells them what direction they
need to go in as as well as what is it
that they need to solve for so with the
problem statement of what is the best
car to buy versus what is the most
affordable car to buy you would be
looking at two different data sets
because the problem of what is the best
car to buy would require looking at
safety ratings versus the most
affordable car you would solely be
looking at prices and in a workplace
setting you're going to have
stakeholders which are basically
basically just people in your
organization who will have business
problems and want you to solve them with
data and I document all of that down in
a design document outlining the problem
what the solution will be including the
impact and then I include the metrics
that we're going to use in the solution
as well and make sure that we are all
aligned before I work on the data data
is not always readily available and
you'll find that in the real world you
spend a lot of the time looking for data
now once you find it you then have to
figure out how to ingest it on a regular
basis and then you work on the actual
analysis part of the data once the data
is prepared then you'll do the
presentation part which is reporting
it'll either be through a visualization
in a bi tool sometimes it's a simple
Excel report other times it's a data
solution in this process you want to
make sure that you're using your
communication skills getting feed
feedback and also documenting everything
so that if someone asked you a few
months later what this report was you
have everything documented what does a
data analyst team look like well it can
either be a team of one or a team of 10
there really is no standard here you may
find a role where you're the only data
analyst and I've been there but I didn't
really like it because I felt that I
didn't have anyone to bounce ideas off
with and no one to learn from whereas
now I'm on a team of data Engineers as
well as partner software engineers and
just being surrounded by a team helps me
learn a lot so I prefer having a larger
team and if you're debating and you even
have a chance to decide I would
recommend going with a bigger team what
is the realistic life of a data analyst
I feel like the data analyst life has
really been glamorized on social media
it's the trend of people working from
home making six figures working in Tech
it's really good but there are just some
realistic downsides that you should be
aware of such as working with
stakeholders who will have unrealistic
expectations of work from you at the end
of the day I get a ping from someone who
says hey can you work on this report and
get it done by end of day and I'm
thinking it already is end of day then
it puts you in a spot of having to work
late and then when you ask those
clarifying questions of hey what exactly
is it that you need they don't even know
and being honest there actually have
been times where I've had to log in at
900 p.m. even because last minute I get
a request saying hey can you pull this
report and so having to manage the
unrealistic idea that you can pull
reports quickly and deliver it happens a
lot and you should just be aware of how
to manage your stakeholders and it's not
only last minute deliverables but you'll
get a lot of side chats from people
pinging you all day they'll have
questions like hey why isn't this
dashboard working or hey can you look
into this one problem I have honestly
responding to all those reports take up
your whole day and before you know it by
5:00 you got nothing done knowing all
this why am I a data analyst well there
are two reasons the first is work life
balance so that part is true I have to
say as a DayDay analyst I do have a lot
of time to myself and I think that's
really important because previously I
was working as a consultant working
50-hour weeks and by the time you're
done with work and commute honestly I
had no time to myself and that's what
made me realize that it's important to
have a good career but also equally
important to have a good life outside of
your career and so being a data analyst
does allow me to confidently make plans
with my friends friends at 5:00 or have
enough time to work on my side passions
like YouTube and if you are enjoying
this video please like And subscribe as
it helps me a lot and just having the
ability to have time to myself is really
the deal breaker for me and second is
the pay so a data analyst pay is very
competitive I'll be honest especially
working in Tech the salary is closer to
150,000 250 ,000 and if you're
interested more in the salary and want a
whole video on that let me know in the
comments because I can do that as well
so should you be a data analyst honestly
anyone can be a data analyst and
learning technical skills is something
that anyone can do but what I feel like
is overlooked a lot is people don't talk
about the soft skills that also are
really important in addition to the
technical skills and yes the technical
skills will get you your first job and
put your foot in the door but once
you're there I think what I learned from
all my experience is that those soft
skills of being able to communicate
influence others make connections with
other teams is really what will get you
promoted will get you a better job those
are skills that I think are equally as
important and so if you're thinking
about a data analyst career think about
all the things I said and see if that is
something you realistically see yourself
doing still want to be a data analyst
watch my next video on how I'd become a
data analyst if I had to start over
Click on any text or timestamp to jump to that moment in the video
Share:
Most transcripts ready in under 5 seconds
One-Click Copy125+ LanguagesSearch ContentJump to Timestamps
Paste YouTube URL
Enter any YouTube video link to get the full transcript
Transcript Extraction Form
Most transcripts ready in under 5 seconds
Get Our Chrome Extension
Get transcripts instantly without leaving YouTube. Install our Chrome extension for one-click access to any video's transcript directly on the watch page.
Chrome Extension