{"id":50916,"date":"2020-06-23T15:43:00","date_gmt":"2020-06-23T13:43:00","guid":{"rendered":"https:\/\/www.cocus.com\/performance-in-sales-no-more-excel\/"},"modified":"2023-11-17T11:21:28","modified_gmt":"2023-11-17T09:21:28","slug":"performance-in-sales-no-more-excel","status":"publish","type":"post","link":"https:\/\/www.cocus.com\/en\/performance-in-sales-no-more-excel\/","title":{"rendered":"Performance in sales &#8211; no more Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"50916\" class=\"elementor elementor-50916 elementor-50486\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f8a256b elementor-section-boxed elementor-section-height-default elementor-section-height-default lottie-bg-no\" data-id=\"f8a256b\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;enable_lottie_background&quot;:&quot;no&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-93b2bd3 lottie-bg-no\" data-id=\"93b2bd3\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;enable_lottie_background&quot;:&quot;no&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a51c3d9 elementor-widget elementor-widget-text-editor\" data-id=\"a51c3d9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Single Source of Truth, SSOT for short &#8211; a state that is not achievable with Excel and yet would offer so many advantages&#8230;<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1322f95 elementor-widget elementor-widget-heading\" data-id=\"1322f95\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How do you tame the time-consuming Excel beast?! <\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c48828a elementor-widget elementor-widget-text-editor\" data-id=\"c48828a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The switch to using MySQL databases, the supporting data analysis software KNIME and the visualization software Tableau represents the ideal solution.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0498881 elementor-widget elementor-widget-video\" data-id=\"0498881\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/youtu.be\\\/K0TtjzIDZK0&quot;,&quot;video_type&quot;:&quot;youtube&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-708af36 elementor-widget elementor-widget-text-editor\" data-id=\"708af36\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\tFirst, this interaction involves users dragging and dropping their data into Nextcloud. KNIME automatically extracts and processes CSV files every hour and loads the processed files into a MySQL database. ETL processes can also be programmed graphically via KNIME. Tableau can then be used to provide interactive analysis across multiple dashboards.<br><br>\nA change is possible for small CSV files up to databases with billions of rows and usually takes only 2-3 weeks!\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-40a73f4 elementor-widget elementor-widget-heading\" data-id=\"40a73f4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h5 class=\"elementor-heading-title elementor-size-default\"><a href=\"https:\/\/youtu.be\/K0TtjzIDZK0\" target=\"_blank\" rel=\"noopener\">Learn more in our webinar - Enjoy watching!<\/a><\/h5>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Single Source of Truth, SSOT for short &#8211; a state that is not achievable with Excel and yet would offer so many advantages&#8230;<\/p>\n","protected":false},"author":24,"featured_media":50616,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"video","meta":{"content-type":"","footnotes":""},"categories":[436,570],"tags":[438,486],"class_list":["post-50916","post","type-post","status-publish","format-video","has-post-thumbnail","hentry","category-data-en","category-news-en","tag-analytics-en","tag-video-en","post_format-post-format-video"],"_links":{"self":[{"href":"https:\/\/www.cocus.com\/en\/wp-json\/wp\/v2\/posts\/50916","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cocus.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cocus.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cocus.com\/en\/wp-json\/wp\/v2\/users\/24"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cocus.com\/en\/wp-json\/wp\/v2\/comments?post=50916"}],"version-history":[{"count":0,"href":"https:\/\/www.cocus.com\/en\/wp-json\/wp\/v2\/posts\/50916\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cocus.com\/en\/wp-json\/wp\/v2\/media\/50616"}],"wp:attachment":[{"href":"https:\/\/www.cocus.com\/en\/wp-json\/wp\/v2\/media?parent=50916"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cocus.com\/en\/wp-json\/wp\/v2\/categories?post=50916"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cocus.com\/en\/wp-json\/wp\/v2\/tags?post=50916"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}