{"id":2788,"date":"2018-05-02T15:53:00","date_gmt":"2018-05-02T19:53:00","guid":{"rendered":"https:\/\/solutionsreview.com\/data-integration\/?p=2788"},"modified":"2018-09-06T15:02:59","modified_gmt":"2018-09-06T19:02:59","slug":"excel-is-still-the-most-commonly-used-data-preparation-tool","status":"publish","type":"post","link":"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/","title":{"rendered":"Excel is (Still) the Most Commonly Used Data Preparation Tool"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2992\" src=\"https:\/\/solutionsreview.com\/data-integration\/files\/2018\/05\/oie_2184655Qeuy2tB1.jpg\" alt=\"Excel is (Still) the Most Commonly Used Data Preparation Tool\" width=\"800\" height=\"400\" srcset=\"https:\/\/solutionsreview.com\/data-integration\/files\/2018\/05\/oie_2184655Qeuy2tB1.jpg 800w, https:\/\/solutionsreview.com\/data-integration\/files\/2018\/05\/oie_2184655Qeuy2tB1-300x150.jpg 300w, https:\/\/solutionsreview.com\/data-integration\/files\/2018\/05\/oie_2184655Qeuy2tB1-768x384.jpg 768w, https:\/\/solutionsreview.com\/data-integration\/files\/2018\/05\/oie_2184655Qeuy2tB1-540x270.jpg 540w, https:\/\/solutionsreview.com\/data-integration\/files\/2018\/05\/oie_2184655Qeuy2tB1-162x81.jpg 162w, https:\/\/solutionsreview.com\/data-integration\/files\/2018\/05\/oie_2184655Qeuy2tB1-360x180.jpg 360w, https:\/\/solutionsreview.com\/data-integration\/files\/2018\/05\/oie_2184655Qeuy2tB1-630x315.jpg 630w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify\">2010 called and wants its data profiling technologies back. According to a new study commissioned by <a href=\"https:\/\/www.sourcemedia.com\/\" target=\"_blank\" rel=\"noopener\">SourceMedia<\/a> Research and <a href=\"https:\/\/www.paxata.com\/\" target=\"_blank\" rel=\"noopener\">Paxata<\/a>, nearly 70 percent of organizations still use Microsoft Excel as their main means of doing data preparation. The report, entitled <a href=\"https:\/\/go.paxata.com\/2018_GLO_DG_Web-Content-AR-Other_The-State-of-Data-Quality_LandingPage.html\" target=\"_blank\" rel=\"noopener\"><em>The State of Data Quality in the Enterprise 2018<\/em><\/a>, is the compilation of the 2017 Data Quality Study. The study surveyed 290 executives and IT professionals at organizations with $100-million or more in annual revenue and found that they remain well behind the eight-ball in a number of data-related tasks.<\/p>\n<div class=\"widget\"><div class=\"aside-card\">\t\t\t<div class=\"textwidget\"><p><a class=\"bgs-speedbump\" title=\"Download link to Data Integration Buyer's Guide\" href=\"https:\/\/solutionsreview.com\/data-integration\/data-integration-buyers-guide\/\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-1682\" src=\"https:\/\/solutionsreview.com\/data-integration\/files\/2019\/02\/di-bg-speedbump.jpg\" alt=\"Download Link to Data Integration Buyer's Guide\" width=\"800\" height=\"225\" \/><\/a><\/p>\n<\/div>\n\t\t<\/div><\/div>\n<p style=\"text-align: justify\">Of the more troubling revelations in the report is that only 15 percent of organizations have deployed viable data quality models. It&#8217;s at least somewhat positive news that 40 percent are in the process of developing those frameworks. 38 percent have just begun thinking about data quality in any meaningful way. These figures aren&#8217;t that surprising given the reality that organizations are being bombarded with data from all directions. Many are simultaneously trying to balance data ingestion, storage, integration, preparation, and analytics.<\/p>\n<p style=\"text-align: justify\">The report outlines two main challenges when it comes to overall data quality. The first and most obvious is data variety, with enterprises attempting to ingest data from several sources at a time. Roughly 37 percent of enterprise data comes from external sources. The complexity of data next up on the docket, and though organizations are still using mostly structured data (64 percent), more than 20 percent report ingesting nearly a fifty-fifty split of structured and unstructured.<\/p>\n<p style=\"text-align: justify\">We&#8217;ve highlighted before the <a href=\"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/\" target=\"_blank\" rel=\"noopener\">time-consuming nature<\/a> of data preparation, and even organizations with mature data quality frameworks struggle with this. In fact, low-level data preparation tasks are the greatest culprits, with 30 percent of time spent on ingestion and 42 percent spent on data profiling. The report found, unsurprisingly, that the more time organizations spent on overall data quality, the more likely they were to be pleased with the results. So it&#8217;s safe to assume this conundrum isn&#8217;t going away anytime soon.<\/p>\n<p style=\"text-align: justify\">It&#8217;s interesting that even those organizations with mature data quality models still utilize Excel to some degree, which raises a number of questions. At first glance it would seem as though many of these organizations simply haven&#8217;t yet made the switch to dedicated data preparation tools. But this simply isn&#8217;t the case, as a number of those professionals polled indicated that Excel still plays a role in their data profiling activities. There&#8217;s also the fact that many of those polled just aren&#8217;t using unstructured data to the degree that would warrant stand-alone data preparation.<\/p>\n<p style=\"text-align: justify\">Solutions Review is most interested in what the buyers think. Of those polled that are currently in-market for data quality solutions have identified the capabilities they are most interested in acquiring in the future. They include support interactivity with structured and unstructured data, ease of use for their non-technical users, and availability for ingesting and preparing large data volumes.<\/p>\n<p>We highly encourage you to read the <a href=\"https:\/\/go.paxata.com\/2018_GLO_DG_Web-Content-AR-Other_The-State-of-Data-Quality_LandingPage.html\" target=\"_blank\" rel=\"noopener\">full report<\/a> (registration required).<\/p>\n<p style=\"text-align: justify\"><div class=\"hr hr\"><\/div><\/p>\n<br \/>Widget not in any sidebars<br \/>\n","protected":false},"excerpt":{"rendered":"<p>2010 called and wants its data profiling technologies back. According to a new study commissioned by SourceMedia Research and Paxata, nearly 70 percent of organizations still use Microsoft Excel as their main means of doing data preparation. The report, entitled The State of Data Quality in the Enterprise 2018, is the compilation of the 2017 [&hellip;]<\/p>\n","protected":false},"author":23,"featured_media":2992,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[3],"tags":[343,291,535],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel is (Still) the Most Commonly Used Data Preparation Tool<\/title>\n<meta name=\"description\" content=\"Microsoft Excel is still the most commonly used data preparation tool in the enterprise, but for reasons you might not immediately think.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tim King\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/\"},\"author\":{\"name\":\"Tim King\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c\"},\"headline\":\"Excel is (Still) the Most Commonly Used Data Preparation Tool\",\"datePublished\":\"2018-05-02T19:53:00+00:00\",\"dateModified\":\"2018-09-06T19:02:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/\"},\"wordCount\":513,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#organization\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2018\/05\/oie_2184655Qeuy2tB1.jpg\",\"keywords\":[\"Data Preparation\",\"Data Quality\",\"SourceMedia Research\"],\"articleSection\":[\"Data Integration News\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/\",\"name\":\"Excel is (Still) the Most Commonly Used Data Preparation Tool\",\"isPartOf\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2018\/05\/oie_2184655Qeuy2tB1.jpg\",\"datePublished\":\"2018-05-02T19:53:00+00:00\",\"dateModified\":\"2018-09-06T19:02:59+00:00\",\"description\":\"Microsoft Excel is still the most commonly used data preparation tool in the enterprise, but for reasons you might not immediately think.\",\"breadcrumb\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/#primaryimage\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2018\/05\/oie_2184655Qeuy2tB1.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2018\/05\/oie_2184655Qeuy2tB1.jpg\",\"width\":800,\"height\":400,\"caption\":\"Excel is (Still) the Most Commonly Used Data Preparation Tool\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/solutionsreview.com\/data-integration\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel is (Still) the Most Commonly Used Data Preparation Tool\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#website\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/\",\"name\":\"Data Integration Tools &amp; ETL Software | Solutions Review\",\"description\":\"Evaluating Enterprise ETL Tools, Cloud iPaaS &amp; Real-Time Data Streaming Platforms.\",\"publisher\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/solutionsreview.com\/data-integration\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#organization\",\"name\":\"Solutions Review\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2016\/02\/Solutions_Review_Header_Data_Integration_225.png\",\"contentUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2016\/02\/Solutions_Review_Header_Data_Integration_225.png\",\"width\":225,\"height\":90,\"caption\":\"Solutions Review\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c\",\"name\":\"Tim King\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2023\/12\/tk.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2023\/12\/tk.jpg\",\"caption\":\"Tim King\"},\"description\":\"Tim is Solutions Review's Executive Editor covering the human impact of AI on the future of work and learning. He is also the Media Strategist behind Insight Jam (1M+ on YouTube) events and programming. A 2017 and 2018 Most Influential Business Journalist and 2021 \\\"Who's Who\\\" in multiple categories, Tim is a recognized thought leader in enterprise tech and AI.\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/author\/timking\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel is (Still) the Most Commonly Used Data Preparation Tool","description":"Microsoft Excel is still the most commonly used data preparation tool in the enterprise, but for reasons you might not immediately think.","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:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/","twitter_misc":{"Written by":"Tim King","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/#article","isPartOf":{"@id":"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/"},"author":{"name":"Tim King","@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c"},"headline":"Excel is (Still) the Most Commonly Used Data Preparation Tool","datePublished":"2018-05-02T19:53:00+00:00","dateModified":"2018-09-06T19:02:59+00:00","mainEntityOfPage":{"@id":"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/"},"wordCount":513,"commentCount":0,"publisher":{"@id":"https:\/\/solutionsreview.com\/data-integration\/#organization"},"image":{"@id":"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2018\/05\/oie_2184655Qeuy2tB1.jpg","keywords":["Data Preparation","Data Quality","SourceMedia Research"],"articleSection":["Data Integration News"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/","url":"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/","name":"Excel is (Still) the Most Commonly Used Data Preparation Tool","isPartOf":{"@id":"https:\/\/solutionsreview.com\/data-integration\/#website"},"primaryImageOfPage":{"@id":"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/#primaryimage"},"image":{"@id":"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2018\/05\/oie_2184655Qeuy2tB1.jpg","datePublished":"2018-05-02T19:53:00+00:00","dateModified":"2018-09-06T19:02:59+00:00","description":"Microsoft Excel is still the most commonly used data preparation tool in the enterprise, but for reasons you might not immediately think.","breadcrumb":{"@id":"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/#primaryimage","url":"https:\/\/solutionsreview.com\/data-integration\/files\/2018\/05\/oie_2184655Qeuy2tB1.jpg","contentUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2018\/05\/oie_2184655Qeuy2tB1.jpg","width":800,"height":400,"caption":"Excel is (Still) the Most Commonly Used Data Preparation Tool"},{"@type":"BreadcrumbList","@id":"https:\/\/solutionsreview.com\/data-integration\/excel-is-still-the-most-commonly-used-data-preparation-tool\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/solutionsreview.com\/data-integration\/"},{"@type":"ListItem","position":2,"name":"Excel is (Still) the Most Commonly Used Data Preparation Tool"}]},{"@type":"WebSite","@id":"https:\/\/solutionsreview.com\/data-integration\/#website","url":"https:\/\/solutionsreview.com\/data-integration\/","name":"Data Integration Tools &amp; ETL Software | Solutions Review","description":"Evaluating Enterprise ETL Tools, Cloud iPaaS &amp; Real-Time Data Streaming Platforms.","publisher":{"@id":"https:\/\/solutionsreview.com\/data-integration\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/solutionsreview.com\/data-integration\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/solutionsreview.com\/data-integration\/#organization","name":"Solutions Review","url":"https:\/\/solutionsreview.com\/data-integration\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/logo\/image\/","url":"https:\/\/solutionsreview.com\/data-integration\/files\/2016\/02\/Solutions_Review_Header_Data_Integration_225.png","contentUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2016\/02\/Solutions_Review_Header_Data_Integration_225.png","width":225,"height":90,"caption":"Solutions Review"},"image":{"@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c","name":"Tim King","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/image\/","url":"https:\/\/solutionsreview.com\/data-integration\/files\/2023\/12\/tk.jpg","contentUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2023\/12\/tk.jpg","caption":"Tim King"},"description":"Tim is Solutions Review's Executive Editor covering the human impact of AI on the future of work and learning. He is also the Media Strategist behind Insight Jam (1M+ on YouTube) events and programming. A 2017 and 2018 Most Influential Business Journalist and 2021 \"Who's Who\" in multiple categories, Tim is a recognized thought leader in enterprise tech and AI.","url":"https:\/\/solutionsreview.com\/data-integration\/author\/timking\/"}]}},"_links":{"self":[{"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/posts\/2788"}],"collection":[{"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/users\/23"}],"replies":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/comments?post=2788"}],"version-history":[{"count":0,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/posts\/2788\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/media\/2992"}],"wp:attachment":[{"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/media?parent=2788"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/categories?post=2788"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/tags?post=2788"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}