Learning Data Analytics Part
2: Extending and Applying
Core Knowledge with 100%
correct answers (latest
update)
In data analytics, noise is _____. - answer Data that is not meaningful for
reporting—systems generate a lot of data that is meaningful to the system
but not always meaningful to your reporting. Noise is anything that isn't
valuable to the report or visualization.
Your customer table has a column titled Customer Type. How does this
most likely relate to your company's business rules? - answer There is a
business rule that defines what a Customer Type is—The rule would define,
for example, Lead as someone who should be contacted and Current as
someone who has ordered.
Why are business rules important? - answer - They help define the data
- They impact the timing of data
- They drive the necessary calculations
What query is used to update data fields? - answer Update queries—will
update values in a field or in a table.
You use Select queries to build data sets that _____. - answer Select fields
of data—When selecting data from a table in a data set, you only need a
select query.
When would you use Merge queries? - answer When you are addressing
joins with multiple tables—Power Query and other software use Merge
queries for this purpose
2: Extending and Applying
Core Knowledge with 100%
correct answers (latest
update)
In data analytics, noise is _____. - answer Data that is not meaningful for
reporting—systems generate a lot of data that is meaningful to the system
but not always meaningful to your reporting. Noise is anything that isn't
valuable to the report or visualization.
Your customer table has a column titled Customer Type. How does this
most likely relate to your company's business rules? - answer There is a
business rule that defines what a Customer Type is—The rule would define,
for example, Lead as someone who should be contacted and Current as
someone who has ordered.
Why are business rules important? - answer - They help define the data
- They impact the timing of data
- They drive the necessary calculations
What query is used to update data fields? - answer Update queries—will
update values in a field or in a table.
You use Select queries to build data sets that _____. - answer Select fields
of data—When selecting data from a table in a data set, you only need a
select query.
When would you use Merge queries? - answer When you are addressing
joins with multiple tables—Power Query and other software use Merge
queries for this purpose
