In our opinion, Airtable is the most beautiful, overpowered, and - perhaps - under-appreciated database. Ready to swap your spreadsheets with a supercharged, AI-powered, automation-enabling tool? We’ll start with a simple Airtable project. But that’s just the beginning.

⭐️ Topic

Mental Health Awareness Month

Tutorials Tailored for You

What is your favorite way to learn?

• Level 1. Watch 'n' Learn. I want to get the information. We recommend the "Video Only" option.

• Level 2. Certificate Seeker. I want to build my data portfolio and earn a certificate. We definitely recommend joining the Live Workshop. Not able to attend the event? A certificate is still possible with the "Video Only" option (see below).

Video-Only Certificate-Seekers 

Unable to make the live workshop but still want a certificate? "Video Only" options are available for those who want to learn at all levels! Video-Only Certificate-seekers have 10 days after the video is shared to complete the project. Please note: Video processing takes around 2-5 weeks. An email will be sent once the Video and Tutorial Kits are ready.

🎯 Data Challenge

Main Objective: Collect key indicators for your community using free sources of Mental Health data and create a portfolio project.

3 Learning Objectives

by the end of the session, participants will be able to:

1. Query & Collect 📊 data on Mental Health for your region

2. Analyze data using the data tool: 🧰 🛠️ Airtable.

3. Visualize & Humanize data by creating a 🎨 database for a key stakeholder i.e. target audience.

Keywords and core concepts also covered:

• How do we measure Mental Health and why does it matter to health?

• Basics of inputing and organizing data in 🧰 🛠️ Airtable

• Advanced features of 🧰 🛠️ Airtable like formulas and AI (Artificial Intelligence)

Prerequisites.

Beginner-friendly, no prior experience needed. Email will be needed for inviting you to an Airtable workspace.

Portfolio Project + Micro Certificate

🎯 Data Challenge: Using a key indicator, create a real-world portfolio project for a key stakeholder for your region

🏆 Micro Certificate awarded for demonstrable skills and projects completed by end of sprint (timeline varies for Live and Video-Only).

⏰ Time Budget: 20-40 minutes. Each project is designed to be successfully completed within 20-40 minutes.

Hosted by BroadStreet

BroadStreet is a 501(c)3 created for learners by learners and centers around practical public health projects that can make an impact.

Belief

📊 Data ❤️ heal the world 🌎

Vision

A healthy nation for all.

Mission

To support advocates for community health through trainings in data, tech, and tools.

Agenda

The 90 minute workshop is split into 3 main parts. Unable to join the full event? There are "breakaway" moments between each part. Join us for part or the full 90 min session. Note: "Doors" close after 15 minutes. Times are approximate.

Please note: Timezone listed for the event is Eastern Time (ET).

• Part 1 (45 min). Pre-survey + Project Overview

• Part 2 (15 min). Step-by-Step walkthrough

• Part 3 (30 min). Team Test 'n' Try. Recommended for certificate seekers.

 Tickets for the Live Workshop are limited. Reserve your spot now by registering.

Learn while making a real-world impact!

Certificates

Workshop attendees seeking certificates will 3-days to complete a Data Challenge. Each Data Challenge is designed to be explained in 20 min. Everyone learns at different paces and in different ways. The average time to complete the challenge is 20-40 minutes. Projects complete by end of Day 3 are awarded certificates.

Video-Only participants who are interested in earning certificates but will not be at the event, will be given a tutorial kit and video 2-5 weeks after the session. Further instructions about how to earn a certificate will be shared at that time.

Instructor

Diana Saad, MPH

Data for Change Program Coordinator

BroadStreet Institute

Diana has a passion for exploring data and using tools like Airtable and over the past year has worked with dozens of trainees on Airtable setup, indicator exploration, data stories, and logic models. Diana is passionate about health and wellness, specifically for women and children.

Connect with Diana on LinkedIn

Event Facilitator

Tracy Flood MD PhD

President and Co-founder

BroadStreet Institute

Dr. Flood has over a decade experience in foraging for community health data, as well as in data visualization, report writing, mapping, and data design for software. She is passionate about empowering community change, increasing data literacy, and turning data into actions that will have long-term impact. She has worked with over 2,000 interns as President of BroadStreet.

Connect with Tracy on LinkedIn

FAQs:

Q: Is it free?

Yes, this is a free event. If you'd like to donate to our  Community Health Impact Fund, please see https://www.broadstreet.org/give

Q: Will it be recorded?

Yes, parts of the session will be recorded. Want to participate in the Data Challenge, but unable to attend the event? Select the "Video Only" ticket option below.

Q: What will I need?

Computer recommended for the workshop. The workshop is an interactive and collaborative session. Joining on mobile is not recommended. If your worksite blocks collaborative platforms like Gdrive, please consider joining on a non-work computer.

Q: What if I cannot make the workshop on Tuesday?

We have a "Video Only" options for those who want to gain the knowledge and earn a microcertificate. We send email updates the week of the workshop.

Financial Disclosures:

BroadStreet Institute and the events are fully funded by our community of learners. This event is not sponsored and we are not affiliated with the tools and tech in our trainings. We hope you will love this Data Challenge and, if you are not a donor yet, we hope you will consider becoming a donor in the future.