Skip to content
Workout Wednesday
  • Tableau Challenges
    • Challenge Insights
  • Power BI Challenges
  • Track & Review
    • Participant Overview
    • Track
  • Contributors
  • Meet The Community
  • Search
Workout Wednesday
  • Tableau Challenges
    • Challenge Insights
  • Power BI Challenges
  • Track & Review
    • Participant Overview
    • Track
  • Contributors
  • Meet The Community
  • Search

2019 Week 4: Headcount Tracking

5 Comments / Tableau, Workout Wednesday / By Curtis Harris

Hello and welcome to week 4 of Workout Wednesday 2019, and my first contribution as an official team member! This week’s challenge should be on the easier side, and forces us to think a little bit about data prep, before we get to producing our Workout Wednesday visualization.

I was recently challenged at work to product additional rows of data between two dates, all while staying within the confines of Tableau. Assuming you don’t have Alteryx, SQL skills/tools, or other data prep tools… how would you use Tableau and every day applications (Excel, Google Docs, etc) to enhance your data set? For this week’s challenge, I want you to use Tableau Desktop’s data source page to enhance your base data set. Keep an eye on the number of records, it is a key requirement this week!

Click image to view on Tableau Public

Requirements

  • Data prep requirements
    • I’ve provided a scaffold of dates in the file that should be used to extend the employee level data
      • Using the data source page, combine the employees data and the dates data into a single data source
      • Important… bring in only dates that fall between an employee’s hire date and termination date. If an employee has no termination date, use today’s date. Example: employee 2 should have 141 records before extracting (every date between 3/1/2018 and 7/19/2018)
      • Your final extract should have exactly 5,947 records
  • Dashboard requirements
    • Dashboard size: 1000 x 600, and should contain no more than 3 sheets
    • Create a summary number that represents how many active employees we have on the latest date left in the data after data prep is complete
    • Create a line and dot combo chart with a mark for every day. When there are gains in employees, highlight that date with a gray circle. When there are losses in employees, highlight that date with a red circle. Size the circles by the absolute volume of the gain/loss.
    • Create a volume chart below the line chart that shows employee gain/loss by day
    • Match formatting, colors, and tooltips as closely as possible
      • Note the positive, neutral, and negative number format in the tooltips. Gains should be displayed as +n, 0 gain/loss days should be displayed as 0, and losses should be displayed as -n. Do not create three fields to accomplish this behavior.

Dataset

This week uses fake headcount data stored in Google Drive.  Connect to the data in Tableau by using the Google Sheets connection, and this link: https://docs.google.com/spreadsheets/d/1DO9bKM4dFVc4q_cID3VACoxVn3mQ5ipbd8owNXXprrY/edit?usp=sharing

Attribute

When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.

Share

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

Track your progress

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

Post navigation

← Previous Post
Next Post →

5 thoughts on “2019 Week 4: Headcount Tracking”

  1. rincon
    January 25, 2019 at 6:49 pm

    Hi Curtis,

    great challenge. It reminds me the presentation of Mrs Ganeshalingam and Singh during TC ” Solving tought time based problem with skeleton tables!

    Reply
  2. Hatem Kotb
    January 27, 2019 at 3:05 am

    I tried to do use the Date field for the joins twice but it didn’t work, had to use Excel for my workaround. Nice challenge Curtis & thanks for the video on the prep – smart!

    Reply
  3. Watsa Chaodee
    January 28, 2019 at 9:38 am

    My first #WorkoutWednesday2019 Week 4 is complete. Thanks for the challenge @curtisharris.
    BTW, I am not sure that the data source in Google Doc is different from the data source in the challenge. The data in Google doc does not have any gain or loss on Dec 16. Therefore mine does not have lost employee on Dec 16. Is it correct?
    https://public.tableau.com/views/WW-2019W4/WW2019W4?:embed=y&:display_count=yes&publish=yes

    Reply
  4. MARCO DEGOLA
    February 1, 2019 at 10:24 am

    Hi Curtis, this was an iteresting one , even if simple on the Tableau Side.

    Here my shot:
    https://public.tableau.com/profile/marcodegola#!/vizhome/ItalianWorkoutWednesday2019/2019w04-ww?publish=yes

    Welcome Aboard!

    Reply
  5. Faisal Akbar
    February 18, 2019 at 7:41 pm

    Interesting one, here is mine:
    https://public.tableau.com/views/WorkoutWednesday2019Week4_6/WorkoutWednesday2019Week4?:embed=y&:display_count=yes&publish=yes

    Reply

Leave a Comment Cancel Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

#WOW2021

vizdiscoverySUBI@vizdiscovery·
2h

#WOW2021 #Powerbi week9 solution
@JSBaucke, @MMarie, @shan_gsd, @dataveld.

Reply on Twitter 1368318190909014022Retweet on Twitter 1368318190909014022Like on Twitter 13683181909090140221
Revathi_dataRevathi Vijayendran@Revathi_data·
3h

My submission to #WOW2021 Week 9
This was bit tough for my level but great learning as always.
Many thanks @JSBaucke, @MMarie, @shan_gsd and @dataveld

Reply on Twitter 1368307966496104449Retweet on Twitter 1368307966496104449Like on Twitter 1368307966496104449
BAyshahAyshah JB@BAyshah·
3h

@BritishVogue
#wowuk
#nubyagarcia
#forcesforchange
#wow2021

Reply on Twitter 1368302194630537229Retweet on Twitter 1368302194630537229Like on Twitter 1368302194630537229
coralhermocCoral Hermo@coralhermoc·
4h

Mira Mglad 2k6+ Sábado espiritual

A por el sábado 🔥🔥🔥

#wow #wowespaña #worldofwarcraft #warcraft #live #twitch #directo #stream #streaming #wow2021 #twitchstreamer #gaming #alianza #horda

https://www.twitch.tv/hateful_pvp

Reply on Twitter 1368287535189876738Retweet on Twitter 1368287535189876738Like on Twitter 13682875351898767381
priyankadobhal_Priyanka Dobhal@priyankadobhal_·
4h

#WOW2021 with #powerbi Week 9
Smart Narrative is just so amazing! Thanks for the challenge @shan_gsd

@JSBaucke, @MMarie, and @dataveld

Reply on Twitter 1368287408765104131Retweet on Twitter 1368287408765104131Like on Twitter 13682874087651041312
Load More...

Recent Posts

  • 2021 Week 9 | Power BI: Forecasting and Anomaly Detection
  • 2021 Week 9: Can You Hide A Chart in the Map Layers?
  • 2021 Week 8 | Power BI: SWITCH()ing Measures
  • #WOW2021 | 08 | Can you use the Brush Filter extension?
  • 2021 Week 7 | Power BI: Conditional Formatting

Categories

  • community
  • Power BI
  • Solution
  • Tableau
  • Uncategorized
  • Workout Wednesday
March 2021
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
293031  
« Feb    

Tags

Actions calculations chart types cluster cohort Color Dates Distance dual axis emoji Extension formatting histogram Index jitterplot KPI labels Level of Detail lods Log measure names Mobile parameter parameter actions Parameters pareto pictogram Power BI reference line retention set actions sets sheet swapping Small Multiples Solution sort sorting Spatial Tableau data model table calculation table calculations union unions window_sum workout
Supported By:




Copyright © 2021 Workout Wednesday
Scroll to Top