Analyze Data To Answer Question

ANALYSIS

Analysis: The process used to make sense of the data collected
The goal of analysis is to identify trends and relationships within data so you can accurately answer the question you are asking
The 4 phase of analysis:
1. Organize data
2. Format and adjust data
3. Get input from others
4. Transform data

=CONVERT(): Can convert F temperature to C, mph to m/s, etc. e.g: =CONVERT(A1, "F", "C")

Data validation:
- Drop-down menu
- Custom checkboxes
- Protect structured data and formulas

Starting with	`CAST` functions can convert to:
Numeric (number)	Integer Numeric Big number Floating integer String
String	Boolean Integer Numeric Big number Floating integer String Bytes Date Date time Time Timestamp
Date	String Date Date time Timestamp

IMPORT AND CMBINE DATA IN SPREADSHEETS AND DATABASES

Import data:

SQL:

In SQL the syntax is:

  INSERT INTO [destination_table_name]
  SELECT [column names, separated by commas, or * for all columns]
  FROM [source_table_name]
  WHERE [condition]

Example:

INSERT INTO customer_promotion
SELECT *
FROM customers
WHERE total_sales = 0 AND postal_code = '12345'

Spreadsheets:
`=IMPORTRANGE(spreadsheet_url, range_string)'

Combine data:

SQL:

  SELECT CONCAT(field1, " ", field2) AS alias
  FROM [table_name]
  -- Example
  SELECT CONCAT(first_name, " ", last_name) AS Customer_name
  FROM customers

Spreadsheets
=CONCATENATE(item1, item2) or =CONCATENATE(item1, " ", item2)

DATA AGGREGATION:

Data aggregation: The process of gathering data from multiple sources in order to combine it into a single summarized collection. It helps:
- Identify trends
- Make comparisons
- Gain insights
=VALUE(): converts a text string to its numeric value

TROUBLESHOOTING QUESTIONS:

How should I prioritize these issues?
In a single sentence, what's the issue I'm facing?
What resources can help me solve the problem?
How can I stop this problem from happening in the future?

JOIN CLAUSE:

SELECT 
	-- table columns from tables are inserted here
	table_name1.column_name
	table_name2.column_name
FROM 
	table_name1
JOIN
	table_name2
ON table_name1.column_name = table_name2.column_name

Type of Join: