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 a self-assessment of analytical thinking skills, providing specific examples of how these skills are applied in a public sector context.
-
Discuss the role of spreadsheets, query languages, and data visualization tools in data analytics for government.
-
Describe the responsibilities of a data analyst with specific reference to job roles within the public sector.
Ask Questions to Make Data-Driven Decisions
-
Explain how each step of the problem-solving framework contributes to common analysis scenarios in government settings.
-
Discuss the role of data in the decision-making process for government agencies.
-
Demonstrate the use of spreadsheets to complete basic tasks of a data analyst, including entering and organizing data.
-
Describe key principles associated with structured thinking in a public sector environment.
Prepare Data for Exploration
-
Explain factors to consider when making decisions about data collection for government initiatives.
-
Discuss the difference between biased and unbiased data in the context of public sector projects.
-
Describe databases with references to their functions and components, focusing on applications relevant to government operations.
-
Outline best practices for organizing data to support efficient analysis for government purposes.
Process Data from Dirty to Clean
-
Define data integrity with reference to types of integrity and risks to data integrity in a public sector setting.
-
Apply basic SQL functions for cleaning string variables in a database, tailored to government data sets.
-
Develop basic SQL queries for use on government databases to support data integrity and accuracy.
-
Describe the process involved in verifying the results of cleaning data to ensure reliability for government reporting.
Analyze Data to Answer Questions
-
Discuss the importance of organizing data before analysis, with specific references to sorting and filtering techniques used in government contexts.
-
Demonstrate an understanding of what is involved in converting and formatting data for government reports and analyses.
-
Apply functions and syntax to create SQL queries that combine data from multiple database tables, supporting comprehensive analysis for government projects.
-
Describe the use of functions to conduct basic calculations on data in spreadsheets, tailored to public sector applications.
Share Data Through the Art of Visualization
-
Explain how data visualizations can be used to communicate findings and results of data analysis for government stakeholders.
-
Identify Tableau as a data visualization tool and understand its applications in the public sector.
-
Explain what data-driven stories are, including their importance and attributes, with examples relevant to government communications.
-
Describe principles and practices associated with effective presentations for government audiences.
Data Analysis with R Programming
-
Describe the R programming language and its environment, highlighting its applications in government data analysis.
-
Explain fundamental concepts associated with programming in R, including functions, variables, data types, pipes, and vectors, as they pertain to public sector projects.
-
Describe the options for generating visualizations in R, focusing on their utility for government reporting.
-
Demonstrate an understanding of basic formatting techniques using 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 portfolio in the context of public sector data analysis projects.
-
Identify key features and attributes of a completed case study that are relevant to government stakeholders.
-
Apply practices and procedures associated with the data analysis process to a given set of data, tailored to a public sector scenario.
-
Discuss how case studies and portfolios can be used to communicate effectively with recruiters and potential employers in government roles.
Requirements
- No degree or experience is required for government.
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.
