Module 2 Flashcards
Database
a collection of data stored in a computer system
In the data life cycle, which phase involves using data to solve problems, make good decisions, and support business goals?
Analyze
6 stages of the data life cycle
Plan, capture, manage, analyze, archive, destroy
Plan
Decide what kind of data is needed, how it will be managed, and who will be responsible for it
Capture
Collect or bring in data from a variety of different sources
Manage
Care for and maintain the data. This includes determining how and where it is stored and the tools used to do so
Analyze
Use the data to solve problems, make decisions, and support business goals
Archive
Keep relevant data stored for long-term and future reference
Destroy
Remove data from storage and delete any shared copies of the data
Stakeholders
People who have invested time and resources into a project and are interest in the outcome
2 popular spreadsheets that data analysts use
Microsoft Excel and Google Sheets
Formula
A set of instructions that performs a specific calculation using the data in a spreadsheet
Function
A preset command that automatically performs a specific process or task using the data in a spreadsheet
Query language
A computer programming language that allows you to retrieve and manipulate data from a database