Mini-project
Pharma & Life Sciences
Medicine sales analysis
Analyse medicine sales by product group and period, and find the fastest-growing segments.
The brief
A pharma company's sales head wants to know which therapy areas are growing and where. Analyse medicine sales by product group and period with SQL and pandas, find the fastest-growing segments and their seasonality, and present it to the sales team. Good looks like: reconciled queries, growth and seasonality charts, and three recommendations.
What you will build
- Load the sales data into a database
- Calculate growth by product group and period
- Find seasonal patterns
- Rank the fastest-growing segments
- Present findings to a sales audience
Free, open data to build it with
- Pharma sales data ↗ Kaggle
Check each dataset's licence before you publish your work. Your mentor gives your team its own version of the brief (data, scope or region), so every team's project is its own.