Data Analytics - Module 2

What is the Data Analysis Process

a structured method used by analysts to extract meaningful insights from raw data and drive decision making

What are the six phases of data analysis process?

ask, prepare, process, analyze, share, act

What is the Ask phase?

define the problem or business need by formulating specific, actionable questions

What is the Prepare phase?

collect, curate, and store the necessary data from reliable sources

What is the Process phase?

clean and organize the data for analysis, addressing issues like duplicates or missing values

What is the Analyze phase?

Perform exploratory and statistical analysis to identify patterns, trends, and relationships

What is the Share phase?

communicate findings using reports, presentations, or data visualizations

What is the Act phase?

use insights to inform decisions and implement data-driven solutions

What is the data life cycle?

the stages data moves through

What is the use of spreadsheets?

data entry, organization, and basic analysis

What is the use of databases?

store and manage large datasets in structured formats

What is the use of query languages

enable analysts to retrieve and manipulate data from databases

What is the use of visualization software

translates raw data into interactive charts and databases

What are the phases of the data life cycle

plan, capture, manage, analyze, archive, destroy

What is the plan phase?

define the objective for data collection and management

What is the capture phase

collect data from internal or external sources

What is the manage phase?

securely store and maintain collected data

What is the analyze phase?

use data to generate insights and support decision-making

What is the archive phase?

store data that is no longer actively used but may need to be accessed later

What is the destroy phase

permanently remove data when it is no longer needed

Formula

A set of instructions used to perform a calculation using the data in a spreadsheet

Function

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

Query

A request for data or information from a database

Stakeholders

People who invest time and resources into a project and are interested in its outcome

Query language

A computer programming language used to communicate with a database