endorsedOngoing

Azure Synapse & Power BI BI Platform for Supply Chain Logistics

Services Covered:

Big Data Analytics and Business Intelligence • Business Consulting • Custom Software Development • IT Consulting

Industry

Logistics & Transportation

Duration

63 months

Budget

200K - 999K

Start Date

1 May 2021

Team Size

Confidential

Engagement Model

Nearshore

Project Capability Score (PCS)

78/100

Good

Project Capability Score (PCS) estimates how capable Sciant is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS

Client

Ligentia

Leeds, United Kingdom

Project Summary

Sciant is developing a BI platform for Ligentia, a supply chain and logistics company, building Azure Synapse Analytics reporting and Power BI dashboards. The engagement includes data migration and transformation from finance, operational, and HR systems, role-based dashboard security, and migration support for an acquired company's finance platform. External assessments of the Azure Synapse work have been positive, and the client reports strong technical design and collaboration.

Key Challenges

Need for custom software development to build a BI and reporting capability
Ensuring secure, role-based access to dashboards so users only see appropriate data
Migrating an acquired company and ensuring finance platform compliance with Poland tax and legal rules

Project Deliverables

New BI platform with Azure Synapse Analytics reporting capability
Data pipelines transforming finance, operational, and HR data
Power BI dashboards with role-based security and KPI measures
Proof of concept (POC) and migration gap analysis for acquired company's finance platform

Project Solution

Sciant is helping develop a new BI platform using Azure Synapse Analytics for reporting and Power BI for dashboards. The team built data pipelines to pull and transform data from finance, operational, and HR platforms, started with a proof of concept, created KPI measures, and implemented role-based security so regional teams see only their data. Sciant also performed migration gap analysis for an acquired company's move to the client's finance platform and provides business analysis and project management support.

Project Outcome

Positive external assessments of the Azure Synapse Analytics implementation
Delivered on time with regular weekly team meetings
Sciant team integrated with the client’s teams and worked effectively alongside internal and external resources
Strong technical design and positive stakeholder feedback

Platforms

Cloud

Tech Stack

Azure
Power BI

Client Endorsement

Overall Review Rating

4.63

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“After two assessments, the client has received positive feedback about the work from Sciant. The team provides excellent technical design and brings an open-minded approach to the engagement. The client has been impressed with the team's ability to cooperate and seamlessly engage with their team.”
Noel Kenningham
Director of Group IT
Date: 05/24/2023