Logistic Improvement

Retail

Company size:

Presence:

Technologies:

10 000+ Employees

7500+ stores in Poland

Power BI, Azure Analysis Services, Azure DWH

01:

CHALLENGE

Client was implementing Digital Transformation in the organization. Due to obsolete and ineffective reporting, new data models and analytical capabilities were required. Additionally, client had new business needs that had to be reflected in a new solution.

The most important features required by users were:

more interactive analysis
ability to drill from aggregated to detailed view
more visual data analysis
ability to analyze data integrated from multiple areas

02:

SOLUTION

analysis of source data and additional source XLSX data structure
design and implementation of ETL processes enhancements in Azure DWH
requirements gathering and analysis with business users
mockuping and prototyping in order to build appropriate UX/UI Design
creation of Power BI data model and Power BI Service structure
migration of old Cognos Reports
testing and data comparison
creation of Power BI dashboard monitoring deliveries, accuracy of shipments, average time per delivery and multiple other KPIs for shipments

03:

RESULTS

reporting Automation (50-70% less manual work)
visibility on operational KPIs for shipments and ability to optimize delivery timing
Fraud detection for Deliveries (eg. drivers doing their private businesses during deliveries)

Logistic Improvement

Let's talk

This website uses cookies.

Learn more