Using Data Analysis

Question 1

What are the 6 steps of the data analysis life cycle?

Answer 1

1. Ask
2. Prepare
3. Process
4. Analyze
5. Share
6. Act

Question 2

What is People Analytics

Answer 2

The practice of collecting and analyzing data on the people who make up a company’s workforce in order to gain insights to improve how the company operates.

Question 3

What are 2 other names for People Analytics?

Answer 3

Human resources analytics or workforce analytics

Question 4

What is Aggregate data

Answer 4

Data collected from multiple sources and compiled into data summaries or summary reports. Typically for the purpose of public reporting or statistical analysis.

Question 5

Examples of Aggregated data

Answer 5

Examining trends, making comparisons, or revealing information and insights that would not be observable when data elements are viewed in isolation.

Question 6

What does it mean to PREPARE data?

Answer 6

Decide how you want to relay your progress to interested parties and Identify what data you need to achieve the successful result.

Question 7

What does it mean to PROCESS data?

Answer 7

Collect, Store, Clean it to make sure it was complete, correct, relevant, and free of errors and outliers. And then Protect the data.

Question 8

What is Decision Intelligence?

Answer 8

a combination of applied data science and the social and managerial sciences.

Question 9

What is Data Science?

Answer 9

creating new ways of modeling and understanding the unknown by using raw data. This is also Data Analytics..

Question 10

What is the data ecosystem?

Answer 10

elements that interact with one another in order to produce, manage, store, organize, analyze, and share data

Question 11

What is Data-driven decision-making

Answer 11

using facts to guide business strategy

Question 12

Questions to ask yourself about a project to help find the perfect balance

Answer 12

• 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?

Question 13

Which of the following statements best defines data?

Answer 13

Data is a collection of facts.

Question 14

What are analytical skills?

Answer 14

The qualities and characteristics associated with solving problems using facts. They are Curiosity, understanding context, and having a technical mindset.

Question 15

A technical mindset

Answer 15

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

Question 16

Data design

Answer 16

Analytical skills that involve how you organize information

Question 17

Understanding context

Answer 17

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

Question 18

Data strategy

Answer 18

The analytical skill involves the management of people, processes, and tools.

Question 19

What is Visualization in data analytics?

Answer 19

the graphical representation of information. Some examples include graphs, maps, or other design elements.

Question 20

What does strategizing do for analyst?

Answer 20

helps data analysts see what they want to achieve with the data and how they can get there.

Question 21

Why do Data Analyst use a problem oriented approach?

Answer 21

to identify, describe, and solve problems.

Question 22

What is Big picture thinking?

Answer 22

This means being able to see the big picture as well as the details. If you only focus on individual pieces, you wouldn’t be able to see past that, which is why big-picture thinking is so important. It helps you zoom out and see possibilities and opportunities.

Question 23

What are the 5 aspects of Analytical Thinking?

Answer 23

1. Visualization
2. Strategy
3. Problem - orientation
4. Correlation
5. Big picture and detail oriented thinking

Question 24

What is Gap analysis

Answer 24

the process of examining and evaluating how a process works currently in order to get where you want to be in the future. Businesses conduct gap analysis to do all kinds of things, such as improve a product or become more efficient.

Question 25

What is a quartile?

Answer 25

A quartile divides data points into four equal parts or quarters.

Question 26

What is Root cause?

Answer 26

The reason a why a problem occurs

Question 27

What are the Steps of the Data Life Cycle?

Answer 27

1. Plan: What plans and decisions do you need to make? What data do you need to answer your question?
   2.Capture: Where does your data come from? How will you get it?
   3.Manage: How will you store your data? What should it be used for? How do you keep this data secure and protected?
   4.Analyze: How will the company analyze the data? What tools should they use?
   5 Archive: What should they do with their data when it gets old? How do they know when it’s time?
2. Destroy: Should they ever dispose of any data? If so, when and how?

Question 28

A data analyst uses a SQL query to retrieve information from a database. They add a WHERE statement to _____ the data based on certain conditions.

Answer 28

Filter

Question 29

What is a query?

Answer 29

A query is basically a request for data or information from a database.

Question 30

The foundation of every SQL query is the same:

Answer 30

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