Join Matt Francis for an in-depth discussion in this video Create an initial filter from a surname, part of Tableau 10 for Data Scientists.
- [Narrator] A useful string calculation…would be the ability to create a filter…so we could look up somebody's surname…by their first initial.…In this example, we've got fifteen thousand records…of runners who've competed in a race.…The first step is to split the name…into forename and surname…then take the surname, split off the initial…and then create a filter using that information.…First, let's split the name.…We just go to name, transform, and split.…
We've now got our two fields, one named forename…and surname.…That should place these on our field.…There we go.…Next thing we need to do is split off the first character…of our surname to create our initial filter.…So for that, we select the surname and do calculated field.…The function we're gonna use is a string function…which can be found here.…
We're gonna use the left function.…This returns a specified number of characters…from the start of a given string.…So for our example, we're gonna say left, the string,…and the number of characters.…We only want the first character so we give that one.…
The training starts with one of the most important features in Tableau: the difference between the green and blue pills (discrete and continuous data) and how this affects every single action Tableau performs. Then find out how to add new maps and create more effective dashboards that maximize screen real estate. Discover how actions can link together sheets and provide greater levels of interactivity and performance, and how formatting can make an ordinary dashboard demand attention. Plus, get some bonus tips on performing date and time calculations in Tableau. This course deep-dives into the practical, applicable, and essential skills that anyone doing data visualization and analytics in a professional setting needs to have.
- Green vs. blue pills
- Using filters, colors, and dates
- Connecting to data
- Extracting data
- Cleaning and prepping data
- Pivoting data
- Merging and joining data
- Highlighting data
- Using the Analytics pane
- Creating new maps
- Creating calculations based on parameters
- Designing dashboards
Skill Level Intermediate
Creating Interactive Dashboards in Tableauwith Nate Makdad1h 38m Intermediate
Data Visualization for Data Analystswith Bill Shander1h 31m Beginner
1. Green and Blue Pills
2. Connect and Extract Data
3. Transform Data
5. Map Your Data
7. Dashboard Design
8. Useful Calculations
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.