Business Analytics

Create a live Excel dashboard to manage volunteer data for an NGO

How big NGOs like Teach for India manage its 55k+ volunteers' data?

Certified by

Role

Business Analyst

Industry

Technology

Menterns at work

Level

Basic

Time Commitment

Submit First Draft in 30 days

Duration

60 days

Tools you’ll learn

Here’s What You Work On

About the Company

Teach for India an education-focussed NGO that trains mid-career professionals to be social impact leaders via a two-year fellowship program. Professionals who have completed training in the Teach For India (TFI) fellowship are now serving more than 33 million children in the country. More than 77% of TFI fellows continue to serve in the social sector.

TFI is attempting to repair India’s educational crisis through Innovation Cell programmes that equip teachers, students and entrepreneurs to spark long term change in education. Through social and print media- TFI has garnered the support of thousands of people from a wide range of sectors, all of whom are invested in the vision of an excellent education for all children.

Explore

the following work techniques

Advanced Analytics

MS Excel (Pivot and VLookup)

Dashboard building

Learn more about our Menternship Principle

Bridging the gap

NGOs like Teach for India depend on volunteers to drive a lot of their ground and strategy work. Volunteers can join an NGO to simply support a campaign for social good like cleanliness drive, or they can join an NGO for a longer duration to contribute to more strategic roles via their professional skills. For example, professionals like accountants and data scientists frequently volunteer at NGOs to help them improve their accounting and data management systems. Similarly, designers, teachers, writers etc can all contribute to an NGO’s work. For a big NGO like TFI, it is important to keep track of the various volunteers who have worked with it or have expressed interest in contributing to its work. The challenge is to maintain this database in a manner that is automated and efficient. The database should integrate well with methods of data collection about volunteer information and it should serve the purpose of teams who need to access this data regularly.

Apply

the following skills

Data Analysis

Data preparation

Hypothesis testing

Learn more about our Menternship Principle

Expected output

Use advanced MS Excel functions to create an automated database for volunteer management at an NGO

Create

the following deliverables

A workflow for data entry and management for volunteer activity

An automated excel dashboard for tracking and managing volunteer activity in an NGO

Learn more about our Menternship Principle

What you’ll need before starting

Basics of database management and MS Excel

Why Do Menternships?

Build Real Skills by doing work, by experience.

Each Menternship experience is powered by the MentorMind experiential learning model. We empower you as a Mentern to produce your own unique real work output through mentoring, deep-learning & applying your learnings to work.

Do Real Work that matches corporate expectations.

All our Menternships are co-created with companies. They are designed for real-time work in the corporate function which allows all levers of a work experience to flourish in your Menternship experience.

Get active guidance from Real Mentors.

You get access to a guild of industry mentors with remarkably diverse experience in their fields. Mentors help you with expert advice, domain guidance or to understand a specific task better. Moreover, you can always depend on our community of menterns, MentorMind Garage, to seek assistance from your co-menterns, guides & mentors!

Showcase your Official Certification.

Successfully completing a Menternship is no less that having practical, hands-on work experience. You earn a Certificate of Recognition from the Menternship partner company which can be showcased on your CV or your LinkedIn as a proof of your real skills!

Become a member of the Mentern Perks Club.

As a Certified Mentern you earn a spot in the exclusive Mentern Perks Club, a MentorMind community that opens up networking amongst menterns from across the globe. MentorMind empowers the community with our amazing Perks Club guides, Do-With-Us workshops & access to work opportunities with our Corporate Partners!

Meet Our Certified Menterns

It was amazing! I learnt so many things like creating engagement on social media platforms. The 1:1 with mentors were super helpful. I learnt how to create Instagram ads, identify goals & do competitor analysis- so many things.

There was a lot of interactive sessions with Mentors. The Menternship I completed gave me a new perspective to how work has to be done. I truly enjoyed working with real figures & actual industry case studies.

My experience was great as I got a chance to explore subjects like Analytics which are difficult to look for. The Menternship allowed to get subject knowledge and see what goes behind the making and delivering of a product.

My experience was very useful as I learnt so much about Fleet Management & Digital Marketing connected to the real-world scenario. I learnt how to actually work with social media channels like IG & Facebook.

Create a live Excel dashboard to manage volunteer data for an NGO

How big NGOs like Teach for India manage its 55k+ volunteers' data?

Explore our curated Resource Hub

Get Guidance in One-on-One Mentor Hours

Ask Questions in our Biweekly AMA

Resolve all doubts on Mentor Support Chatbox

Get Actionable Mentor Feedback on your work

Learn & Network at the exclusive Mentern Perks Club