Posts by Rody Zakovich

Week 51: Container Fun!

Ok, this week is all about working with Containers. Now that we have the ability to control inner/outer padding on Dashboard objects, as well as color, we can really make our dashboards shine without having to float everything. Note on the week, the data/charts don’t really matter, I honestly just threw some on the dashboard. The challenge is about working with the containers, and matching the design given the requirements below. Good luck!

CLICK TO VIEW

 

Requirements

  • Dashboard size is 1250px wide by 750px tall.
  • ONLY USE CONTAINERS, NO FLOATING OBJECTS!
  • Dashboard has a total of 5 containers (no more, no less)
  • The Filter Pane.
    • 10px padding on the right/left side.
    • Each filter has 5px of padding
  • The Charts Pane.
    • All 3 charts must be in one vertical container
    • Background must be light grey
    • Each chart has 20 px of padding between them and other objects
    • Each chart has a grey border, slight darker than the Pane background color.
  • The Pane under the Title has a grey border.

Dataset

You can use any data set for this week’s challenge. but  you can get Superstore 2018.3 at data.world

Share

After you finish your workout, share on Twitter using the hashtag #WorkoutWednesday2018 and tag @AnnUJackson@LukeStanke@lorna_eden,
@curtisharris_@RodyZakovich, and @VizWizBI!

Track your progress

Also, don’t forget to track your progress using this Workout Wednesday form.

Week 45: Cross-Highlight

Continuing in line with Ann, I thought it would be great to do another challenge around Set Actions. I’ve used “Cross-Highlighting” in Tableau before, but it required a lot of Data Modelling, and was extremely slow on the Public Servers. But with Set Actions, what use to be a very complicated task, can now be down very quickly. There are a lot of great analytical powers with Set Actions, but there are some nice UX ones as well.

https://public.tableau.com/views/Cross-Highlight/CROSS-HIGHLIGHT?:embed=y&:display_count=yes&publish=yes

Requirements

  • Dashboard size: 520 x 560; 1 sheet
  • Create 2 Parameters
    • Y Axis: Category and Sub-Category
    • X Axis: Region and Segment
  • Create a Crosstab that shows Sales based on the Parameter Selection
  • ***On Hover*** highlight all values in the same Y/X column as the mark being hovered over.

FYI: Set Actions aren’t quite working on Tableau Public, so I encourage you to download the workbook and view in 2018.3 to explore the full interactivity!

Data from this week comes from the Saved Data Source in Tableau 2018 (Sample – Superstore), download here if needed.

After you finish your workout, share on Twitter using the hashtag #WorkoutWednesday and tag @AnnUJackson, @LukeStanke, and @RodyZakovich.  (Tag @VizWizBI if you have space, he would love to see your work too!)

Also, don’t forget to track your progress using this Workout Wednesday form.

Week 42: Radial Mapping

Getting a little bit tricky this week, mostly because I won’t be at TC this year….. 🙁

This week we are going to do some radial mapping in Tableau. While extensions might replace this trick, I think it’s still useful when analyzing locations within N miles of a target location.

Click Image for Interactive Version
(Click for Interactive Version)

Requirements

  • This is a tricky one, so the first thing you want to do is get all the Lats/Longs for City/State from SuperStore and create a new dataset with it. You need to be able to use the Lats/Longs in calcs, and we can’t use generated lat/longs at the moment.
  • Create a Parameter for City/State
  • Create a Parameter to set the number of miles
  • Create a Map of Sales for City/State sized by Sales
  • Draw a Radial Circle around the selected location that has a radius equal to the Miles Parameter.
  • The Map should be filtered down to only show locations within the Radial Circle
  • This does require some data modelling…if you get stuck, check out my blog post on radial mapping.http://www.datatableauandme.com/2017/12/radial-mapping-in-tableau.html

Dataset

This week uses the superstore dataset for Tableau 2018.1.  You can get it here at data.world

Share

After you finish your workout, share on Twitter using the hashtag #WorkoutWednesday and tag @AnnUJackson@LukeStanke, and @RodyZakovich.  (Tag @VizWizBI too – he would REALLY love to see your work!)

WEEK 39: VERTICAL LABEL AND 3 MARKS

Hello Again! This week I am back with a fairly simple challenge, but one that has a few (I believe) useful tricks that could help spice up your next viz. The tricks used here are geared toward design, but have additional benefits.

Requirements:

  • Dashboard size: 1000 x 800
  • Create a Parameters for metrics Sales|Profit|Quantity
  • Create an Area Chart with a Line and Circle Marks for the Selected Metric over Month/Year of Order Date
  • The Metric Selected must be Vertically displayed on the Y Axis, this is dynamic based on the Metric Parameter, and is a single calculated field. 
    • DON’T HARD CODE THE LABELS! Think through what features Tableau offers that allow you to dynamically change/format strings
  • Pay attention to White Space and weighting!

Data from this week comes from the Saved Data Source in Tableau 2018 (Sample – Superstore), download here if needed.

After you finish your workout, share on Twitter using the hashtag #WorkoutWednesday and tag @AnnUJackson, @LukeStanke, and @RodyZakovich.  (Tag @VizWizBI if you have space, he would love to see your work too!)

Also, don’t forget to track your progress using this Workout Wednesday form.