Integrated Logistics and Reporting Portal

📋 Overview

A large logistics operator with warehouses in Portugal and Spain was struggling with scattered information. Operations, quality and senior management each used different systems and reports. The new portal unified access to operational documentation and performance indicators in a single control panel.

🎯 The Challenge

Business context The truth about service level — on-time delivery, incidents, stock accuracy — varied depending on who you asked. Excel reports circulated by email, often out of date hours after being sent. Process documentation was disorganised on slow file servers.

Technical requirements

• Single pane of glass: one site where a manager can read the operations manual and see today’s performance chart beside it.
• Hierarchical security: warehouse directors see only their unit; Iberian management sees the aggregate.
• External access: the ability to share specific reports securely with major clients.

💡 The Solution

Strategic approach Use SharePoint Online as the unifying container, embedding contextual Power BI reports directly into each operational team’s pages. If the team is Warehouse North, the page shows North’s news, North’s procedures and Power BI filtered to North.

Technical implementation

• Site structure: a Logistics hub site with associated sites by geography.
• Power BI Embedded: interactive reports inserted through a secure web part, with row-level security filtering the data at source.
• Intelligent document management: metadata — document type, validity — replaced deep folder trees, enabling dynamic views such as Procedures In Force.

Timeline

• Phase 1 (information architecture): 3 weeks
• Phase 2 (Power BI development): 4 weeks
• Phase 3 (SharePoint build): 3 weeks
• Phase 4 (deployment): 1 week

📈 The Results

Success metrics

• 📊 Alignment: the whole organisation now discusses the same numbers — one version of the truth.
• ⏱️ Efficiency: KPIs reachable in three clicks, against thirty minutes searching email.
• 🤝 Clients: better relationships with key accounts through transparent sharing of quality metrics.

Business impact The culture shifted from opinions about problems to decisions based on facts. The portal became the homepage for every operations manager.

🛠️ Technology Stack

• SharePoint Online: intranet and document management.
• Power BI: embedded data intelligence.
• Azure AD B2B: secure access for partners and clients.

💬 Client Testimonial

“We used to spend meetings arguing about whose Excel was the right one. Now we all look at the Portal and argue about how to improve the operation.”

Operations Director Logistics Operator