Foundations Flashcards
What is Data Analysis?
the collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making
What are the 6 steps of the Data Analysis process?
- Ask
- Prepare
- Process
- Analyze
- Share
- Act
What does analytical thinking involve?
involves identifying and defining a problem, then solving it by using data in an organized, step-by-step manner.
What are the 5 key aspects of thinking analytically?
- Visualization
- Strategy
- Problem-orientation
- Correlation
- Big-picture and detail-oriented thinking
What are analytical skills?
qualities and characteristics associated with solving problems using facts
What are the 5 essential aspects of analytical skills?
- Curiosity
- Understanding context
- Having a technical midset
- Data Design
- Data Strategy
What are the 6 stages of the data lifecycle?
- Planning
- Capture
- Manage
- Analyze
- Archive
- Destroy
What is the difference between the data life cycle and data analysis cycle?
Data analysis is not a lifecycle; it’s a process of analyzing data. Data life cycle provides a generic/common framework for how data is managed.
What are 3 common data analyst tools?
- Spreadsheets
- Query languages for databases
- Visualization tools
What is the purpose of spreadsheets? (3)
To collect and organize data
Help identify pattern and piece data for each specific data project
Create data visualizations (like graphs and charts)
Define query language.
a computer programming language that allows you to retrieve and manipulate data from a database
What does query language help analysts do? (3)
- Allow analysts to locate specific info from database(s)
- Easier for you to learn & understand requests made to databases
- Allow analysts to select, create add or download data from database
Define data visualization.
Graphical representation of data
(Spreadsheets) What are “columns” also known as?
Attribute
(Spreadsheets) What is a “row” also known as?
Observation
(SQL) What does SQL allow analysts to do?
SQL allows data analysts to talk to their database
(SQL) What can SQL do?
SQL can store, organize, and analyze data
SQL needs a database that understand it’s language?
True.
(SQL) What is a query?
A request for data or information from a database. When you query databases, use SQL to communicate your question/request
What is the basic syntax of a SQL query? And what do each statement do?
SELECT - choose the columns you want to return
FROM - choose the tables where the columns you want are located
WHERE - to filter for certain information
(SQL) How would you request multiple columns in query?
SELECT
Column A,
Column B,
Column C,
(SQL) How would you format multiple conditions in the WHERE clause?
WHERE
Condition 1,
AND Condition 2,
AND Condition 3,
(SQL) What does LIKE do?
allows you to tell the database to look for certain pattern
(SQL) What is “%”?
Wild card. Used to match one or more characteristics.
