Course Outline

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.

Requirements

  • No specific degree or prior experience is required for government roles.
 35 Hours

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories