Course 1: Foundations: Data, Data, Everywhere

Question 1

“What data ecosystems are known to us so far?”

Answer 1

As a data analyst its your job to harness the power of the data ecosystem. Find the right info. and provide the team with analysis that helps them make smart decisions.

Question 2

• What kind of results are needed?
• Who will be informed?
• Am I answering the question being asked?
• How quickly does a decision need to be made?

Answer 2

Successful analysis needs to be accurate, and fast enough to help decision-makers. So try asking yourself these questions about a project:

Question 3

The qualities and characteristics associated with solving problems using facts

Answer 3

Analytical skills

Question 4

The analytical skill that involves breaking processes down into smaller steps and working with them in an orderly, logical way

Answer 4

A technical mindset

Question 5

Data design

Answer 5

Analytical skills that involve how you organize information

Question 6

Understanding context

Answer 6

The analytical skill that has to do with how you group things into categories

Question 7

The analytical skill that involves managing the processes and tools used in data analysis

Answer 7

Data strategy

Question 8

five key aspects to analytical thinking

Answer 8

visualization, 
strategy, 
problem-orientation, 
correlation, 
and finally,
big-picture and detail-oriented thinking.

Question 9

Visualization

Answer 9

Graphical Representation of Information

Question 10

Strategy

Answer 10

Strategizing helps data analysts see what they
want to achieve with the data and how they can get there.
Strategy also helps improve
the quality and usefulness of the data we collect.
By strategizing, we know all our data is
valuable and can help us accomplish our goals.

Question 11

Being problem-oriented

Answer 11

Data analysts use a problem-
oriented approach in order to identify,
describe, and solve problems.
It's all about keeping the problem top of
mind throughout the entire project.

Question 12

correlation

Answer 12

you know what a correlation is…. correlation does not equal causation….

Question 13

big picture thinking

Answer 13

being able to see the big picture
as well as the details.
(looking at a jig saw puzzle, you can enjoy picture without focusing on each individual piece).

Question 14

What’s a Query?

Answer 14

The way we use SQL to communicate with the database.

Question 15

Basic foundations of every SQL query:

Answer 15

Use SELECT to choose the fields you want to return.
Use FROM to choose the tables where the fields you want are located.
Use WHERE to filter for certain information

Question 16

What is <> mean in SQL?

Answer 16

“Does not equal”