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.
Testimonials (2)
The scheduling of every topic and the breaks inserted it helps in digesting the information specially to the newbie to the topic
Jerico Torres - Globe Telecom
Course - Google BigQuery
Responses with solutions and practical use.