Everyone is talking about data integration these days. Development staff are using Razor’s Edge, finance staff are using Quickbooks, and your grants management staff is using Fluxx. You can’t put all that in one system, but sometimes you need to ask questions that can only be answered by pulling data from multiple sources.
For example, how many volunteers are also donors? How many people are served by our grantees across different program areas or communities? Sometimes straightforward questions about outcomes (how many children are reading on grade level?) requires program information from a program database, as well as data from the school system. Combining data from different sources is challenging but oh so rewarding.
In this webinar, we will talk about how to create data strategies and practices that are essential to data integration, whether you are managing multiple databases or multiple excel spreadsheets. Then for the real nerds we will talk about the challenges of combining data from systems you don’t manage, and will explain more about open APIs, data warehouses, and data lakes. (Spoiler alert, your fancy data warehouse won’t do much if you don’t have a clear strategy about what you collect, and good data hygiene to make sure data is clean and complete.)
In this webinar, Kristen Halsey, Data Analyst, showed us a few tricks to help you prepare your data for analysis. The dataset she was working with was a record set of donors including their organization, contact name, address, donation amount, etc. This lesson is for those of us who enter data regularly, can navigate Excel and write some formulas, but unfortunately find ourselves manually making time-consuming changes in Excel.
She went over how to use basic Excel functions and formulas to maximize efficiency and accuracy. This webinar answered questions like:
For part 2 of our Excel series, Kristen focused on simple descriptive analysis and data visualization using Excel. This webinar is particularly helpful for analysis for reporting. This lesson is for those of us who can navigate Excel and write basic formulas but find ourselves manually counting or filtering to get the information we need. Also, we understand the principles of tabular format and data cleaning. She went over some basic analysis using a “countif” formula. She walked us through making a simple pivot table and showed some examples of visualizations you could make.
You will learn how to quickly figure out the number, or percent, of each category of a variable, or more than one variable with a pivot table. You will be able to answer questions like:
Inciter helps clients measure impact, communicate, and fundraise through research, visualization, and data systems. We do this by helping them collect the right information, at the right time, using the right tools.
Established in 2003 as Carson Research Consulting, Inciter is a small, woman-owned firm located in Baltimore, MD. When you work with Inciter, you get a team of experienced researchers, evaluators, and custom software designers. While we are located on the East Coast, we work across the country.
© 2020 Inciter. All Rights Reserved. Incite is a trademark and product offering of Inciter. 712 H Street NE Washington, DC 20002