Tableau Prep is a new visual data preparation tool that integrates with Tableau Desktop. Prep makes it easy to clean your data and to complete many data transformations that would be tedious or even impossible in Desktop or in the data source. As a self-proclaimed sports nerd, when I have free time, I like to dive into sports data sets. When the NFL Draft season arrived, I couldn’t help but to look at some NFL Draft data to analyze the incoming draft class against active NFL players. With so much talk about the NFL Draft this year, I decided to look at the money being paid to each player being drafted.
The filter is one of Tableau’s most essential features. It allows users to efficiently comb through large datasets and focus on relevant information to find valuable insights. Imagine you have a massive dataset containing information on different countries over the last decade. You can spend lots of time working through a mass of data or more efficiently focus your information on specific countries and years. Filters enable you to target your analysis.
COE's Head of Analytics, Chris Cronk, is back once again to join Joe for the latest episode of the InSync Podcast. In this edition, the guys discuss the recent release of Tableau Prep, the benefits of the program, and an exciting use case that speaks to just how powerful it is.
Every year Gartner provides an overview of the analytics and business intelligence landscape. Around February, we all wait anxiously to see what will remain after the dust of development frenzy and market shifts settles. Which of these new hopefuls and industry titans are leading BI’s path into the future?
Data visualization is fun, interesting, and beautiful. Data preparation, on the other hand, is none of these things. Data can provide valuable insights to the organization, but only once it has been extracted from wherever it lives, cleaned up, and shaped into a form that can support visualization.
Tableau, at its core, is a visual tool. While its main purpose is to serve as an industry-leading data visualization platform, Tableau offers many other ways to help you get the most out of your data. One of those ways is by providing metadata, in the form of a structured XML tree, in the un-packaged versions of its workbooks. In this post, we’ll use a workbook built on Superstore datasets to highlight some of the major elements of this XML tree structure and illustrate some of the ways you can access and extract valuable information from this Tableau workbook metadata.
Tableau’s number formatting is not inherently dynamic. For a given measure, number formatting is fixed regardless of value. If you set your measure to display in ‘thousands,’ or with a ‘K’ suffix, and your measure contains values that are orders of magnitude smaller or greater than a thousand, your measure values will sometimes display in a way that makes it difficult for the dashboard user to glean information.
This is an Excel world, and we’re all living in it. Whether it's financial models, healthcare information, sales records, or HR stats – the spreadsheet program is ubiquitous across industries and business units, and some level of proficiency in it is expected for more jobs each year. My CoEnterprise colleagues know that I love working with Excel, but it's also because of Excel that I feel so comfortable as a Tableau and analytics professional. If you’re nervous about making the jump from Excel to Tableau, let me take you down my path from spreadsheet enthusiast to visualization fanatic.
Tableau’s parameters give the end user the ability to control many elements of their dashboard. Many use cases employ parameters to switch between measures, determine sort order or, control other aspects of how data is displayed. Parameters can also be made useful in analysis by including them as an input to a calculated field. In this post, I'll show you how to add parameter control within a calculated field to extend the estimated end dates of projects and determine which would be most affected by anticipated delays.
Action filters make interacting with data more tangible and fun, but they can also aid in dashboard layout efficiency. My illustrious colleague Lisa Li posted a tutorial recently about ways to reveal hidden views with clever actions, but what if you're running low on real-estate and find these new planes cluttering your space?