cristian9217

Case Study 3: Medication Sales Across Pharmacies

The objective of this analysis is to evaluate medication sales across different pharmacies to identify key patterns and trends. By understanding variations in location, customer traffic, dates and product demand, we can uncover meaningful insights. We will also focus on storytelling to clearly communicate the results and highlight the most important factors in driving performance.

Description of the data

Analysis period: January 1, 2023 to November 15, 2024.

Total records: 1,000 transactions.

Variable Type of data
Date Text
Year Numeric
Month_Name Text
Day Numeric
Season Text
Location_Store Text
Gender Text
Age Numeric
Type_Plan Text
City_Client Text
Name_Product Text
Category Text
Covered_Plan Text
Unit_Price Numeric
Quantity Numeric
Total_Sale Numeric