MJV Technology & Innovation
Jul 02, 2021
No image
Completed

Enhancing supply chain productivity

$25,000+
2-3 months
Brazil, Rio de Janeiro
6-9
Service categories
Service type
Custom Software Development
Design
Other
Domain focus
Energy & Utilities
Solution type
BI Tools
Programming language
Python
SQL

Challenge

The challenge of our project was to map data, organize it and make visualizations tangible through an analytical dashboard to give integrity to data consumption in the logistics process.
The challenge of our project was to map data, organize it and make visualizations tangible through an analytical dashboard to give integrity to data consumption in the logistics process.

Solution

After an Immersive analysis of the data and its entire structure many issues were addressed in their transactional base and the business rules used in their analysis process. The Power BI dashboard made information dissemination faster, brought security and reliability to corporate data.

Results

A high fidelity prototyping of Power BI dashboard, implementation of the entire cloud analytic ecosystem, consuming data available in a data lake, working it through the databricks platform using a mix of SQL and Python scripts and making the result available in a database. SQL Server to be consumed by a dashboard in Power BI. +10M Processed items and 26 real time graphics.