Industry

Logistic

Challenges

Track of Business KPIs & MIS reporting

Solution

Centralized reporting platform for Business KPIs & MIS reporting

Business value

Reduce time spent on creating the reports manually & data-related issues that crept in due to manual consolidation and analysis.

Technology

Data studio • Big Query • GCP Data flow

Challenge

DTDC is one of the largest courier companies with operations in multiple countries. They deliver millions of packages each month across India. The sheer size of operations is huge and there are different systems that track sales, marketing, operations etc.

The challenge that DTDC was looking to solve, was to have a centralized reporting platform that can be used to keep track of not only the business KPIs but also to enable MIS reporting as well. The data was siloed in different systems and manual reconciliation and reporting process was slow and error-prone.

The stakeholder dashboards were created manually but that took a lot of time and effort. The large volume of data also made it a lot tougher to consolidate and share reports manually.

Solution

BluePi developed a comprehensive end to end solution on Google Cloud Platform that enabled centralized reporting. The core component of the solution was the data warehouse that stores assimilated data from different systems and makes it available, through secure channels.

Dashboards on top of the data warehouse are just one of the possibilities. With the central data repository, different teams within DTDC have access to the data and can introduce KPIs and other business metrics for their functions. The data warehouse also lends itself nicely to data science capabilities as well.

Salient features:
  • ETL pipeline using GCP Data flow, that collected, cleaned and transformed the data from different systems, and loaded into the data warehouse.
  • Data studio dashboards for MIS reporting, with low-level details that can help identify and diagnose bottlenecks,
  • Business KPI performance dashboards for senior management.
Business value delivered

The dashboards and data collection framework put in place by BluePi helped DTDC:

  • Build the practice and adoption of centralized reporting
  • Reduce time spent on creating the reports manually
  • Reduce data-related issues that crept in due to manual consolidation and analysis.
  • Achieve the reporting and the complete data platform, at a very economical cost.

In fact, due to the success of the reporting platform, DTDC team is now working on building much more extensive and data capable platform for reporting and plan to launch organization vide in the recent future.

Technology deployed
  • Data studio
  • Big Query
  • GCP Data flow
Read

More Case studies

Helped a Leading DTH Company to Analyze Consumer Behaviour
Helped a Leading DTH Company to Analyze Consumer Behaviour

Company DTH Company Location India Segment DTH Solution Analytics How well do you know your...

ABP News- CMS Migration to Cloud
ABP News- CMS Migration to Cloud

Customer ABP News Location India Segment Media Solution Migration Customer Profile ABP News, a leading...

How BluePi Helped automate deployment for Repchecker AWS DevOps
How BluePi Helped automate deployment for Repchecker AWS DevOps

Customer Qmetrix Location USA Segment Hospitality Solution DevOps Customer Profile qMetrix provides customized, integrated logistics...

call to action

Invest in better
solutions today