Company Overview 

Company J is a specialist in aesthetic medical devices, developing and manufacturing laser, radio-frequency, and ultrasound systems. It serves plastic-surgery and dermatology markets in Korea and abroad and is expanding globally through product competitiveness and business capabilities.

 Business Challenges 

As repeat purchases of consumables became a key growth driver after equipment sales, J needed a structured way to analyze recurring revenue based on customer purchasing patterns and product usage. Sales, consumables, customer, country, and product-line data were fragmented, making it difficult to identify repurchase opportunities and churn-risk customers quickly.

 Why Woongjin 

J selected Microsoft Fabric and Power BI to build a scalable analytics platform on existing data. Woongjin analyzed key datasets and defined the data mart structure and KPI calculation standards. It then designed a recurring-revenue analytics model and Power BI dashboards for executives and sales teams.

 Results 

J can now segment core customers, repurchase prospects, and churn-risk customers using purchase cycles, most recent purchase dates, and installed-equipment information. Power BI visualizes recurring-revenue KPIs such as consumables repurchase rates, annual consumables revenue per device, expected repurchase revenue, and country-level sales. The analysis also identifies upsell and cross-sell opportunities from product ownership and purchase-gap data.

 Project Keywords 

#MicrosoftFabric #PowerBI #DataMart #RecurringRevenueAnalytics #RepurchaseAnalytics #CustomerSegmentation #MedicalDevices