Optimizing Purchase Tracking and Supplier Performance with Power BI
The project aimed to improve the purchase process by developing a Power BI dashboard that consolidates purchase data, tracks total spending, evaluates supplier performance, and monitors pending orders in real-time. The dashboard simplified decision-making and provided an efficient way to manage purchases and suppliers.
Client Overview
The client is a leading healthcare distributor based in the UAE, specializing in the distribution of pharmaceuticals, consumer health products, and veterinary medicines. With decades of experience, they serve both private and government sectors, working with top global brands.
Technical Stack
Industry
Healthcare and Pharmaceuticals
Region
UAE
Project-size
Non-Disclosable
Implementation Highlights
Integrated data from ERP systems, Excel spreadsheets, and supplier platforms into one Power BI dashboard.
 Developed visuals for real-time tracking of purchase orders, including overdue orders, PO values, and supplier performance metrics.
 Added top supplier analysis to assess vendor performance and track spending patterns by vendor.
Integrated currency-wise breakdowns to monitor PO values and payments in multiple currencies.
 Provided filters for tracking PO types, line items, shipment statuses, and more.
Challenges & Solutions
Difficulty in tracking pending orders and payment delays.
Solution: Added real-time order tracking visuals to provide insights into pending orders and delayed payments.
Hard to track supplier performance and issues with purchases.
Solution: Added supplier performance pages to track how suppliers are doing, find top suppliers, and spot any PO problems.
Hard to track the current status of each order.
Solution: Added a status tracker to see where each order is in the process (e.g., pending, shipped, delivered).
Lack of details on which purchase orders are fully paid.
Solution: Added payment status to track which POs have been fully paid and which are still pending.
1000+ Projects Experienced
Access Iqra Technology’s skilled developers and experts. Enjoy a risk-free two-week trial and take advantage of our cost-effective solutions.
8+
Years of Business
Experience
100+
Happy
Customers
15+
Countries with
Happy Customers
100+
Agile enabled
employees
Results & Impact
- Automated reports saved 50% of the time spent on manual tracking.
- The dashboard enabled quicker decisions on delayed payments and urgent orders.
- Real-time PO and payment tracking made the procurement process more efficient and proactive.
- Supplier performance insights improved relationships with top vendors and addressed issues with low performers.
- Tracking billed amounts, pending payments, and PO values enhanced cash flow management and reduced overdue payments.
Key Learnings & Next Steps
- Centralizing data improves visibility and decision-making. Automation saves time, reduces errors, and helps track orders and payments in real-time for better budget and supplier management.
