Understanding the product flow: A data visualization tool for a complex terrain

img
Client Location

Europe

img
Client Industry

Food manufacturing

img
Services Provided

Data strategy, Web app development and Data visualization tool

img
Technologies Used

Python, Django REST Framework, Azure SQL, SQLite3, Pandas, Numpy, Azure Storage Blob, Azure

img
Allocated Team Size

15+
Engineers

img
Project duration

16+ Weeks

Client

Client Background

Founded in the early 20th century, our client is a renowned Packaged-Food-Manufacturer that is loved by people and their pets across the globe. Creating a wide range of flavours and confections, our client has set the bar for consumer expectations higher and constantly comes up with innovative products to maintain their standards. Constantly evolving to suit their target audience, our client’s vision for sustainability is expected to significantly impact the market, drastically reducing the carbon footprint!

Requirement

With its presence in over 80+ countries, our client needed a system that collects, accumulates, and analyzes the global sales data by monitoring the supplier pipeline across different regions. This system needs to be simple, responsive, and highly fluid for easy navigation and better results.

img img
Problems

Business Challenges

01.

It is relatively challenging to define the number of suppliers in the market and their effect on the overall sales of the product

02.

The efficiency of the system is determined by the quality of the data from the suppliers. Often, there is a margin of error in real-time scenarios that could eventually tamper with the overall approach

03.

Consolidation of data across different categories of products and suppliers is challenging

04.

Lack of a drill-down approach, making the whole process difficult

img img
Methodologies

Our Process

01

Understanding the supplier’s role

To ensure a business-centric data strategy, our priority is to understand the role of the suppliers in the process as they bridge the client’s product and the market

02

Accumulating and organizing their data

We built an adaptive and dynamic data system that can accumulate data from different entry points and organize them accordingly

03

Filtering crucial data from the bunch

Crucial data is almost always hidden in plain sight. Our analytics system helps our client to identify repetitive patterns and pivotal data that has a huge impact on the whole process

04

Creating a minimalistic visualization tool

Leveraging app development, we aimed for a visualization tool that transcends different hierarchies within and outside the client’s organization

img
Our Team

Team Structure

We have handpicked our engineers and business analysts to better suit the project’s nature. The team structure was designed in such a way that it brings different perspectives to the table and complements each other’s domain and style of work.

img2

Data Engineer

img1

Cloud Architect

img1

Backend Developer

img1

Projects Manager

img1

Customer Success Manager

img
Tech Stack

Tools and Technologies

We used various tools and technologies that significantly simplify the workflow while being highly versatile.

img
Communication Tools:
  • Slack for internal communication.
  • Google meetings/Zoom for client communication.
img
Technologies
  • Language: Python.
  • Framework: Django REST Framework.
  • Database: Azure SQL, SQLite3.
  • Libraries: Pandas, Numpy, Azure Storage Blob.
  • Cloud: Azure.
img
Project Management Tools
  • JIRA- Task tracking and sprint plans.
  • Github- version control.
  • Confluence- Documents management.
img
img
Outcome

Solutions Offered

Result

Business Impact

Understa

img

Understanding the data at ground level

Allowing the client to access first-hand, real-time data, our solutions helped the client to extract valuable insights from a complex system.

Identify

img

Identifying potential sales channels

Understanding the data empowers our client to stay informed on various grounds and enables them to access untapped markets and highly potential sales channels.

Betters

img

Better supply-demand sync

As our client manufactures their own line of products, our data solutions help them understand the dynamic market and prepare for future demands accordingly.

Join us on a free webinar on EdTech happening on August 17th, 2022 at 4:30 PM GST. Register now!