Intro to Data Analytics for Nonprofits (Charity Analytics)
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.
What is data, what type of data should I collect, and how do I collect it?
What do I do with this data?
-
2
Introduction -
3
Why Should My Nonprofit Worry About Data? -
4
What Is Data?
-
5
Data Points and Observations
-
6
Team Trees Data
-
7
What is Data Part 2
-
8
What Type of Data Should I Collect?
-
9
How Do I Collect Data?
-
10
What Do I Do If Most of My Data is Paper-Based?
-
11
Why Do Some Nonprofits Grow and Others Don't?
-
12
Excel Tips and Tricks
-
13
Conclusion
How can I show others the information from the data?
-
14
Introduction
-
15
Data Relationships
-
16
Mighty Four
-
17
Using Excel
-
18
Calculating the Mighty FourUse Excel or Google Sheets to calculate the min, max, median, and mean of the donations dataset.
-
19
Standard Deviation
-
20
Standard Deviation Continued
-
21
Calculate Standard Deviation
Use Excel or Google Sheets to calculate the standard deviation of the donation amounts
-
22
Why Univariate Matters
-
23
Bivariate Relationships
-
24
Multivariate Relationships
-
25
Conclusion
What advanced analysis can I perform on my data?
-
26
Data Viz Introduction
-
27
The Only Chart Types You'll Need
-
28
Data Visualization Software
-
29
Tableau Installation
-
30
Creating Charts In Tableau
-
31
Chart Types Quiz
Test your knowledge of 4 basic chart types.
-
32
4 Guidelines for Improving Your Visuals
-
33
Improving Your Visuals in Tableau
-
34
Best Practices Quiz
Test your knowledge of data viz best practices
-
35
Conclusion
-
36
Additional Resources
How do I present the data?
-
37
Introduction
-
38
Skew
-
39
Box and Whisker Plot Introduction
-
40
Box and Whisker Plot Excel
-
41
Tableau Demos
-
42
Donations 2.0 Dataset
A bigger and better dataset for Tableau analysis
-
43
Tableau Skew
How to show your data's distribution using Tableau
-
44
Tableau Box and Whisker Plot
Box and whisker plots in Tableau
-
45
Regression Introduction
-
46
Regression Excel
-
47
ANOVA
-
48
Forecasting in Tableau
Depending on your dataset, roughly predict the future using Tableau's built in forecasting tool.
-
49
Using reference lines in Tableau
Leverage reference lines in Tableau to guide you're audience's attention
-
50
Conclusion
How do I keep data secure?
-
51
Introduction
Combine all your learning to tell stories with your data
-
52
Written Reports
Things to know when using your data in a written report or proposal
-
53
Creating visualizations for written reports
Hands-on practice building a visualization for written reports
-
54
Oral Presentations
Things to know when using your data in oral presentations
-
55
Creating visualizations for oral presentations
Hands-on practice building a visualization for written reports
-
56
Conclusion
Conclusion to telling stories with your data
Course Conclusion
-
57
Introduction
-
58
Disclaimer
Disclaimer about any security content taught in this module.
-
59
Why Should I Care?
Learn why nonprofits should care about data security.
-
60
What is Data Security?
Learn the basics of data security including confidentiality, integrity, and availability (CIA Triad).
-
61
Data Security
Brief quiz covering the content of the "What is Data Security?" lecture.
-
62
Mitigating Risk
Learn the basics of risk and the defense in depth model.
-
63
Data Audit
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.
-
64
Data Audit Example
Learn how to fill out the Digital Governance Workbook.
-
65
Data Audit Practice
-
66
PII and Data Masking
Learn the importance of Personally Identifiable Information and methods to mask it.
-
67
PII
Brief quiz about personally identifiable information (PII)
Please be sure to talk to a lawyer or someone in the know, as the legal definition of PII could be different for your nonprofit or your state.
-
68
Data Masking Example
Learn examples of how to mask your data in Excel.
-
69
Risk Assessment
Learn how to calculate risk. Learn how to perform a risk assessment on your nonprofit to determine what threats need to be addressed.
-
70
Risk Assessment Example
Learn how to perform a risk assessment using the sample template in Excel.
-
71
Risk Assessment Practice
-
72
Current Actions
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.
-
73
Future Actions
Learn what additional controls you can add to your nonprofit in the future.
-
74
Security Awareness
Learn the importance of security awareness, in addition to social engineering and phishing.
-
75
Breach Response
Learn the importance of a breach response and why you should be prepared.
-
76
Resources
Resources specifically written for nonprofits to improve their security posture.
-
77
Conclusion
Related Courses
