Visualization and reporting solution
Overview
Having analytical tools means that you get a lot of data, metrics, and insights that can overwhelm you. When you need to present results or make strategic decisions it is optimal if you can visualize your data. A visualization solution does that for you and it brings your analytics to life. It can help you spot errors, discrepancies, disruptions, or opportunities in your business processes.
With any data-related project, it is optimal if you can visually present data for quicker decision-making. Users can understand data better if it’s visually represented and when they can see how certain metrics, insights, or KPIs move through time. Through interactive and comprehensive graphs, tables or charts, users can interpret data and share the interpretations with others.
Our approach was to represent complex data in an easy, understandable way so the clients wouldn’t have to go through endless data sets to discover what’s important to them. Also, what we needed to accomplish was to identify outliers and show which KPIs are standing out from the rest or why there were certain jumps or declines in a certain period.
This visualization tool was made to show the activities and KPIs in the supply chain, from transportation to matching supply and demand. It had the task of using data from web or mobile software solutions and creating analytics for reporting. When decisions have to be made or when users have to share insights with others, it is easier to have visualizations that can convey their findings.
Project scope
Discovery:
- Workshops
- Client interviews
- Data assessment
- Data validation
- Project planning
Procedure:
- Data collection and consolidation
- Data marts creation
- Creating visualizations and reports
- Visualization and reports creation
- Solution presentation
Team:
- Data scientists
- Data engineers
Project duration:
- 3 months
Methods:
- DWH + no-code visualizations
- Data engineering
- Data warehousing
Project goal:
- Create an easy to use solution
- Give insights into KPI movements
- Represent complex data in a simple and understandable way
- To identify outliers
- To discover actionable insights
Technologies used:
Tableau
Vertica
Pentaho Data Integration
Main goals:
Main issues:
Main goals:
- Visualization of analytics
- Combined data and reporting in one place for visualization that allows filtering by multiple criteria
- Data accessibility through visualization (data transparency)
Main issues:
- How to combine multiple data sources in the visualization solution?
- How to make reporting and visualization simpler?
- How to enable multiple filtering at once?
- How to automatically generate visual representations of data and analytics from the web and mobile solutions?
Our process:
A visualization solution can be developed custom for a certain analytical solution or it can be made in Tableau which gives semi-finished options. Depending on the needs of the user, it can be made custom where graphs, charts, or maps are made to fit certain criteria on looks and feel. For the Tableau approach, it is much quicker since it uses half-finished visuals and it can combine multiple data criteria and reports in one.
In our case, we used custom and Tableau approaches.
Solution:
A visualization solution can point out oversights in the supply chain and combine data from Fusion and Mobile Manifest. Where Deegloo answered the project from a web and mobile development standpoint, we took on the data part to bring information to life through visualization. When working in an industry where your supply chain is long and has many links, having a solution that can visualize those steps is important. In supply chains, you generate great amounts of data and it can be daunting to turn it all into graphs, charts, or maps. With visualization, you can plan more in detail and more precisely. Visualization is applicable in dispatch discipline, plant performance, detention tracking, and goods movement from loading to unloading. In dispatch discipline, you can visualize when a certain hauler is called for loading or unloading. You can visualize the distribution or when there are higher intervals of loading and unloading. According to that, dispatchers can organize haulers to spread them out so the waiting time is lower.
Through visualization of plant performance, there is the possibility of finding out when and why are there some standstills, especially in warehouse logistics. It can answer why are some trucks waiting a long time to load or unload and whether it is the plant’s fault or the hauler’s.
For detention tracking, it can visualize when and where did the driver of a certain hauler company make stops or where is he on the route. This visualization solution can keep track of every link in the chain and visually present data so the user can see the distribution of data and their analytics.
Results:
Visualized analytics all in one place
Reduced need for manual visualization
It reduces costs
Keeps track of the whole supply chain and each segment
Easy presentation and reporting
Admired by
