{"id":40779,"date":"2018-08-16T23:00:00","date_gmt":"2018-08-17T03:00:00","guid":{"rendered":"https:\/\/granicus.com\/blog\/4-simple-steps-to-do-qualitative-analysis\/"},"modified":"2024-02-22T09:46:25","modified_gmt":"2024-02-22T14:46:25","slug":"4-simple-steps-to-do-qualitative-analysis","status":"publish","type":"blog_posts","link":"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/","title":{"rendered":"4 Simple Steps to do Qualitative Analysis"},"content":{"rendered":"","protected":false},"author":11,"featured_media":40780,"template":"","resource_tax_market":[186,187,188,189,190],"resource_tax_dept":[198],"resource_tax_type":[164],"resource_tax_region":[],"resource_tax_outcomes":[205],"resource_tax_topic":[],"resource_tax_products":[191],"resource_tax_solutions":[214],"resource_tax_services":[],"class_list":["post-40779","blog_posts","type-blog_posts","status-publish","has-post-thumbnail","hentry","resource_tax_market-local-government-uk","resource_tax_market-central-government-uk","resource_tax_market-healthcare-uk","resource_tax_market-emergency-services-uk","resource_tax_market-housing-uk","resource_tax_dept-engagement-community-outreach-uk","resource_tax_type-blogs-uk","resource_tax_outcomes-foster-community-engagement-uk","resource_tax_products-engagementhq-uk","resource_tax_solutions-engagement-uk"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>4 Simple Steps to do Qualitative Analysis<\/title>\n<meta name=\"description\" content=\"How to do Qualitative Analysis? Follow these 4 simple steps for qualitative analysis to help you organise, code, explore &amp; report on your consultation data.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"4 Simple Steps to do Qualitative Analysis\" \/>\n<meta property=\"og:description\" content=\"How to do Qualitative Analysis? Follow these 4 simple steps for qualitative analysis to help you organise, code, explore &amp; report on your consultation data.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/\" \/>\n<meta property=\"og:site_name\" content=\"Granicus\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/granicusco\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-22T14:46:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/granicus.com\/wp-content\/uploads\/blog-Header-qualitative-analysis.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1440\" \/>\n\t<meta property=\"og:image:height\" content=\"590\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"4 Simple Steps to do Qualitative Analysis\" \/>\n<meta name=\"twitter:site\" content=\"@Granicus\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":[\"Article\",\"BlogPosting\"],\"@id\":\"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/\"},\"author\":{\"name\":\"Granicus Marketing\",\"@id\":\"https:\/\/granicus.com\/uk\/#\/schema\/person\/86d618ccb52051e285962f72626e8881\"},\"headline\":\"4 Simple Steps to do Qualitative Analysis\",\"datePublished\":\"2018-08-17T03:00:00+00:00\",\"dateModified\":\"2024-02-22T14:46:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/\"},\"wordCount\":6,\"publisher\":{\"@id\":\"https:\/\/granicus.com\/uk\/#organization\"},\"image\":{\"@id\":\"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/granicus.com\/wp-content\/uploads\/blog-Header-qualitative-analysis.png\",\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/\",\"url\":\"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/\",\"name\":\"4 Simple Steps to do Qualitative Analysis\",\"isPartOf\":{\"@id\":\"https:\/\/granicus.com\/uk\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/granicus.com\/wp-content\/uploads\/blog-Header-qualitative-analysis.png\",\"datePublished\":\"2018-08-17T03:00:00+00:00\",\"dateModified\":\"2024-02-22T14:46:25+00:00\",\"description\":\"How to do Qualitative Analysis? Follow these 4 simple steps for qualitative analysis to help you organise, code, explore & report on your consultation data.\",\"breadcrumb\":{\"@id\":\"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/#primaryimage\",\"url\":\"https:\/\/granicus.com\/wp-content\/uploads\/blog-Header-qualitative-analysis.png\",\"contentUrl\":\"https:\/\/granicus.com\/wp-content\/uploads\/blog-Header-qualitative-analysis.png\",\"width\":1440,\"height\":590},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/granicus.com\/uk\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"4 Simple Steps to do Qualitative Analysis\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/granicus.com\/uk\/#website\",\"url\":\"https:\/\/granicus.com\/uk\/\",\"name\":\"Granicus\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/granicus.com\/uk\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/granicus.com\/uk\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/granicus.com\/uk\/#organization\",\"name\":\"Granicus\",\"url\":\"https:\/\/granicus.com\/uk\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/granicus.com\/uk\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/granicus.com\/wp-content\/uploads\/2023\/05\/Granicus-G-logo-Red.svg\",\"contentUrl\":\"https:\/\/granicus.com\/wp-content\/uploads\/2023\/05\/Granicus-G-logo-Red.svg\",\"width\":\"1024\",\"height\":\"1024\",\"caption\":\"Granicus\"},\"image\":{\"@id\":\"https:\/\/granicus.com\/uk\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/granicusco\/\",\"https:\/\/x.com\/Granicus\",\"https:\/\/www.linkedin.com\/company\/granicusinc\/\",\"https:\/\/www.facebook.com\/granicusco\",\"https:\/\/www.facebook.com\/granicuslac\",\"https:\/\/www.youtube.com\/@GranicusLAC\",\"https:\/\/www.instagram.com\/granicuslac\/\",\"https:\/\/www.linkedin.com\/company\/granicuslac\",\"https:\/\/twitter.com\/granicuslac\/\",\"https:\/\/twitter.com\/GranicusUK\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/granicus.com\/uk\/#\/schema\/person\/86d618ccb52051e285962f72626e8881\",\"name\":\"Granicus Marketing\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/granicus.com\/uk\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f18a3514fa5c1d54c5ef212b4ddd23f1946461a2d8d778191a29a45101706969?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f18a3514fa5c1d54c5ef212b4ddd23f1946461a2d8d778191a29a45101706969?s=96&d=mm&r=g\",\"caption\":\"Granicus Marketing\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"4 Simple Steps to do Qualitative Analysis","description":"How to do Qualitative Analysis? Follow these 4 simple steps for qualitative analysis to help you organise, code, explore & report on your consultation data.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/","og_locale":"en_GB","og_type":"article","og_title":"4 Simple Steps to do Qualitative Analysis","og_description":"How to do Qualitative Analysis? Follow these 4 simple steps for qualitative analysis to help you organise, code, explore & report on your consultation data.","og_url":"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/","og_site_name":"Granicus","article_publisher":"https:\/\/www.facebook.com\/granicusco\/","article_modified_time":"2024-02-22T14:46:25+00:00","og_image":[{"width":1440,"height":590,"url":"https:\/\/granicus.com\/wp-content\/uploads\/blog-Header-qualitative-analysis.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_title":"4 Simple Steps to do Qualitative Analysis","twitter_site":"@Granicus","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/#article","isPartOf":{"@id":"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/"},"author":{"name":"Granicus Marketing","@id":"https:\/\/granicus.com\/uk\/#\/schema\/person\/86d618ccb52051e285962f72626e8881"},"headline":"4 Simple Steps to do Qualitative Analysis","datePublished":"2018-08-17T03:00:00+00:00","dateModified":"2024-02-22T14:46:25+00:00","mainEntityOfPage":{"@id":"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/"},"wordCount":6,"publisher":{"@id":"https:\/\/granicus.com\/uk\/#organization"},"image":{"@id":"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/#primaryimage"},"thumbnailUrl":"https:\/\/granicus.com\/wp-content\/uploads\/blog-Header-qualitative-analysis.png","inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/","url":"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/","name":"4 Simple Steps to do Qualitative Analysis","isPartOf":{"@id":"https:\/\/granicus.com\/uk\/#website"},"primaryImageOfPage":{"@id":"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/#primaryimage"},"image":{"@id":"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/#primaryimage"},"thumbnailUrl":"https:\/\/granicus.com\/wp-content\/uploads\/blog-Header-qualitative-analysis.png","datePublished":"2018-08-17T03:00:00+00:00","dateModified":"2024-02-22T14:46:25+00:00","description":"How to do Qualitative Analysis? Follow these 4 simple steps for qualitative analysis to help you organise, code, explore & report on your consultation data.","breadcrumb":{"@id":"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/#primaryimage","url":"https:\/\/granicus.com\/wp-content\/uploads\/blog-Header-qualitative-analysis.png","contentUrl":"https:\/\/granicus.com\/wp-content\/uploads\/blog-Header-qualitative-analysis.png","width":1440,"height":590},{"@type":"BreadcrumbList","@id":"https:\/\/granicus.com\/uk\/blog\/4-simple-steps-to-do-qualitative-analysis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/granicus.com\/uk\/"},{"@type":"ListItem","position":2,"name":"4 Simple Steps to do Qualitative Analysis"}]},{"@type":"WebSite","@id":"https:\/\/granicus.com\/uk\/#website","url":"https:\/\/granicus.com\/uk\/","name":"Granicus","description":"","publisher":{"@id":"https:\/\/granicus.com\/uk\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/granicus.com\/uk\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/granicus.com\/uk\/#organization","name":"Granicus","url":"https:\/\/granicus.com\/uk\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/granicus.com\/uk\/#\/schema\/logo\/image\/","url":"https:\/\/granicus.com\/wp-content\/uploads\/2023\/05\/Granicus-G-logo-Red.svg","contentUrl":"https:\/\/granicus.com\/wp-content\/uploads\/2023\/05\/Granicus-G-logo-Red.svg","width":"1024","height":"1024","caption":"Granicus"},"image":{"@id":"https:\/\/granicus.com\/uk\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/granicusco\/","https:\/\/x.com\/Granicus","https:\/\/www.linkedin.com\/company\/granicusinc\/","https:\/\/www.facebook.com\/granicusco","https:\/\/www.facebook.com\/granicuslac","https:\/\/www.youtube.com\/@GranicusLAC","https:\/\/www.instagram.com\/granicuslac\/","https:\/\/www.linkedin.com\/company\/granicuslac","https:\/\/twitter.com\/granicuslac\/","https:\/\/twitter.com\/GranicusUK"]},{"@type":"Person","@id":"https:\/\/granicus.com\/uk\/#\/schema\/person\/86d618ccb52051e285962f72626e8881","name":"Granicus Marketing","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/granicus.com\/uk\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f18a3514fa5c1d54c5ef212b4ddd23f1946461a2d8d778191a29a45101706969?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f18a3514fa5c1d54c5ef212b4ddd23f1946461a2d8d778191a29a45101706969?s=96&d=mm&r=g","caption":"Granicus Marketing"}}]}},"acf":{"page_type":"internal","external_url":"","page_template":"centered","sidebar_position":"right","post_author":"","post_date":"","post_description":"","post_link":"","post_file":false,"media_gallery":false,"project_metrics_title":"","project_metrics":false,"show_hero":false,"hero_margin":false,"hero_type":"image","hero_subhead":"","hero_headline":"","hero_text":"","hero_button":"","hero_icon":false,"hero_image":false,"sidebar_type":"sticky","content_builder_sidebar_group":{"content_builder_sidebar":false},"flexible_page_builder_group":{"flexible_page_builder_fields":[{"acf_fc_layout":"wysiwyg","add_menu_anchor":false,"anchor_menu_text":"","wysiwyg_group":{"show_section":true,"alignment":"left","subhead":"","headline":"","wysiwyg":"<p>If you\u2019ve just completed a large surveying activity, forum conversation or just have a large amount of written feedback and comments to make sense of, then you might need to utilise qualitative analysis techniques.<\/p>\n<p>Unpacking large amounts of qualitative data can be a daunting task but with a little preparation and some simple steps, drawing insights from you data can be made just that little bit easier.<\/p>\n<p>In this article, we look at a simple process for organising and coding qualitative data.<\/p>\n<p>The steps outlined below are especially useful if you have thoroughly planned your projects prior to engaging with your community.<\/p>\n<h2>4 simple steps To Do Qualitative Analysis<\/h2>\n<p><a href=\"#step-1\">Step 1: Gather your feedback<\/a><br \/>\n<a href=\"#step-2\">Step 2: Coding your comments<\/a><br \/>\n<a href=\"#step-3\">Step 3: Run your queries<\/a><br \/>\n<a href=\"#step-4\">Step 4: Reporting<\/a><\/p>\n<p><a id=\"step-1\"><\/a><strong>Step 1: Gather your feedback<\/strong><\/p>\n<p>The first step towards conducting qualitative analysis of your data is to gather all of the comments and feedback you want to analyze.<\/p>\n<p>This data might be captured in different formats such as on paper or post-it notes or in online forums and surveys, so it\u2019s important to get all of your content into a single place.<\/p>\n<p>For this activity, you might consider a master spreadsheet as a place to collect all of your feedback or you might have other digital tools such as <a href=\"https:\/\/granicus.uk\/solution\/govdelivery\/engagementhq\/\">EngagementHQ<\/a> to help you organise your content.<\/p>\n<p>As part of organising your content you want to setup your analysis template. If you are using a spreadsheet you might consider using variables as seen below to help get you started.<\/p>\n<table style=\"border: 1px solid gray; padding: 5px;\">\n<tbody>\n<tr>\n<th style=\"border: 1px solid gray; padding: 5px;\">Data Source<\/th>\n<th style=\"border: 1px solid gray; padding: 5px;\">Stakeholder Type<\/th>\n<th style=\"border: 1px solid gray; padding: 5px;\">Qualitative Data<\/th>\n<th style=\"border: 1px solid gray; padding: 5px;\">Code<\/th>\n<th style=\"border: 1px solid gray; padding: 5px;\">Question<\/th>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid gray; padding: 5px;\">Pop-up<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">Resident 1<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">I want to see more bins&#8230;<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">Waste<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">4<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid gray; padding: 5px;\">Pop-up<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">Resident 1<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">I also want to see more lighting in the streets<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">Safety<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">4<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid gray; padding: 5px;\">Pop-up<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">Worker 2<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">I really do not like the new parking laws because&#8230;<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">Parking<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">6<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><em>Above: Example of how to setup a qualitative analysis spreadsheet.<\/em><\/p>\n<p>In the first column, you can see a field for data source. This variable will allow you to filter through your responses to compare views collected via different means.<\/p>\n<p>Next, you can see a stakeholder type variable, which comes in handy for drilling down into different stakeholder groups which you might need to report on.<\/p>\n<p>Obviously, you are going to need to have a field in your data for the actual feedback you collected and you might label this field \u201cfeedback\u201d or \u201cqualitative data\u201d.<\/p>\n<p>The most important variable required for your dataset is the code field which you will use to code and organise you data in the next step.<\/p>\n<p>Finally, you can also include an identifier for the question the data was collected for to further help you drill down into your insights.<\/p>\n<p><a id=\"step-2\"><\/a>In your master data template you can also include multiple columns for collecting your coding and you might also be required to add any demographic fields you have captured.<\/p>\n<p>You should allow a suitable amount of time for organising your data, especially if you are collecting it and entering it from a variety of sources.<\/p>\n<p><strong>Step 2: Coding your comments<\/strong><\/p>\n<p>The next step in this process is about coding your comments and most importantly reading and making a decision about how each one should be organised.<\/p>\n<p>There are two ways to approach this;<\/p>\n<p>The first way assumes that you are looking for a pre-defined set or list of issues or themes, whilst the other method is focused on unpacking themes without having any prior expectations about what they should be.<\/p>\n<p>For the first method, it\u2019s crucial you articulate your coding legend.<\/p>\n<p>A good way to do this is to create a simple table outlining what each code is and what it covers.<\/p>\n<p>This can be mapped to the areas you need to report on or the key components of your project.<\/p>\n<table>\n<tbody>\n<tr>\n<th style=\"border: 1px solid gray; padding: 5px;\">Code<\/th>\n<th style=\"border: 1px solid gray; padding: 5px;\">Description of what the code refers to<\/th>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid gray; padding: 5px;\">Safe<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">Discussion about improving the safety.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid gray; padding: 5px;\">Family-friendly<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">Comment is about being a good place for families.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid gray; padding: 5px;\">Connected<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">Discussion about improving transport, including active transport such as walking or cycling.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><em>Above is an example of a coding table used for qualitative analysis.<\/em><\/p>\n<p>In this legend, you can outline your theme and description and if you want to take it a step further you might even add issues as a secondary tag within a theme.<\/p>\n<p>If you decide to do the alternate method and unpack your qualitative data to try and derive themes for your code list, you are going to need to read a sample of your comments.<\/p>\n<p>We recommend reading at least 25% of your comments and making a first pass judgement about where each piece of feedback might sit.<\/p>\n<p>Once you have completed this you should ask a colleague to read through the same sample and check to see if they agree with your coding.<\/p>\n<p>When this is complete, refer to the themes you have identified and complete a coding sheet as per above.<\/p>\n<p>Regardless of which option you choose, you will be required to read through your comments and make some decisions about them.<\/p>\n<p>Complete your coding by reading through each comment, using legend will be your guide.<\/p>\n<p>If anything falls outside of your coding list, simply mark it with an identifier such as \u201cunsure\u201d and come back to it later.<\/p>\n<p><a id=\"step-3\"><\/a>Intimate knowledge of the feedback is often missed with automated tag clouds and sentiment analysis and it can encourage lazy practice and unintentionaly lead you to jump to incorrect conclusions.<\/p>\n<p>This coding process can also be completed using <a href=\"https:\/\/granicus.uk\/solution\/govdelivery\/engagementhq\/\">EngagementHQ\u2019s<\/a> comment analysis tool, allowing you to digitally code comments and feedback across all nine engagement tools, including essay and single line text questions in surveys.<\/p>\n<p><strong>Step 3: Run your queries<\/strong><\/p>\n<p>Once you have coded all of your data, it is time to run your queries.\u00a0In essence, this means looking for insights in your data.\u00a0Your reporting requirements will determine the extent and type of the queries you run during this step.<\/p>\n<p>Below are some recommended queries to run on your data:<br \/>\n<a id=\"step-4\"><\/a><\/p>\n<ul>\n<li>Which are the most used codes or themes? Represent this visually to get a sense of the most important areas.<\/li>\n<li>How did people respond via different formats? Were there any differences in views based on the submission type?<\/li>\n<li>Which issues are of most concern to different demographics segments?<\/li>\n<li>Are there any relationships between issues? ie. are people who are concerned with one issue more likely to be concerned with another?<\/li>\n<\/ul>\n<p>Once you have run your queries and explored your data you should have a good foundation and enough insights to begin your reporting.<\/p>\n<p><strong>Step 4: Reporting<\/strong><\/p>\n<p>The final step is reporting on your findings.<\/p>\n<p>This is a critical step as it\u2019s your opportunity to tell the story of what you learnt from your consultation.\u00a0If you fail to do this step well, your community will absolutely lose faith in your process and you might even face potential community outrage.\u00a0Being transparent and timely is the best way to avoid this situation.<\/p>\n<p>Use your insights to create a narrative about the issues and opportunities which your community have identified.\u00a0When framing your insights you might consider using the following as a useful way of talking about and quantifying your findings;<\/p>\n<p style=\"padding-left: 40px;\"><em>\u201cParticipants frequently raised concerns around the flexibility in defining \u2018sympathetic additions\u2019 with some participants suggesting that altering heritage buildings in any way could impact the character of the neighbourhood.\u201d<\/em><\/p>\n<p style=\"padding-left: 40px;\"><em>\u201cMany participants commented that a three storey maximum height was preferred for the eastern precinct of the Futureville Village, rather than four.&#8221;<\/em><\/p>\n<p style=\"padding-left: 40px;\"><em>\u201cMost participants suggested a three storey preferred height limit in Howitt Street, rather than four. The main concern was that this would affect the \u2018village atmosphere\u2019 of the street.\u201d<\/em><\/p>\n<p>You should also include relative charts and visuals to help your community further explore your data.\u00a0Generate these in a spreadsheet or other data visualisation software application such as Microsoft Power BI, Google Studio or Qualtrics to name a few.<\/p>\n<p>Once you have compiled and circulated your report, it\u2019s good practice to again ask your community for final comments and input.<\/p>\n<p>At this stage, you can test whether you have framed their concerns and issues correctly and allow yourself to make and final changes before you submit a final report and make your decisions.<\/p>\n<h2>Conclusion<\/h2>\n<p>As you can see, these four steps provide a simple process to follow for organising your data, determining your coding tables, running queries and reporting on your consultation.<\/p>\n<p>Make these steps a part of your project planning process and ensure you always have an end to end picture of how you are going to collect and report on your data before you begin your consultation.<\/p>\n","button":""}}]},"posts_slider_group":{"show_section":true,"posts_slider":[{"add_anchor":false,"anchor_name":"","background_color":"green","slider_subhead":"","slider_headline":"Discover More Blogs","slider_text":"","slider_type":"blog_posts","manual_resources":false,"slider_resource_tax":"recent","add_additional_filters":false,"department_filter":false,"market_filter":false,"outcome_filter":false,"product_filter":false,"region_filter":false,"solution_filter":false,"topic_filter":false,"slider_link":{"title":"View All Resources","url":"\/uk\/learning-center\/","target":""},"slider_link_icon":false}]},"centered_layout_builder_clone":{"flexible_page_builder_group":{"flexible_page_builder_fields":[{"acf_fc_layout":"wysiwyg","add_menu_anchor":false,"anchor_menu_text":"","wysiwyg_group":{"show_section":true,"alignment":"left","subhead":"","headline":"","wysiwyg":"<p>If you\u2019ve just completed a large surveying activity, forum conversation or just have a large amount of written feedback and comments to make sense of, then you might need to utilise qualitative analysis techniques.<\/p>\n<p>Unpacking large amounts of qualitative data can be a daunting task but with a little preparation and some simple steps, drawing insights from you data can be made just that little bit easier.<\/p>\n<p>In this article, we look at a simple process for organising and coding qualitative data.<\/p>\n<p>The steps outlined below are especially useful if you have thoroughly planned your projects prior to engaging with your community.<\/p>\n<h2>4 simple steps To Do Qualitative Analysis<\/h2>\n<p><a href=\"#step-1\">Step 1: Gather your feedback<\/a><br \/>\n<a href=\"#step-2\">Step 2: Coding your comments<\/a><br \/>\n<a href=\"#step-3\">Step 3: Run your queries<\/a><br \/>\n<a href=\"#step-4\">Step 4: Reporting<\/a><\/p>\n<p><a id=\"step-1\"><\/a><strong>Step 1: Gather your feedback<\/strong><\/p>\n<p>The first step towards conducting qualitative analysis of your data is to gather all of the comments and feedback you want to analyze.<\/p>\n<p>This data might be captured in different formats such as on paper or post-it notes or in online forums and surveys, so it\u2019s important to get all of your content into a single place.<\/p>\n<p>For this activity, you might consider a master spreadsheet as a place to collect all of your feedback or you might have other digital tools such as <a href=\"https:\/\/granicus.uk\/solution\/govdelivery\/engagementhq\/\">EngagementHQ<\/a> to help you organise your content.<\/p>\n<p>As part of organising your content you want to setup your analysis template. If you are using a spreadsheet you might consider using variables as seen below to help get you started.<\/p>\n<table style=\"border: 1px solid gray; padding: 5px;\">\n<tbody>\n<tr>\n<th style=\"border: 1px solid gray; padding: 5px;\">Data Source<\/th>\n<th style=\"border: 1px solid gray; padding: 5px;\">Stakeholder Type<\/th>\n<th style=\"border: 1px solid gray; padding: 5px;\">Qualitative Data<\/th>\n<th style=\"border: 1px solid gray; padding: 5px;\">Code<\/th>\n<th style=\"border: 1px solid gray; padding: 5px;\">Question<\/th>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid gray; padding: 5px;\">Pop-up<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">Resident 1<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">I want to see more bins&#8230;<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">Waste<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">4<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid gray; padding: 5px;\">Pop-up<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">Resident 1<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">I also want to see more lighting in the streets<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">Safety<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">4<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid gray; padding: 5px;\">Pop-up<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">Worker 2<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">I really do not like the new parking laws because&#8230;<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">Parking<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">6<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><em>Above: Example of how to setup a qualitative analysis spreadsheet.<\/em><\/p>\n<p>In the first column, you can see a field for data source. This variable will allow you to filter through your responses to compare views collected via different means.<\/p>\n<p>Next, you can see a stakeholder type variable, which comes in handy for drilling down into different stakeholder groups which you might need to report on.<\/p>\n<p>Obviously, you are going to need to have a field in your data for the actual feedback you collected and you might label this field \u201cfeedback\u201d or \u201cqualitative data\u201d.<\/p>\n<p>The most important variable required for your dataset is the code field which you will use to code and organise you data in the next step.<\/p>\n<p>Finally, you can also include an identifier for the question the data was collected for to further help you drill down into your insights.<\/p>\n<p><a id=\"step-2\"><\/a>In your master data template you can also include multiple columns for collecting your coding and you might also be required to add any demographic fields you have captured.<\/p>\n<p>You should allow a suitable amount of time for organising your data, especially if you are collecting it and entering it from a variety of sources.<\/p>\n<p><strong>Step 2: Coding your comments<\/strong><\/p>\n<p>The next step in this process is about coding your comments and most importantly reading and making a decision about how each one should be organised.<\/p>\n<p>There are two ways to approach this;<\/p>\n<p>The first way assumes that you are looking for a pre-defined set or list of issues or themes, whilst the other method is focused on unpacking themes without having any prior expectations about what they should be.<\/p>\n<p>For the first method, it\u2019s crucial you articulate your coding legend.<\/p>\n<p>A good way to do this is to create a simple table outlining what each code is and what it covers.<\/p>\n<p>This can be mapped to the areas you need to report on or the key components of your project.<\/p>\n<table>\n<tbody>\n<tr>\n<th style=\"border: 1px solid gray; padding: 5px;\">Code<\/th>\n<th style=\"border: 1px solid gray; padding: 5px;\">Description of what the code refers to<\/th>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid gray; padding: 5px;\">Safe<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">Discussion about improving the safety.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid gray; padding: 5px;\">Family-friendly<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">Comment is about being a good place for families.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid gray; padding: 5px;\">Connected<\/td>\n<td style=\"border: 1px solid gray; padding: 5px;\">Discussion about improving transport, including active transport such as walking or cycling.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><em>Above is an example of a coding table used for qualitative analysis.<\/em><\/p>\n<p>In this legend, you can outline your theme and description and if you want to take it a step further you might even add issues as a secondary tag within a theme.<\/p>\n<p>If you decide to do the alternate method and unpack your qualitative data to try and derive themes for your code list, you are going to need to read a sample of your comments.<\/p>\n<p>We recommend reading at least 25% of your comments and making a first pass judgement about where each piece of feedback might sit.<\/p>\n<p>Once you have completed this you should ask a colleague to read through the same sample and check to see if they agree with your coding.<\/p>\n<p>When this is complete, refer to the themes you have identified and complete a coding sheet as per above.<\/p>\n<p>Regardless of which option you choose, you will be required to read through your comments and make some decisions about them.<\/p>\n<p>Complete your coding by reading through each comment, using legend will be your guide.<\/p>\n<p>If anything falls outside of your coding list, simply mark it with an identifier such as \u201cunsure\u201d and come back to it later.<\/p>\n<p><a id=\"step-3\"><\/a>Intimate knowledge of the feedback is often missed with automated tag clouds and sentiment analysis and it can encourage lazy practice and unintentionaly lead you to jump to incorrect conclusions.<\/p>\n<p>This coding process can also be completed using <a href=\"https:\/\/granicus.uk\/solution\/govdelivery\/engagementhq\/\">EngagementHQ\u2019s<\/a> comment analysis tool, allowing you to digitally code comments and feedback across all nine engagement tools, including essay and single line text questions in surveys.<\/p>\n<p><strong>Step 3: Run your queries<\/strong><\/p>\n<p>Once you have coded all of your data, it is time to run your queries.\u00a0In essence, this means looking for insights in your data.\u00a0Your reporting requirements will determine the extent and type of the queries you run during this step.<\/p>\n<p>Below are some recommended queries to run on your data:<br \/>\n<a id=\"step-4\"><\/a><\/p>\n<ul>\n<li>Which are the most used codes or themes? Represent this visually to get a sense of the most important areas.<\/li>\n<li>How did people respond via different formats? Were there any differences in views based on the submission type?<\/li>\n<li>Which issues are of most concern to different demographics segments?<\/li>\n<li>Are there any relationships between issues? ie. are people who are concerned with one issue more likely to be concerned with another?<\/li>\n<\/ul>\n<p>Once you have run your queries and explored your data you should have a good foundation and enough insights to begin your reporting.<\/p>\n<p><strong>Step 4: Reporting<\/strong><\/p>\n<p>The final step is reporting on your findings.<\/p>\n<p>This is a critical step as it\u2019s your opportunity to tell the story of what you learnt from your consultation.\u00a0If you fail to do this step well, your community will absolutely lose faith in your process and you might even face potential community outrage.\u00a0Being transparent and timely is the best way to avoid this situation.<\/p>\n<p>Use your insights to create a narrative about the issues and opportunities which your community have identified.\u00a0When framing your insights you might consider using the following as a useful way of talking about and quantifying your findings;<\/p>\n<p style=\"padding-left: 40px;\"><em>\u201cParticipants frequently raised concerns around the flexibility in defining \u2018sympathetic additions\u2019 with some participants suggesting that altering heritage buildings in any way could impact the character of the neighbourhood.\u201d<\/em><\/p>\n<p style=\"padding-left: 40px;\"><em>\u201cMany participants commented that a three storey maximum height was preferred for the eastern precinct of the Futureville Village, rather than four.&#8221;<\/em><\/p>\n<p style=\"padding-left: 40px;\"><em>\u201cMost participants suggested a three storey preferred height limit in Howitt Street, rather than four. The main concern was that this would affect the \u2018village atmosphere\u2019 of the street.\u201d<\/em><\/p>\n<p>You should also include relative charts and visuals to help your community further explore your data.\u00a0Generate these in a spreadsheet or other data visualisation software application such as Microsoft Power BI, Google Studio or Qualtrics to name a few.<\/p>\n<p>Once you have compiled and circulated your report, it\u2019s good practice to again ask your community for final comments and input.<\/p>\n<p>At this stage, you can test whether you have framed their concerns and issues correctly and allow yourself to make and final changes before you submit a final report and make your decisions.<\/p>\n<h2>Conclusion<\/h2>\n<p>As you can see, these four steps provide a simple process to follow for organising your data, determining your coding tables, running queries and reporting on your consultation.<\/p>\n<p>Make these steps a part of your project planning process and ensure you always have an end to end picture of how you are going to collect and report on your data before you begin your consultation.<\/p>\n","button":""}}]}},"post_slider_clone":{"posts_slider_group":{"show_section":true,"posts_slider":[{"add_anchor":false,"anchor_name":"","background_color":"green","slider_subhead":"","slider_headline":"Discover More Blogs","slider_text":"","slider_type":"blog_posts","manual_resources":false,"slider_resource_tax":"recent","add_additional_filters":false,"department_filter":false,"market_filter":false,"outcome_filter":false,"product_filter":false,"region_filter":false,"solution_filter":false,"topic_filter":false,"slider_link":{"title":"View All Resources","url":"\/uk\/learning-center\/","target":""},"slider_link_icon":false}]}},"call_to_action":{"hide_call_to_action":false,"color":"red","custom_cta":false,"custom_subhead":"","custom_headline":"","custom_description":"","custom_link":null,"custom_image":false}},"_links":{"self":[{"href":"https:\/\/granicus.com\/uk\/wp-json\/wp\/v2\/blog_posts\/40779","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/granicus.com\/uk\/wp-json\/wp\/v2\/blog_posts"}],"about":[{"href":"https:\/\/granicus.com\/uk\/wp-json\/wp\/v2\/types\/blog_posts"}],"author":[{"embeddable":true,"href":"https:\/\/granicus.com\/uk\/wp-json\/wp\/v2\/users\/11"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/granicus.com\/uk\/wp-json\/wp\/v2\/media\/40780"}],"wp:attachment":[{"href":"https:\/\/granicus.com\/uk\/wp-json\/wp\/v2\/media?parent=40779"}],"wp:term":[{"taxonomy":"resource_tax_market","embeddable":true,"href":"https:\/\/granicus.com\/uk\/wp-json\/wp\/v2\/resource_tax_market?post=40779"},{"taxonomy":"resource_tax_dept","embeddable":true,"href":"https:\/\/granicus.com\/uk\/wp-json\/wp\/v2\/resource_tax_dept?post=40779"},{"taxonomy":"resource_tax_type","embeddable":true,"href":"https:\/\/granicus.com\/uk\/wp-json\/wp\/v2\/resource_tax_type?post=40779"},{"taxonomy":"resource_tax_region","embeddable":true,"href":"https:\/\/granicus.com\/uk\/wp-json\/wp\/v2\/resource_tax_region?post=40779"},{"taxonomy":"resource_tax_outcomes","embeddable":true,"href":"https:\/\/granicus.com\/uk\/wp-json\/wp\/v2\/resource_tax_outcomes?post=40779"},{"taxonomy":"resource_tax_topic","embeddable":true,"href":"https:\/\/granicus.com\/uk\/wp-json\/wp\/v2\/resource_tax_topic?post=40779"},{"taxonomy":"resource_tax_products","embeddable":true,"href":"https:\/\/granicus.com\/uk\/wp-json\/wp\/v2\/resource_tax_products?post=40779"},{"taxonomy":"resource_tax_solutions","embeddable":true,"href":"https:\/\/granicus.com\/uk\/wp-json\/wp\/v2\/resource_tax_solutions?post=40779"},{"taxonomy":"resource_tax_services","embeddable":true,"href":"https:\/\/granicus.com\/uk\/wp-json\/wp\/v2\/resource_tax_services?post=40779"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}