Intro to Data Analytics for Nonprofits (Charity Analytics)

Name: Intro to Data Analytics for Nonprofits (Charity Analytics)
Rating: 4.0 (70 reviews)

Helping nonprofits measure, amplify, and communicate their impact

Created byEric Clinger, Josh Haines, Haley Roberts

Last updated 4/2020

English

What you'll learn

How to use data analytics to help nonprofits measure their outcomes and impact
How to collect data, vizualize data, make business decisions with data, present data, and secure data

Course content

8 sections • 70 lectures • 3h 15m total length

Introduction3:03
This lecture will introduce the course and the instructors.

Introduction0:35
Skew3:45
Box and Whisker Plot Introduction5:02
Box and Whisker Plot Excel3:09
Tableau Demos0:21
Donations 2.0 Dataset0:48
A bigger and better dataset for Tableau analysis
Tableau Skew2:13
How to show your data's distribution using Tableau
Tableau Box and Whisker Plot1:14
Box and whisker plots in Tableau
Regression Introduction5:14
Regression Excel6:34
ANOVA4:26
Forecasting in Tableau2:30
Depending on your dataset, roughly predict the future using Tableau's built in forecasting tool.
Using reference lines in Tableau2:11
Leverage reference lines in Tableau to guide you're audience's attention
Conclusion0:23

Introduction0:42
Combine all your learning to tell stories with your data
Written Reports4:58
Things to know when using your data in a written report or proposal
Creating visualizations for written reports10:35
Hands-on practice building a visualization for written reports
Oral Presentations5:04
Things to know when using your data in oral presentations
Creating visualizations for oral presentations6:18
Hands-on practice building a visualization for written reports
Conclusion0:14
Conclusion to telling stories with your data

Introduction1:15
Disclaimer0:12
Disclaimer about any security content taught in this module.
Why Should I Care?1:02
Learn why nonprofits should care about data security.
What is Data Security?3:09
Learn the basics of data security including confidentiality, integrity, and availability (CIA Triad).
Data Security
Mitigating Risk2:07
Learn the basics of risk and the defense in depth model.
Data Audit1:48
Learn the importance of a data audit to figure out what data you have, where it is located, and who has possession of it. Learn about the Stanford PACS Digital Governance Workbook and why it takes a novel approach at a data audit.
Data Audit Example4:51
Learn how to fill out the Digital Governance Workbook.
Data Audit Practice
PII and Data Masking3:13
Learn the importance of Personally Identifiable Information and methods to mask it.
PII
Data Masking Example4:30
Learn examples of how to mask your data in Excel.
Risk Assessment3:59
Learn how to calculate risk. Learn how to perform a risk assessment on your nonprofit to determine what threats need to be addressed.
Risk Assessment Example4:22
Learn how to perform a risk assessment using the sample template in Excel.
Risk Assessment Practice
Current Actions4:01
Learn what security controls will provide the biggest return on investment. Learn the importance of passwords, software updates, antivirus software, physical security, WiFi security, and backups.
Future Actions2:44
Learn what additional controls you can add to your nonprofit in the future.
Security Awareness2:23
Learn the importance of security awareness, in addition to social engineering and phishing.
Breach Response0:55
Learn the importance of a breach response and why you should be prepared.
Resources0:08
Resources specifically written for nonprofits to improve their security posture.
Conclusion0:29

Requirements

Be a registered 501c nonprofit
Have access to computer, Microsoft Excel or Google Sheets

Description

Learn how to collect, analyze, visualize, present, and securely store data for obtaining more data insights for your organization. The ultimate goal of this course is to help nonprofits measure their outcomes and impact. This course is designed for users with little to no technical and data analytics experience. Additionally, this course will provide users with resources provided for free for nonprofits and teach organizations how to use them.

Who this course is for:

Nonprofit employees
Beginner data analysts

Intro to Data Analytics for Nonprofits (Charity Analytics)

What you'll learn

Explore related topics

Course content

Course Introduction1 lecture • 3min

What is data, what type of data should I collect, and how do I collect it?12 lectures • 22min

What do I do with this data?10 lectures • 21min

How can I show others the information from the data?9 lectures • 42min

What advanced analysis can I perform on my data?14 lectures • 38min

How do I present the data?6 lectures • 28min

How do I keep data secure?17 lectures • 41min

Course Conclusion1 lecture • 1min

Requirements

Description

Who this course is for: