Logistic Improvement

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)

YOU MAY ALSO LIKE:

contact

Let's talk

Katarzyna Strzelecka

Sales Operations Manager

+48 722 233 444

Clouds On Mars needs the contact information you provide to us to contact you about our products and services. You may unsubscribe from these communications at any time. For information on how to unsubscribe, as well as our privacy practices and commitment to protecting your privacy, please review our Privacy policy.

contact

Let's talk

Clouds On Mars needs the contact information you provide to us to contact you about our products and services. You may unsubscribe from these communications at any time. For information on how to unsubscribe, as well as our privacy practices and commitment to protecting your privacy, please review our Privacy policy.

This website uses cookies.