- Level Professional
- Duration 15 hours
- Course by University of Michigan
-
Offered by
About
Gain a foundational understanding of key terms and concepts in public administration and public policy while learning foundational programming techniques using the R programming language. You will learn how to execute functions to load, select, filter, mutate, and summarize data frames using the tidyverse libraries with an emphasis on the dplyr package. By the end of the course, you will create custom functions and apply them to population data which is commonly found in public sector analytics. Throughout the course, you will work with authentic public datasets, and all programming can be completed in RStudio on the Coursera platform without additional software. This is the first of four courses within the Data Analytics in the Public Sector with R Specialization. The series is ideal for current or early career professionals working in the public sector looking to gain skills in analyzing public data effectively. It is also ideal for current data analytics professionals or students looking to enter the public sector.Modules
Welcome to the Data Analytics in the Public Sector Certificate
1
Discussions
- Meet Your Fellow Learners
1
Videos
- Welcome from the University of Michigan!
3
Readings
- Certificate Road Map
- Course Syllabus
- Help Us Learn About You
Let's Get our Terms Defined and Clear
3
Videos
- What is the Public Sector & What are Public Goods/Services?
- Data Science and Data Analytics: An Introduction
- What Does Public Administration & Public Policy Mean?
3
Readings
- Course Glossary of Terms
- Meaning and Significance of Data Analytics for the Public Sector
- 7 Reasons for Policy Professionals to Get into R Programming
RStudio Lab Orientation
1
Labs
- RStudio
1
Videos
- Introduction to RStudio
Week 1 Wrap-Up
1
Assignment
- Week 1 Quiz: Introduction to Data Analytics in the Public Sector with R
1
Readings
- Week 1 Optional Readings & Resources
Core Functions of Public Administration
1
Discussions
- Public Administration Functions: Point of Reflection
5
Videos
- General Organization of Government Bureaucracies
- Examples of Government Bureaucracies
- Core Functions of Public Administration: Planning, Organizing, Staffing, & Directing
- Core Functions of Public Administration: Coordinating, Reporting, & Budgeting
- Applications of Data Analytics to Public Administration Functions
1
Readings
- POSDCORB: Important 7 Steps, Functions, Strength, Criticism
Skill Development in RStudio: Getting Started With R
1
Assignment
- Getting Started With R: Practice & Knowledge Check
7
Videos
- Getting Started with R: The Basics
- Getting started with R: The Basics of Vectorized Language
- Getting started with R: Attributes of Data
- Exploring R Dataframes: Columns as Variables
- Using Vectors to Select and Analyze Data
- Exploring R Dataframes: Dealing with Missing Values Through Boolean Masking
- Exploring R Dataframes: Creating Statistics from Cleaned Dataframe
1
Readings
- RStudio Cheat Sheet
Week 2 Wrap-Up
1
Assignment
- Week 2 Quiz: Getting Started With R
1
Videos
- One More Thing for This Week!
1
Readings
- Week 2 Optional Readings & Resources
Analysis Skills for Survey Data
2
Assignment
- Survey Data Analytics Knowledge Check
- What Analysts Need to Know: Knowledge Check
7
Videos
- Survey Data Analytics: Importance, Types and Examples of Survey Data Analytics in the Public Sector
- What Analysts Need to Know About Survey Designs & Types
- What Analysts Need to Know About Survey Deployment
- What Analysts Need to Know in Understanding Survey Data | Part 1
- What Analysts Need to Know in Understanding Survey Data | Part 2
- Example: Reading a Codebook
- Example: Dashboards
Skill Development in RStudio: Analysis Skills for Survey Data
1
Assignment
- Data Manipulation: Practice & Knowledge Check
6
Videos
- Example of a Codebook: The Behavioral Risk Factor Surveillance System
- Data Manipulation with dplyr: Tidyverse & Exploring the Data
- Data Manipulation with dplyr: Pipe Operator & Adding Variables
- Data Manipulation with dplyr: Formulas in R
- Data Analysis: Grouping by Variable
- Data Analysis: Grouping by Multiple Variables
1
Readings
- Required Resources Needed Ahead
Week 3 Wrap-Up
1
Assignment
- Week 3 Quiz: Analysis Skills for Survey Data
1
Videos
- One More Thing for This Week!
1
Readings
- Week 3 Optional Readings & Resources
Analysis Skills for Population Data
1
Assignment
- Generating & Interpreting Population Data
3
Videos
- Importance of Population Data Analytics & the Three Main Demographic Processes
- Population Data Analytics: Key Population Data Sources
- Population Data Analytics: The Answer to a Basic Population Question
Skill Development in RStudio: Analysis Skills for Population Data
2
Assignment
- Custom Analytics: Practice & Knowledge Check
- RStudio Function for Data Analysis: Practice & Knowledge Check
4
Videos
- Creating Custom Analytics
- Applying Custom Analytics to Groups
- Writing Functions
- Alternative Analytics for TDR
Week 4 Wrap-Up
1
Assignment
- Week 4 Quiz: Analysis Skills for Population Data
1
Readings
- Week 4 Optional Readings & Resources
Stories from Experts in the Field
2
Discussions
- Point of Reflection: Day to Day Role of Public Health Data
- Point of Reflection: National Security, Data & Government Bureaucracy
3
Videos
- Day-to-Day Role of Public Health Data: Interview with Joneigh Khaldun
- Interview with Javed Ali (Part 1): National Security & Government Bureaucracy
- Interview with Javed Ali (Part 2): The Role of Data in National Security as a Public Good
Course Wrap-Up
1
Assignment
- Final Quiz
1
Videos
- One More Thing for This Week: Congratulations!
1
Readings
- Course Survey
Auto Summary
Unlock the essentials of data analytics in the public sector with R in this Coursera course. Ideal for public sector professionals and aspiring data analysts, this course covers foundational programming techniques, key public administration concepts, and practical skills using tidyverse libraries. Over 900 minutes, learn to load, filter, and summarize data frames, create custom functions, and work with authentic datasets—all within RStudio on Coursera. Available through Starter and Professional subscriptions.

Christopher Brooks

Paula Lantz