Concepts Flashcards
The collection, transformation, and organization of data in order to draw conclusions, make predictions and drive informed decision making.
Data Analysis
What are the six steps of the data analysis process?
Ask Prepare Process Analyze Share Act
The various elements that interact with one another to produce, manage, store, organize, analyze and share data.
Data Ecosystem
The graphical representation of information.
Visualization
A method for examining and calculating how a process works currently in order to get where you want to be in the future
Gap Analysis
What is the life cycle of data?
Plan Capture Manage Analyze Archive Destroy
A collection of data stored in a computer system
Database
People who have invested time and resources into a project and are interested in the outcome.
Stakeholders
A characteristic or quality of data used to label a column in a table.
Attribute
All of the attributes for something contained in a row of a data table
Observation
A unique set of guidelines for a programming language
Syntax
What is the basic SQL structure?
SELECT [choose from the column you want]
FROM [from the appropriate table]
WHERE [a certain condition is met]
The process of recognizing the current problem or situation, organizing available information, revealing gaps and opportunities, and identifying the options
Structured thinking
The specific and objective measures of numerical facts. This is often the what, how many, and how often about a problem.
Quantitative data
Subjective or explanatory measures of qualities and characteristics or things that can’t be measured with numerical data. Used to answer why questions
Qualitative data
A static collection of data given to stakeholders periodically.
Report
Monitors live incoming data
Dashboard
A data summarization tool that is used to summarize, sort, recognize, group, count, total or average data stored in a database
Pivot table
A single quantifiable type of data that can be used for measurement.
Metric
What are the metrics used in ROI (Return on Investment)?
Profit and Investments
What are the types of dashboards?
Strategic- focuses on long term goals and strategies at the highest level of metrics
Operational- short term performance tracking and intermediate goals
Analytical- consists of the datasets and the mathematics used in those sets
Something made up of specific metrics over a short, well-defined period of time and used to make day-to-day decisions.
Small data
Large less specific datasets covering a long period of time and usually have to be broken down and analyzed.
Big data
A collection of two or more cells
Range
An agreed upon outline of the work you’re going to perform on a project
Scope of Work (SOW)
What is the format of SOW
Deliverables
Milestones
Timeline
Reports
Small files stored on computers that contain information about users
Cookies