Data Analytics: Week 3
Two popular visualization tools are __________ and __________.
Tableau and Looker
Destroy phase: this is when the company use a secure data to _____________. If there were paper files they would be _________. This is important for protecting a ____________
erasure software shredded too company's private information.
Process: Data analysts find and eliminate any _______ and ________ that can get in the way of results.
errors and inaccuracies
Analyze Phase Use tools to ___________ and _________ ________ and ________ data Identify ___________and _____________ Make ___________ and _________ Make data ___________
format and transform data Sort and filter patterns and draw conclusions prediction and recommendations driven decisions
Prepare Phase Understand how data is __________ and ___________ Identify and use different ____________, ____________ and _______ Make sure data is _____________ and ___________ ___________ and __________ data
generated and collected data formats, types and structures unbiased and credible Organize and protect
Data analysts use a number of visualization tools, like ______, _____, __________ and ____.
graphs, maps, tables, charts, and more
Manage phase: we are going to discuss ________ and ___________. The tools used to keep it safe and secure, and
how and where the data is stored
ACT Phase Apply your ___________ Solve ____________ Make ____________ Create ____________
insights problems decisions something new
Share: _______________ and _____________ results to others to make data-driven decisions
interpret and communicate
A dairy farmer decides to open an ice cream shop on her farm. After surveying the local community about people's favorite flavors, she takes the data they provided and stores it in a secure hard drive so it can be maintained safely on her computer. This is part of which phase of the data life cycle?
manage
Plan: Decide what kind of data is ________, how it will be _________, and who will be ____________
needed managed responsible for it.
Ask: define the ________and confirm ______________
problem stakeholder expectations
Archive: Keep______________ for long-term and future reference.
relevant data stored
Analyze phase: this is the phase where the data is used to ______________, ________________, and _____________
solve problems, make great decisions support business goals.
Analyze: Use the data to __________, ____________ and _________
solve problems, make decisions, and support business goals.
Query languages Allow analysts to isolate ___________ from a ____________ Make it easier for you to__________ and __________ the requests made to databases Allow analysts to _________, _______, ________ or ________ data from a database for analysis
specific information database(s) learn and understand select, create, add, or download
Depending on which phase of the data analysis process you're in, you will need to use different tools. For example, if you are focusing on creating complex and eye-catching visualizations, then the visualization tools we discussed earlier are the best choice. But if you are focusing on organizing, cleaning, and analyzing data, then you will probably be choosing between ____________ and ________________.
spreadsheets and databases using queries
The most common programs and solutions used by data analysts include ___________, __________ and ____________
spreadsheets, query languages, and visualization tools.
A database is a collection of ____________ in a computer system. Some popular Structured Query Language (SQL) programs include __________, ___________, __________
structured data stored MySQL, Microsoft SQL Server, and BigQuery.
Stakeholders are people who have invested _________ and __________ into a __________and are interested in the ___________
time and resource project outcome
Share Phase
understand visualization Create effective visuals Bring data to life Use data storytelling Communicate to help others understand results
Share phase Understand ______________ Create _______________ Bring data to ___________ Use ________________ Communicate to help others understand __________
visualization effective visuals life data storytelling results
Archiving phase: storing data in a place where it is still _________but __________________
available may not be used again
Defining a problem means that you look at the __________ and identify how it is different from the ___________
current state ideal state.
Database is a collection of __________stored in a ___________
data computer system
- Looker communicates directly with a _________, allowing you to connect your data right to the______________
database visual tool you choose
Capture phase happens when data is collected from a variety of __________ and brought into the__________
different sources organization.
- Tableau's simple _____________lets users create ____________in ___________ and _________
drag-and-drop feature interactive graphs dashboards and worksheets
Analyze: use data analysis tool to _____________
draw conclusions
ASK Phase Ask _______________ Define the ___________ Use __________________ Communicate with ______________
effective questions Problem structured thinking others
Planning happens well before starting an _______________
Analysis project
After opening the ice cream shop on her farm, the same dairy farmer then surveys the local community about people's favorite flavors. She uses the data she collected to determine that the top five flavors are strawberry, vanilla, chocolate, mint chip, and peanut butter. She feels confident in her decision to sell these flavors. This is part of which phase of the data life cycle?
Analyze
ACT Phase
Apply your insights Solve Problems Make Decisions Create something new
Data Analysis process are
Ask Prepare Process Analyze share Act
What are the the phases of data analysis
Ask Prepare Process Analyze share Act
Ask Phase
Ask effective questions Define the problem Use structured thinking communicate with others
In the data life cycle, which phase involves gathering data from various sources and bringing it into the organization?
Capture
Manage: ___________ and __________the data. This includes determining how and where it is __________and the _______________
Care for and maintain stored tools used to do so.
Capture: __________or _________in data from a variety of different sources.
Collect Bring
Spreadsheets structure data in a meaningful way by letting you ____________, _____________, _____________ and ________________ Identify _______________ and _________together in a way that works for each specific data project Create excellent data visualizations, like ___________ and ___________
Collect, store, organize and sort information patterns and piece the data graphs and charts.
Process Phase
Create and transform data Maintain data integrity Test data Clean data Verify and report on cleaning results
Process phase create and transform _____________ Maintain ______________ _________ data _________data _________ and __________ on cleaning results
Data Data integrity Test Clean Verify and report
_______________ is the graphical representation of a data
Data Visualization
A data analyst finishes using a dataset, so they erase or shred the files in order to protect private information. This is called archiving. T/F
FALSE
________________ is a set of instructions that performs a specific calculation using the data in a spreadsheet.
Formula
______________ and __________ are common for data analyst
Looker and tabelu
How the data analysis process guides this program
Memorize it honey
Data Analysis is a life cycle?
No
Act: put our insight to work in order to solve the _____________
Original problem
what is the life cycle of data
Plan Capture Manage Analyze Archive Destroy
What are some of the tools data analysts use each and everyday ?
Spreadsheets Query Languages for databases Visualizations
Be careful not to mix up or confuse the six stages of the data life cycle (________________, ______________, ______________, ______________, ____________ and ______________) with the six phases of the data analysis life cycle (_______________, ____________, ______________, _____________, _____________ and ___________). They shouldn't be used or referred to _________________
Plan, Capture, Manage, Analyze, Archive, and Destroy Ask, Prepare, Process, Analyze, Share, and Act interchangeably.
Fill in the blank: During the _____ phase of the data life cycle, a business decides what kind of data it needs, how it will be managed, who will be responsible for it, and the optimal outcomes.
Planning
_______________ is a computer programming language that allows you to retrive and manipulate data from a database?
Query Language
A career as a data analyst also involves using programming languages, like _________ and __________, which are used a lot for statistical analysis, visualization, and other data analysis.
R and Python
Destroy: _____________ and ____________ any shared copies of the data.
Remove data from storage and delete
Data analysis is the process of analyzing data T/F
True
Prepare Phase
Understand how the data is generated and collected Identify and use different data formats, types and structures Make sure data is unbiased and credible Organize and protect data
Analyze Phase
Use tools to format and transform data sort and filter data Identify patterns and draw conclusions Make predictions and recommendations Make data-driven decisions
Tableau and Looker Turn complex numbers into __________________ Help stakeholders come up with___________ that lead to informed decisions and effective_______________ Have ___________________
a story that people can understand conclusions business strategies multiple features
Process: ______ and ___________ data to ensure _________
clean and transform integrity
Data analysts rely on spreadsheets to ______ and ________. Two popular spreadsheet applications you will probably use a lot in your future role as a data analyst are ______________ and __________
collect and organize data Microsoft Excel and Google Sheets.
Prepare: _____ and __________ data for analysis
collect and store
Prepare: this is where data analyst ________ and _________ they'll use for the upcoming ___________
collect and store data analysis process