Module 2

Question 1

What is the data analysis process?

Answer 1

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

Question 2

What is the life cycle of data?

Answer 2

1. Plan
2. Capture
3. Manage
4. Analyze
5. Archive
6. Destroy

Question 3

What is the plan phase in the life cycle of data? Give an example.

Answer 3

Before any analysis, businesses determine their data needs, management strategies, responsible teams, and desired outcomes.
Example: An electricity provider might plan to collect data on customer energy usage to identify savings opportunities.

Question 4

What is the capture phase in the life cycle of data?

Answer 4

Data is gathered from various sources, such as public datasets, internal databases, or external resources, and integrated into the organization’s systems.

Question 5

What is a database?

Answer 5

A collection of data stored in a computer system.

Question 6

What is the manage phase in the life cycle of data?

Answer 6

This phase focuses on data care, including storage, security, maintenance, and ensuring data integrity, credibility, and privacy.

Question 7

What is the manage phase in the life cycle of data?

Answer 7

This phase focuses on data care, including storage, security, maintenance, and ensuring data integrity, credibility, and privacy.

Question 8

What is the analyze phase in the life cycle of data?

Answer 8

Data analysts come into play here, using the data to solve problems, make informed decisions, and support business goals, like helping customers reduce energy consumption.

Question 9

What is the archive phase in the life cycle of data?

Answer 9

Data that is no longer actively used but may be needed in the future is stored securely and accessible.

Question 10

What is the destroy phase in the life cycle of data?

Answer 10

When data is no longer required, it is permanently deleted following secure data erasure practices to protect sensitive information.

Question 11

Who are stakeholders?

Answer 11

People who have invested time and resources into a project and are interested in the outcome.

Question 12

What is the ask phase of the data analysis process?

Answer 12

Focuses on understanding the stakeholder needs and defining the core questions that the data analysis aims to answer.

Question 13

What is the prepare phase of the data analysis process?

Answer 13

Involves identifying and gathering the right data sources that are relevant to the problem being addressed.

Question 14

What is the process phase of the data analysis process?

Answer 14

Data analysts clean, transform, and prepare the data for analysis, ensuring completeness and accuracy. This includes handling missing values, converting data types, and addressing potential biases.

Question 15

What is the analyze phase of the data analysis process?

Answer 15

Utilizes tools like spreadsheets and SQL to transform and organize data, enabling conclusions, predictions, and informed decisions.

Question 16

What is the share phase of the data analysis process?

Answer 16

Effectively communicating your findings to stakeholders through clear visualizations and reports, making the data understandable and actionable.

Question 17

What is the act phase of the data analysis process?

Answer 17

Apply the insights gained from your analysis to make informed decisions, solve problems, and drive positive change.

Question 18

What is data processing?

Answer 18

Involves cleaning, understanding the data’s structure, and ensuring its quality and reliability for accurate analysis.

Question 19

What are common tools used by data analysts?

Answer 19

Spreadsheets, query languages for databases, and visualization tools.

Question 20

What are spreadsheets?

Answer 20

Spreadsheets are digital worksheets that help organize and sort data, revealing patterns and making information easy to find. They also have formulas and functions for calculations and data manipulation.

Question 21

What is a formula?

Answer 21

A set of instructions that performs a specific calculation using the data in a spreadsheet?

Question 22

What is a function?

Answer 22

A preset command that automatically performs a specific process or task using the data in a spreadsheet.

Question 23

What is a query languages? Give an example.

Answer 23

A computer programming language that allows you to retrieve and manipulate data from a database.

SQL.

Question 24

How are data visualization tools used? Give an example.

Answer 24

They transform data into graphs, maps, and tables, making it easier to understand and share insights.

Tableau and Looker.

Question 25

What is the difference between spreadsheets and databases?

Answer 25

Spreadsheets are great for organizing, cleaning, and analyzing small to medium datasets.

Databases excel at storing, managing, and analyzing large and complex datasets.