Skip to content
Workout Wednesday
  • Tableau
    • Challenge Insights
  • Power BI
  • CRM Analytics
  • Track & Review
    • Participant Overview
    • Track
  • Contributors
  • Search
Workout Wednesday
  • Tableau
    • Challenge Insights
  • Power BI
  • CRM Analytics
  • Track & Review
    • Participant Overview
    • Track
  • Contributors
  • 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 *

Recent Posts

  • 2023 Week 13 | Power BI: Create a connected scatterplot with image markers
  • 2023 Week 13 | Predicting Customer Churn
  • #WOW2023 Week 13: Can you use dynamic axis titles?
  • 2023 Week 12 | Data Syncs & Scheduling
  • #WOW2023 | Week 12 | Can you build a dashboard using containers?

Recent Comments

  1. Shannon Lindsay on #WOW2022 W43: Advanced Formatting by Jeremy Anderson
  2. Ellen on #WOW2022 W43: Advanced Formatting by Jeremy Anderson
  3. 2023 Week 12 | Recipe Scheduling – Workout Wednesday on 2023 Week 01 | Simple Recipe – Line Item Sales
  4. 2023 Week 12 | Power BI: Are your reports accessible? – Workout Wednesday on 2021 Week 14 | Power BI: Accessibility Enhancements
  5. Shannon Lindsay on 2022 Week 17 | Power BI : Create a Custom Theme

Archives

  • March 2023
  • February 2023
  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018

Categories

  • community
  • CRM Analytics
  • Power BI
  • Solution
  • Tableau
  • Uncategorized
  • Workout Wednesday

Sponsored by

Copyright © 2023 Workout Wednesday
Scroll to Top