Articles
Our latest articles are below, or you can filter by category using this dropdown:
New Template: Analyst Quality Assurance Notes, Checklist and Style Guide Template
Streamline your data analysis process with our Analyst Quality Assurance Notes, Checklist, and Style Guide Template! This tool helps you document data-related assumptions, decisions, and analytic steps in one organized file.
Data Visualization Applications: Slope Charts
Slope charts are an effective data visualization tool for illustrating changes over time. They allow for easy comparisons between two distinct time periods, simplify complex data, and enhance data storytelling. This article provides a step-by-step guide on how to create an impactful slope chart in Excel, including best practices for formatting, highlighting key insights, and improving the overall appearance.
New Template: Stratified Sampling Tool (Single Strata)
Discover our new Stratified Sampling Tool template, designed for researchers and evaluators working with large datasets. Learn how to generate representative samples, ensure fair subgroup representation, and increase precision in your data collection. Includes both single strata and multiple stratum versions with step-by-step instructions.
Data Visualization Applications: Line Charts
Explore the power of line charts in our ongoing series on data visualization. This article explains how to create impactful line charts using Excel 365. This tutorial not only guides you through chart creation but also emphasizes data visualization best practices to enhance clarity and professionalism. Whether you're new to charting or refining your skills, this article equips you with essential techniques for visually compelling data storytelling.
Survey Design: Unsure about Unsure
Ever been frustrated by a poorly designed survey? From limited response options to confusing questions, we've all encountered surveys that leave us scratching our heads. But fear not! This article unravels the mysteries of survey design, offering invaluable insights into mitigating respondent frustrations and maximizing data quality.
Stratified Random Sampling in Evaluation
Enhance evaluation precision through Stratified Random Sampling—a method that partitions populations into subgroups for nuanced insights. Whether adopting proportionate or disproportionate approaches, this strategy fosters inclusivity and robust representation, enriching the evaluative process, learn about it in this article.
How to Link Surveys in Qualtrics with a Participant ID
This is a step-by-step guide for linking your surveys in Qualtrics with a participant ID to assess change over time. Linking surveys together means that you’re connecting the data from all your surveys in a way that lets you track an individual respondent.
Encrypting and Anonymizing Personally Identifiable Information (PII) in Raw Data
Data protection in the world of evaluation is a must, especially when handling personally identifiable information (PII). Want to learn how to safeguard your data effectively? Discover the essential steps, including encryption and anonymization, to ensure your PII is shielded from unauthorized access, all while staying compliant with regulations.
Data Visualization Applications: Lollipop Charts - An Alternative to Bar Charts
While traditional bar charts are both straightforward and powerful for data representation, there are instances when we seek innovative alternatives to breathe new life into our reports. Enter the lollipop chart. Learn how to develop them in Excel here.
Data Visualization Applications: Bar Charts
In this first instalment of our Data Visualization Applications series, we'll guide you through the art of transforming raw data into compelling visualizations. We kick things off by delving into the power and simplicity of the bar chart. By following these steps and best practices, you'll elevate your charts to ensure your data speaks clearly and convincingly. Stay tuned for more insights and techniques in our Data Visualization Applications series.
Data Visualization Best Practices: A Practical Guide for Getting the Most out of your Data Viz
Want visuals that best express your data story? Here are some ideas to clean up those charts and help make them pop.
Survey Design Part 1: Planning for your survey – A review of Designing Quality Survey Questions (2019) by Robinson and Firth-Leonard
The article discusses the book "Designing Quality Survey Questions" by Robinson and Leonard, offering guidance for beginners in survey design. It highlights understanding survey purpose, tool suitability, respondent characteristics, and cultural context, serving as a useful resource for both new and experienced survey designers. Part 2 will delve into crafting quality survey questions.
New infographic: Data viz decision tree
Choosing the right type of chart to display your data can help to improve clarity among your readers and lessens the likelihood that your findings may be misinterpreted. With so many different types of charts and graphs, it can be tough to know where to start. This infographic is for anyone who wants to clearly display their quantitative data in a meaningful way but isn’t sure how to pick the best chart for the job.
How to combine data from multiple sources for cleaning and analysis.
This article walks you step-by-step through the process we use when merging datasets from multiple sources.
Chart Templates: The Time Saver You Should Be Using
Chart templates will alleviate the pains of trying to reformat every new chart from scratch. From adjusting text size and font to formatting bar width and colour, a template will save you a significant amount of time in drafting your next evaluation report.
Sampling bias: identifying and avoiding bias in data collection
Bias in evaluation is inevitable. Reflection helps us to identify our bias and when we do, it is necessary to identify sources of bias in our processes, eliminate which bias we can, and acknowledge which bias we cannot.