- Google Data Analytics Professional Certificate Personal Repository.
- All assignments, challenges, and capstones have been done.
- Case Study Completed - Case Study 2: How can a wellness company play it smart?
- Spreadsheet
- Data Cleansing
- Data Analysis
- Data Visualization (DataViz)
- SQL
- Questioning
- Decision-Making
- Problem Solving
- Metadata
- Data Collection
- Data Ethics
- Sample Size Determination
Prepare for a new career in the high-growth field of data analytics, no experience or degree required. Get professional training designed by Google and have the opportunity to connect with top employers. There are 337,400 U.S. job openings in data analytics with a $67,900 average entry-level salary.¹
Data analytics is the collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision making.
Over 8 courses, gain in-demand skills that prepare you for an entry-level job. You’ll learn from Google employees whose foundations in data analytics served as launchpads for their own careers. At under 10 hours per week, you can complete the certificate in less than 6 months.
You’ll prepare yourself for jobs that include junior or associate data analyst, database administrator, and more. Upon completion of the certificate, you can directly apply for jobs with Google and over 130 U.S. employers, including Walmart, Best Buy, Astreya.
This program includes over 180 hours of instruction and hundreds of practice-based assessments, which will help you simulate real-world data analytics scenarios that are critical for success in the workplace. The content is highly interactive and exclusively developed by Google employees with decades of experience in data analytics. Through a mix of videos, assessments, and hands-on labs, you’ll get introduced to analysis tools and platforms and key analytical skills required for an entry-level job.
Skills you’ll gain will include: Data cleaning, problem solving, critical thinking, data ethics, and data visualization
Platforms and tools you will learn include: Presentations, Spreadsheets, SQL, Tableau and R Programming
In addition to expert training and hands-on projects, you'll complete a case study that you can share with potential employers to showcase your new skill set. Learn concrete skills that top employers are hiring for right now.
Foundations: Data, Data, Everywhere
This is the first course in the Google Data Analytics Certificate. These courses will equip you with the skills you need to apply to introductory-level data analyst jobs. Organizations of all kinds need data analysts to help them improve their processes, identify opportunities and trends, launch new products, and make thoughtful decisions. In this course, you’ll be introduced to the world of data analytics through hands-on curriculum developed by Google. The material shared covers plenty of key data analytics topics, and it’s designed to give you an overview of what’s to come in the Google Data Analytics Certificate. Current Google data analysts will instruct and provide you with hands-on ways to accomplish common data analyst tasks with the best tools and resources.
Learners who complete this certificate program will be equipped to apply for introductory-level jobs as data analysts. No previous experience is necessary.
By the end of this course, you will:
- Gain an understanding of the practices and processes used by a junior or associate data analyst in their day-to-day job.
- Learn about key analytical skills (data cleaning, data analysis, data visualization) and tools (spreadsheets, SQL, R programming, Tableau) that you can add to your professional toolbox.
- Discover a wide variety of terms and concepts relevant to the role of a junior data analyst, such as the data life cycle and the data analysis process.
- Evaluate the role of analytics in the data ecosystem.
- Conduct an analytical thinking self-assessment.
- Explore job opportunities available to you upon program completion, and learn about best practices in the job search.
Ask Questions to Make Data-Driven Decisions
This is the second course in the Google Data Analytics Certificate. These courses will equip you with the skills needed to apply to introductory-level data analyst jobs. You’ll build on your understanding of the topics that were introduced in the first Google Data Analytics Certificate course. The material will help you learn how to ask effective questions to make data-driven decisions, while connecting with stakeholders’ needs. Current Google data analysts will continue to instruct and provide you with hands-on ways to accomplish common data analyst tasks with the best tools and resources.
Learners who complete this certificate program will be equipped to apply for introductory-level jobs as data analysts. No previous experience is necessary.
By the end of this course, you will:
- Learn about effective questioning techniques that can help guide analysis.
- Gain an understanding of data-driven decision-making and how data analysts present findings.
- Explore a variety of real-world business scenarios to support an understanding of questioning and decision-making.
- Discover how and why spreadsheets are an important tool for data analysts.
- Examine the key ideas associated with structured thinking and how they can help analysts better understand problems and develop solutions.
- Learn strategies for managing the expectations of stakeholders while establishing clear communication with a data analytics team to achieve business objectives.
Prepare Data for Exploration
This is the third course in the Google Data Analytics Certificate. These courses will equip you with the skills needed to apply to introductory-level data analyst jobs. As you continue to build on your understanding of the topics from the first two courses, you’ll also be introduced to new topics that will help you gain practical data analytics skills. You’ll learn how to use tools like spreadsheets and SQL to extract and make use of the right data for your objectives and how to organize and protect your data. Current Google data analysts will continue to instruct and provide you with hands-on ways to accomplish common data analyst tasks with the best tools and resources.
Learners who complete this certificate program will be equipped to apply for introductory-level jobs as data analysts. No previous experience is necessary.
By the end of this course, you will:
- Find out how analysts decide which data to collect for analysis.
- Learn about structured and unstructured data, data types, and data formats.
- Discover how to identify different types of bias in data to help ensure data credibility.
- Explore how analysts use spreadsheets and SQL with databases and data sets.
- Examine open data and the relationship between and importance of data ethics and data privacy.
- Gain an understanding of how to access databases and extract, filter, and sort the data they contain.
- Learn the best practices for organizing data and keeping it secure.
Process Data from Dirty to Clean
This is the fourth course in the Google Data Analytics Certificate. These courses will equip you with the skills needed to apply to introductory-level data analyst jobs. In this course, you’ll continue to build your understanding of data analytics and the concepts and tools that data analysts use in their work. You’ll learn how to check and clean your data using spreadsheets and SQL as well as how to verify and report your data cleaning results. Current Google data analysts will continue to instruct and provide you with hands-on ways to accomplish common data analyst tasks with the best tools and resources.
Learners who complete this certificate program will be equipped to apply for introductory-level jobs as data analysts. No previous experience is necessary.
By the end of this course, you will be able to do the following:
- Learn how to check for data integrity.
- Discover data cleaning techniques using spreadsheets.
- Develop basic SQL queries for use on databases.
- Apply basic SQL functions for cleaning and transforming data.
- Gain an understanding of how to verify the results of cleaning data.
- Explore the elements and importance of data cleaning reports.
Analyze Data to Answer Questions
This is the fifth course in the Google Data Analytics Certificate. These courses will equip you with the skills needed to apply to introductory-level data analyst jobs. In this course, you’ll explore the “analyze” phase of the data analysis process. You’ll take what you’ve learned to this point and apply it to your analysis to make sense of the data you’ve collected. You’ll learn how to organize and format your data using spreadsheets and SQL to help you look at and think about your data in different ways. You’ll also find out how to perform complex calculations on your data to complete business objectives. You’ll learn how to use formulas, functions, and SQL queries as you conduct your analysis. Current Google data analysts will continue to instruct and provide you with hands-on ways to accomplish common data analyst tasks with the best tools and resources.
Learners who complete this certificate program will be equipped to apply for introductory-level jobs as data analysts. No previous experience is necessary.
By the end of this course, you will:
- Learn how to organize data for analysis.
- Discover the processes for formatting and adjusting data.
- Gain an understanding of how to aggregate data in spreadsheets and by using SQL.
- Use formulas and functions in spreadsheets for data calculations.
- Learn how to complete calculations using SQL queries.
Share Data Through the Art of Visualization
This is the sixth course in the Google Data Analytics Certificate. These courses will equip you with the skills needed to apply to introductory-level data analyst jobs. You’ll learn how to visualize and present your data findings as you complete the data analysis process. This course will show you how data visualizations, such as visual dashboards, can help bring your data to life. You’ll also explore Tableau, a data visualization platform that will help you create effective visualizations for your presentations. Current Google data analysts will continue to instruct and provide you with hands-on ways to accomplish common data analyst tasks with the best tools and resources.
Learners who complete this certificate program will be equipped to apply for introductory-level jobs as data analysts. No previous experience is necessary.
By the end of this course, you will:
- Examine the importance of data visualization.
- Learn how to form a compelling narrative through data stories.
- Gain an understanding of how to use Tableau to create dashboards and dashboard filters.
- Discover how to use Tableau to create effective visualizations.
- Explore the principles and practices involved with effective presentations.
- Learn how to consider potential limitations associated with the data in your presentations.
- Understand how to apply best practices to a Q&A with your audience.
Data Analysis with R Programming
This course is the seventh course in the Google Data Analytics Certificate. These courses will equip you with the skills needed to apply to introductory-level data analyst jobs. In this course, you’ll learn about the programming language known as R. You’ll find out how to use RStudio, the environment that allows you to work with R. This course will also cover the software applications and tools that are unique to R, such as R packages. You’ll discover how R lets you clean, organize, analyze, visualize, and report data in new and more powerful ways. Current Google data analysts will continue to instruct and provide you with hands-on ways to accomplish common data analyst tasks with the best tools and resources.
Learners who complete this certificate program will be equipped to apply for introductory-level jobs as data analysts. No previous experience is necessary.
By the end of this course, you will:
- Examine the benefits of using the R programming language.
- Discover how to use RStudio to apply R to your analysis.
- Explore the fundamental concepts associated with programming in R.
- Explore the contents and components of R packages including the Tidyverse package.
- Gain an understanding of dataframes and their use in R.
- Discover the options for generating visualizations in R.
- Learn about R Markdown for documenting R programming
Google Data Analytics Capstone: Complete a Case Study
This course is the eighth course in the Google Data Analytics Certificate. You’ll have the opportunity to complete an optional case study, which will help prepare you for the data analytics job hunt. Case studies are commonly used by employers to assess analytical skills. For your case study, you’ll choose an analytics-based scenario. You’ll then ask questions, prepare, process, analyze, visualize and act on the data from the scenario. You’ll also learn other useful job hunt skills through videos with common interview questions and responses, helpful materials to build a portfolio online, and more. Current Google data analysts will continue to instruct and provide you with hands-on ways to accomplish common data analyst tasks with the best tools and resources.
Learners who complete this certificate program will be equipped to apply for introductory-level jobs as data analysts. No previous experience is necessary.
By the end of this course, you will:
- Learn the benefits and uses of case studies and portfolios in the job search.
- Explore real world job interview scenarios and common interview questions.
- Discover how case studies can be a part of the job interview process.
- Examine and consider different case study scenarios.
- Have the chance to complete your own case study for your portfolio.
