C2-M1 - Google Data Analytics Certificate Roadmap

What You Will Learn:
- Real life roles and responsibilities of a junior data analyst.
- How businesses transform data into actionable insights.
- Basics of spreadsheets, databases, and queries.
- Introduction to data visualization basics.
Skill Sets You Will Build:
- Using data in everyday life.
- Thinking analytically and applying tools from the data analytics toolkit.
- Showing trends and patterns through data visualizations, ensuring fair data analysis.

What You Will Learn:
- How data analysts solve problems with data.
- Utilizing analytics for data-driven decisions.
- Spreadsheet formulas, functions, and dashboard basics, including Tableau.
- Basics of data reporting.
Skill Sets You Will Build:
- Asking smart and effective questions.
- Structuring thoughts and summarizing data.
- Contextualizing data, managing team expectations, problem-solving, and conflict resolution.

What You Will Learn:
- Generation of data, features of different data types, fields, and values.
- Database structures and the function of metadata in data analytics.
- Structured Query Language (SQL) functions.
Skill Sets You Will Build:
- Ensuring ethical data analysis practices.
- Addressing bias and credibility issues.
- Accessing databases, importing data, and writing simple queries.
- Organizing and protecting data, engaging with the data community.

What You Will Learn:
- Importance of data integrity and clean data.
- Tools and processes for data cleaning, verification, and reporting.
- Basics of statistics, hypothesis testing, and margin of error.
- Resume building and job posting interpretation.
Skill Sets You Will Build:
- Connecting business objectives to data analysis.
- Identifying clean vs. dirty data.
- Cleaning small datasets with spreadsheets and large datasets using SQL.
- Documenting data cleaning processes.

What You Will Learn:
- Steps to organize data and combine data from multiple sources.
- Spreadsheet calculations, pivot tables, and SQL calculations including temporary tables.
- Data validation techniques.
Skill Sets You Will Build:
- Sorting and filtering data in spreadsheets and using SQL queries.
- Converting and formatting data for analysis.
- Substantiating data analysis processes and seeking feedback from peers.

What You Will Learn:
- Design thinking for data visualizations.
- Benefits of using Tableau for presenting data analysis findings.
- Deep dive into data-driven storytelling, dashboards, and strategies for effective data presentation.
Skill Sets You Will Build:
- Creating visualizations and dashboards in Tableau.
- Addressing accessibility issues in data communication.
- Understanding business communication tools and presenting data-driven stories.
- Preparing to answer questions about data during presentations.

What You Will Learn:
- Programming languages and environments relevant to data analysis.
- R packages, functions, and data types.
- Overview of R data frames, bias, and credibility in R.
- Visualization tools and R markdown for documentation and emphasis.
Skill Sets You Will Build:
- Coding in R and writing functions.
- Accessing, cleaning, and visualizing data in R.
- Reporting data analysis results to stakeholders.

What You Will Learn:
- Importance of a data analytics portfolio for candidates.
- Practical problem-solving strategies for extracting data insights.
- Presenting data findings clearly.
Skill Sets You Will Build:
- Building a portfolio to enhance employability.
- Showcasing analytical knowledge, skills, and technical expertise.
- Communication of unique value propositions during interviews.