{"id":5014,"date":"2022-10-21T14:00:12","date_gmt":"2022-10-21T18:00:12","guid":{"rendered":"https:\/\/solutionsreview.com\/data-integration\/?p=5014"},"modified":"2022-12-19T16:57:45","modified_gmt":"2022-12-19T21:57:45","slug":"categorical-data-vs-quantitative-data-whats-the-difference","status":"publish","type":"post","link":"https:\/\/solutionsreview.com\/data-integration\/categorical-data-vs-quantitative-data-whats-the-difference\/","title":{"rendered":"Categorical Data vs. Quantitative Data; What’s the Difference?"},"content":{"rendered":"

\"Quantitative<\/p>\n

This is part of Solutions Review\u2019s Premium Content Series, a collection of contributed columns written by industry experts in maturing software categories. In this submission, thatDot<\/a> COO Rob Malnati compares categorical data vs. quantitative data so you know the difference.<\/em><\/strong><\/p>\n

\"SRWith all the talk about how valuable data is (it is the new oil, after all), you might be forgiven if you think enterprises are doing all they can to capture and extract value from every precious byte. But that\u2019s simply not the case.<\/p>\n

In fact, according to some estimates, as much as 95 percent of the data generated by businesses goes unprocessed, generating no value; worse, 70 percent of it is discarded, meaning the opportunity to derive value is lost forever.<\/p>\n

Why? Because, like oil, there are different types of data \u2013 the most basic being quantitative (often called numerical) and categorical data \u2013 and each requires different tools to process. And because most enterprises lack those tools, particularly for categorical data, a surprising amount of data gets thrown away.<\/p>\n

Below we look at the difference between categorical and quantitative data, the challenges of processing both, and how leaders can evolve their tools and processes to make the most out of the abundance of data.<\/p>\n

\t\t\t

\"Download<\/a><\/p>\n<\/div>\n\t\t<\/div><\/div>\n

Quantitative Data vs. Categorical Data<\/strong><\/h2>\n
<\/div>\n

Quantitative data includes any calculable or measurable information that can be operated on mathematically. Quantitative data can describe the physical world \u2013 weights and measures \u2013 or model the hypothetical world with statistical analysis. Bank balances, air temperatures, and polling data are all quantitative.<\/p>\n

Categorical data, on the other hand, is descriptive and conceptual and cannot be directly manipulated with mathematical operations. Colors, product models, and email addresses are common examples. Your bank account number, describing the weather as hot, mild, or cold, and classifying the results of a poll in order of results are all categorical data.<\/p>\n

\"thatDot<\/p>\n

Very few applications or processes can be understood using only one type of data. For example, think about just a fraction of the data created when shipping a package from Seattle to Washington, DC:<\/p>\n

\"thatDot<\/p>\n

It seems evident that without both quantitative and numerical data, one can\u2019t fully understand let alone analyze this data. Both types of data are needed. And yet, when it comes to analyzing large amounts of mixed data \u2013 whether in SIEM tools like Splunk<\/a><\/strong><\/span> or using common machine learning algorithms \u2013 the tools are almost entirely skewed toward processing quantitative data.<\/p>\n

Current Challenges of Processing Categorical Data<\/strong><\/h3>\n

There are two widely available means of processing categorical data: turning it into numbers using encoding techniques like \u201cone-hot\u201d or full-text search systems.<\/p>\n

A quick search for \u201ccategorical data\u201d in the documentation of leading databases, data lakes, and SIEM providers indicates how pervasive this approach is. Encoding rarely works well in conveying important information that we can immediately detect, like gradations of intensity (chilly vs. cool or hot vs. scorching) or relationships (kitten to cat; login attempt to account).<\/p>\n

Text search is the most common way to work with categorical data types. However, while it is well-suited for finding a specific pattern of characters within files, search is best for data retrieval and basic quantitative analytics (e.g., counts of terms). The terms kitten and cat in the context of search are as different as the terms kitten and cobalt.<\/p>\n

What is lacking is a way to organize and understand categorical data the way humans think: to express causality, progression, ordinality, and degree of difference.<\/p>\n

The value of most data is time sensitive. While we can learn from historical data, our world moves rapidly, and we need instant decision-making. Legacy data processing needs to shift into real-time now more than ever.<\/p>\n

In the past, the data processing tools on the market have excelled at processing one type of data over the other, transforming the data and taking a long time to process large volumes. Enterprises need to focus on what results and information they are trying to garner from this influx of data and choose a tool that can keep up with the volume and demand for real-time analysis.<\/p>\n

Keep an eye out for part two of this series, where I will dive deeper into the best types of tools and processes to organize your data, categorical, quantitative, or hybrid.<\/p>\n

<\/div>\n

\t\t\t

\"Download<\/a><\/p>\n<\/div>\n\t\t<\/div><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"

This is part of Solutions Review\u2019s Premium Content Series, a collection of contributed columns written by industry experts in maturing software categories. In this submission, thatDot COO Rob Malnati compares categorical data vs. quantitative data so you know the difference. With all the talk about how valuable data is (it is the new oil, after […]<\/p>\n","protected":false},"author":212,"featured_media":5016,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[1102],"acf":[],"yoast_head":"\nCategorical Data vs. Quantitative Data; What's the Difference?<\/title>\n<meta name=\"description\" content=\"In this submission, thatDot COO Rob Malnati compares categorical data vs. quantitative data so you know the difference.\" \/>\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\/categorical-data-vs-quantitative-data-whats-the-difference\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rob Malnati\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/categorical-data-vs-quantitative-data-whats-the-difference\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/categorical-data-vs-quantitative-data-whats-the-difference\/\"},\"author\":{\"name\":\"Rob Malnati\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/73bc233602e65c565b506621aac346af\"},\"headline\":\"Categorical Data vs. Quantitative Data; What’s the Difference?\",\"datePublished\":\"2022-10-21T18:00:12+00:00\",\"dateModified\":\"2022-12-19T21:57:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/categorical-data-vs-quantitative-data-whats-the-difference\/\"},\"wordCount\":728,\"publisher\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#organization\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/categorical-data-vs-quantitative-data-whats-the-difference\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2022\/10\/MicrosoftTeams-image-4.jpg\",\"keywords\":[\"thatDot\"],\"articleSection\":[\"Best Practices\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/categorical-data-vs-quantitative-data-whats-the-difference\/\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/categorical-data-vs-quantitative-data-whats-the-difference\/\",\"name\":\"Categorical Data vs. Quantitative Data; What's the Difference?\",\"isPartOf\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/categorical-data-vs-quantitative-data-whats-the-difference\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/categorical-data-vs-quantitative-data-whats-the-difference\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2022\/10\/MicrosoftTeams-image-4.jpg\",\"datePublished\":\"2022-10-21T18:00:12+00:00\",\"dateModified\":\"2022-12-19T21:57:45+00:00\",\"description\":\"In this submission, thatDot COO Rob Malnati compares categorical data vs. quantitative data so you know the difference.\",\"breadcrumb\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/categorical-data-vs-quantitative-data-whats-the-difference\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/solutionsreview.com\/data-integration\/categorical-data-vs-quantitative-data-whats-the-difference\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/categorical-data-vs-quantitative-data-whats-the-difference\/#primaryimage\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2022\/10\/MicrosoftTeams-image-4.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2022\/10\/MicrosoftTeams-image-4.jpg\",\"width\":800,\"height\":400,\"caption\":\"Quantitative Data vs. Categorical Data\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/categorical-data-vs-quantitative-data-whats-the-difference\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/solutionsreview.com\/data-integration\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Categorical Data vs. Quantitative Data; What’s the Difference?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#website\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/\",\"name\":\"Best Data Integration Vendors, News & Reviews for Big Data, Applications, ETL and Hadoop\",\"description\":\"Data Integration Buyers Guide and Best Practices\",\"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\/73bc233602e65c565b506621aac346af\",\"name\":\"Rob Malnati\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5783ec80da43f77efc55934815bcaf56?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5783ec80da43f77efc55934815bcaf56?s=96&d=mm&r=g\",\"caption\":\"Rob Malnati\"},\"description\":\"Rob Malnati, COO of thatDot, is a repeat entrepreneur focused on enterprise infrastructure as software. He has defined, evangelized, and managed product and go-to-market strategies for forward-looking service, software, and cloud-based SaaS providers.\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/author\/rmalnati\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Categorical Data vs. Quantitative Data; What's the Difference?","description":"In this submission, thatDot COO Rob Malnati compares categorical data vs. quantitative data so you know the difference.","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\/categorical-data-vs-quantitative-data-whats-the-difference\/","twitter_misc":{"Written by":"Rob Malnati","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/solutionsreview.com\/data-integration\/categorical-data-vs-quantitative-data-whats-the-difference\/#article","isPartOf":{"@id":"https:\/\/solutionsreview.com\/data-integration\/categorical-data-vs-quantitative-data-whats-the-difference\/"},"author":{"name":"Rob Malnati","@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/73bc233602e65c565b506621aac346af"},"headline":"Categorical Data vs. Quantitative Data; What’s the Difference?","datePublished":"2022-10-21T18:00:12+00:00","dateModified":"2022-12-19T21:57:45+00:00","mainEntityOfPage":{"@id":"https:\/\/solutionsreview.com\/data-integration\/categorical-data-vs-quantitative-data-whats-the-difference\/"},"wordCount":728,"publisher":{"@id":"https:\/\/solutionsreview.com\/data-integration\/#organization"},"image":{"@id":"https:\/\/solutionsreview.com\/data-integration\/categorical-data-vs-quantitative-data-whats-the-difference\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2022\/10\/MicrosoftTeams-image-4.jpg","keywords":["thatDot"],"articleSection":["Best Practices"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/solutionsreview.com\/data-integration\/categorical-data-vs-quantitative-data-whats-the-difference\/","url":"https:\/\/solutionsreview.com\/data-integration\/categorical-data-vs-quantitative-data-whats-the-difference\/","name":"Categorical Data vs. Quantitative Data; What's the Difference?","isPartOf":{"@id":"https:\/\/solutionsreview.com\/data-integration\/#website"},"primaryImageOfPage":{"@id":"https:\/\/solutionsreview.com\/data-integration\/categorical-data-vs-quantitative-data-whats-the-difference\/#primaryimage"},"image":{"@id":"https:\/\/solutionsreview.com\/data-integration\/categorical-data-vs-quantitative-data-whats-the-difference\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2022\/10\/MicrosoftTeams-image-4.jpg","datePublished":"2022-10-21T18:00:12+00:00","dateModified":"2022-12-19T21:57:45+00:00","description":"In this submission, thatDot COO Rob Malnati compares categorical data vs. quantitative data so you know the difference.","breadcrumb":{"@id":"https:\/\/solutionsreview.com\/data-integration\/categorical-data-vs-quantitative-data-whats-the-difference\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/solutionsreview.com\/data-integration\/categorical-data-vs-quantitative-data-whats-the-difference\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-integration\/categorical-data-vs-quantitative-data-whats-the-difference\/#primaryimage","url":"https:\/\/solutionsreview.com\/data-integration\/files\/2022\/10\/MicrosoftTeams-image-4.jpg","contentUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2022\/10\/MicrosoftTeams-image-4.jpg","width":800,"height":400,"caption":"Quantitative Data vs. Categorical Data"},{"@type":"BreadcrumbList","@id":"https:\/\/solutionsreview.com\/data-integration\/categorical-data-vs-quantitative-data-whats-the-difference\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/solutionsreview.com\/data-integration\/"},{"@type":"ListItem","position":2,"name":"Categorical Data vs. Quantitative Data; What’s the Difference?"}]},{"@type":"WebSite","@id":"https:\/\/solutionsreview.com\/data-integration\/#website","url":"https:\/\/solutionsreview.com\/data-integration\/","name":"Best Data Integration Vendors, News & Reviews for Big Data, Applications, ETL and Hadoop","description":"Data Integration Buyers Guide and Best Practices","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\/73bc233602e65c565b506621aac346af","name":"Rob Malnati","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5783ec80da43f77efc55934815bcaf56?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5783ec80da43f77efc55934815bcaf56?s=96&d=mm&r=g","caption":"Rob Malnati"},"description":"Rob Malnati, COO of thatDot, is a repeat entrepreneur focused on enterprise infrastructure as software. He has defined, evangelized, and managed product and go-to-market strategies for forward-looking service, software, and cloud-based SaaS providers.","url":"https:\/\/solutionsreview.com\/data-integration\/author\/rmalnati\/"}]}},"_links":{"self":[{"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/posts\/5014"}],"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\/212"}],"replies":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/comments?post=5014"}],"version-history":[{"count":0,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/posts\/5014\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/media\/5016"}],"wp:attachment":[{"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/media?parent=5014"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/categories?post=5014"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/tags?post=5014"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}