Ask Questions To Make Data Driven Decisions (Terms) Flashcards
A box in the lower-right-hand corner of a selected spreadsheet cell that can be dragged through neighboring cells in order to continue an instruction
Fill handle
A calculation that involves addition, subtraction, multiplication, or division (also called a math expression)
Equation
A calculation that involves addition, subtraction, multiplication, or division (also called an equation)
Math expression
A cell or a range of cells in a worksheet typically used in formulas and functions
Cell reference
A chart created from the fields in a pivot table
Pivot chart
A collection of two or more cells in a spreadsheet
Range
A computer programming language used to communicate with a database
Structured Query Language
A data summarization tool used to sort, reorganize, group, count, total, or average data
Pivot table
A digital worksheet
Spreadsheet
A formula that uses the metrics of investment and profit to evaluate the success of an investment
Return on investment (ROI)
A function that is used as part of a mathematical formula
Math function
A measurable goal set by a company and evaluated using metrics
Metric goal
A place to keep data online, rather than a computer hard drive
Cloud
A process or set of rules followed for a specific task
Algorithm
A question that has significance to the problem to be solved
Relevant question
A question that is simple, significant, and focused on a single topic or a few closely related ideas
Specific question
A question that makes assumptions or is difficult to answer honestly
Unfair question
A question that specifies a timeframe to be studied
Time-bound question
A question that steers people toward a certain response
Leading question
A question whose answers can be quantified and assessed
Measurable question
A question whose answers lead to change
Action-oriented question
A single, quantifiable type of data that is used for measurement
Metric
A specific and objective measure, such as a number, quantity, or range
Quantitative data
A spreadsheet function that adds the values of a selected range of cells
SUM
A spreadsheet function that counts the number of cells in a range that meet a specific criteria
COUNT
A spreadsheet function that returns an average of the values from a selected range
AVERAGE
A spreadsheet function that returns the largest numeric value from a range of cells
MAX
A spreadsheet function that returns the smallest numeric value from a range of cells
MIN
A static collection of data periodically given to stakeholders
Report
A subjective and explanatory measure of a quality or characteristic
Qualitative data
A symbol that names the operation or calculation to be performed
Operator
A tool for determining a question’s effectiveness based on whether it is specific, measurable, action-oriented, relevant, and time-bound
SMART methodology
A tool that monitors live, incoming data
Dashboard
An agreed-upon outline of the tasks to be performed during a project
Scope of work (SOW)
Data that is available to the public
Open data
Exploring different data sources to find out what they have in common
Data-inspired decision-making
Large, complex datasets typically involving long periods of time, which enable data analysts to address far-reaching business problems
Big data
Lines that can be added around two or more cells on a spreadsheet
Borders
Refer to Structured Query Language
SQL
Restating a problem or challenge, then redirecting it toward a potential resolution
Reframing
Small, specific data points typically involving a short period of time, which are useful for making day-to-day decisions
Small data
The area of analysis that encompasses every activity affecting or affected by a problem
Problem domain
The first row in a spreadsheet that labels the type of data in each column
Header
The process of arranging data into a meaningful order to make it easier to understand, analyze, and visualize
Sorting
The process of recognizing the current problem or situation, organizing available information, revealing gaps and opportunities, and identifying options
Structured thinking
The process of showing only the data that meets a specified criteria while hiding the rest
Filtering
The rate at which employees voluntarily leave a company
Turnover rate
The sequence of stages that data experiences, which include plan, capture, manage, analyze, archive, and destroy
Data life cycle
The six phases of ask, prepare, process, analyze, share, and act whose purpose is to gain insights that drive informed decision-making
Data analysis process
The total amount of income generated by the sale of goods or services
Revenue
The various problems that data analysts encounter, including categorizing things, discovering connections, finding patterns, identifying themes, making predictions, and spotting something unusual
Problem types
Using parentheses to group together spreadsheet values in order to clarify the order in which operations should be performed
Order of operations
