Nonprofits, funders, donors, and beneficiaries need to focus on strategic investment and impact using data from a variety of sources. Questions many nonprofits are asking include; how do we become more data driven, and how do we use data to make decisions and design programs? 2018 just started. It's not too early to begin thinking about how to improve your use of data this new year. Here are examples of where you can start.
"CLEVELAND, Ohio - How does a family choose a rental home?
That's what healthy homes advocates want to know.
Understanding the experiences of families who rent in Cleveland is the next step to learning how to provide renters with useful information on issues like asthma and lead poisoning that are overwhelmingly linked to substandard housing, according to Kim Foreman of the non-profit Environmental Health Watch.
In the last week of October, from the 23rd to the 25th, over 420 people descended on the Global Center for Health Innovation in Cleveland to attend Meeting of the Minds. For their 11th annual summit, Meeting of the Minds came to the Midwest from San Francisco after a whirlwind tour of Cleveland on a freezing cold January day. When Meeting of the Minds executive director, Jessie Feller Hahn stated “I want to get an apartment here!” I knew we were good to go.
Participants came from all over the U.S. and 13 countries, and along with the Cleveland Clinic’s Medical Innovation Summit held simultaneously at the Convention Center, sold out hotels in the area and created an innovation buzz in downtown. Meeting of the Minds participants didn’t just sit in a darkened (albeit, comfortable) conference room listening to smart people share real and awesome examples of how technology and innovation is making cities more resilient and efficient. They also got out into our neighborhoods to see firsthand how innovation, technology, creativity, and quiet persistence are transforming Cleveland’s culture and future with 21st century assets.
These days, it’s not uncommon to hear about organizations being “data-driven.” With so much data out there in so many different formats, many organizations have made it a priority to try to understand how all this data can be used. As part of its mission to advance the use of data and analytics across civic sector organizations, DigitalC conducted focus groups and surveys to understand what types of training would advance this learning. High on the list were: “how to use data,” doing more data analysis with Microsoft Excel, and data visualization. In response, DigitalC’s inaugural Data Analytics Workshop in October focused on Excel and Tableau as tools people could use in their daily professional lives to do more data-driven work.
Still, Excel and Tableau are not necessarily the only tools people think of when they think of “data analytics” and “data visualization.” Other tools such as Python, R, and SAS are also popular choices. This left us wondering: how do Excel and Tableau rank next to some other, similar tools in today’s increasingly technology-and-data-driven workplace.
Although, Halloween may be over and while Thanksgiving is around the corner, here is a little treat on Excel tricks for which to be thankful.
People are using Excel daily, but odds are they are not unlocking its full potential. This article will outline five tips and tricks using the example of a spreadsheet of donor data that can be transferable to assist with managing client information. The article features screenshots and examples in a sequential manner in order to ensure that you can to replicate the work within your own data.
These tricks are just a framework to get started- dive into how you can maximize your capabilities with Excel at DigitalC’s Data Analytics Workshops, as part of the Learning Studios, at our November Workshop held Nov. 14-16 HERE.