2 Replies Latest reply on Jan 24, 2019 7:36 AM by Shane Carr

    Noob - How to approach this problem domain?

    Shane Carr

      I am brand new to Tableau and could use some guidance as to how to approach this data set.

      My data set is Hospital related. Its data for Jan – Dec 2018 related to waiting times for patients to see a specialist.

      Data is broken down into brackets by age:

      • 0-4
      • 4-17
      • 18-64
      • 65+

      And by number of weeks on a waiting list:

      • 0-12 (weeks)
      • 13-26
      • 27-39
      • 40-52
      • 52+

      Additionally, we are capturing the number of NEW patients for each age bracket coming into the system each month.

      The goal here is identify trends in terms of Age Profiles Vs Weeks Waiting; also to identify areas where the number of new patients is outstripping the number of patients seen (so the clinic saw 100 patients but there were 110 new patients registered)

      My noob brain is saying I need to do a trend analysis graph and possibly a heatmap to effectively ‘dashboard’ the information in a visually appealing and digestible way.

      Any helpful suggestions are very welcome.

        • 1. Re: Noob - How to approach this problem domain?
          Jim Dehner

          Hi Shane - welcome to Tableau and the forum

           

          If I understand the post you have a point in time data set that identifies patients by age and the number of weeks they have been on the waiting list?  Do you plan to update the regularly?  or is the data mor a patient list with the data they were placed on the wait list and the date they got an appointment -

          They solution will be very different based on the actual and the structure of the data

           

          Jim

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

          • 2. Re: Noob - How to approach this problem domain?
            Shane Carr

            Hello Jim,

             

            Thanks, I'm looking forward to being part of the community - hopefully, in a couple of months I'll be able to help someone else.

             

            The data is reported monthly and would be updated on an ongoing basis. Effectively it is an overall number similar to the randomized data below.

             

              

            Description         Jan           Feb         Mar
            Number of existing Specialist clients offered an appointment and seen: 0-4 yrs1016857
            Number of existing Specialist clients offered an appointment and seen: 5-17 yrs813413
            Number of existing Specialist clients offered an appointment and seen: 18-64 yrs1013834
            Number of existing Specialist clients offered an appointment and seen: 65 yrs and over7110666
            Number of New Specialist clients offered first appointment and seen > 12 weeks but ≤ 26 weeks: 0-4 yrs837190
            Number of New Specialist clients offered first appointment and seen > 12 weeks but ≤ 26 weeks: 5-17 yrs11749107
            Number of New Specialist clients offered first appointment and seen > 12 weeks but ≤ 26 weeks: 18-64 yrs694286
            Number of New Specialist clients offered first appointment and seen > 12 weeks but ≤ 26 weeks: 65 yrs and over296078