HB Pharma regularly receives sales and stock reports from multiple retail partners — each using different formats and timelines. This made it difficult to consolidate data, monitor trends, and act quickly on critical issues like soon-to-expire medications.

The key challenges were:

• Fragmented reporting across pharmacy chains

• Lack of a unified system to analyze product movement and stock levels

• No automated way to detect and manage expiring inventory

• Time-consuming manual processes that delayed insights

DataStudio built an automated, end-to-end Power BI solution, centered around a SharePoint-driven workflow:

• Users simply drag and drop incoming Excel files from partner chains into designated SharePoint folders

• The system automatically processes and consolidates the data

• A comprehensive set of interactive Power BI dashboards displays:

  • Sales trends across products and locations

  • Inventory status and movement

  • Expiration alerts for medications approaching shelf life

  • Opportunities to reallocate slow-moving or expiring stock to better-performing locations

With the new reporting platform, HB Pharma achieved:

• A fully automated reporting pipeline, reducing manual work to nearly zero

• Real-time visibility into sales and stock dynamics

• A proactive approach to managing expiring inventory

• Enhanced ability to support pharmacy chains with data-driven inventory decisions

• Faster and more confident commercial planning

The solution transformed a complex, reactive process into a streamlined, intelligent workflow — helping HB Pharma stay ahead in a fast-moving industry.