Category Archives: Technology

4 Tips for Getting Started with Tableau

Have you ever seen beautiful charts or dashboards that make the data “pop” in the report or presentation and wondered how could you do that?  At Transform Consulting Group, we have made a lot of charts and graphs to help our clients evaluate their programs and understand important information in a way that is easy to digest. We work to find the most efficient ways to assist our clients with the data that they need to make informed, timely decisions. 2016 Percent of Annual Income a family pays for high-quality careOne way to do this is staying current with data analysis and visualization software.

The data visualization software that we are crushing on these days is Tableau. It is essentially an accelerated version of “pivot tables”.  If any of you are familiar with Excel, then you know pivot tables.  A pivot table is a tool that we use to determine the relationship between two or more data points. For example, when we were working with TeenWorks, a college and career readiness program, to see if their students are enrolling and persisting in college, then we might want to dig deeper in understanding who the students are that are not persisting, what schools are they enrolled in, what type of school is it (public or private, 2-year or 4-year), what is their major, and what is their gender and other socioeconomic statistics.

These additional data points help tell the story of what change is occurring and how that could impact the program model, partnership development, target clients, professional development and so many other factors.  Tableau helped our team answer these questions and more to better understand the relationship of our client’s program to its intended 19

Recently, Transform Consulting Group used Tableau to complete a statewide needs assessment on Indiana’s youngest children ages 0-5 by pulling together data from multiple agencies and partners. The analysis resulted in the Indiana’s Early Learning Advisory Committee’s (ELAC) help
2017 Annual Report. The intended audience for the report are policy makers who do not have a lot of time to read technical reports, but Tableau equipped out team with creating a visually-appealing report that draws attention to the key findings.

These are our top four tips of getting started with Tableau:

  1. Use Tableau support. There are many support options through Tableau. One option is the Tableau Community, which allows users to connect and ask or answer questions for each other. This can be a quick way to find answers to a common problem or question that users have.  For example, we were havProjected Employment Needsing difficulty with one of our state maps and Tableau Community had a solution that we were able to implement.
  2. Another option is to contact a Tableau consultant through Tableau. A consultant can provide customized personal training and guidance, which might be especially helpful for a new staff person using Tableau and/or a special project (like a dashboard). The consultant won’t do the work for you but is available along the way for further questions and guidance as you complete your project.  
  3. Organize your data. Tableau can be picky about how the original data is organized and certain charts require different data formatting. Before getting started, it is helpful to organize your data into one spreadsheet. Transform Consulting Group prefers to use Google Sheets because it allows multiple people to work in a document and view changes real time, but Excel or Numbers could also work.
  4. Work with a Tableau expert.  Your project might be beyond the capacity (time and knowledge) of your current team, so partnering with a group or individual who has used Tableau might be a more efficient and effective solution.

If your organization needs help with analyzing and visualizing your data, contact Transform Consulting Group for a free consultation!

Disclaimer: This is not a sponsored post.  We were not asked by Tableau to write this post.  This is our own opinion.

Share this article:Share on FacebookShare on Google+Tweet about this on TwitterEmail this to someoneShare on LinkedIn

Transformational Organization Spotlight: TechSoup

TechSoup is transforming organizations and having a ripple effect in the non-profit world. TechSoup is dedicated to connecting nonprofits, charities, foundations, and public libraries with technology products, services, and free learning resources needed ticon-what-we-do-techsoup Big.jpgo make informed technology decisions and investments. TechSoup partners with key technology players such as Adobe, Cisco, and Microsoft to provide donated and discounted software and refurbished hardware for eligible non-profit organizations.

Through its website, TechSoup provides two types of memberships: 1) for the eligible entities identified above, and 2) for non-eligible entities. Eligible organizations are able to access free and discounted resources. Non-eligible organizations are able to access resources through TechSoup’s articles, blogs and webinars posted online. The average nonprofit saves $12,000 on technology products over the course of its TechSoup membership!

Technology is an integral part of any organization, especially in today’s Information Age. Staying current with technology allows an organization to sustain quality service and efficiency levels, while saving money. However, choosing new technologies can be overwhelming and sometimes an outside expert is needed. TechSoup has partnered with several technology consulting services to provide consultation for non-profits to assist them in making such decisions. This is yet another benefit of TechSoup!

Transform Consulting Group applauds TechSoup for its leadership in connecting non-profits with great technology resources, services and information. Transform Consulting Group is dedicated to helping organizations stay current with the latest research and best practices. Follow us on Facebook, Twitter, LinkedIn, or contact Transform today to learn more!

Share this article:Share on FacebookShare on Google+Tweet about this on TwitterEmail this to someoneShare on LinkedIn

Federal Program Spotlight: Amber Alert



This post is part of Transform Consulting Group’s blog series highlighting federal programs that provide education opportunities and/or youth development services in communities.

The U.S. Department of Justice AMBER Alert program was instituted in 1996 as an early warning system designed to help find and return abducted children. According to the National Center for Missing & Exploited Children, approximately 800,000 children under 18 were reported missing in 1999. Fifteen years later in 2014, there were 466,949 missing children in the FBI’s National Crime information Center (NCIC). As of March 2015, the AMBER Alert program has recovered 745 children, and hopes to continue reuniting US families.

The goal of an AMBER Alert is to instantly galvanize an entire community to assist in the search for and safe recovery of an abducted child. In a recent online video, Attorney General Eric Holder announces new tools that will “expand the reach of the AMBER Alert program.” Partnerships with Facebook and Bing will allow AMBER Alerts to reach residents of search areas in new ways. Facebook will now send alerts to users if they are in a designated search area, along with detailed information and photographs. Bing will allow users to access Amber Alerts through online tools.

Attorney General Holder strongly encourages other companies and organizations to step forward and offer any assistance they can provide. Currently, the AMBER Alert program operates as a voluntary partnership between law-enforcement agencies, TV and radio broadcasters, transportation agencies, and the wireless industry to issue warnings in the most serious child abduction cases.

Individuals and organizations looking to get more involved in the AMBER Alert program can visit here to get the latest information and tools. The National Center for Missing and Exploited Children also has information on how to get involved on their website.

Transform Consulting Group is dedicated to helping organizations use technology to expand their audience and reach their goals. Contact us today to learn more.



Share this article:Share on FacebookShare on Google+Tweet about this on TwitterEmail this to someoneShare on LinkedIn

Free Fundraising App for Nonprofits


Givelify Video image

Nonprofit organizations are always looking for alternate and new ways to fundraise for their cause. In today’s Information Age, technology provides an opportunity for nonprofits to diversify and expand their fundraising efforts. A new fundraising App, Givelify, might be a good solution for your nonprofit organization.

Givelify has decided to offer this donation App for free to 100 nonprofit organizations. In return, the organizations will be asked to test it out and provide feedback to Givelify. Sign-ups are currently open to the first 100 nonprofit organizations and the donation app will go live on September 30, 2014. Sign-ups are completely free for this great opportunity.

Givelify is a local Indiana company who has primarily been serving the church community with their mobile giving platform. Givelify received better than expected results from the faith-based community and have decided that to expand into the larger nonprofit sector. Givelify is currently in the process of launching their nonprofit version of this donation App.

The Givelify App can be set up by the organization to help fund ongoing efforts or special projects depending on the need and is very simple to use. While it is easy for the nonprofit to use and set up, it is also an easy way for the person who is looking to donate to give to a cause. The donor does not have to remember to bring cash or take the time to write out the check.

All the donor has to do is go on the App and find the cause that they are looking to give to and then indicate what amount they would like to give. After they do this they then just have to push one button to confirm that they want this amount taken from their pre-entered credit card. This video was made by the creators to give everyone a better understanding of the Givelify platform.

Transform Consulting Group is always on the lookout for new and innovative funding opportunities to support nonprofit organizations and its clients. Is your organization looking to grow and diversify your revenue? Contact Transform Consulting Group today for a free consultation and to learn more about our fund development services.



Share this article:Share on FacebookShare on Google+Tweet about this on TwitterEmail this to someoneShare on LinkedIn

New Smartphone App To Prevent Bullying


Knowbullying - SAMHSASubstance Abuse and Mental Health Services Administration (SAMHSA) is launching a free mobile App that provides parents, caretakers, educators and others information and support to address youth bullying. The KnowBullying app was developed in conjunction with the federal partnership of

The Knowbullying App helps parents talk about what bullying is and how to stand up to it safely. Bullying can take place anytime and anywhere in a child’s life. To have quick and easy access to information about how to address bullying is a great advantage.

Through the use of technology, the KnowBullying App shares new research and strategies for the prevention of bullying to everyone. The KnowBullying App can help get the conversation started and provides tips on talking to children.

The KnowBullying App includes the following:

  • Information about bullying
  • Warning signs that your child may be bullying others, being bullied, or witnessing others being bullied
  • Conversation starters to talk with your child about bullying
  • Reminders to talk with your child at times that work best for you and your family
  • Ability to share advice right from the app in an email and/or text message
  • Quick access to bullying prevention resources
  • Resources for educators

The KnowBullying App is available for free both iPhone and Android users. The App utilizes technology and advanced research to help prepare parents, teachers, and children to prevent bullying. The App is a great example of how research, collaboration, and building strategies can help others be more informed and develop favorable outcomes.

Transform Consulting Group is dedicated to bringing nonprofits the latest news and information. Follow Transform Consulting Group on Facebook, Twitter, LinkedIn, or contact Transform today for a free consultation!



Share this article:Share on FacebookShare on Google+Tweet about this on TwitterEmail this to someoneShare on LinkedIn

U.S. Census Bureau Launches New App – Dwellr



The U.S. Census Bureau is providing free mobile Apps to iPhone and Android users that will allow easy access to statistical information. The dwellr App uses Census Bureau data to match the user with 25 places that best fit his or her lifestyle. Dwellr provides all kinds of neighborhood-level statistics such as demographics, home values, educational levels, population diversity, or the percent of single or married people in a city. 

The dwellr App uses data from the American Community Survey (ACS) Five-Year Estimates. ACS is an ongoing survey that provides information every 1, 3 and 5 years about every neighborhood in the nation. ACS collects statistics on age, ethnicity, marital status, taxes, education, income, and much more. Dwellr updates as new data becomes available.

The dwellr App makes accessing and using data easy and user-friendly. Transform Consulting Group applauds the Census Bureau in their effort to make statistics mobile.

Transform Consulting Group uses statistics to provide clients with information that may be crucial when making decisions about the future. At Transform Consulting Group, we help organizations collect statistical data about their communities to better serve their communities. Contact us today for a free consultation.



Share this article:Share on FacebookShare on Google+Tweet about this on TwitterEmail this to someoneShare on LinkedIn

FREE Text Messages to Keep You & Your Baby Healthy


Baby HandJoin the hundreds of thousands of moms who receive free text messages throughout their pregnancy and their baby’s first year.  Text4baby is a free service of the nonprofit National Healthy Mothers, Healthy Babies Coalition (HMHB) and was created in collaboration with Founding Sponsor Johnson & Johnson. The Text4baby service has four goals:

 1.    Demonstrate the potential of mobile health technology to address a critical national health priority: maternal and child health.

 2.    Demonstrate the potential of mobile health technology to reach underserved populations with critical health information.

 3.    Develop a base of evidence on the efficacy of mobile health interventions.

 4.    Catalyze new models for public-private partnerships in the area of mobile health.

In addition to ensuring medical accuracy, HMHB is committed to providing messages that are relevant, clear, understandable, and actionable by mothers of all literacy levels.  If you have limited texting per month, Text4baby won’t take away from your total amount of messages. Most wireless carriers in the U.S., including AT&T, Verizon and Sprint, have agreed to waive the standard text messaging fees for text4baby users.  The service also sends text messages to encourage dads and dads-to-be to engage with their children early.  Parents, friends and relatives, and even health care providers can sign up to receive text4baby messagesYou can sign up for text4baby in Spanish by texting BEBE to 511411. You can sign up for text4baby in English by texting BABY to 511411.

Transform Consulting Group is dedicated to bringing nonprofits the latest news and information. Follow Transform Consulting Group on Facebook, Twitter, LinkedIn, or contact Transform today for a free consultation!



Share this article:Share on FacebookShare on Google+Tweet about this on TwitterEmail this to someoneShare on LinkedIn