Learning Data Analytics -
LinkedIn with 100% correct
answers (latest update)
Analysts engage in all of the following activities, except: - answer
changing data values
Learning syntax is one of the first big hurdles for any analyst. Which of
the following are NOT recommended for learning syntax? - answer trial
and error
Getting data to a _____ format can help you do more with it.
raw
queried
customized
aggregated - answer raw
The result of a(n) _____ join for two tables/columns/etc. always contains all
records of the "left" table, even if the join-condition does not find any
matching record in the "right" table.
right outer
inner
left outer
outer - answer left outer
What kind of join requires that there is a record in both of the joined
tables/columns?
left outer
inner
outer
right outer - answer inner
, If you want to improve a process and create better data reports from
existing ones, what is something you should ask for (or create if it doesn't
exist)?
excel spreadsheet
software
database access
Workflow Diagram - answer Workflow Diagram
All of the following are common actions when cleaning data, except:
removing errors (data that isn't controlled when entered can have errors)
altering (data should be reconfigured in order to meet goals)
validating (comparing the data you have against the verified "truth")
standardizing (ensuring data has a standard) - answer altering (data
should be reconfigured in order to meet goals)
Data ____ ensures that we have quality data.
queries
calculations
governance
measures - answer Governance
If you're a beginner to data analysis, what is the first thing you should
check when you build data queries?
workflow diagrams
calculations
differentials
record counts - answer record counts
LinkedIn with 100% correct
answers (latest update)
Analysts engage in all of the following activities, except: - answer
changing data values
Learning syntax is one of the first big hurdles for any analyst. Which of
the following are NOT recommended for learning syntax? - answer trial
and error
Getting data to a _____ format can help you do more with it.
raw
queried
customized
aggregated - answer raw
The result of a(n) _____ join for two tables/columns/etc. always contains all
records of the "left" table, even if the join-condition does not find any
matching record in the "right" table.
right outer
inner
left outer
outer - answer left outer
What kind of join requires that there is a record in both of the joined
tables/columns?
left outer
inner
outer
right outer - answer inner
, If you want to improve a process and create better data reports from
existing ones, what is something you should ask for (or create if it doesn't
exist)?
excel spreadsheet
software
database access
Workflow Diagram - answer Workflow Diagram
All of the following are common actions when cleaning data, except:
removing errors (data that isn't controlled when entered can have errors)
altering (data should be reconfigured in order to meet goals)
validating (comparing the data you have against the verified "truth")
standardizing (ensuring data has a standard) - answer altering (data
should be reconfigured in order to meet goals)
Data ____ ensures that we have quality data.
queries
calculations
governance
measures - answer Governance
If you're a beginner to data analysis, what is the first thing you should
check when you build data queries?
workflow diagrams
calculations
differentials
record counts - answer record counts
