Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed Intro to Data Analysis!
You have completed Intro to Data Analysis!
Preview
Take a peek into what a Data Analyst does.
Data analysis process
- Profile data
- What data do you have access to?
- What form is it in?
- Can it be used for analysis?
- Extract your data
- Merge data if necessary
- Clean the data
- Analyze the data
- Present the data
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
Data is changing our world every day.
0:00
For example,
data is used to help provide clean water,
0:03
lower infant mortality rates and
reduce carbon emissions.
0:07
Data also helps in smaller ways,
like creating better experiences and
0:12
products for customers.
0:17
A data analyst is someone who uses data
to answer questions and draw conclusions.
0:19
An analyst for a school district
might track student test scores to
0:26
answer questions around what
makes a student test better.
0:31
Is it early morning, after lunch, or
late afternoon testing times?
0:35
Right after the weekend break,
middle of the week, or end of the week?
0:41
Answers to these questions can help the
district change their testing schedules
0:46
to help meet students when
they do their best work.
0:51
The first step for
a data analyst is to profile their data.
0:56
Knowing what data is available,
the forms it comes in, and whether or
1:01
not it will work for an analysis.
1:06
At this point, you may or may not have
a question you're looking to answer.
1:10
You may determine what questions
you have during this process.
1:16
Once an analyst has found the data
they need, they extract it and
1:20
merge it if necessary to create
a table, spreadsheet, or database.
1:24
Analysts then spend most of their time
cleaning and prepping data for analysis.
1:31
Data comes in many shapes,
sizes, and forms.
1:36
In order to run an analysis,
1:40
the data typically needs to be cleaned
by making sure it's in the right format,
1:42
like a date column, actually formatted as
a date and not just a string of numbers.
1:47
Cleaning may also include
removing columns, or
1:54
rows that have incomplete,
or inaccurate data.
1:57
For instance, data from a form
might have a column where an
2:02
optional response is held.
2:06
If only 5 out of 1000
people left a response,
2:08
then that column doesn't
represent the group well.
2:12
It may be best to leave that
column out of your analysis.
2:16
Once the data has been profiled and
2:20
cleaned, it can be analyzed
to find answers and insights.
2:22
These answers are then presented
to stakeholders, coworkers, or
2:27
maybe even your customers.
2:31
This process is repeated over and
over to help a business grow,
2:34
a charity help those in need, or
a city solve traffic congestion.
2:38
a data analyst's responsibilities will be
different depending on the industry or
2:44
type of organization in which they work.
2:48
Data analysis is a powerful tool.
2:52
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up