{"id":223,"date":"2024-07-21T15:05:26","date_gmt":"2024-07-21T22:05:26","guid":{"rendered":"https:\/\/sarahpallett.com\/?p=223"},"modified":"2024-07-21T15:17:09","modified_gmt":"2024-07-21T22:17:09","slug":"the-help-behind-the-help-desk-dashboard","status":"publish","type":"post","link":"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/","title":{"rendered":"The ‘help’ behind the Help Desk Dashboard"},"content":{"rendered":"
\n
\"\"<\/figure><\/div>\n\n\n

As a data visualization consultant, having proof-of-concept dashboards is essential for discussing the types of visualizations we want\u2014or, more importantly, don’t want\u2014when starting a new project. The biggest challenge, however, is finding a clean, anonymized dataset to build these demo dashboards. That\u2019s where Tableau Community Projects, like RealWorldFakeData<\/a> (RWFD), come in handy. RWFD is a treasure trove of business-related datasets.  A more recent initiative, Adam Mico\u2019s Data Mockstar<\/a>, is incredibly useful as well. This ChatGPT tool allows you to specify the desired columns and it returns a dataset of randomly generated data. For my Help Desk Dashboard, I decided to take Data Mockstar for a test drive. With just a few clicks and the following prompt, I had a mock dataset in csv format ready to use for my demo dashboard.<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n
\n
\"\"<\/figure><\/div>\n\n\n

<\/p>\n\n\n\n

Brilliant! I connected Tableau Desktop to the csv file provided by Data Mockstar and began an initial data discovery to determine the best way to visualize the data (hello, bar charts). Early in the process, I realized that the analysis relies heavily on date fields\u2014specifically, Ticket Created Date and Ticket Closed Date. The mock dataset contains two years of daily data (2023 and 2024, per my specifications), which is fine for now. However, to future-proof this dashboard, I needed to shift the rows of data so that it always includes two years up to and including today<\/em>, rather than a fixed period from January 1, 2023, to December 31, 2024. Shoutout to Andy Kriebel, whose Next-Level Tableau Program<\/a> inspired the set of calculations needed to perpetually shift the dates. <\/p>\n\n\n\n

The end result? A dynamic dashboard that appears to update \u201clive\u201d even though the data source is a flat file generated once. You can find the dashboard on my Tableau Public profile page<\/a>\u2014feel free to download it and take a look under the hood!<\/p>\n\n\n\n

Happy Vizzing! <\/p>\n","protected":false},"excerpt":{"rendered":"

As a data visualization consultant, having proof-of-concept dashboards is essential for discussing the types of visualizations we want\u2014or, more importantly, don’t want\u2014when starting a new project. The biggest challenge, however, is finding a clean, anonymized dataset to build these demo dashboards. That\u2019s where Tableau Community Projects, like RealWorldFakeData (RWFD), come in handy. RWFD is a… Continue Reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[8],"tags":[24,28,29,27,15,4,3,21],"class_list":["post-223","post","type-post","status-publish","format-standard","hentry","category-the-inside-scoop","tag-datafam-2","tag-datamockstar","tag-nextleveltableau","tag-rwfd","tag-datafam","tag-dataviz","tag-tableau","tag-tableaupublic","clear"],"yoast_head":"\nThe 'help' behind the Help Desk Dashboard - Sarah Pallett<\/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:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The 'help' behind the Help Desk Dashboard - Sarah Pallett\" \/>\n<meta property=\"og:description\" content=\"As a data visualization consultant, having proof-of-concept dashboards is essential for discussing the types of visualizations we want\u2014or, more importantly, don’t want\u2014when starting a new project. The biggest challenge, however, is finding a clean, anonymized dataset to build these demo dashboards. That\u2019s where Tableau Community Projects, like RealWorldFakeData (RWFD), come in handy. RWFD is a... Continue Reading →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/\" \/>\n<meta property=\"og:site_name\" content=\"Sarah Pallett\" \/>\n<meta property=\"article:published_time\" content=\"2024-07-21T22:05:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-21T22:17:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2024\/07\/Dashboard-1-1024x853.png\" \/>\n<meta name=\"author\" content=\"Sarah\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sarah\" \/>\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:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/\"},\"author\":{\"name\":\"Sarah\",\"@id\":\"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8\"},\"headline\":\"The ‘help’ behind the Help Desk Dashboard\",\"datePublished\":\"2024-07-21T22:05:26+00:00\",\"dateModified\":\"2024-07-21T22:17:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/\"},\"wordCount\":317,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2024\/07\/Dashboard-1-1024x853.png\",\"keywords\":[\"#Datafam\",\"#DataMockstar\",\"#NextLevelTableau\",\"#RWFD\",\"DataFam\",\"DataViz\",\"Tableau\",\"TableauPublic\"],\"articleSection\":[\"The Inside Scoop\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/\",\"url\":\"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/\",\"name\":\"The 'help' behind the Help Desk Dashboard - Sarah Pallett\",\"isPartOf\":{\"@id\":\"https:\/\/sarahpallett.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2024\/07\/Dashboard-1-1024x853.png\",\"datePublished\":\"2024-07-21T22:05:26+00:00\",\"dateModified\":\"2024-07-21T22:17:09+00:00\",\"author\":{\"@id\":\"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8\"},\"breadcrumb\":{\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/#primaryimage\",\"url\":\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2024\/07\/Dashboard-1.png\",\"contentUrl\":\"https:\/\/sarahpallett.com\/wp-content\/uploads\/2024\/07\/Dashboard-1.png\",\"width\":1199,\"height\":999},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sarahpallett.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The ‘help’ behind the Help Desk Dashboard\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/sarahpallett.com\/#website\",\"url\":\"https:\/\/sarahpallett.com\/\",\"name\":\"Sarah Pallett\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/sarahpallett.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8\",\"name\":\"Sarah\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/sarahpallett.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4ded2c9e00b6c56390986018adbae452?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4ded2c9e00b6c56390986018adbae452?s=96&d=mm&r=g\",\"caption\":\"Sarah\"},\"sameAs\":[\"https:\/\/sarahpallett.com\/wp\"],\"url\":\"https:\/\/sarahpallett.com\/index.php\/author\/admin_sp\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The 'help' behind the Help Desk Dashboard - Sarah Pallett","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:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/","og_locale":"en_US","og_type":"article","og_title":"The 'help' behind the Help Desk Dashboard - Sarah Pallett","og_description":"As a data visualization consultant, having proof-of-concept dashboards is essential for discussing the types of visualizations we want\u2014or, more importantly, don’t want\u2014when starting a new project. The biggest challenge, however, is finding a clean, anonymized dataset to build these demo dashboards. That\u2019s where Tableau Community Projects, like RealWorldFakeData (RWFD), come in handy. RWFD is a... Continue Reading →","og_url":"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/","og_site_name":"Sarah Pallett","article_published_time":"2024-07-21T22:05:26+00:00","article_modified_time":"2024-07-21T22:17:09+00:00","og_image":[{"url":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2024\/07\/Dashboard-1-1024x853.png","type":"","width":"","height":""}],"author":"Sarah","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sarah","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/#article","isPartOf":{"@id":"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/"},"author":{"name":"Sarah","@id":"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8"},"headline":"The ‘help’ behind the Help Desk Dashboard","datePublished":"2024-07-21T22:05:26+00:00","dateModified":"2024-07-21T22:17:09+00:00","mainEntityOfPage":{"@id":"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/"},"wordCount":317,"commentCount":0,"image":{"@id":"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/#primaryimage"},"thumbnailUrl":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2024\/07\/Dashboard-1-1024x853.png","keywords":["#Datafam","#DataMockstar","#NextLevelTableau","#RWFD","DataFam","DataViz","Tableau","TableauPublic"],"articleSection":["The Inside Scoop"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/","url":"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/","name":"The 'help' behind the Help Desk Dashboard - Sarah Pallett","isPartOf":{"@id":"https:\/\/sarahpallett.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/#primaryimage"},"image":{"@id":"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/#primaryimage"},"thumbnailUrl":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2024\/07\/Dashboard-1-1024x853.png","datePublished":"2024-07-21T22:05:26+00:00","dateModified":"2024-07-21T22:17:09+00:00","author":{"@id":"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8"},"breadcrumb":{"@id":"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/#primaryimage","url":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2024\/07\/Dashboard-1.png","contentUrl":"https:\/\/sarahpallett.com\/wp-content\/uploads\/2024\/07\/Dashboard-1.png","width":1199,"height":999},{"@type":"BreadcrumbList","@id":"https:\/\/sarahpallett.com\/index.php\/2024\/07\/21\/the-help-behind-the-help-desk-dashboard\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sarahpallett.com\/"},{"@type":"ListItem","position":2,"name":"The ‘help’ behind the Help Desk Dashboard"}]},{"@type":"WebSite","@id":"https:\/\/sarahpallett.com\/#website","url":"https:\/\/sarahpallett.com\/","name":"Sarah Pallett","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sarahpallett.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/sarahpallett.com\/#\/schema\/person\/dce769f945c604f38bb244e91205abe8","name":"Sarah","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sarahpallett.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4ded2c9e00b6c56390986018adbae452?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4ded2c9e00b6c56390986018adbae452?s=96&d=mm&r=g","caption":"Sarah"},"sameAs":["https:\/\/sarahpallett.com\/wp"],"url":"https:\/\/sarahpallett.com\/index.php\/author\/admin_sp\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/posts\/223","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/comments?post=223"}],"version-history":[{"count":6,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/posts\/223\/revisions"}],"predecessor-version":[{"id":233,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/posts\/223\/revisions\/233"}],"wp:attachment":[{"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/media?parent=223"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/categories?post=223"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sarahpallett.com\/index.php\/wp-json\/wp\/v2\/tags?post=223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}