1.1.1.Start the Program - sj50179/Google-Data-Analytics-Professional-Certificate GitHub Wiki

Data analysis is the collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making.

A Data analyst is someone who collects, transforms, and organizes data in order to help make informed decisions.


Program description and course syllabus

Become job-ready Every day, the amount of data out there gets bigger and bigger. So the ability to interpret it effectively is more important than ever before. Data analytics is becoming one of the fastest-growing and most rewarding career choices in the world. In the next decade, the demand for business analytics skills will probably be higher than the demand for any other career (10.9% vs. 5.2%) (Source: Bureau of Labor Statistics). All kinds of companies all over the world need qualified data analysts to solve problems and help them make the best possible business decisions. And right now, fifty-nine percent of companies have plans to add even more positions requiring data analysis skills (Source: SHRM). By the time you are done with this program, you will be well-prepared to make smart, strategic, data-driven recommendations for organizations in all kinds of industries.

During each course of the program, you will complete lots of hands-on assignments and projects based on both day-to-day life and the practical activities of a data analyst. Along the way, you will learn how to ask the right questions and understand objectives. You will also learn how to effectively clean and organize large amounts of data to make it ready for high-quality analysis. On top of that, you will get hands-on experience using all kinds of tools and techniques that will help you recognize patterns and uncover relationships between data points. And to help you communicate the results of your analysis, you will learn how to design visuals and dashboards. There is even an opportunity to create a case study, which you can highlight in your resume to show what you have learned to potential employers.

Course content

Course 1– Foundations: Data, Data, Everywhere

  1. Introducing data analytics: Data helps us make decisions, in everyday life and in business. In this first part of the course, you will learn how data analysts use tools of their trade to inform those decisions. You will also get to know more about this course and the overall program expectations.
  2. Thinking analytically: Data analysts balance many different roles in their work. In this part of the course, you will learn about some of these roles and the key skills that are required. You will also explore analytical thinking and how it relates to data-driven decision making.
  3. Exploring the wonderful world of data: Data has its own life cycle, and data analysts use an analysis process that cuts across and leverages this life cycle. In this part of the course, you will learn about the data life cycle and data analysis process. They are both relevant to your work in this program and on the job as a future data analyst. You will be introduced to applications that help guide data through the data analysis process.
  4. Setting up a data toolbox: Spreadsheets, query languages, and data visualization tools are all a big part of a data analyst’s job. In this part of the course, you will learn the basic concepts to use them for data analysis. You will understand how they work through examples provided.
  5. Discovering data career possibilities: All kinds of businesses value the work that data analysts do. In this part of the course, you will examine different types of businesses and the jobs and tasks that analysts do for them. You will also learn how a Google Data Analytics Certificate will help you meet many of the requirements for a position with these organizations.
  6. Completing the Course Challenge: At the end of this course, you will be able to put everything you have learned into perspective with the Course Challenge. The Course Challenge will ask you questions about the main concepts you have learned and then give you an opportunity to apply those concepts in two scenarios.

What to expect

Each week of the course includes a series of lessons with many types of learning opportunities. These include:

  • Videos for instructors to ****teach new concepts and demonstrate the use of tools
  • Readings to introduce new ideas and build on the concepts from the videos
  • Discussion forums to share, explore, and reinforce lesson topics for better understanding
  • Discussion prompts to promote thinking and engagement in the discussion forums
  • Practice quizzes to prepare you for graded quizzes
  • Graded quizzes to measure your progress and give you valuable feedback
  • Also, be sure to pay attention to the in-video questions that will pop up from time to time. They are designed for you to check your learning.

Data analysis process : Ask, prepare, process, analyze, share, and act.

Fill in the blank: Data is a collection of _____ that can be used to draw conclusions, make predictions, and assist in decision-making.

Answer : facts.


Google Data Analytics Certificate roadmap

Use this guide to review the topics covered, tools used, and skills you will use in each course.

F&Q

What tools or platforms are included in the curriculum? Spreadsheets, SQL, presentation tools, Tableau, RStudio, and Kaggle.

Will you be teaching R or Python? This program teaches the open-source programming language, R, which is great for foundational data analysis, and offers helpful packages for beginners to apply to their projects. We do not cover Python in the curriculum.

1. Foundations

What you will learn:

  • Real-life roles and responsibilities of a junior data analyst
  • How businesses transform data into actionable insights
  • Spreadsheet basics
  • Database and query basics
  • Data visualization basics

Skill sets you will build:

  • Using data in everyday life
  • Thinking analytically
  • Applying tools from the data analytics toolkit
  • Showing trends and patterns with data visualizations
  • Ensuring your data analysis is fair

2. Ask

What you will learn:

  • How data analysts solve problems with data
  • The use of analytics for making data-driven decisions
  • Spreadsheet formulas and functions
  • Dashboard basics, including an introduction to Tableau
  • Data reporting basics

Skill sets you will build:

  • Asking SMART and effective questions
  • Structuring how you think
  • Summarizing data
  • Putting things into context
  • Managing team and stakeholder expectations
  • Problem-solving and conflict-resolution

3. Prepare

What you will learn:

  • How data is generated
  • Features of different data types, fields, and values
  • Database structures
  • The function of metadata in data analytics
  • Structured Query Language (SQL) functions

Skill sets you will build:

  • Ensuring ethical data analysis practices
  • Addressing issues of bias and credibility
  • Accessing databases and importing data
  • Writing simple queries
  • Organizing and protecting data

4. Process

What you will learn:

  • Data integrity and the importance of clean data
  • The tools and processes used by data analysts to clean data
  • Data-cleaning verification and reports
  • Statistics, hypothesis testing, and margin of error
  • Resume building and interpretation of job postings (optional)

Skill sets you will build:

  • Connecting business objectives to data analysis
  • Identifying clean and dirty data
  • Cleaning small datasets using spreadsheet tools
  • Cleaning large datasets by writing SQL queries
  • Documenting data-cleaning processes

5. Analyze

What you will learn:

  • Steps data analysts take to organize data
  • How to combine data from multiple sources
  • Spreadsheet calculations and pivot tables
  • SQL calculations
  • Temporary tables
  • Data validation

Skill sets you will build:

  • Sorting data in spreadsheets and by writing SQL queries
  • Filtering data in spreadsheets and by writing SQL queries
  • Converting data
  • Formatting data
  • Substantiating data analysis processes
  • Seeking feedback and support from others during data analysis

6. Share

What you will learn:

  • Design thinking
  • How data analysts use visualizations to communicate about data
  • The benefits of Tableau for presenting data analysis findings
  • Data-driven storytelling
  • Dashboards and dashboard filters
  • Strategies for creating an effective data presentation

Skill sets you will build:

  • Creating visualizations and dashboards in Tableau
  • Addressing accessibility issues when communicating about data
  • Understanding the purpose of different business communication tools
  • Telling a data-driven story
  • Presenting to others about data
  • Answering questions about data

7. Act

What you will learn:

  • Programming languages and environments
  • R packages
  • R functions, variables, data types, pipes, and vectors
  • R data frames
  • Bias and credibility in R
  • R visualization tools
  • R Markdown for documentation, creating structure, and emphasis

Skill sets you will build:

  • Coding in R
  • Writing functions in R
  • Accessing data in R
  • Cleaning data in R
  • Generating data visualizations in R
  • Reporting on data analysis to stakeholders

8. Capstone

What you will learn:

  • How a data analytics portfolio distinguishes you from other candidates
  • Practical, real-world problem-solving
  • Strategies for extracting insights from data
  • Clear presentation of data findings
  • Motivation and ability to take initiative

Skill sets you will build:

  • Building a portfolio
  • Increasing your employability
  • Showcasing your data analytics knowledge, skill, and technical expertise
  • Sharing your work during an interview
  • Communicating your unique value proposition to a potential employer