Case study · Industry
Turning years of Power Apps builds into one integrated hub
Reconciling distillery, lab, business, IT and legal apps built up since 2019 for a global whisky brand, into a single connected experience.
Microsoft SQL Server
Since 2019
Power Apps built up across the business
5
Teams united in one front-end hub
1
Consolidated SQL Server database behind every app
The client
Since 2019, a global whisky brand had been building up Power Apps solutions for different parts of the business, covering distillery operations, lab testing, business users and more, including its own contracts database app for the legal team.
As the number of apps grew, so did interest in a reconciliation piece: going back over what had already been built, finding similar processes that could be brought together into a more integrated experience, and identifying any gaps along the way.
The challenges
- •Integrating multiple existing applications, each originally built for a specific team or process.
- •Multiple layers of stakeholders, from distillery and lab users to business, IT and legal teams, each with different needs from the same system.
- •Rationalising the underlying data structures without disrupting the fact tables and processes already in daily use.
What we delivered
- ✓An integrated front-end hub, linking every app’s relevant screens by user group (distillery, lab, business, IT and legal) rather than leaving each as a separate silo.
- ✓An “Active Requests” screen for distillery and lab users, giving visibility over active mature-spirit tanker loads and outstanding samples.
- ✓A consolidated Microsoft SQL Server database, keeping existing fact tables intact while rationalising the shared layers that link them together.
The outcome
- ✓A single hub streamlined how staff accessed every app, including shared functionality like label printing and barcode scanning.
- ✓Consolidated back-end data that’s easier to maintain and build on going forward.
- ✓Requests between user groups logged directly in the system, replacing hard-to-trace email trails.