Enterprise Supply Chain Network, North America

The Challenge

Supply chain visibility initiatives tend to fail for a structural reason, not a data reason: every new operational question requires a new custom report, and a fixed dashboard can't keep pace with how fast priorities shift in logistics. The platform needed a Dimension and Metrics API layer flexible enough to power many different widget configurations — region, supplier, product line, carrier, on-time delivery, inventory turnover — without a bespoke backend build for every new view, so business and analytics teams across the organisation could configure their own widgets directly. That self-service ambition only works if the platform is genuinely simple to operate, which meant investing as much in widget configuration patterns and team enablement as in the APIs themselves. Beyond the analytics platform, the broader organisation was still running document management, approvals, and internal process workflows through manual, email- and spreadsheet-driven routines — slow, inconsistent, and disconnected from the SharePoint repositories where the underlying documents actually lived.

Our Solution

GYSP designed and built the Dimension and Metrics APIs powering the Supply Chain Intelligence platform's configurable widget system — a flexible data layer letting any new widget query the dimensions and metrics it needs without a bespoke backend build for every new view. To make the platform genuinely self-service, GYSP ran dedicated knowledge transfer sessions for other teams on widget configuration, alongside ongoing mentorship for junior developers joining the project — extending the platform's reach without growing engineering headcount. The team operates fully within Agile — sprint planning, daily stand-ups, reviews, and retrospectives — with peer review on every completed task to maintain code quality at pace. In parallel, GYSP modernised the organisation's internal process layer on the Microsoft Power Platform: SharePoint integrations connected document management and workflow automation directly to the platform, Power Apps solutions replaced ad hoc spreadsheet- and email-driven processes with structured business applications, and Power Automate streamlined approvals and notifications across the organisation — extending the same Office automation discipline built on earlier engagements into a low-code, organisation-wide automation layer. The engagement remains active, with platform capability and process automation continuing to expand.

Key Deliverables

• Dimension and Metrics APIs designed and built to power a configurable, widget-based Supply Chain Intelligence platform
• Self-service widget configuration enabled across teams through dedicated knowledge transfer sessions and ongoing mentorship
• Full Agile delivery cadence — sprint planning, daily stand-ups, reviews, retrospectives, and peer review on every completed task
• SharePoint integrations connecting document management and workflow automation directly to the platform
• Power Apps business applications built for internal process improvements, replacing ad hoc spreadsheet- and email-driven workflows
• Power Automate flows streamlining approvals and notifications organisation-wide
• Internal tools extending Office Add-in automation concepts beyond the original VSTO-based integrations
• Active, ongoing engagement since March 2024 — continuously expanding platform capability and internal process automation

Services Delivered

• Data Engineering
• BI & Analytics APIs
• Power Platform Automation
• SharePoint Integration

Tech Stack

Frequently Asked Questions