Course 1: Foundations: Data, Data, Everywhere Flashcards
Data
A collection of facts
Data Analysis
A collection, transformation and organization of data, to draw conclusions make predictions and drive informed decision making
Data Analyst
Someone who collects, transforms, and organizes data in order to drive informed decision-making
Data Analytics
The science of data
Data-driven decision-making
Using facts to guide business strategy
Data ecosystem
The various elements that interact with one another in order to produce,
manage, store, organize, analyze, and share data
Data science
A field of study that uses raw data to create new ways of modelling and understanding the unknown
Dataset
A collection of data that can be manipulated or analyzed as one unit.
Analytical skills
: Qualities and characteristics associated with using facts to solve problems.
Analytical Thinking
The process of identifying and defining a problem, then solving it by using
data in an organized, step-by-step manner
Context
The condition in which something exists or happens
Gap Analysis
A method for examining and evaluating the current state of a process in order to
identify opportunities for improvement in the future
Root Cause
The reason a problem occurs.
Technical Mindset
The ability to break things down into smaller steps or pieces and work with
them in an orderly and logical way
Visualization
Refers to data visualization.
6 Stages of Data Lifecycle
- Plan
- Capture
- Manage
4: 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.
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.
Data Strategy
The management of the people, processes and tools of in data analysis
Database
A collection of datastored in a computer system
Formula
A set of instructions used to perform a calculation using data in a spreadsheet
Function
A preset command that automatically performs a specified process or task using the data in a spreadsheet
Query Language
a computer programming language used to communicate with a database
Stakeholders
people who invest time and resources into a project and are interested in its outcomes
Syntax to SQL Qeuries
The syntax of every SQL query is the same:
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.
SELECT Syntax
Use SELECT to choose the Columns you want to return
FROM Syntax
Use From to choose the tables where the columns you want are located
WHERE Syntax
Use Where to Filter for Certain Information
Attribute
A characteristic or quality of data used to label a column in a table
Data Design
How information is organized
Data Driven Decision-Making
Using facts to driven business strategy
Data Visualization
The graphical representation of data
Observation
Observation: The attributes that describe a piece of data contained in a row of a table
Query
A request for data information from a table
