Pharmaceuticals Data Analysis

Foresight Pharmaceuticals is one of the leading Pharmaceutical manufacturing companies with a global presence. Their markets are divided into different regions across the world. One of those regions manages the German and Polish markets. But the company does not sell directly to customers. Instead, they work with a couple of distributors in all their regions. They have an agreement with each of the distributors to share their sales data with them. This enables them to gain insights up to the retail level.

In this project, I dive into the data of a big pharma company to reveal insights, trends and patterns hidden inside the data. The data contains information about distributors, products, customers, managers, sales teams and a whole lot leading to this project having 5 dashboards at the end of the analysis and visualization.

Tools Used: SQL and Microsoft Power BI

Link to project documentation on GitHub: https://github.com/richmond-yeboah/Pharmaceuticals-Data-Analysis

Link to SQL queries: https://github.com/richmond-yeboah/Pharmaceuticals-Data-Analysis/blob/main/pharma%20data%20querying.sql

Link to Power BI dashboard: https://app.powerbi.com/view?r=eyJrIjoiYjhiMmM2NDYtZTVjNi00Y2QyLTkwNDQtNjFkNTYwYzBlMjk5IiwidCI6IjFjZTU4MjFjLTE5NDItNDczMy1hNmRjLTBmYzNhODJiNzRkYiJ9