excel

DVR TIG Week: Interactive Dashboards in Excel: A Cost Effective, Easy-to-Learn Alternative by Shelly Engelman & Tom Withee

Hello all! This is Shelly Engelman and Tom Withee, and we love communicating stories with data and data visualizations. Like many trying out data viz, we initially hopped on the bandwagon with several Business Intelligence platforms. However, we quickly ran into several of the following impediments: Too time-consuming to generate dashboards for one-off surveys Too …

DVR TIG Week: Interactive Dashboards in Excel: A Cost Effective, Easy-to-Learn Alternative by Shelly Engelman & Tom Withee Read More »

IE TIG Week: Using Evaluation of Service Geography for Organizational Improvement by Matan BenYishay and Allison Guarino

Hello! We are Matan BenYishay, Program Evaluation Manager, and Allison Guarino, Quality Improvement Coordinator, at AIDS Action Committee, the public health division of Fenway Health in Boston. We are sharing a lesson from our low-threshold Drug-User Health Program called Access. Among other services, this program trains and distributes Naloxone to People Who Use Drugs (PWUD) …

IE TIG Week: Using Evaluation of Service Geography for Organizational Improvement by Matan BenYishay and Allison Guarino Read More »

Tools for Mapping Location Data by Sarah Dunifon

Hi! I’m Sarah Dunifon, Research and Evaluation Associate at the Wildlife Conservation Society (WCS). In my role, I create many reports and I’m always looking for efficient tools for data visualization. I’ve found a few different programs to display location data, which I’d like to share with the wider AEA community. Rad Resources: Google Fusion …

Tools for Mapping Location Data by Sarah Dunifon Read More »

Kicking Your Cars Into VLOOKUP 4WD by Becca Sanders and Heather Robinson

Greetings Colleagues!  We are Becca Sanders (Hood River, Oregon) and Heather Robinson (Rochester, New York) of Iteration Evaluation LLC. Our forte is the “…ahhh… there is no button on your system for that” analysis requests.  We work mostly with behavioral health organizations whose current informational needs often far exceed what existing systems can pull off. …

Kicking Your Cars Into VLOOKUP 4WD by Becca Sanders and Heather Robinson Read More »

Internal Eval Week: A tool for helping staff translate results into action by Jay Szkola

Hello!  I am Jay Szkola, senior program analyst in the Strategy, Evaluation and Learning Division at Good Shepherd Services. As an internal evaluator, I have the opportunity not only to evaluate the programs in my portfolio, but also assist staff in using data in their day-to-day work with participants. This doesn’t have to involve a …

Internal Eval Week: A tool for helping staff translate results into action by Jay Szkola Read More »

Counting and Computing with Microsoft Excel by Laura Sefton

Hi! I’m Laura Sefton, Project Analyst in the University of Massachusetts Medical School’s Center for Health Policy and Research. Many AEA365 readers use sophisticated statistical software like SPSS, SAS, or Stata for their data analytic needs, but others don’t have ready access to such software and depend on more freely available options like Microsoft Excel. …

Counting and Computing with Microsoft Excel by Laura Sefton Read More »

DVR TIG Week: Tony Fujs on Can You See What Is Not There? Visualizing Missing Data

Hello! I’m Tony Fujs, Data Scientist at the World Bank. As many fellow data nerds, I love to visualize the data I have in my hands, but I also like to spend time visualizing data that I don’t have: Missing data. Why would I do that? Because bad handling of missing data can seriously bias …

DVR TIG Week: Tony Fujs on Can You See What Is Not There? Visualizing Missing Data Read More »

Pei-Pei Lei and Carla Hillerns on the Beauty of Banner Tables

Hi, we are Pei-Pei Lei and Carla Hillerns from the Office of Survey Research at the University of Massachusetts Medical School’s Center of Healthcare Policy and Research. The other day, we asked each other what one analysis tool is most vital to our quantitative survey work. We agreed on the answer – a banner table. …

Pei-Pei Lei and Carla Hillerns on the Beauty of Banner Tables Read More »

2-for1 Week: Lisa R. Holliday on Data Cleaning and Fuzzy Matching

My name is Lisa R. Holliday, and I am a Data Architect with The Evaluation Group. Cleaning data is a large part of my job.  For studies that need to match participants’ names or IDs, it is critical to ensure that information is entered consistently from one data collection cycle to the next. However, depending …

2-for1 Week: Lisa R. Holliday on Data Cleaning and Fuzzy Matching Read More »