Google Data Analytics Certificate Flashcards

1
Q

Data

A

A Collection of Facts

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Data Analysis

A

The collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision making.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Data Analyst

A

Someone who collects, transforms, and organizes data in order to help make informed decisions.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Sherlock Holmes via Sir arthur Conan Doyle

A

Data! Data! Data!… I can’t make bricks without clay!

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Data Analytics

A

The Science of data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Program Features

A

1) Video vignettes
2) Data Journal
3) Readings
4) Activities
5) Discussion Prompts

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Course-1 Foundations

A

What you will learn:
1) Real-Life roles and responsibilities of a junior data analyst.
2) How businesses transform data into actionable insights.
3) Spreadsheet basics
4) Database and query basics.
5) Data visualization basics.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Skill sets you will build:

A

1) Using data in everyday life
2) Thinking analytically
3) Applying tools from the data analytics toolkit
4) Showing trends and patterns with data visualizations.
5) Ensuring you data analysis is fair.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Course-2 Ask

A

What you will learn:
1) How data analysts solve problems with data.
2) The use of analytics for making data-driven decisions.
3) Spreadsheet formulas and functions.
4) Dashboard basics, including an introduction to tableau.
5) Data reporting basics

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Skills set you will build:

A

1) Asking SMART and effective questions.
2) Structuring how you think
3) Summarizing data
4)Putting things into context
5) Managing team and stakeholder expectations.
6) Problem-solving and conflict-resolution.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Course-3 Prepare

A

What you will learn:
1) How data is generated
2) Features of different data types, fields, and values.
3) Database structures
4) The function of metadata in data analytics
5) Structured Query Language(SQL) functions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Skill sets you will build:

A

1) Ensuring ethical data analysis practices.
2) Addressing issues of bias and credibility.
3) Accessing databases and importing data.
4) Writing simple queries
5) Organizing and protecting data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Course-4 Process

A

What you will learn:
1) Data integrity and the importance of clean data.
2) The tools and processes used by data analysts to clean data.
3) Data-cleaning verification and reports.
4) Statistics, hypothesis testing, and margin of error.
5) Resume building and interpretation of job postings (optional)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Skill sets you will build:

A

1) Connecting business objectives to data analysis.
2) Identify clean and dirty data.
3) Cleaning small datasets using spreadsheet tools.
4) Cleaning large datasets by writing SQL queries.
5) Documenting data- Cleansing processes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Course-5 Analyze

A

What you will learn:
1) Steps data analysts take to organize data.
2) How to combine data from multiple sources.
3) Spreadsheet calculations and pivot tables.
4) SQL calculations
5) Temporary tables
6) Data validation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Skills sets you will Build:

A

1) Sorting data in spreadsheets and by writing SQL queries.
2) Filtering data in spreadsheets and by writing SQL queries.
3) Converting data
4) Formatting data
5) Substantiating data analysis processes
6) Seeking feedback and support from others during data analysis.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Course-6 Share

A

What you will learn:
1) Design thinking
2) How data analysts use visualizations to communicate about data.
3) The benefits of tableau for presenting data analysis findings.
4) Data-driven storytelling
5) Dashboards and dashboard filters.
6) Strategies for creating an effective data presentation.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Skills sets you will build:

A

1) Creating visualizations and dashboards in Tableau.
2) Addressing accessibility issues when communicating about data.
3) Understanding the purpose of different business communication tools.
4) Telling a data-driven story
5) Presenting to others about data.
6) Answering questions about data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Course-7 Act

A

What you will learn:
1) Programming languages and environments.
2) R packages
3) R functions, variables, data types, pipes, and vectors
4) R data frames
5) Bias and credibility in R
6) R Visualization tools
7) R Markdown for documentation, creating structure, and emphasis.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Skill sets you will build:

A

1) Coding in R
2) Writing functions in R
3) Accessing data in R
4) Cleaning data In R.
5) Generating data visualizations in R.
6) Reporting on data analysis to stakeholders.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Course- 8 Capstone

A

What you will lean:
1) How a data analytics portfolio distinguishes you from other candidates.
2) Practical, real-world problem,-solving.
3)Strategies for extracting insights from data
4) Clear presentation of data findings.
5) Motivation and ability to take initiative.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Skills sets you will build:

A

1) Building a portfolio
2) Increasing your employability
3) Showcasing your data analytics knowledge, skill, and technical expertise.
4) Sharing your work during an interview
5) Communicating you unique value proposition to a potential employer.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Businesses use ways to control data

A

1) Improve processes
2) Identify opportunities and trends
3) Launch new products
4) Server customers
5 ) Make thoughtful decisions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Data ecosystems

A

The various elements that interact with one another in order to produce, manage, store, organize, analyze, and share data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Cloud
A place to keep data online, rather than a computer hard drive.
26
Data Science
Creating new ways of modeling and understanding the unknown by using raw data.
27
Data analytics
The science of data
28
Data-Driven decision-making
Using facts to guide business strategy
29
Dataset
A collection of data that can be manipulated or analyzed as one unit.
30
Analytical skills
Qualities and characteristics associated with solving problems using facts.
31
Analytical skill set 5 Essential Points
1) Curiosity 2) Understanding context 3) Having a technical mindset 4) Data design 5) Data strategy
32
Context
The condition in which something exists or happens .
33
A technical mindset
The ability to break things down into smaller steps or pieces and work with them in an orderly and logical way.
34
Data Design
How you organize information
35
Data strategy
The Management of people, processes and tools used in data analysis.
36
Analytical skills
The qualities and characteristics associated with solving problems using facts.
37
A technical Mindset
The analytical skill that involves breaking processes down into smaller steps and working with them in an orderly and logical way.
38
Data design
The analytical skill that involves how you organize information.
39
Understanding context
The analytical skill that has to do with how you group things into categories.
39
Data Strategy
The analytical skill that involves managing the processes and tools used in data analysis.
40
Analytical thinking
Identifying and defining a problem and then solving it by using data in an organized step-by-step manner.
41
5 aspects of Analytical thinking
1) Visualization 2) Strategy 3)Problem- orientation 4) Correlation 5) Big-Picture and detail-oriented thinking
42
Visualization
The graphical representation of information
43
Correlation does not equal causation
44
Root cause
The reason why a problem occurs
45
The 5 whys
Ask. Why? Five times to reveal the root cause.
46
Gap analysis
A method for examining and evaluating how a process works currently in order in order to get where you want to be in the future.
47
Data-Driven decision-making
Using facts to guide business strategy
48
What is a quartile?
A quartile divides data points into four equal parts.
48
What is a quartile?
A quartile divides data points into four equal parts.
49
What are non-profits?
Non-Profits are organizations dedicated to advancing a social cause or advocating for a particular effort.
50
Life-cycle of data
1) Planning 2) Capture 3) Manage 4) Analyze 5) Archive 6) Destroy
51
Database
A collection of data stored in a computer system.
52
Archive
Storing data in place where its still available but might not be used again.
53
Plan
Decide what Kind of data is needed, how it will be managed, who will be responsible for it.
54
Capture
Collect or bring in data from a variety of different sources.
55
Manage
Care for and maintain the data. This includes determining how and where it is stored and the tools used to do so.
56
Analyze
Use the data to solve problems, and support business goals.
57
Archive
Keep relevant data stored for long-term and future reference.
58
Destory
Remove data from storage and delete any shared copies of the data.
59
Stakeholders
People who have invested time and resources into a project and are interested in the outcome.
60
Defining a Problem
Look at the current state and identify how its different from the ideal state.
61
Data Analyst Tools
1) Spreadsheets 2) Query language s for databases 3) Visualization tools
62
2 Popular spreadsheet options
1) Microsoft excel 2) Google sheets
63
Formula
A set of instructions that performs a specific calculation using the data in a spreadsheet.
64
Function
A Preset command that automatically performs a specific process or task using the data in a spreadsheet.
65
Query language
A computer programming language that allows you to retrieve and manipulate data from a database.
66
Structured query language
67
Data Visualization
The graphical representation of information.
68
Some Popular Visualization tools
1) Tableau 2) Looker
69
Attribute
A characteristic or quality of data used to label a column in a table.
70
Observation
All of the attributes for something contained in a row of a data table.
71
SQL
1) Store 2) Organize 3) Analyze
72
Examples Include:
1) Oracle 2) MY SQL 3) PostgreSQL 4) Microsoft SQL Server
73
Query
A request for data or information from a database.
74
Your data analysis tools (so far)
1) Spreadsheets 2) SQL 3) Data visualization tools
75
What you will learn?
1) Role of a data Analyst 2) Business tasks for data analysts 3) Fairness in analysis 4) Opportunities for you 5) And your future success!
76
Use of data analyst Skills in various industries
1) Technology 2) Marketing 3) Finance 4) Heath-care
77
Roles of a data analyst
1) Technology 2) Finance 3) Healthcare 4)Government
78
Roles of a data analyst
Use geographic data to power GPS technology in cars.
79
Issue
A topic or subject to investigate
80
Question
Designed to discover information
81
Problem
An obstacle or complication that needs to be worked out
82
Business task
The question or problem data analysis answers for a business.
83
Business task example
Analyze weather data from the last decade to identify predictable patterns
84
Fairness
Ensuring that your analysis doesn't create or reinforce bias
85
Dream Job Factors
1) Industry 2) Tools 3) Location 4) Travel 5) Culture
86
Revenue data can used in 3 different ways.
1) Financial services 2) Telecom 3) Tech