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