Contents

Disclosure:

  • Identifiable data has been altered and names changed to maintain complete anonymity.
  • As most charts are done using Tableau, they are interactive and best viewed full screen.
  • You can hover over data points, columns, use the filters, whatever you wish, you’re not going to break them.

INJECTION SCHEDULE

This chart wasn’t meant to analyze a specific business case, it was created to replace a calculator of sorts. It was more of a product design than an analysis.

This chart is for a specific medical application, the target user is extremely specific and knowledgeable about it’s use so it wasn’t meant to be presented to a board as a result of analysis. I spent a tremendous amount of time researching formulas, data, and information regarding the specific drug/medication whichever term you prefer to use. Finally, when I presented the options to the user, this was chosen because it is easy to use, extremely visual, and instantaneous, and virtually impossible to break.

  • It is meant to show the amount of medication available in the body at specific days throughout the treatment
  • The variables are the dosage amounts, strength of medication, and interval between injections
  • Variables are set in the right side of the chart
  • Based on each dosage and strength you’ll get a different level of the drug in the system
  • Each spike corresponds to the time of injection

Play around with the filter on the right, by checking on and off different boxes (medication strength and frequency)

Here is an example:

  • Let’s say you are using Medication Strength- 250 at 0.33cc injected every 3rd day, you’d
  • Check All then uncheck All to clear the board
  • On the upper side of the choices choose: 250-0.333
  • That gives you the base median for that specific medication with that strength
  • Now choose 250-3Rd which signifies an injection of that dose every 3rd day now you see the availability of that drug in the body and how it fluctuates around the mean line
  • Now choose 250-4th as well, and you’ll see how that new line falls below the base mean line
  • If you choose 250-5th, 250-6th …. you’ll see how the level of available medication in the body is decreasing
  • Let’s say you want to increase the strength from X250 to X300 just check the box next to 300-0.333 and you’ll see how that compares to the 250-0.333

 

Now here is something that is not quickly noticable but obvious if you’re a doctor or if you are the designer of this chart (since I must’ve used it a thousands times before I delivered it).

  1. If you use 25-0.333 injected at 250-3rd, then add 250-4th – Now you have a base line and two lines one for each injection plan on the 3rd day and one for the 4th day
  2. Obviously the line for the 4th day is lower
  3. Now let’s add the base line for a smaller dose, let’s say 250-0.25
  4. Watch how the median line is almost the average of the higher dose 250-0.333 injected on the 4th day (250-4th)