Hi Everyone, Thank you for attending the Boston Alteryx User Group this week! I am glad to hear that it went well and excited that Alteryx For Good was a hot topic! @lagueux_kerry has asked me to provide some details on how to get AFG licenses to a non-profit and share how other User Groups have provided analytical support. What is Alteryx For Good? Grand Rapids, MI Alteryx User Group At Alteryx, we’re passionate about giving back to worthy causes and invite you to join us in doing good. Together, we can significantly impact our communities and the lives of others. Alteryx for Good provides the state-of-the-art analytic platform for educators, students, nonprofit organizations and local government entities to be better analysts, enabling their information to make an impact and influence social change. Our program is empowering ordinary people to do extraordinary things. We’re for cause, passion, and the power of sharing. Alteryx For Good License Requirements * Non-profit organization needs to have an operating income less than $10M to qualify for a free AFG License* Check non-profit status at Guidestar.org – It’s free! * Contact the Alteryx For Good Team: alteryxforgood@alteryx.com * Volunteer with the non-profit on analytical projects* This can be done as an individual or as a User Group Alteryx User Groups Giving Back in Their Communities Alteryx User Groups and Non-Profits with Future Data Projects I would like to call upon @Deanna from the Dallas User Group, she has done amazing job getting the Dallas User Group working with a local organization called The Commit! Partnership. I believe in the first week they completed multiple data related projects! Deanna, do you have some advice for this group on where to get start and some best practices you've learned along the way? Attached you'll find a FAQ. If this is something you are interested in doing, please reply back to this thread and the Alteryx For Good team will get in touch with you to get started! Thank you.

Thanks, @AbhiSyal! Please let me know any time if you have any questions or need ideas on how to roll out AFG for your non-profit. Glad to hear it is going well! @Deanna

Thank you - this has been amazing ! I got it setup. In the next 2 months, I will be figuring out how we can roll-out AFG. I want to ensure that if we use any tools we use it cinsistently over time. Cheers, Abhi

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Alteryx For Good Volunteering Information

LaurenU

Hi Everyone,

Thank you for attending the Boston Alteryx User Group this week! I am glad to hear that it went well and excited that Alteryx For Good was a hot topic! @lagueux_kerry has asked me to provide some details on how to get AFG licenses to a non-profit and share how other User Groups have provided analytical support.

What is Alteryx For Good?Grand Rapids, MI Alteryx User Group

At Alteryx, we’re passionate about giving back to worthy causes and invite you to join us in doing good. Together, we can significantly impact our communities and the lives of others.

Alteryx for Good provides the state-of-the-art analytic platform for educators, students, nonprofit organizations and local government entities to be better analysts, enabling their information to make an impact and influence social change.

Our program is empowering ordinary people to do extraordinary things. We’re for cause, passion, and the power of sharing.

Alteryx For Good License Requirements

Non-profit organization needs to have an operating income less than $10M to qualify for a free AFG License
- Check non-profit status at Guidestar.org – It’s free!
Contact the Alteryx For Good Team: alteryxforgood@alteryx.com
Volunteer with the non-profit on analytical projects
- This can be done as an individual or as a User Group

Alteryx User Groups Giving Back in Their Communities

Alteryx User Groups and Non-Profits with Future Data Projects

I would like to call upon @Deanna from the Dallas User Group, she has done amazing job getting the Dallas User Group working with a local organization called The Commit! Partnership. I believe in the first week they completed multiple data related projects! Deanna, do you have some advice for this group on where to get start and some best practices you've learned along the way?

Dallas UG (2).jpg

Attached you'll find a FAQ. If this is something you are interested in doing, please reply back to this thread and the Alteryx For Good team will get in touch with you to get started! Thank you.

Accepted answers

All comments

AbhiSyal

Is it a cloud license?

LaurenU

Hi @AbhiSyal, the non-profit will get a designer license to use and depending on the need we can take a look at if Alteryx can provide additional resources.

Deanna

Hi, everyone! I would be very glad to help, and to join on a WebEx any time to talk about how our Dallas Alteryx User Group started volunteering with The Commit! Partnership in Dallas!

We started with one AFG license for Commit, and they were thrilled with what they could begin to accomplish. For AFG week a couple of months ago, I sent out a few posts to our user group ahead of time, asking for volunteers to sign up. We ended up with about 12 volunteers, and half of them could meet onsite at Commit during AFG week. Some advice I would give is to have one or two leaders to coordinate schedules: working directly with the non-profit contact, and reaching out to all of the volunteers. It is especially helpful first to ask the non-profit what days and times work for them, then let the volunteers choose multiple options. It also really helps to give the volunteers a wide range of dates and times they can be onsite; for example, 1 day, 1 afternoon for 4 hours, or even a few lunch hours spread throughout a week. We met with Commit 3 times in the first week, and our meeting times ranged from mornings to afternoons, depending on Commit's availability. Onsite volunteering doesn't have to take up a whole day; it seems to work best when volunteers can use their lunch hour or 1-2 hours in a day - as we all have seen, you can accomplish a lot with Alteryx in one hour! (In the first hour we met with Commit, we transferred one of their Excel processes into an Alteryx workflow that runs in 2 minutes

We also arranged meetings with multiple Commit staff and departments, through our main contact there. When the various departments saw the benefits that Alteryx could provide, it became clear right away that more than one license was needed; having Alteryx in the hands of many of these staff members meant that they could realize not only goals they had been waiting to achieve (like accessing large datasets that wouldn't fit into Excel), but also generate ideas for many more analytics they didn't have time for previously!

Something that really helped our volunteer team get started with Commit was to send them a list of "data and analytics" questions, to get to know their processes, data, and analytic methods, as well as issues and needs. I created the following list, and sent it about a week prior to our first AFG visit:

Are there Alteryx processes you have wanted to utilize, but haven’t had the time? These would include analytic apps to make repetitive processes easier (i.e., enter a location name, and a report is automatically generated).
Do you have data preparation methods that are manual, such as entering data into Excel, cutting and pasting data, etc.?
Are there reports you would like to transfer into Alteryx, and let Alteryx generate them?
Do you have “messy” data that needs to be cleaned prior to use?
Do you come across any bottlenecks in your processes, such as waiting for analyses to be completed, waiting for reports to be batch run, waiting for data to be cleaned?
Are there any data that you connect to via the internet for download, and are you manually downloading them?
Do you need assistance connecting to multiple data sources and/or databases?
Do you need a way to place reports into a central shared drive/repository?
What is your day like? Do you spend most of it using spreadsheets and/or downloading and cleaning data?

The responses to these questions helped our team formulate our approach, even for the first visit. We were able to arrive at Commit with targeted answers to the responses, as well as ideas for creating many different workflows that would provide solutions for their needs. In the first week, we not only built workflows to transfer Excel processes to Alteryx, but we started 1) creating analytic apps for their Gallery, 2) using the In-Database tools to access large databases, and 3) showing them how to connect to Salesforce and pull data; we also introduced them to spatial and demographic analytics!

After AFG week, we continue to meet with Commit when possible; however, since half of our volunteers aren't available to meet onsite, we developed a way for us to share data and Alteryx workflows through the internet. Commit had previously sent us some initial data via DropBox, and I realized that this could be a way for our volunteers to download data and partially created workflows, and work on augmenting and/or completing these workflows on their own time. I have found it helpful to review a main workflow or project, then divide the workflow into smaller "tasks" that each volunteer can work on. Getting to know each volunteer's strengths, such as spatial, analytic apps, database connections, etc., allowed me to recommend certain tasks to specific volunteers ("Tom, can you take on this DB connection task?" or "Brian, can you convert this numeric data to a string and add a leading zero?"). We are now branching into this type of collaborative online volunteering, and it is exciting to see where these next steps will take us and Commit!

I think DropBox works well for this non-profit, since any datasets they are sharing are public data; however, if the non-profit you are working with needs to share private, proprietary, or sensitive data, I would recommend researching into highly secure options.

In addition, I would recommend having the volunteers sign an NDA (non-disclosure agreement) if the volunteers will be accessing and/or seeing any proprietary or sensitive data. Some non-profits may be able to provide their own NDA to the volunteers.

I would be interested in hearing from your users what secure options might be considered for online data/workflow storage and collaboration? Any recommendations you have would be great to share with other user groups!

Commit has just installed their additional Alteryx licenses, and are moving forward at an amazing speed; I let them know about the wealth of online training available at Alteryx.com (Menu/Resources/Training), and I am meeting with them later this week to provide some one on one training in spatial and demographic analytics. This type of onsite training (or by WebEx) might be another benefit your volunteer team can offer to your non-profit as well.

Marie at Commit also has let me know that the users are training each other; when they find something cool, such as Dynamic Rename, they share it with the other users. She also has suggested having an internal weekly meeting for the users where they discuss Alteryx and share what they have discovered! I think this is a best practice that many AFG non-profits could start utilizing when they receive Alteryx; it is wonderful to think that all of this started just a couple of months ago, and they have made so much progress in a very short time. I imagine that this will happen for your user group and non-profit(s) as well very soon!

As mentioned, I am glad to join on a WebEx any time and talk more about Alteryx For Good and how to get started! As @LaurenU said in the post, the non-profit needs to apply and become qualified (see Requirements below). Reach out to the amazing AFG team at alteryxforgood@alteryx.com as well as the talented and energetic User Group staff such as Lauren! Together, they were our guides for the Dallas Alteryx User Group, and we couldn't have done it all without each of them ( @ToriA, @QuyenT, @TaylorM, Lauren and @TatianaS ) and our wonderful volunteers!

Looking forward to hearing about the Boston User Group's accomplishments with Alteryx For Good, and the many, many ways your non-profit(s) will benefit!

@Deanna

LaurenU

Thank you so much for sharing @Deanna!!!

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15911

binu_acs 15783

MarqueeCrew 13710

apathetichell 13703