{"id":9004111224359373,"date":"2022-12-20T08:00:19","date_gmt":"2022-12-20T12:00:19","guid":{"rendered":"https:\/\/www.pragmaticinstitute.com\/?post_type=resources&p=9004111224359373"},"modified":"2022-12-21T11:12:41","modified_gmt":"2022-12-21T15:12:41","slug":"15-questions-to-ask-when-preparing-data-for-analysis","status":"publish","type":"resources","link":"https:\/\/www.pragmaticinstitute.com\/resources\/articles\/data\/15-questions-to-ask-when-preparing-data-for-analysis\/","title":{"rendered":"15 Questions to Ask When Preparing Data for Analysis"},"content":{"rendered":"

As a data practitioner, you probably spend over <\/span>80% of your time<\/span><\/a> preparing your data for analysis. This may be frustrating at times as you are eager to perform the analysis and uncover trends and insights.\u00a0<\/span><\/p>\n

However, data preparation is an integral component of <\/span>data analysis<\/span><\/a>. Without proper data preparation, subsequent data analysis will be flawed.\u00a0<\/span><\/p>\n

The preparation process includes reformatting and cleaning the data, correcting any errors and outliers, and combining data sets if applicable.\u00a0<\/span><\/p>\n

Effective data preparation is beneficial for organizations to optimize the analysis process. Preparing the data is a key step to ensure the data available is of good quality and insights derived from it are accurate and reliable.\u00a0<\/span><\/p>\n

Additionally, a thorough exploration of the <\/span>data<\/span><\/a> and possible methods during this phase is well worth the effort and can save a lot of time and aggravation down the line.\u00a0<\/span><\/p>\n

 <\/p>\n

DATA PREPARATION SCENARIO\u00a0<\/b><\/h3>\n

Imagine a mobile communications company wants to understand the characteristics of customers who churn or leave the company for another provider. If you were the data analyst presented with this request, you\u2019d want to use the data preparation phase to help you understand the feasibility of this request before diving into the data.\u00a0<\/span><\/p>\n

The first step is to determine how far back stakeholders want the data to be investigated and then identify if there is data available on who churned during that period (e.g., 5 years). Machine learning and <\/span>artificial intelligence models<\/span><\/a> can help determine if the data set is available and applicable.\u00a0<\/span><\/p>\n

Decisions will arise. Will you delete or ignore missing data? Or would you try to fill in missing values through imputation? If there are extreme values, will you keep or delete them?\u00a0<\/span><\/p>\n

 <\/p>\n

QUESTIONS TO KEEP IN MIND FOR DATA ANALYSIS<\/b><\/h3>\n

Here is a checklist with questions to help you ensure you cover all the important bases of the data preparation phase of a data project.\u00a0<\/span><\/p>\n

This checklist helps to ensure you have access to accurate data and identifies other key issues from the start. It begins with general overview questions and becomes more specific and <\/span>action-oriented<\/span><\/a>.\u00a0<\/span><\/p>\n

You will likely want to add relevant questions of your own pertaining to your industry and organization.\u00a0<\/span><\/p>\n

 <\/p>\n

AT FIRST GLANCE:\u00a0<\/b><\/h4>\n

1. Does the data you need exist?\u00a0<\/span><\/p>\n

2. Do you know how the data was generated and collected?\u00a0<\/span><\/p>\n

3. Is the data enough to reach reliable conclusions?\u00a0<\/span><\/p>\n

UPON FURTHER REFLECTION:<\/b>\u00a0<\/span><\/h4>\n

4. Does it measure what you need?\u00a0<\/span><\/p>\n

5. Are the variables the correct types or levels?\u00a0<\/span><\/p>\n

6. Do you understand the labels and codes used?\u00a0<\/span><\/p>\n

AFTER EXPLORING THE DATA:<\/b><\/p>\n

7. Does the data include the required range and variability?\u00a0<\/span><\/p>\n

8. Are the distributions as you would expect?\u00a0<\/span><\/p>\n

9. Have you identified outliers or anomalies?\u00a0<\/span><\/p>\n

CONSIDER RETURN ON INVESTMENT (ROI):<\/b><\/p>\n

10. Are you focusing on predictors you can control?\u00a0<\/span><\/p>\n

11. Have you identified the costs of manipulating the predictors?\u00a0<\/span><\/p>\n

12. Have you identified the potential benefits of conducting your analysis?\u00a0<\/span><\/p>\n

AT THE END OF YOUR PREPARATION:\u00a0<\/b><\/p>\n

13. Are you confident that your analysis will produce the desired insights?\u00a0<\/span><\/p>\n

14. Have you identified if anything can be safely and usefully reduced?\u00a0<\/span><\/p>\n

15. Can you explain and justify your conclusions and recommendations?<\/span><\/p>\n

 <\/p>\n

[Want to see more data preparation questions not listed here? <\/b>Download our ebook<\/b><\/a> \u2013 Prepare: Avoid Common Pitfalls by Analyzing the Right Data]\u00a0<\/b><\/p>\n

 <\/p>\n

CONCLUSION<\/b><\/p>\n

Data is only as useful as its accuracy.\u00a0<\/span><\/p>\n

As organizations spend resources and time to ensure the <\/span>quality of their data<\/span><\/a> is accurate and reliable, an error or issue in the data can significantly impact decision-making or skew insights. Asking the right questions when preparing your data is critical to getting accurate data insights.\u00a0<\/span><\/p>\n

 <\/p>\n

Advance From A Tactical Role to Being A Strategic Contributor<\/b>\u00a0<\/span><\/p>\n

Translate business needs into achievable data projects with Pragmatic Institute\u2019s course, <\/span>Business-Driven Data Analysis<\/i><\/b><\/a>. The course is built around the Pragmatic Data Insights Model to ensure data practitioners and stakeholders embrace an optimized approach to data projects. Master the Pragmatic Data Insights Model and implement these skills within your own organization using real-world data.<\/span><\/p>\n

Learn More<\/b><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Effective data preparation is beneficial for organizations to optimize the analysis process. Preparing the data is a key step to ensure the data available is of good quality and insights derived from it are accurate and reliable.\u00a0<\/p>\n","protected":false},"author":9004111224189798,"featured_media":9004111224359384,"menu_order":0,"template":"","categories":[9004111222509931],"tags":[],"content-series":[],"content-format":[9004111223037711],"framework-box":[],"vertical":[132],"ppma_author":[1262],"class_list":["post-9004111224359373","resources","type-resources","status-publish","has-post-thumbnail","hentry","category-data-science","content-format-article","vertical-data","author-pragmatic-institute-expert-training-for-data-design-product"],"yoast_head":"\n15 Questions to Ask When Preparing Data for Analysis | Pragmatic Institute<\/title>\n<meta name=\"description\" content=\"Effective data preparation is beneficial for organizations to optimize the analysis process. Preparing the data is a key step to ensure the data available is of good quality and insights derived from it are accurate and reliable.\u00a0\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pragmaticinstitute.com\/resources\/articles\/data\/15-questions-to-ask-when-preparing-data-for-analysis\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"15 Questions to Ask When Preparing Data for Analysis | Pragmatic Institute\" \/>\n<meta property=\"og:description\" content=\"Effective data preparation is beneficial for organizations to optimize the analysis process. Preparing the data is a key step to ensure the data available is of good quality and insights derived from it are accurate and reliable.\u00a0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pragmaticinstitute.com\/resources\/articles\/data\/15-questions-to-ask-when-preparing-data-for-analysis\/\" \/>\n<meta property=\"og:site_name\" content=\"Pragmatic Institute - Resources\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-21T15:12:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.pragmaticinstitute.com\/resources\/wp-content\/uploads\/sites\/6\/2022\/12\/programmers-questioning-source-cyber-attacks-system-security-coverage-software-technician-triangulates-hacker-location-by-updating-safety-script-codes-data-processor-sequencer-scaled.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1707\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.pragmaticinstitute.com\/resources\/articles\/data\/15-questions-to-ask-when-preparing-data-for-analysis\/\",\"url\":\"https:\/\/www.pragmaticinstitute.com\/resources\/articles\/data\/15-questions-to-ask-when-preparing-data-for-analysis\/\",\"name\":\"15 Questions to Ask When Preparing Data for Analysis | Pragmatic Institute\",\"isPartOf\":{\"@id\":\"https:\/\/www.pragmaticinstitute.com\/resources\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.pragmaticinstitute.com\/resources\/articles\/data\/15-questions-to-ask-when-preparing-data-for-analysis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.pragmaticinstitute.com\/resources\/articles\/data\/15-questions-to-ask-when-preparing-data-for-analysis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.pragmaticinstitute.com\/resources\/wp-content\/uploads\/sites\/6\/2022\/12\/programmers-questioning-source-cyber-attacks-system-security-coverage-software-technician-triangulates-hacker-location-by-updating-safety-script-codes-data-processor-sequencer-scaled.jpg\",\"datePublished\":\"2022-12-20T12:00:19+00:00\",\"dateModified\":\"2022-12-21T15:12:41+00:00\",\"description\":\"Effective data preparation is beneficial for organizations to optimize the analysis process. Preparing the data is a key step to ensure the data available is of good quality and insights derived from it are accurate and reliable.\u00a0\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pragmaticinstitute.com\/resources\/articles\/data\/15-questions-to-ask-when-preparing-data-for-analysis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pragmaticinstitute.com\/resources\/articles\/data\/15-questions-to-ask-when-preparing-data-for-analysis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.pragmaticinstitute.com\/resources\/articles\/data\/15-questions-to-ask-when-preparing-data-for-analysis\/#primaryimage\",\"url\":\"https:\/\/www.pragmaticinstitute.com\/resources\/wp-content\/uploads\/sites\/6\/2022\/12\/programmers-questioning-source-cyber-attacks-system-security-coverage-software-technician-triangulates-hacker-location-by-updating-safety-script-codes-data-processor-sequencer-scaled.jpg\",\"contentUrl\":\"https:\/\/www.pragmaticinstitute.com\/resources\/wp-content\/uploads\/sites\/6\/2022\/12\/programmers-questioning-source-cyber-attacks-system-security-coverage-software-technician-triangulates-hacker-location-by-updating-safety-script-codes-data-processor-sequencer-scaled.jpg\",\"width\":2560,\"height\":1707,\"caption\":\"Data preparation is critical\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pragmaticinstitute.com\/resources\/articles\/data\/15-questions-to-ask-when-preparing-data-for-analysis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pragmaticinstitute.com\/resources\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Resources\",\"item\":\"https:\/\/www.pragmaticinstitute.com\/resources\/resources\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"15 Questions to Ask When Preparing Data for Analysis\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.pragmaticinstitute.com\/resources\/#website\",\"url\":\"https:\/\/www.pragmaticinstitute.com\/resources\/\",\"name\":\"Pragmatic Institute\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.pragmaticinstitute.com\/resources\/#organization\"},\"alternateName\":\"Pragmatic\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.pragmaticinstitute.com\/resources\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.pragmaticinstitute.com\/resources\/#organization\",\"name\":\"Pragmatic Institute\",\"url\":\"https:\/\/www.pragmaticinstitute.com\/resources\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.pragmaticinstitute.com\/resources\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.pragmaticinstitute.com\/resources\/wp-content\/uploads\/sites\/6\/2021\/09\/The_Pragmatic_Institute_Stacked_Logo.png\",\"contentUrl\":\"https:\/\/www.pragmaticinstitute.com\/resources\/wp-content\/uploads\/sites\/6\/2021\/09\/The_Pragmatic_Institute_Stacked_Logo.png\",\"width\":216,\"height\":224,\"caption\":\"Pragmatic Institute\"},\"image\":{\"@id\":\"https:\/\/www.pragmaticinstitute.com\/resources\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"15 Questions to Ask When Preparing Data for Analysis | Pragmatic Institute","description":"Effective data preparation is beneficial for organizations to optimize the analysis process. Preparing the data is a key step to ensure the data available is of good quality and insights derived from it are accurate and reliable.\u00a0","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:\/\/www.pragmaticinstitute.com\/resources\/articles\/data\/15-questions-to-ask-when-preparing-data-for-analysis\/","og_locale":"en_US","og_type":"article","og_title":"15 Questions to Ask When Preparing Data for Analysis | Pragmatic Institute","og_description":"Effective data preparation is beneficial for organizations to optimize the analysis process. Preparing the data is a key step to ensure the data available is of good quality and insights derived from it are accurate and reliable.\u00a0","og_url":"https:\/\/www.pragmaticinstitute.com\/resources\/articles\/data\/15-questions-to-ask-when-preparing-data-for-analysis\/","og_site_name":"Pragmatic Institute - Resources","article_modified_time":"2022-12-21T15:12:41+00:00","og_image":[{"width":2560,"height":1707,"url":"https:\/\/www.pragmaticinstitute.com\/resources\/wp-content\/uploads\/sites\/6\/2022\/12\/programmers-questioning-source-cyber-attacks-system-security-coverage-software-technician-triangulates-hacker-location-by-updating-safety-script-codes-data-processor-sequencer-scaled.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.pragmaticinstitute.com\/resources\/articles\/data\/15-questions-to-ask-when-preparing-data-for-analysis\/","url":"https:\/\/www.pragmaticinstitute.com\/resources\/articles\/data\/15-questions-to-ask-when-preparing-data-for-analysis\/","name":"15 Questions to Ask When Preparing Data for Analysis | Pragmatic Institute","isPartOf":{"@id":"https:\/\/www.pragmaticinstitute.com\/resources\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pragmaticinstitute.com\/resources\/articles\/data\/15-questions-to-ask-when-preparing-data-for-analysis\/#primaryimage"},"image":{"@id":"https:\/\/www.pragmaticinstitute.com\/resources\/articles\/data\/15-questions-to-ask-when-preparing-data-for-analysis\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pragmaticinstitute.com\/resources\/wp-content\/uploads\/sites\/6\/2022\/12\/programmers-questioning-source-cyber-attacks-system-security-coverage-software-technician-triangulates-hacker-location-by-updating-safety-script-codes-data-processor-sequencer-scaled.jpg","datePublished":"2022-12-20T12:00:19+00:00","dateModified":"2022-12-21T15:12:41+00:00","description":"Effective data preparation is beneficial for organizations to optimize the analysis process. Preparing the data is a key step to ensure the data available is of good quality and insights derived from it are accurate and reliable.\u00a0","breadcrumb":{"@id":"https:\/\/www.pragmaticinstitute.com\/resources\/articles\/data\/15-questions-to-ask-when-preparing-data-for-analysis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pragmaticinstitute.com\/resources\/articles\/data\/15-questions-to-ask-when-preparing-data-for-analysis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pragmaticinstitute.com\/resources\/articles\/data\/15-questions-to-ask-when-preparing-data-for-analysis\/#primaryimage","url":"https:\/\/www.pragmaticinstitute.com\/resources\/wp-content\/uploads\/sites\/6\/2022\/12\/programmers-questioning-source-cyber-attacks-system-security-coverage-software-technician-triangulates-hacker-location-by-updating-safety-script-codes-data-processor-sequencer-scaled.jpg","contentUrl":"https:\/\/www.pragmaticinstitute.com\/resources\/wp-content\/uploads\/sites\/6\/2022\/12\/programmers-questioning-source-cyber-attacks-system-security-coverage-software-technician-triangulates-hacker-location-by-updating-safety-script-codes-data-processor-sequencer-scaled.jpg","width":2560,"height":1707,"caption":"Data preparation is critical"},{"@type":"BreadcrumbList","@id":"https:\/\/www.pragmaticinstitute.com\/resources\/articles\/data\/15-questions-to-ask-when-preparing-data-for-analysis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pragmaticinstitute.com\/resources\/"},{"@type":"ListItem","position":2,"name":"Resources","item":"https:\/\/www.pragmaticinstitute.com\/resources\/resources\/"},{"@type":"ListItem","position":3,"name":"15 Questions to Ask When Preparing Data for Analysis"}]},{"@type":"WebSite","@id":"https:\/\/www.pragmaticinstitute.com\/resources\/#website","url":"https:\/\/www.pragmaticinstitute.com\/resources\/","name":"Pragmatic Institute","description":"","publisher":{"@id":"https:\/\/www.pragmaticinstitute.com\/resources\/#organization"},"alternateName":"Pragmatic","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pragmaticinstitute.com\/resources\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.pragmaticinstitute.com\/resources\/#organization","name":"Pragmatic Institute","url":"https:\/\/www.pragmaticinstitute.com\/resources\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pragmaticinstitute.com\/resources\/#\/schema\/logo\/image\/","url":"https:\/\/www.pragmaticinstitute.com\/resources\/wp-content\/uploads\/sites\/6\/2021\/09\/The_Pragmatic_Institute_Stacked_Logo.png","contentUrl":"https:\/\/www.pragmaticinstitute.com\/resources\/wp-content\/uploads\/sites\/6\/2021\/09\/The_Pragmatic_Institute_Stacked_Logo.png","width":216,"height":224,"caption":"Pragmatic Institute"},"image":{"@id":"https:\/\/www.pragmaticinstitute.com\/resources\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.pragmaticinstitute.com\/resources\/wp-json\/wp\/v2\/resources\/9004111224359373","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pragmaticinstitute.com\/resources\/wp-json\/wp\/v2\/resources"}],"about":[{"href":"https:\/\/www.pragmaticinstitute.com\/resources\/wp-json\/wp\/v2\/types\/resources"}],"author":[{"embeddable":true,"href":"https:\/\/www.pragmaticinstitute.com\/resources\/wp-json\/wp\/v2\/users\/9004111224189798"}],"version-history":[{"count":0,"href":"https:\/\/www.pragmaticinstitute.com\/resources\/wp-json\/wp\/v2\/resources\/9004111224359373\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pragmaticinstitute.com\/resources\/wp-json\/wp\/v2\/media\/9004111224359384"}],"wp:attachment":[{"href":"https:\/\/www.pragmaticinstitute.com\/resources\/wp-json\/wp\/v2\/media?parent=9004111224359373"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pragmaticinstitute.com\/resources\/wp-json\/wp\/v2\/categories?post=9004111224359373"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pragmaticinstitute.com\/resources\/wp-json\/wp\/v2\/tags?post=9004111224359373"},{"taxonomy":"content-series","embeddable":true,"href":"https:\/\/www.pragmaticinstitute.com\/resources\/wp-json\/wp\/v2\/content-series?post=9004111224359373"},{"taxonomy":"content-format","embeddable":true,"href":"https:\/\/www.pragmaticinstitute.com\/resources\/wp-json\/wp\/v2\/content-format?post=9004111224359373"},{"taxonomy":"framework-box","embeddable":true,"href":"https:\/\/www.pragmaticinstitute.com\/resources\/wp-json\/wp\/v2\/framework-box?post=9004111224359373"},{"taxonomy":"vertical","embeddable":true,"href":"https:\/\/www.pragmaticinstitute.com\/resources\/wp-json\/wp\/v2\/vertical?post=9004111224359373"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.pragmaticinstitute.com\/resources\/wp-json\/wp\/v2\/ppma_author?post=9004111224359373"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}