Intro to Data Analytics for Nonprofits (Charity Analytics)

Name: Intro to Data Analytics for Nonprofits (Charity Analytics)
Rating: 4.1 (71 reviews)

Helping nonprofits measure, amplify, and communicate their impact

Created byEric Clinger, Josh Haines, Haley Roberts

Last updated 4/2020

English

English [Auto],

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:45
Why Should My Nonprofit Worry About Data?2:31
What Is Data?1:02
Data Points and Observations2:19
Understand the difference between data points and data observations using a donations dataset from Team trees, and learn why consistency across observations enables data analysis.
Team Trees Data0:12
What is Data Part 23:01
What Type of Data Should I Collect?2:37
How Do I Collect Data?5:03
What Do I Do If Most of My Data is Paper-Based?1:27
Why Do Some Nonprofits Grow and Others Don't?1:54
Excel Tips and Tricks0:36
Conclusion0:25

Introduction0:26
Explore how data relationships uncover trends and patterns in your nonprofit's data, and prepare to master basic data analytics tasks that empower your organization.
Data Relationships1:54
Explore data relationships by examining statistics and how data relate to insights and trends, enabling more informed decisions through data analytics.
Mighty Four2:29
Explore the mighty four—min, max, mean, and median—to assess data distribution, skew, and spread, with standard deviation to be covered later on this donations dataset.
Using Excel0:18
Calculating the Mighty Four
Standard Deviation3:43
Standard Deviation Continued0:11
Calculate Standard Deviation
Why Univariate Matters0:42
Bivariate Relationships9:22
Multivariate Relationships1:07
Explore multivariate relationships by linking donation amount to multiple factors like zip code, household income, donation count, and donation timing, illustrating advanced data analytics for nonprofits.
Conclusion0:21

Data Viz Introduction1:22
Explore data visualization to turn raw data from various sources into meaningful information for nonprofits. Discover how the DIY kW pyramid guides moving from information toward knowledge and wisdom.
The Only Chart Types You'll Need3:24
Master four essential chart types for nonprofit analytics: big number, bar chart, scatter plot, and line graph, with notes on when to avoid pie charts, all in Tableau.
Data Visualization Software0:47
Tableau Installation0:42
Creating Charts In Tableau13:07
Chart Types Quiz
4 Guidelines for Improving Your Visuals12:15
Improving Your Visuals in Tableau9:39
Best Practices Quiz
Conclusion0:31
Explore how raw data becomes visual charts and accessible insights in nonprofit analytics. Discover additional resources, books, websites, and podcasts to deepen your understanding of data visualization.
Additional Resources0:06

Introduction0:35
Skew3:45
Box and Whisker Plot Introduction5:02
Explore box and whisker plots to visualize medians, quartiles, inner quartile range (iqr), and outliers for continuous data, and learn to detect skew and compare mean to median in Excel.
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
Explore analysis of variance (ANOVA) for comparing means across categorical groups, such as education levels affecting donations or salaries, and understand between-group and within-group variance, plus post hoc tests.
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
Protect your nonprofit's data, including donors, customers, and employees, by applying proven data security practices, and prioritize the most impactful steps that fit your budget.
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
Conclude by prioritizing security for your nonprofit, implementing simple practices to reduce risk for you and those you serve, while acknowledging protection won't be perfect.

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: