Data Analytics- Questions and Answers|
Latest Update
If you learn Power Query in Excel, in which other platform will you also know how to use it?
Metabase
Google Data Studio
Attempted correct option
Power BI
Superset Power BI
Which function in Excel determines what happens if a condition is true or false?
MATCH
INT
Attempted correct option
IF
NOT IF
What is a benefit of maintaining your original data?
Cleanup is remembered for future projects.
Changes are automatically saved.
Attempted correct option
You are provided with an audit trail. You are provided with an audit trail.
, Which function is used to create aggregated datasets in Power Query?
the Group function
Attempted correct option
the Group By function
the sort function the Group By function
Why is it important to note where your source data comes from?
Correct answer
so you have a path to follow if something is off in your data
Attempted incorrect option
so you can have the source data file at hand even when changes are made
so you are in data governance compliance so you have a path to follow if something is off
in your data
Why should you only request access to the data you need?
to save on costs for the company
to prevent copyright infringements
Attempted correct option
to protect yourself and your organization to protect yourself and your organization
Combining the definitions of three words describes a data analyst. What are the three words?
Attempted incorrect option
Latest Update
If you learn Power Query in Excel, in which other platform will you also know how to use it?
Metabase
Google Data Studio
Attempted correct option
Power BI
Superset Power BI
Which function in Excel determines what happens if a condition is true or false?
MATCH
INT
Attempted correct option
IF
NOT IF
What is a benefit of maintaining your original data?
Cleanup is remembered for future projects.
Changes are automatically saved.
Attempted correct option
You are provided with an audit trail. You are provided with an audit trail.
, Which function is used to create aggregated datasets in Power Query?
the Group function
Attempted correct option
the Group By function
the sort function the Group By function
Why is it important to note where your source data comes from?
Correct answer
so you have a path to follow if something is off in your data
Attempted incorrect option
so you can have the source data file at hand even when changes are made
so you are in data governance compliance so you have a path to follow if something is off
in your data
Why should you only request access to the data you need?
to save on costs for the company
to prevent copyright infringements
Attempted correct option
to protect yourself and your organization to protect yourself and your organization
Combining the definitions of three words describes a data analyst. What are the three words?
Attempted incorrect option
