Medical Trial Dataset

Key Observations:

• Patients can only be on one medication at a time.
• Medication B is administered once a month, whereas Medication A has a higher frequency of administration.
• Dosage units differ between medications and are not convertible.
• A month is defined as 4.33 weeks to maintain consistency in analysis.

Metadata:

Administration Data:

• ID: Patient identification number
• Medication Type: A or B
• Administration Date: Date when each medication was administered
• Dosage Units: Amount administered

Lab Data:

• ID: Patient ID for lab results
• Draw Date: Date when lab tests were conducted
• Lab Result Code: Unique codes for different lab tests
• Lab Value: Results of lab tests in numerical form

Business Goals:

XYZ Healthcare seeks to understand the impact of switching medications by analyzing usage patterns, costs, and lab results. The focus is on determining if Medication B is a cost-effective and beneficial alternative for its patient base.

Key Questions for Analysis:

1. Monthly Medication Usage: What is the overall usage pattern of both medications on a monthly basis across all patients?
2. Patient Distribution: How many patients received Medication A vs. Medication B over the study period (July-November)?
3. Average Monthly Dose per Patient: What was the average monthly dose for each patient on both medications?
4. Switching Trends:
   • How many patients switched to Medication B in each month?
   • How many patients started on Medication B without prior administration of Medication A?
5. Time on Medication A Before Switching: On average, how long did patients stay on Medication A before switching to B?
6. Pre- and Post-Switch Dose Comparison:
   • What were the average doses of Medication A before switching and of Medication B after the switch?
7. Breakeven Analysis:
   • Assuming Medication A costs $1 per 100 units, what is the breakeven price for Medication B based on its dosing and usage?
8. Dose Adjustment Over Time: How did the average dose change for patients switched to Medication B, based on the month of the switch (September, October, November)?
9. Second Dose Analysis: What percentage of patients had a higher, lower, or same dosage during their second month on Medication B compared to the first month?
10. Lab Results: Compare the average lab values for patients on Medication A versus those on Medication B to assess any significant differences in health outcomes.

By expanding the dataset with these key insights and metrics, the XYZ team can make a more informed decision regarding the transition from Medication A to Medication B.