Analysis

Question 1

Organize and sort and adjust

Answer 1

The first two phases of data analysis, Organize data and Format and adjust data, are important for data analysts because they can use these phases to manipulate their data in ways that make important patterns and trends more obvious.

Question 2

How do you sort in sql

Answer 2

Where and order by. Defaults to ascending order. To arrange in descending order use DESC

Question 3

Aggregate

Answer 3

Collecting many parts into a whole

Question 4

Data analytics puzzle analogy

Answer 4

Shelf of puzzles that falls to the floor. Aggregate or sort into parts. And the putting of the puzzles together is the analysis.

Question 5

Value function

Answer 5

Changes from text to numeric values

Question 6

Temporary table

Answer 6

Create in sql to refer to and access info better. Use with, select into, create table

Question 7

Start with “With”

Answer 7

Parenthesis select statement creates temporary table

Question 8

Select into

Answer 8

Copies data from one table into a new table, but doesn’t add the new table into the database. Copy a table with a specific condition.

Question 9

Create table

Answer 9

Good option when several people need to access the same temp table. This statement adds the table into the database.

Question 10

Modulo

Answer 10

An operator (%) that returns the remainder when one number is divided by another