Overview
Foundations: Data, Data, Everywhere is the first of eight required courses in the Google Data Analytics Certificate. It defines data, data analysis and the data ecosystem, introduces the five aspects of analytical thinking, and separates two frameworks that sound alike: the data life cycle (plan, capture, manage, analyze, archive, destroy) and the data analysis process (ask, prepare, process, analyze, share, act). It also gives a first look at spreadsheets, SQL and visualization tools, and closes on the analyst's job and the duty to analyze fairly.
The six analysis phases become the names of Courses 2 to 6, so this course is the map for the rest of the program. If you can place any task on that map, such as writing a SMART question (ask), checking a source's credibility (prepare) or removing duplicates (process), later module challenges feel like detail added to a structure you already own.
How it's tested
Course 1 module challenges are short graded quizzes, typically multiple-choice and select-all-that-apply items built on a sentence or two of workplace context. They test classification more than calculation: which phase, which stage, which tool, which skill, or which choice is fair. Read the verb in the scenario, since 'collect', 'clean', 'store' and 'present' each point to a different phase or stage.
-
Name the phase or stage
A task such as deleting records after a retention period or presenting findings to a manager is described, and you place it in the data life cycle or the six-phase analysis process.
-
Match the tool to the job
You choose between a spreadsheet, a query language such as SQL and a visualization tool such as Tableau based on data size and what the analyst must produce.
-
Spot the fair choice
A business decision based on data is described and you identify whether it excludes or disadvantages a group, or which change would make the analysis fair.
A scenario says an analyst at a clinic has finished a report and the operations team is now changing appointment slots based on it. The question asks which analysis phase the team is in. Candidates often pick 'share' because the report was just delivered. The clue is that people are implementing a change, not receiving findings, so the phase is act. Share ends when stakeholders understand the findings; act begins when they use them.
Modules 4
Official modules from the Google outline, in outline order.
1.1 Introducing data analytics and analytical thinkingWhat data analysis is, the data ecosystem, analyst skills and the five aspects of analytical thinking.
- What it means
- Data is a collection of facts, data analysis is collecting, transforming and organizing those facts to draw conclusions and support decisions, and the data ecosystem is the set of elements that produce, manage, store, organize, analyze and share data. Analytical thinking is described through five aspects: visualization, strategy, problem-orientation, correlation, and big-picture and detail-oriented thinking.
- What to understand
- Each aspect of analytical thinking has a recognizable behavior: sketching the problem is visualization, keeping the work focused on the goal is strategy, identifying and describing the problem is problem-orientation, looking for relationships between variables is correlation, and switching between overall context and specific details is the fifth. Google also names five analyst skills: curiosity, understanding context, having a technical mindset, data design and data strategy.
- How it shows up
- A short description of an analyst's behavior, such as asking 'why' repeatedly to reach the root cause or noticing that two measures move together, asks which aspect of analytical thinking or which skill it shows.
- Common confusion
- Treating correlation as proof of cause; the course stresses that two variables moving together does not show that one causes the other.
1.2 The wonderful world of dataThe data life cycle versus the data analysis process, and the tools that move data through them.
- What it means
- The data life cycle describes what happens to data over its life: plan, capture, manage, analyze, archive and destroy. The data analysis process describes the analyst's project steps: ask, prepare, process, analyze, share and act.
- What to understand
- The life cycle is about the data itself, including storage and eventual secure deletion, while the analysis process is about answering one business question. Both contain an 'analyze' step, which is why questions about the other stages are where marks are lost.
- How it shows up
- A task such as moving old records to long-term storage (archive) or defining the business question (ask) is described, and you name the stage or phase.
- Common confusion
- Answering with an analysis phase when the question asks for a life-cycle stage, for example choosing 'process' for storing data securely, which is 'manage'.
1.3 Set up your data analytics toolboxSpreadsheets, query languages such as SQL, and data visualization tools.
- What it means
- Spreadsheets organize data in rows (observations) and columns (attributes) and calculate with formulas and functions; SQL (Structured Query Language) retrieves and manipulates data stored in databases; visualization tools such as Tableau turn results into charts and dashboards.
- What to understand
- A formula is an expression you write, such as =B2+B3, while a function is a preset command such as =SUM(B2:B10); both start with an equals sign. SQL suits data too large for a spreadsheet or stored in a relational database, and a basic query reads SELECT columns FROM table WHERE condition.
- How it shows up
- A scenario gives the size and location of a dataset and the output needed, and you choose the tool, or you identify the result of a simple formula or query clause.
- Common confusion
- Calling every spreadsheet calculation a function; a typed calculation such as =A2*0.2 is a formula, while SUM, AVERAGE and COUNT are functions.
1.4 Become a fair and impactful data professionalWhere analysts work, what they do, and how to make data-driven decisions fairly.
- What it means
- This module looks at the kinds of organizations that employ analysts, the tasks they perform, and the principle that analysis should not create or reinforce bias against any group of people.
- What to understand
- Fairness means checking who is represented in the data, who is affected by the decision, and whether the conclusion would hold for every group, not only the convenient majority. Data-driven decisions can still be unfair if the data under-represents a group.
- How it shows up
- A scenario describes a decision, such as setting staff schedules or targeting a promotion, based on data that leaves out part of the population, and you identify the fairness problem or the best fix.
- Common confusion
- Assuming that a decision is fair because it is based on data; biased or incomplete data produces confident but unfair conclusions.
High-yield concepts
The terms, rules and formulas this domain turns into questions most often.
-
Data analysis process (six phases)
Google's project framework is ask, prepare, process, analyze, share and act, and Courses 2 to 6 are named after the first five phases.
- Remember
- Ask defines the problem, prepare collects and stores data, process cleans it, analyze finds patterns, share communicates findings and act puts them to use.
- Tested as
- Phase-placement questions appear throughout the certificate and structure the capstone case study.
- Trap
- Putting cleaning in prepare; in Google's model, cleaning and integrity checks are the process phase.
-
Data life cycle
The stages data passes through in an organization: plan, capture, manage, analyze, archive and destroy.
- Remember
- Archive keeps data that is no longer in active use but must be retained; destroy removes it securely when it is no longer needed.
- Tested as
- Tested directly by naming the stage that a records-management task belongs to.
- Trap
- Mixing life-cycle stages with analysis phases because both lists contain the word 'analyze'.
-
Data ecosystem
The hardware, software, people and processes that produce, manage, store, organize, analyze and share data, such as a retailer's point-of-sale systems, cloud warehouse and reporting tools.
- Remember
- An ecosystem is the whole environment, not a single tool or dataset.
- Tested as
- Definition items in the first module challenge.
- Trap
- Choosing 'database' when the question describes the wider set of connected systems.
-
Analytical thinking (five aspects)
Visualization, strategy, problem-orientation, correlation, and big-picture and detail-oriented thinking describe how analysts approach a problem.
- Remember
- Each aspect maps to an observable behavior, such as sketching a process (visualization) or tracing related variables (correlation).
- Tested as
- Behavior-to-aspect matching questions.
- Trap
- Labeling an analyst who keeps the project on its goal as 'problem-oriented'; that behavior is strategy.
-
Five whys
A root-cause technique of asking 'why' about a problem repeatedly, usually about five times, until the underlying cause appears.
- Remember
- The goal is the root cause, not the first plausible explanation.
- Tested as
- Appears as an example of problem-solving and analytical thinking.
- Trap
- Stopping at the first answer and treating a symptom, such as late shipments, as the cause.
-
Data-driven decision-making
Using facts from data to guide business strategy, such as choosing store hours from foot-traffic counts rather than a manager's hunch.
- Remember
- Data supports the decision but still needs context and human judgment about what the numbers mean.
- Tested as
- Recurring theme across Courses 1 and 2.
- Trap
- Thinking data-driven means data alone decides with no business context.
-
Formula vs. function
A formula is a calculation you write with operators and cell references; a function is a preset command such as SUM, AVERAGE or COUNT.
- Remember
- Both start with '=' in Google Sheets and Excel, and a function can sit inside a formula.
- Tested as
- Spreadsheet basics items in Module 3.
- Trap
- Forgetting that a range such as B2:B10 uses a colon, not a comma, to mean every cell between the two.
-
SQL query structure
SELECT names the columns, FROM names the table and WHERE filters the rows that meet a condition.
- Remember
- SQL is used for large datasets in relational databases that are too big or too shared for spreadsheets.
- Tested as
- Toolbox questions and an early preview of Courses 3 to 5.
- Trap
- Choosing a spreadsheet for millions of rows held in a company database.
-
Fairness in analysis
Analysis is fair when its conclusions do not create or reinforce bias against any group, which starts with checking whose data is collected.
- Remember
- Ask who is missing from the data and who bears the impact of the decision.
- Tested as
- Module 4 scenario questions about making fair business decisions.
- Trap
- Equating 'the numbers are accurate' with 'the decision is fair'.
-
Observation and attribute
In a table, an attribute is a characteristic stored in a column, such as 'customer age', and an observation is one row with all its attribute values.
- Remember
- Columns are attributes (fields); rows are observations (records).
- Tested as
- Basic spreadsheet and dataset vocabulary.
- Trap
- Swapping rows and columns in definition items.
Side by side
Concepts candidates mix up, compared on the point that decides the answer.
Data life cycle vs. data analysis process
| Concept | Meaning | Key difference | Common trap |
|---|---|---|---|
| Data life cycle | Plan, capture, manage, analyze, archive, destroy | Describes the life of the data itself, from planning to secure deletion | Using it to label steps of a single analysis project |
| Data analysis process | Ask, prepare, process, analyze, share, act | Describes how an analyst answers one business question | Expecting archive or destroy steps in it |
Spreadsheet vs. SQL vs. Tableau
| Concept | Meaning | Key difference | Common trap |
|---|---|---|---|
| Spreadsheet | Grid of rows and columns with formulas, functions, sorting and charts | Best for small to moderate datasets that one person edits directly | Using it for very large, shared database tables |
| SQL | Query language for relational databases | Retrieves and transforms large datasets where they are stored | Thinking SQL is a charting tool |
| Tableau | Visualization and dashboard tool | Presents results visually and interactively | Choosing it to clean or query raw data |
Analytical thinking aspects
| Concept | Meaning | Key difference | Common trap |
|---|---|---|---|
| Visualization | Representing information graphically to understand it | Draws or maps the problem | Confusing it with building a final dashboard |
| Strategy | Keeping focus on the goal and what to do with the data | Steers the work toward the objective | Labeling it problem-orientation |
| Problem-orientation | Identifying, describing and solving the problem | Keeps the problem at the center | Labeling it strategy |
| Correlation | Finding relationships between variables | Spots variables that move together | Reading correlation as causation |
Exam traps
Each trap is an answer that looks right. Learn the clue that should change your mind.
-
Share versus act
- What candidates pick
- Share, for any step after the analysis is complete.
- Why it looks right
- Sharing and acting both happen after analysis and often involve the same stakeholders.
- Why it's wrong
- Share is communicating findings so stakeholders understand them; act is the organization implementing a decision based on those findings.
Clue to watch for Look for whether people are receiving information or changing what they do.
-
Prepare versus process
- What candidates pick
- Prepare, for removing duplicates or fixing typos.
- Why it looks right
- Cleaning feels like getting data ready, which sounds like preparation.
- Why it's wrong
- In Google's framework, prepare is collecting and storing data and checking its source; process is cleaning and verifying its integrity.
Clue to watch for Words such as clean, transform, remove errors or check integrity point to process.
-
Life-cycle stage answered with a project phase
- What candidates pick
- Process or prepare, for a question about storing or retaining data.
- Why it looks right
- The analysis phases are more familiar after the first module.
- Why it's wrong
- Storing and maintaining data is the manage stage, keeping it for future reference is archive, and secure deletion is destroy; these belong to the life cycle.
Clue to watch for The question says 'data life cycle' or describes retention, storage or deletion.
-
Correlation read as cause
- What candidates pick
- The option claiming one variable causes the other because they rise together.
- Why it looks right
- A clear pattern in the numbers looks like an explanation.
- Why it's wrong
- Correlation shows only that variables move together; a third factor or coincidence may explain it.
Clue to watch for Words such as 'caused', 'proves' or 'because of' attached to two trends that simply move together.
-
Biggest tool for every job
- What candidates pick
- SQL or Tableau for a small list one person maintains.
- Why it looks right
- More advanced tools sound more professional.
- Why it's wrong
- The right tool fits the data size, where the data lives and the output; a small team list is a spreadsheet job.
Clue to watch for Dataset size, whether data sits in a database, and whether the output is a calculation, a query result or a chart.
-
Accurate equals fair
- What candidates pick
- Approve the decision because the calculations are correct.
- Why it looks right
- Correct numbers seem to settle the question.
- Why it's wrong
- Fairness depends on whether the data represents everyone affected; accurate numbers from a skewed sample still produce unfair decisions.
Clue to watch for The scenario mentions that data came only from one location, shift, channel or customer group.
Answer framework
Use these steps on any Course 1 question that asks you to classify a task, tool or decision.
- Decide whether the question is about the life of the data (life cycle) or about answering a business question (analysis process).
- Find the action verb in the scenario, such as define, collect, clean, find, present or implement, and map it to one phase or stage.
- If a tool is involved, weigh dataset size, where the data is stored and whether the output is a calculation, query result or visual.
- Check any claim about cause; if the evidence only shows variables moving together, reject causal wording.
- Before choosing a decision, ask who is missing from the data and who is affected, and prefer the option that makes the analysis fair to every group.
Practice question
Want more like this? The Google Data Analytics practice test has questions for every domain.
Checklist
0 of 12
Tick each one you can do without notes. Your ticks stay in this browser.
Study strategy
Start by memorizing two lists cold: the six analysis phases (ask, prepare, process, analyze, share, act) and the six life-cycle stages (plan, capture, manage, analyze, archive, destroy). Write each on a card with one example task per step, because nearly every later course assumes you can place work on these maps without thinking.
Next, cover analytical thinking and the analyst skills by writing a one-line behavior for each aspect, such as 'drew the checkout process on a whiteboard' for visualization. That is how the module challenges phrase them. The most underestimated area is fairness in Module 4: learners skim it as soft content, then miss scenario items about data that leaves out a group.
For the toolbox module, open Google Sheets and type a few formulas and functions yourself, then read a simple SELECT, FROM, WHERE query aloud. Afterward, take a practice quiz that mixes phase-placement and tool-choice items, and move on to Course 2, where the ask phase is taught in depth.
FAQ
Is there an exam for Course 1 of the Google Data Analytics Certificate?
There is no single proctored exam for the certificate. Course 1 is assessed through graded module challenges at the end of each of its four modules, plus knowledge checks and activities along the way.
How hard is Foundations: Data, Data, Everywhere?
The concepts are introductory, but the module challenges test exact vocabulary. Most lost marks come from mixing up life-cycle stages with analysis phases rather than from difficult content.
What is the difference between the data life cycle and the data analysis process?
The life cycle (plan, capture, manage, analyze, archive, destroy) follows data through an organization over its lifetime. The analysis process (ask, prepare, process, analyze, share, act) is how an analyst answers one business question.
Do I need to know SQL or Tableau to pass Course 1?
No hands-on depth is required yet. You need to know what spreadsheets, SQL and visualization tools are for and when each fits; Courses 3 to 6 teach them properly.
How long does Course 1 take?
Coursera lists about 13 hours of content. Our planning estimate of 20 to 25 hours allows for practice and review, and is an editorial estimate, not an official figure.
Why does fairness come up in a technical course?
Because analysis drives decisions about people. The course teaches that data collected from only part of a population can make an accurate-looking analysis unfair, and later courses build on this with bias and data ethics.
How does Course 1 connect to the rest of the certificate?
Courses 2 to 6 are each named after a phase of the analysis process introduced here, and the capstone asks you to work through those phases on a real case study.
Other Data & Analytics certifications
Where the same subject shows up in other exams. Cards marked "Same subject" open the matching domain.
Test your Domain 1 knowledge
You have covered the data life cycle, the six analysis phases, analytical thinking and the analyst's toolbox. Check that you can classify tasks and tools quickly and accurately.
Keep going
- Training Training Built on your Weak areas
- Practice test Questions by domain, with explanations
- Mock exam Full length, timed like the real exam
- Readiness test Find your weakest domain in minutes
- Cheat sheet Key terms and formulas on one page
- Ask the Google Data Analytics AI tutor Get any concept explained your way