{"id":509,"date":"2018-04-11T00:08:42","date_gmt":"2018-04-11T00:08:42","guid":{"rendered":"https:\/\/www.diggernaut.com\/blog\/?p=509"},"modified":"2019-01-12T10:18:56","modified_gmt":"2019-01-12T10:18:56","slug":"import-data-from-diggernaut-into-tableau-for-analysis-and-visualization","status":"publish","type":"post","link":"https:\/\/www.diggernaut.com\/blog\/import-data-from-diggernaut-into-tableau-for-analysis-and-visualization\/","title":{"rendered":"Import data from Diggernaut into Tableau for analysis and visualization"},"content":{"rendered":"<p><a href=\"https:\/\/www.tableau.com\/\">Tableau<\/a> is one of the most popular BI (Business intelligence) platforms for analytics and data visualization in the world. The company offers to use both computer applications, as well as cloud solutions, as well as server versions for corporate clients. By the way, Tableau is very popular not only in business but also widely used in data journalism.<\/p>\n<p>For our users who are active in Tableau, we have developed a Web Data Connector (WDC), through which you can easily download your datasets from Diggernaut to Tableau. The connector uses the REST API, so you\u2019ll need an API key. You can get it in the Diggernaut members area, in the section called \u201cSettings -> API keys\u201d. The connector itself is located at <a href=\"https:\/\/www.diggernaut.com\/wdc\/\">https:\/\/www.diggernaut.com\/wdc\/<\/a>.<\/p>\n<p>For those who are not yet very familiar with Tableau, we give a small instruction on importing data sets from Diggernaut:<\/p>\n<ul>\n<li>Run the Tableau software.<\/li>\n<\/ul>\n<figure id=\"attachment_mmd_510\" class=\"wp-block-image alignnone\"><a href=\"https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau1.jpg\"><img width=\"1915\" height=\"1038\" src=\"https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau1.jpg\" class=\"attachment-full size-full\" alt=\"Tableau - running the software\" decoding=\"async\" loading=\"lazy\" align=\"none\" srcset=\"https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau1.jpg 1915w, https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau1-768x416.jpg 768w\" sizes=\"auto, (max-width: 1915px) 100vw, 1915px\" \/><\/a><\/figure>\n<ul>\n<li>In the left column \u201cConnect\u201d, select \u201cMore\u201d option and in the opened panel select \u201cWeb Data Connector\u201d option.<\/li>\n<\/ul>\n<figure id=\"attachment_mmd_511\" class=\"wp-block-image alignnone\"><a href=\"https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau2.jpg\"><img width=\"1920\" height=\"1038\" src=\"https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau2.jpg\" class=\"attachment-full size-full\" alt=\"Tableau - select connection type\" decoding=\"async\" loading=\"lazy\" align=\"none\" srcset=\"https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau2.jpg 1920w, https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau2-768x415.jpg 768w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/figure>\n<ul>\n<li>In the window that opens, enter the URL of our WDC: <a href=\"https:\/\/www.diggernaut.com\/wdc\/\">https:\/\/www.diggernaut.com\/wdc\/<\/a> and press Enter on the keyboard.<\/li>\n<\/ul>\n<figure id=\"attachment_mmd_512\" class=\"wp-block-image alignnone\"><a href=\"https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau3.jpg\"><img width=\"1033\" height=\"828\" src=\"https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau3.jpg\" class=\"attachment-full size-full\" alt=\"Tableau - enter URL of Diggernaut WDC\" decoding=\"async\" loading=\"lazy\" align=\"none\" srcset=\"https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau3.jpg 1033w, https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau3-768x616.jpg 768w\" sizes=\"auto, (max-width: 1033px) 100vw, 1033px\" \/><\/a><\/figure>\n<ul>\n<li>The WDC page opens, where you will be asked to enter your API key. We remind you that you can get it in your personal Diggernaut account, in the section \u201cSettings -> API keys\u201d.<\/li>\n<\/ul>\n<figure id=\"attachment_mmd_513\" class=\"wp-block-image alignnone\"><a href=\"https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau4.jpg\"><img width=\"991\" height=\"741\" src=\"https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau4.jpg\" class=\"attachment-full size-full\" alt=\"Tableau - entering Diggernaut REST API key\" decoding=\"async\" loading=\"lazy\" align=\"none\" srcset=\"https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau4.jpg 991w, https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau4-768x574.jpg 768w\" sizes=\"auto, (max-width: 991px) 100vw, 991px\" \/><\/a><\/figure>\n<ul>\n<li>If you enter the correct key, then you will be prompted to choose a digger. Attention! You must have active diggers that have collected datasets. After selecting a digger, click the Connect button.<\/li>\n<\/ul>\n<figure id=\"attachment_mmd_514\" class=\"wp-block-image alignnone\"><a href=\"https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau5.jpg\"><img width=\"974\" height=\"730\" src=\"https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau5.jpg\" class=\"attachment-full size-full\" alt=\"Tableau - choosing the digger\" decoding=\"async\" loading=\"lazy\" align=\"none\" srcset=\"https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau5.jpg 974w, https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau5-768x576.jpg 768w\" sizes=\"auto, (max-width: 974px) 100vw, 974px\" \/><\/a><\/figure>\n<ul>\n<li>Depending on the size of your dataset, you will need to wait for it to load into Tableau. After that, the interface of the application will open and show you the structure of your dataset. Click the Update button to download the data.<\/li>\n<\/ul>\n<figure id=\"attachment_mmd_515\" class=\"wp-block-image alignnone\"><a href=\"https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau6.jpg\"><img width=\"1918\" height=\"1016\" src=\"https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau6.jpg\" class=\"attachment-full size-full\" alt=\"Tableau - dataset is imported\" decoding=\"async\" loading=\"lazy\" align=\"none\" srcset=\"https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau6.jpg 1918w, https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau6-768x407.jpg 768w\" sizes=\"auto, (max-width: 1918px) 100vw, 1918px\" \/><\/a><\/figure>\n<ul>\n<li>Now you can switch to the \u201cSheet 1\u201d tab and start working with your data.<\/li>\n<\/ul>\n<figure id=\"attachment_mmd_516\" class=\"wp-block-image alignnone\"><a href=\"https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau7.jpg\"><img width=\"1917\" height=\"1037\" src=\"https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau7.jpg\" class=\"attachment-full size-full\" alt=\"Tableau - data is updated\" decoding=\"async\" loading=\"lazy\" align=\"none\" srcset=\"https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau7.jpg 1917w, https:\/\/www.diggernaut.com\/blog\/wp-content\/uploads\/2018\/04\/tableau7-768x415.jpg 768w\" sizes=\"auto, (max-width: 1917px) 100vw, 1917px\" \/><\/a><\/figure>\n<p>Happy analyzing with Tableau!<\/p>","protected":false},"excerpt":{"rendered":"<p>Tableau is one of the most popular BI (Business intelligence) platforms for analytics and data visualization in the world. The company offers to use both computer applications, as well as cloud solutions, as well as server versions for corporate clients. By the way, Tableau is very popular not only in business but also widely used [&hellip;]<\/p>","protected":false},"author":4,"featured_media":517,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[33,34,19,35],"tags":[],"class_list":["post-509","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business","category-data","category-data-for-journalists","category-integrations"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.diggernaut.com\/blog\/wp-json\/wp\/v2\/posts\/509","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.diggernaut.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.diggernaut.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.diggernaut.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.diggernaut.com\/blog\/wp-json\/wp\/v2\/comments?post=509"}],"version-history":[{"count":3,"href":"https:\/\/www.diggernaut.com\/blog\/wp-json\/wp\/v2\/posts\/509\/revisions"}],"predecessor-version":[{"id":627,"href":"https:\/\/www.diggernaut.com\/blog\/wp-json\/wp\/v2\/posts\/509\/revisions\/627"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.diggernaut.com\/blog\/wp-json\/wp\/v2\/media\/517"}],"wp:attachment":[{"href":"https:\/\/www.diggernaut.com\/blog\/wp-json\/wp\/v2\/media?parent=509"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.diggernaut.com\/blog\/wp-json\/wp\/v2\/categories?post=509"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.diggernaut.com\/blog\/wp-json\/wp\/v2\/tags?post=509"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}