Data Analytics- Questions and Answers| Latest Update

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