Introduction to Primary Analysis

Worksheet A is a space to determine what to prioritize for secondary analysis (columns with code name, code count, triangulation check, interesting co-occurrences)

Worksheet B is a space for note-taking during secondary analysis (columns with theme name, name of the reviewer, source breakdown, and draft findings write up)

Worksheet C is the space for an FCR Matrix (columns for theme name, Findings, Conclusions, and Recommendations)

Worksheets D are multiple sheets for primary analysis of each descriptor set used during coding (with one axis as the list of codes and the other as the descriptor fields)

Worksheets E are multiple sheets for each code/theme you are secondarily analyzing (columns for code category, code, media, excerpt, and then any descriptors or codes you are comparing for co-occurrence)

1. When beginning analysis, it is useful to export the total application counts for each code in your codebook. To export this helpful information, go to the Analyze screen, click on Qualitative Charts, open the Code Application chart, and click on the export button in the upper-right corner. 
2. For exporting descriptor data from Dedoose, go to the Analyze screen, click on Descriptors Charts, open the Descriptor x Code Count Table chart, choose a descriptor set, and click on the export button in the upper-right corner. Do this for each of your descriptor sets.
3. While not necessary to export, the code co-occurrence chart is where you can visually see how different codes have overlapped on excerpts. The top and left axes show the entire codebook, and the grey diagonal line of boxes is where the same code intersects. We will discuss how to review co-occurrences for analysis in the section below.

PRIMARY ANALYSIS

1. Paste your code application counts into Worksheet A.
2. Determine which codes require secondary analysis. We first eliminate codes that are applied less than 3 times, looking for trends with a higher likelihood of triangulation (occurrence in at least 3 different sources). We then eliminate parent codes that are mostly encompassed by their child codes, check the number of sources for triangulation of codes with less than 10 applications and eliminate those which are not found in at least 3 different media, and remove specialized bucket codes (for example, “illustrative quotes,” “bright spots,” and “issues with the quality of evidence”), which are reviewed separately to bolster triangulated findings and the report. The codes remaining are the ones with the most potential for leading to rigorous and actionable learnings for the client, and they should be put through a round of secondary analysis (discussed in the next blog post).
3. Identify significant code co-occurrences. In order to analyze code co-occurrences, we recommend taking a look at the Code Co-Occurrence Chart in Dedoose and making a note of any cross-codes that have numerous co-occurrences which are not intuitive nor overlapping within the same parent code group. If you identify potentially interesting co-occurrences, you should then check to ensure that these co-occurrences are triangulated (that these two codes co-occur in at least 3 different documents). In order to check for triangulation, click on the numbered box you are interested in with the chart, and it will tell you the number of “Matching Resources.” Make a note in Worksheet A of any significant, triangulated co-occurring codes. When doing secondary analysis, you will look for triangulated sub-trends related to these co-occurring codes, which would establish a meaningful association between those two codes.
4. Analyze descriptor applications. Paste the descriptor data into Worksheets D. When looking at the descriptor data, examine the application counts to find significant trends for additional analysis through pivot tables. Is there a significant difference in evidence by region? By stakeholder group related to a particular parent code grouping? What is the breakdown of types and rigor of evidence in the dataset? The analyst will have to make this decision based on how best to describe the dataset according to the evaluation or qualitative efforts purpose, as well as what appears unusual or significant among the data. Sometimes this is easier to see upon adding charts from a pivot table, so feel free to use these visual options to make exploring trends easier. These tables allow for a closer examination of a subset of codes against a subset of descriptor fields.
5. Create illustrative tables and graphs. Now that you have done an initial review of the code counts, co-occurrences, and descriptors, the next step will be to create some visuals to highlight interesting and noteworthy initial findings. The goal of creating tables and charts here is to look at the evidence base as it relates to the descriptors that have been assigned and the evaluation questions or any implications the final dataset will have on how audiences should frame the findings. You should take time to reflect on the previous steps and identify subsets where the code application count is unusually high or low or if there are any unexpected co-occurrences. The particular subset of information that you want to feature will determine if it is best reflected in a pivot table, pie chart, or some other type of visual. We recommend keeping the visuals you create in the same spreadsheet tab (Worksheets D) as the related Descriptor information for easy reference.