Google Data Analytics Professional Training Course

Foundations: Data, Data, Everywhere

• Define and explain key concepts involved in data analytics for government, including data, data analysis, and the data ecosystem.

• Conduct an analytical thinking self-assessment, providing specific examples of how analytical thinking is applied in a governmental context.

• Discuss the role of spreadsheets, query languages, and data visualization tools in data analytics for government operations.

• Describe the role of a data analyst with specific reference to jobs and positions within government agencies.

Ask Questions to Make Data-Driven Decisions

• Explain how each step of the problem-solving roadmap contributes to common analysis scenarios in government decision-making processes.

• Discuss the use of data in the decision-making process for government operations and policy formulation.

• Demonstrate the use of spreadsheets to complete basic tasks of a data analyst, including entering and organizing data for government purposes.

• Describe the key ideas associated with structured thinking in the context of governmental data analysis.

Prepare Data for Exploration

• Explain factors to consider when making decisions about data collection for government initiatives and programs.

• Discuss the difference between biased and unbiased data in the context of governmental research and policy analysis.

• Describe databases with references to their functions and components, particularly as they relate to government data management systems.

• Describe best practices for organizing data within government agencies to ensure efficiency and accuracy.

Process Data from Dirty to Clean

• Define data integrity with reference to types of integrity and the risks to data integrity in governmental databases.

• Apply basic SQL functions for use in cleaning string variables in a government database.

• Develop basic SQL queries for use on government databases to ensure data accuracy and reliability.

• Describe the process involved in verifying the results of cleaning data for government use.

Analyze Data to Answer Questions

• Discuss the importance of organizing data before analysis, with references to sorts and filters used in government datasets.

• Demonstrate an understanding of what is involved in the conversion and formatting of data for government reports and analyses.

• Apply the use of functions and syntax to create SQL queries for combining data from multiple database tables in a governmental context.

• Describe the use of functions to conduct basic calculations on data in spreadsheets, specifically for government reporting purposes.

Share Data Through the Art of Visualization

• Describe the use of data visualizations to communicate data and the results of data analysis within government agencies.

• Identify Tableau as a data visualization tool and understand its applications in government data presentation.

• Explain what data-driven stories are, including their importance and attributes in the context of government communication.

• Explain principles and practices associated with effective presentations for government audiences.

Data Analysis with R Programming

• Describe the R programming language and its programming environment, particularly as it is used in government data analysis.

• Explain the fundamental concepts associated with programming in R, including functions, variables, data types, pipes, and vectors, for government applications.

• Describe the options for generating visualizations in R for governmental reporting and analysis.

• Demonstrate an understanding of the basic formatting of R Markdown to create structured and emphasized content for government documents.

Google Data Analytics Capstone: Complete a Case Study

• Differentiate between a capstone, case study, and a portfolio in the context of data analysis projects for government agencies.

• Identify the key features and attributes of a completed case study that are relevant to government operations and decision-making.

• Apply the practices and procedures associated with the data analysis process to a given set of data for government use.

• Discuss the use of case studies and portfolios when communicating with recruiters and potential employers in government agencies.