Business Intelligence & Analytics (Manufacturing & Logistics/BI & Big Data Technologies)

 

 

About the client

 
Item 1

Our Customer is leading the Digital Transformation of Energy Management and Automation in Homes, Buildings, Data Centers, Infrastructure and Industries.

Our Customer develops connected technologies and solutions to manage energy and process in ways that are safe, reliable, efficient and sustainable. The Group invests in R&D in order to sustain innovation and differentiation, with a strong commitment to sustainable development.

Client Business Challenge

 

Regional offices have issues to generate the logistics reports and KPIs as there is no single system which has consolidated database to give the necessary views to see the required reports. The silos of data is not accessible to the different country teams and there is no platform where they can collaborate and access the reports.

Solution

 

The following Business Intelligence (BI) solutions has been implemented for customer.


  • Logistic Intelligence Made Easy (“LIME”) to serve the needs of regional offices in the SEA serving 18 countries .
  • Features includes Dashboard and KPI’s with data feed from 3 ERP source system.
  • KPI measures like Order Value, Number of sales/purchase orders, % Stock order lines, Order entry lead time .
  • Ability to attach and send out reports over email to the external users (customers, distributors etc.)
  • Scalable design for growing demand and greater adoption rate with more feeder systems integrated

Implementation

 

We have integrated with SAP source system and implemented hourly batch process to fetch the latest transactions.


  • Star Schema is used to develop data warehouse and dimensional data marts.
  • For Visualization, High Charts component has been implemented.

Technologies used

 
 
Microsoft SQL Server
.NET MVC
jQuery

The Result

 

A single platform where the consolidated data is available to generate reports required by different types of users and business entities.


  • Simple and easy to use Dashboard features.
  • User select different visualization views and instantaneously see the graphical view.
  • Filtering option like market segment, sales office location, product line, year/month/week .