Data Analysis Process
This step of the data analysis process involves defining the problem to be solved and understanding stakeholder expectations
What is ask?
The data analysis process and data life cycle share this 4th step
What is analyze?
A set of instructions that perform a specific calculation using data in a spreadsheet
What is a formula?
Also used to store data, this tool can help with creating data visuals too
What is Spreadsheets?
A collection of facts
What is data?
Data visualization is especially important during this step of the data analysis process
What is share?
During this phase of the life cycle, a university system gathers historical academic data from an outside database and information from the internal records of student applications.
What is capture?
This programming language lets data analysts communicate with a database through queries
What is Structured Query Language (SQL)?
The 4 main types of data visuals data analysts use
What are graphs, maps, tables, and charts?
Using facts to guide business strategy
Data-driven decision-making
During the ___ step of the data analysis process, data analysts use tools such as spreadsheets to draw useful conclusions
What is analyze?
This step of the life cycle involves deciding where to store data, determining how to best maintain data, and thinking about what tools can be used to keep data safe
What is manage?
A preset command that automatically performs a specific process or task using the data in a spreadsheet
What is a function?
This tool creates easy-to-understand visuals including interactive graphs in dashboards and worksheets
What is Tableau?
How information is organized
What is data design?
During this step of the process, a data professional fixes typos and inaccuracies from a dataset containing feedback and ratings. They also verify and share their data-cleaning procedures with stakeholders.
What is process?
Software used to destroy data stored on a hard drive
What is data-erasure software?
This program works best when dealing with larger and more complex data
What are databases?
This tool creates visuals based on the results of a query and communicates directly with a database
What is Looker?
A method for examining and evaluating the current state of a process in order to identify opportunities for improvement in the future
What is gap analysis?
The 6 steps of the data analysis process, in order
What is ask, prepare, process, analyze, share, and act?
The 6 steps of the data life cycle, in order
What is plan, capture, manage, analyze, archive, and destroy?
Spreadsheets structure data in a row and column format, databases structure data using ___ and ___
What are rules and relationships?
Data visualizations help to identify ___ in data and gain ___ more quickly
What are patterns and insights?
The ability to break things down into smaller steps or pieces and work with them in an orderly and logical way
What is a technical mindset?