Project Type: Full-Stack Business Intelligence & Data Analytics
Company: Health Supply 770 Inc. (Medical Supply Distribution)
Role: Product Analyst
Duration: 2025 Annual Performance Analysis
Tools Used: Python, PostgreSQL, Power BI, DAX, Monday.com API
Scope: End-to-End BI Solution Implementation
Developed a comprehensive business intelligence solution for Health Supply 770 Inc., a leading medical supply distributor serving hospitals and healthcare facilities nationwide. As a Product Analyst, I transformed raw operational data from the company's Monday.com order management system into actionable insights through an interactive Power BI dashboard.
Working with real-world e-commerce and B2B distribution data, the project analyzed 7,179 orders representing $1.16M in annual revenue across 60,000+ products and 150+ brands. The analysis identified $23K+ in losses from underperforming brands, $289K in return-related costs, and uncovered $400K+ in growth opportunities through data-driven analysis.
Business Context:
Health Supply 770 processes orders through Monday.com boards, with each month's transactions tracked separately. The company needed consolidated analytics to monitor KPIs, identify operational bottlenecks, optimize brand mix, and make strategic decisions about inventory, suppliers, and geographic expansion.
Key Achievements:
✅ Automated data pipeline processing 7,179 orders across 12 monthly boards
✅ Built 4-page interactive dashboard with 60+ DAX measures and real-time KPIs
✅ Identified 3 critical business issues costing $312K annually with actionable solutions
✅ Delivered strategic roadmap projecting 47% revenue growth to $1.7M
✅ Provided executive leadership their first comprehensive business intelligence platform
m[onday.com](<http://monday.com/>) (Source) → Python ETL → PostgreSQL → Power BI → Business Analysis
↓ ↓ ↓ ↓ ↓
Raw Data Data Merge Data Transform Visualization Insights