Consider where the data came from ✓ Show
Correct Create reports for stakeholders Ask questions about the data ✓ Correct Use descriptive column headers ✓ Correct Which of the following situations would a data analyst use spreadsheets instead of SQL Select all that apply?Correct. An analyst would choose to use spreadsheets instead of SQL when visually inspecting data or working with a small dataset.
What are the advantages of learning and using standard SQL Select all that apply?With Standard SQL, complex queries can be started not only with SELECT but also with WITH, making code easier to read, comment, and understand. This also means it's easier to prevent your own and correct others' mistakes.
Which of the following SQL functions can data analysts use to clean string variables select all that apply?Correct. Data analysts can use the SUBSTR and TRIM functions to clean string variables.
What do data analysts use SQL for?Data Analysts use SQL to manipulate the data, understand the data, and access, read and analyze the data before storing it in the database.
|