Get started on your journey to become a government data analysis rockstar.
Free tutorial
4.3
Created by Socrata Data Academy
English
What you’ll learn
- How to frame a data analysis project
- The power of simple descriptive statistics to guide decision making
- Examples of data being effectively used in the public sector
- Methods to download, evaluate, clean, and analyze data using Excel
- How you can be influenced by biases, and can unintentionally introduce them into your analysis
- The difference between structured, machine-readable data and unstructured, human-readable data
Requirements
- You should be able to open Excel and be a government employee.
Description
Data has exploded in the last few years, but educational resources for government information workers to take advantage of that data to improve program outcomes haven’t kept up. This first course in the series Fundamentals of Data Analysis for Government focuses on the key components of setting up and executing a data analysis project.What You’ll Learn in this Course
- How to frame a data analysis project
- The power of simple descriptive statistics to guide decision making
- Examples of data being effectively used in the public sector
- Methods to download, evaluate, clean, and analyze data using Excel
- How you can be influenced by biases, and can unintentionally introduce them into your analysis
- The difference between structured, machine-readable data and unstructured, human-readable data
Contents and Overview
This course is ideal for government employees who have a strong qualitative understanding of their work but have yet to master the quantitative skills needed to leverage data in their day-to-day responsibilities. Through ~25 lectures and ~2 hours worth of content, you’ll learn all of the fundamentals of government data analysis and establish a strong understanding of the concepts behind using data. Each chapter contains proficiency quizzes and hands-on exercises to practice while you’re learning.
Starting with a high-level overview of a data analysis project framework, this course will take you through identifying the actual problem to solve, exploring and defining a conceptual model around the problem, analyzing data to support or reject that model, then communicating insights found from the data analysis to address the problem at hand. Students will see all steps of the framework completed through the lens of a real-world data project done in the City of New Orleans.
Students completing the course will have the knowledge to analyze data and utilize it to improve government program delivery.
With these basics mastered, students are able to continue their learning through the Socrata Data Academy courses online.
Who this course is for:
- Government employees who work with data in their day-to-day job.
Show less
Course content
9 sections • 21 lectures • 1h 11m total lengthCollapse all sections
Introduction to Data Analysis2 lectures • 5min
- Introduction to Data Analysis – Part 103:52
- Introduction to Data Analysis – Part 200:59
- Introduction to Data Analysis2 questions
Identifying the Problem2 lectures • 6min
- Identifying the Problem – Part 102:45
- Identifying the Problem – Part 202:56
- Identifying the Problem3 questions
Exploring the Problem1 lecture • 2min
- Exploring the Problem02:08
- Exploring the Problem3 questions
Refining the Problem2 lectures • 5min
- Refining the Problem – Part 103:40
- Refining the Problem – Part 201:11
- Refining the Problem3 questions
Finding the Data2 lectures • 4min
- Finding the Data – Part 103:10
- Finding the Data – Part 200:29
- Finding the Data3 questions
Bias, Opinions, and Assumptions1 lecture • 4min
- Bias, Opinions, and Assumptions04:10
- Bias, Opinions, and Assumptions3 questions
Downloading and Manipulating Data1 lecture • 6min
- Downloading and Manipulating Data06:23
- Downloading and Manipulating Data3 questions
Descriptive Statistics9 lectures • 37min
- Descriptive Statistics – Part 100:45
- Walkthrough: Descriptive Statistics09:52
- Descriptive Statistics – Part 200:39
- Walkthrough: Distribution04:39
- Descriptive Statistics – Part 300:29
- Walkthrough: Central Tendencies10:35
- Descriptive Statistics – Part 400:21
- Walkthrough: Standard Deviation09:28
- Descriptive Statistics – Part 500:36
- Descriptive Statistics3 questions
Conclusion1 lecture • 3min
- Conclusion02:41