1. Project Title & Company Review
Phillip_hill Solution: Sales Performance Analysis and Reporting.
INDUSTRY: Pharmaceutical.
Phillip-Hill Solutions, a leading pharmaceutical distributor, is facing challenges in optimizing sales performance, managing inventory efficiently, and identifying key market opportunities.
The company serves a diverse healthcare sector, ensuring the availability of essential medications. However, inefficiencies in demand forecasting, stock management, and customer engagement strategies have impacted perationaleffectiveness.
ROLE: Data Analyst.
2. Business Problem
The company needs to identify the following key business questions:
- Challenges optimizing sales performance.
- Poor inventory management.
- Identifying key market opportunities.
3. Business Objectives
TOP/BOTTOM Analysis
- Develop Overall sales metrics.
- Compare monthly performance.
- Identify top 5 & bottom 5 Drugs in sales performance.
CUSTOMER PERFORMANCE
- Analyze customer demographics.
- Calculate average revenue per customer per customer segment.
- Visualize revenue distribution by country and customer type.
- Revenue by gender & age.
- Geographical insights.
4. My Approach
- Data loading of MS Excel dataset.
- Data Cleaning in Power Query.
- Data Modeling.
- M Language & DAX Language.
- Business insights.
- Dashboard building.
- Recommendations.
TOOL USED: Power BI
5. Key Deliverables
Delivered a Power BI dashboard to improve data-driven decision -making
6. Insights
- There is a fluctuation in the revenue & profit across all the months, but January, July, and September generating the most revenue: $5.5M; $5.2M & $5.3M respectively.
- Among all the top-selling drugs in revenue & profit, Ergocalciferol is the only product that sold more in quantity: Total os 6,077 sold out.
- Canada has the highest revenue of $26.6M while Australia has $12.3M.
- Among the 6 countries, Canada & Australia combined generated a revenue of $36.9M which is 65.9% of te total revenue of $56M.
- The Old contributed the highes revenue of $14M, representing 25% of the revenue. Next to that is the Elder with $13M in revenue wihich is 24% of th revenue and lastly the Senior with $8M, which is 14% of the revenue.
7. Recommendations
- Increase investment of top-selling products, with a focus on Ergocalciferol, Doxycycline & Ezetimibe.
- For efficient stock management, ensure the top-selling products are available compared to the least-selling ones.
- For the top-performing customers, they should be rewarded with incentives and given premium attention, which will make it easier for you to make referral demands from their network.
- A survey should be carried out to find out which products the Senior (Age group), other (Gender) and User Type need to maximize revenue & profit.