This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Announcing Alteryx + Snowflake | Alteryx and Snowflake make analytics and data science fundamentally easier. With the new integrated starter kit, you can push down data prep transformations and more into Snowflake for faster data quality and analytics output. Learn More
2018 Excellence Awards Entry: Bringing Efficiencies to Charities Through Alteryx For Good Program
Name: Rusheen Rathore, Palak Jindal, Vivek Sahoo and Yugandhar Muley
Company: Sai Krushna Charitable Trust and Sneha Care Home
Collaborators: Nezrin Noushad, Bangalore Alteryx User Group and Alteryx For Good India Group
Overview of Use Case
Alteryx For Good (AFG) was launched in India in March of 2018 and since then the AFG team in India has managed to on-board five charities onto this program. We are a team who is not only passionate about the Alteryx Platform, but also passionate about giving back to society. Alteryx For Good provides just the exact blend of this passion for the Platform and giving back. With a mission to create an impact on these charities and enable charities to achieve their objectives, we started dedicating some of our weekends towards solving their data-related challenges.
As a part of these visits, we did multiple activities, including: digitization of their data, training charity staff on the importance of digitization (storing data in digital format compared to storing it as hard copies), Alteryx training to the staff, and of course building Alteryx models to increase efficiency.
Sneha Care Home was onboarded as the first charity firm to the Alteryx For Good, India program. Sneha Care Home provides residence for HIV-positive children within the age group of 5 to 13 who have lost their parents. Sneha Care Home strives to provide a safe and healthy environment for children infected with HIV to grow and become beautiful, joyful, and responsible human beings.
Another charity, Sai Krushna Trust, provides residence for orphan children and runs a school for free of charge for children in the nearby villages. Sai Krushna Trust aims to fulfill its objectives of serving the downtrodden without any barrier of caste, creed, race or religion. During one of the visits and discussions with charities, we found out that these charities spend a lot of manual efforts and time writing report cards and creating certificates for the students after each cultural, sporting, and academic event. Post brainstorming, we managed to create templates for recording the exam scores and certificate details and then we built Alteryx models that automate the generation of these report cards and certifications.
Describe the business challenge or problem you needed to solve
Sneha Care Home and Sai Krushna Trust are both driven to provide a healthy, safe, and educational environment for children in need. With that said, it is important that the staff dedicate their time as much as possible towards taking care of the kids, instead of spending time on manual tasks that can be taken care of by tools such as Alteryx. The staff used to spend around 150 hours in creating report cards and certificates for the kids. Additionally, the staff used to spend time and money in printing a pre-defined template from a vendor for these report cards and certificates. The volunteer team swiftly began looking for a solution to the manual time spent on these projects.
Describe your working solution
As a part of the brainstorming, the team of volunteers came up with a plan to tackle this problem. We started with the digitization of the data, that involved creating a standard template for each class to store the data in a standard format for report cards. We then built Alteryx models (using Alteryx Designer) that could consume this data, enrich the data with some of the mappings of class, student ID, the name of the school/trust, month and year of exam, subjects, etc. Later, with the help of the reporting tools, we were able to generate a standard form of the report card per student including the name of the charity and we then ran second workflow to generate certificates for each of the events.
Describe the benefits you have achieved
The impact of this workflow is beyond the number of hours saved by the staff members of these charities. This time saving is a form of a love to these children as the staff members can now spend more time with them. This time saving is an opportunity for the staff members to provide better diet and nutrition to the children, which ties back to the main objective of the charity--to provide a proper education, and healthy environment for the children. This is not just an Alteryx workflow, it is an emotional bond between the staff and the kids. It's not about the time, but it's about the smile and satisfaction that we get to see on those kids face. It's about making someone feel happy.