Google Data Analytics study guide
Google Data Analytics · Work through your exam, one topic at a time.
The Google Data Analytics Certificate is a self-paced, fully online professional certificate delivered on Coursera. It is a foundational credential for people who want to prepare, process, analyze, and visualize data in an entry-level analytics role. The Google Data Analytics study guide has 8 sections and about 2,435 words.
01Foundations: Data, Data, Everywhere
Data is a collection of facts; information is data that has been processed, organized, and given context so it can drive a decision. Candidates must know the six-phase data analysis lifecycle - Ask, Prepare, Process, Analyze, Share, Act - and what happens in each.
321 words, about 2 min02Ask Questions to Make Data-Driven Decisions
The Ask phase converts a vague business concern into a well-scoped question. Use SMART criteria: Specific , Measurable , Action-oriented , Relevant , and Time-bound .
307 words, about 2 min03Prepare Data for Exploration
Preparation is about finding data that is reliable and appropriate. Classify sources by party : first-party data is collected directly by you, second-party data is collected by another organization and shared with you (often a partner), and third-party data comes from an outside aggregator or provider.
332 words, about 2 min04Process Data from Dirty to Clean
Cleaning is where analysts spend most of their time. Dirty data includes missing values, duplicates, misspellings, inconsistent formats or units, stray whitespace, outliers, and values that fail business rules.
283 words, about 1 min05Analyze Data to Answer Questions
Analysis means aggregating, comparing, and testing data to answer the Ask-phase question. Core operations are filter , sort , group , and calculate .
275 words, about 1 min06Share Data Through the Art of Visualization
Visualization translates findings into something an audience can act on. Match the chart to the question: bar charts compare categories, line charts show change over time, pie charts show parts of a whole (only with a few slices), scatter plots reveal relationships between two numeric variables, and histograms show the distribution of one numeric variable across bins.
303 words, about 2 min07Introduction to Data Analysis Using Python
Python analysis centers on Jupyter notebooks and the pandas library. A DataFrame is a two-dimensional labeled table; a Series is a single labeled column.
298 words, about 1 min08Data Analytics Capstone Project: Complete a Case Study
The capstone asks you to run the full lifecycle on a self-chosen dataset and present it as a portfolio case study. The work is judged on process as much as outcome.
316 words, about 2 min