{"id":6413,"date":"2014-12-02T15:42:54","date_gmt":"2014-12-02T20:42:54","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=6413"},"modified":"2017-11-06T08:17:12","modified_gmt":"2017-11-06T13:17:12","slug":"faster-spotfire-bi","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/","title":{"rendered":"Faster Spotfire BI via CoSort"},"content":{"rendered":"<p><em>Introduction: As with\u00a0multiple BI platforms discussed throughout\u00a0<a href=\"http:\/\/www.iri.com\/blog\/category\/business-intelligence\/\" target=\"_blank\" rel=\"noopener\">this section<\/a> of the IRI blog site, this\u00a0article analyzes the relative data preparation performance (and benefit) of\u00a0IRI CoSort with\u00a0Tibco Spotfire when &#8216;big data&#8217; sources\u00a0are involved.<\/em><\/p>\n<p>Business intelligence (BI) is a technology-driven process for analyzing data and boosting business performance by helping executives and end users make the decisions that will optimize\u00a0internal business processes. BI and analytic systems can help organizations\u00a0identify market trends and spot problems that need to be addressed.<\/p>\n<p>These platforms encompass a variety of tools, applications, and methodologies that enable organizations to collect data from internal systems and external sources; then prepare it for analysis. Some of the large BI vendors are IBM, Microsoft, Oracle, and SAP, while newer\u00a0mid-size analytic vendors are QlikView, R, Splunk, Spotfire, and Tableau.<\/p>\n<p>Spotfire can\u00a0extract data from multiple sources<sup><a id=\"ref1\" href=\"#fn1\">1<\/a><\/sup> and render it in user-friendly charts and graphs. It is particularly useful for data intensive life science researchers and financial organizations who require simple-to-build dashboards. Spotfire features\u00a0in-memory visualization processing, and sophisticated predictive analytics.<\/p>\n<p>Spotfire can also obtain\u00a0query results, but cannot chart\u00a0data until it has been located, acquired, and otherwise prepared for visualization. Data acquisition and preparation is where <a href=\"http:\/\/www.iri.com\/products\/cosort\">IRI CoSort<\/a>\u00a0provides value to Spotfire users. CoSort is a multi-purpose, big data manipulation and management package that speeds, performs, and combines:<\/p>\n<ul>\n<li><a href=\"http:\/\/www.iri.com\/solutions\/data-integration\" target=\"_blank\" rel=\"noopener\">Data integration <\/a>(ETL) of\u00a0structured, semi-, and unstructured\u00a0<a href=\"http:\/\/www.iri.com\/products\/workbench\/data-sources\" target=\"_blank\" rel=\"noopener\">sources<\/a><\/li>\n<li>Legacy data-type, file-format, and database <a href=\"http:\/\/www.iri.com\/solutions\/data-and-database-migration\/database-migration\" target=\"_blank\" rel=\"noopener\">migrations<\/a><\/li>\n<li><a href=\"http:\/\/www.iri.com\/solutions\/data-masking\" target=\"_blank\" rel=\"noopener\">Data masking<\/a>, including encryption, pseudonymization, and redaction<\/li>\n<li><a href=\"http:\/\/www.iri.com\/solutions\/business-intelligence\" target=\"_blank\" rel=\"noopener\">Reporting<\/a>, with built-in 2D\u00a0features, or <a href=\"http:\/\/www.iri.com\/blog\/business-intelligence\/data-franchising\/\" target=\"_blank\" rel=\"noopener\">data franchising<\/a>\u00a0for\u00a0BI tools like Spotfire<\/li>\n<\/ul>\n<p>CoSort can extract and join data from <a href=\"http:\/\/www.iri.com\/products\/workbench\/data-sources\" target=\"_blank\" rel=\"noopener\">multiple sources<\/a> and <a href=\"http:\/\/www.iri.com\/solutions\/big-data\/big-data-provisioning\" target=\"_blank\" rel=\"noopener\">provide<\/a>\u00a0it to various targets. Without a\u00a0DB engine, appliances, or Hadoop, CoSort &#8212; and its <a href=\"http:\/\/www.iri.com\/products\/cosort\/sortcl\" target=\"_blank\" rel=\"noopener\">SortCL program<\/a> in particular &#8212; franchises\u00a0(a\/k\/a munges, subsets, wrangles) or otherwise\u00a0prepares massive amounts of raw data for downstream applications.<\/p>\n<p>By way of example, and to demonstrate the relative performance in preparing data for Spotfire visualizations, I processed the\u00a0raw data for Spotfire visualization in both Spotfire and CoSort\/SortCL, and timed them:<\/p>\n<p><strong>Data Preparation in\u00a0Spotfire<\/strong><\/p>\n<p>The first step in Spotfire was to import data by selecting the option to Add Data Tables or Open File. In this case, a flat-file called Transactions.csv:<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image003-e1417552919170.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6416\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image003-e1417552919170.png\" alt=\"image003\" width=\"550\" height=\"657\" \/><\/a> Once I imported the file, I\u00a0sorted it by DeptNum, and then performed an aggregation using a &#8220;cross table&#8221; in a separate step. A cross table\u00a0consists of\u00a0columns and rows. Also known as a pivot table or a multi-dimensional table, it\u00a0can\u00a0structure, summarize, and display aggregate data.<\/p>\n<p>Cross tables can also determine if\u00a0there is a relation between the row variable and the column variable. The cross table (Total) displays the GrandTotal for\u00a0price by Department Number. Filters are used to cull the data, as shown in this screenshot:<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image005-e1417552945721.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6417\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image005-e1417552945721.png\" alt=\"image005\" width=\"600\" height=\"575\" \/><\/a><\/p>\n<p><strong>Data Preparation in\u00a0CoSort\/SortCL<\/strong><\/p>\n<p>CoSort provides multiple\u00a0ways for end-users to acquire and stage data. The two most common are a SortCL program script created in a text editor and run from the command line, or the same job built automatically in the free <a href=\"http:\/\/www.iri.com\/products\/workbench\" target=\"_blank\" rel=\"noopener\">IRI Workbench<\/a> GUI, built on Eclipse\u2122. In this case, I used a wizard in the IRI Workbench to create, run, and manage my data connections, metadata, and job script.<\/p>\n<p>My SortCL job opens\u00a0transactions.dat, sorts it by\u00a0DeptNum,\u00a0and\u00a0sums the Price values in each DeptNum group. The output is a CSV file that any BI tool, including Spotfire, can readily ingest.\u00a0This\u00a0screenshot shows my SortCL script:<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image0011-e1417800513344.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6447\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image0011-e1417800513344.png\" alt=\"image001\" width=\"600\" height=\"360\" \/><\/a><\/p>\n<p>The obtained output in both processes was equal, but the time taken to achieve the results was not. Given 20 million rows of data, the IRI CoSort SortCL program took 1m 21s to prepare the data, while SpotFire required 5m 34s, more than 4 times longer:<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/finalgraph1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6488\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/finalgraph1.png\" alt=\"finalgraph\" width=\"558\" height=\"316\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/finalgraph1.png 558w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/finalgraph1-300x169.png 300w\" sizes=\"(max-width: 558px) 100vw, 558px\" \/><\/a><\/p>\n<p>Either way, \u00a0the raw data was ultimately distilled into the same subset ready for graphical representation (DeptNum vs. Price) in Spotfire:<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image011-e1418051115924.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6460\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image011-e1418051115924.png\" alt=\"image011\" width=\"600\" height=\"351\" \/><\/a><\/p>\n<hr \/>\n<p><sup id=\"fn1\">1. Spotfire currently has native data connectors to Apache Hadoop\/Hive, Cloudera Hive and Impala, Composite Information Server, Hortonworks data platform, HP Veritica, IBM Netezza, MS Analysis Services, MS SQL Server, MySQL, Oracle and Oracle Exadata, Oracle Essbase, Pivotal Greenplum, Pivotal HAWQ, PostgreSQL, SAP HANA, SAP NetWeaver Business Warehouse, Teradata, Teradata Aster.<a title=\"Jump back to footnote 1 in the text.\" href=\"#ref1\">\u21a9<\/a><\/sup><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction: As with\u00a0multiple BI platforms discussed throughout\u00a0this section of the IRI blog site, this\u00a0article analyzes the relative data preparation performance (and benefit) of\u00a0IRI CoSort with\u00a0Tibco Spotfire when &#8216;big data&#8217; sources\u00a0are involved. Business intelligence (BI) is a technology-driven process for analyzing data and boosting business performance by helping executives and end users make the decisions that<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/\" title=\"Faster Spotfire BI via CoSort\">Read More<\/a><\/div>\n","protected":false},"author":53,"featured_media":11640,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[108,32],"tags":[549,25,52,57,107,14,359,100,570,546,571,50,548,547,573,572,574,356,569],"class_list":["post-6413","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-big-data-2","category-business-intelligence","tag-benefit","tag-big-data","tag-business-intelligence-2","tag-data-franchising","tag-data-integration","tag-data-masking","tag-data-preparation","tag-etl","tag-ibm","tag-iri-cosort","tag-microsoft","tag-oracle","tag-performance","tag-qlikview","tag-r","tag-sap","tag-splunk","tag-tableau","tag-tibco-spotfire"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.4 (Yoast SEO v23.4) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Faster Spotfire BI via CoSort - IRI<\/title>\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.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Faster Spotfire BI via CoSort\" \/>\n<meta property=\"og:description\" content=\"Introduction: As with\u00a0multiple BI platforms discussed throughout\u00a0this section of the IRI blog site, this\u00a0article analyzes the relative data preparation performance (and benefit) of\u00a0IRI CoSort with\u00a0Tibco Spotfire when &#8216;big data&#8217; sources\u00a0are involved. Business intelligence (BI) is a technology-driven process for analyzing data and boosting business performance by helping executives and end users make the decisions thatRead More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2014-12-02T20:42:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-11-06T13:17:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/iri-spotfire-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"550\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Chaitali Mitra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Chaitali Mitra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/\"},\"author\":{\"name\":\"Chaitali Mitra\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/9bae14a309616863b027c2d56f532caf\"},\"headline\":\"Faster Spotfire BI via CoSort\",\"datePublished\":\"2014-12-02T20:42:54+00:00\",\"dateModified\":\"2017-11-06T13:17:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/\"},\"wordCount\":700,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/iri-spotfire-1.png\",\"keywords\":[\"benefit\",\"big data\",\"business intelligence\",\"data franchising\",\"data integration\",\"data masking\",\"data preparation\",\"ETL\",\"IBM\",\"IRI CoSort\",\"Microsoft\",\"Oracle\",\"performance\",\"QlikView\",\"R\",\"SAP\",\"Splunk\",\"tableau\",\"Tibco Spotfire\"],\"articleSection\":[\"Big Data\",\"Business Intelligence (BI&#041;\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/\",\"url\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/\",\"name\":\"Faster Spotfire BI via CoSort - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/iri-spotfire-1.png\",\"datePublished\":\"2014-12-02T20:42:54+00:00\",\"dateModified\":\"2017-11-06T13:17:12+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/iri-spotfire-1.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/iri-spotfire-1.png\",\"width\":550,\"height\":300},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Faster Spotfire BI via CoSort\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.iri.com\/blog\/#website\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"width\":750,\"height\":206,\"caption\":\"IRI\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/9bae14a309616863b027c2d56f532caf\",\"name\":\"Chaitali Mitra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/95a11f3d0b709c00df3262bab0152f3a?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/95a11f3d0b709c00df3262bab0152f3a?s=96&d=blank&r=g\",\"caption\":\"Chaitali Mitra\"},\"sameAs\":[\"http:\/\/www.iri.com\"],\"url\":\"https:\/\/www.iri.com\/blog\/author\/chaitalim\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Faster Spotfire BI via CoSort - IRI","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.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/","og_locale":"en_US","og_type":"article","og_title":"Faster Spotfire BI via CoSort","og_description":"Introduction: As with\u00a0multiple BI platforms discussed throughout\u00a0this section of the IRI blog site, this\u00a0article analyzes the relative data preparation performance (and benefit) of\u00a0IRI CoSort with\u00a0Tibco Spotfire when &#8216;big data&#8217; sources\u00a0are involved. Business intelligence (BI) is a technology-driven process for analyzing data and boosting business performance by helping executives and end users make the decisions thatRead More","og_url":"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/","og_site_name":"IRI","article_published_time":"2014-12-02T20:42:54+00:00","article_modified_time":"2017-11-06T13:17:12+00:00","og_image":[{"width":550,"height":300,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/iri-spotfire-1.png","type":"image\/png"}],"author":"Chaitali Mitra","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Chaitali Mitra","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/"},"author":{"name":"Chaitali Mitra","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/9bae14a309616863b027c2d56f532caf"},"headline":"Faster Spotfire BI via CoSort","datePublished":"2014-12-02T20:42:54+00:00","dateModified":"2017-11-06T13:17:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/"},"wordCount":700,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/iri-spotfire-1.png","keywords":["benefit","big data","business intelligence","data franchising","data integration","data masking","data preparation","ETL","IBM","IRI CoSort","Microsoft","Oracle","performance","QlikView","R","SAP","Splunk","tableau","Tibco Spotfire"],"articleSection":["Big Data","Business Intelligence (BI&#041;"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/","url":"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/","name":"Faster Spotfire BI via CoSort - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/iri-spotfire-1.png","datePublished":"2014-12-02T20:42:54+00:00","dateModified":"2017-11-06T13:17:12+00:00","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/iri-spotfire-1.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/iri-spotfire-1.png","width":550,"height":300},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/faster-spotfire-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Faster Spotfire BI via CoSort"}]},{"@type":"WebSite","@id":"https:\/\/www.iri.com\/blog\/#website","url":"https:\/\/www.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.iri.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/www.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","width":750,"height":206,"caption":"IRI"},"image":{"@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/9bae14a309616863b027c2d56f532caf","name":"Chaitali Mitra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/95a11f3d0b709c00df3262bab0152f3a?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/95a11f3d0b709c00df3262bab0152f3a?s=96&d=blank&r=g","caption":"Chaitali Mitra"},"sameAs":["http:\/\/www.iri.com"],"url":"https:\/\/www.iri.com\/blog\/author\/chaitalim\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/iri-spotfire-1.png","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/6413"}],"collection":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/users\/53"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=6413"}],"version-history":[{"count":28,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/6413\/revisions"}],"predecessor-version":[{"id":11632,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/6413\/revisions\/11632"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/11640"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=6413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=6413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=6413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}