Leveraging data to achieve

multi-contextual metrics

for a retail electronics company!

img
Client Location

India

img
Client Industry

Electronic/Retail

img
Services Provided

Data infused business model & Visualization system

img
Technologies Used

Power BI, MS SQL Server, ETL, Azure Synapse, Azure Cloud

img
Allocated Team Size

6
Engineers

img
Project duration

28 Weeks

Client

Client Background

Changing the retail scene in the market, our client is a renowned electronics retailer with multiple branches and hubs across the country. Known for providing excellent in-shop experience and flexible financing options among their consumers, our client has a vast base of loyal brand advocates. Right from basic to flagship electronics, their inventory is stocked with fast-moving products across different categories.

Requirement

With multiple branches and storage units, our client faced problems with efficient resource accumulation. So, our client needed a central data system that could monitor the footprints of different electronics products across various regions.

img img
Problems

Business Challenges

01.

Identifying the categories of the products is tedious as there are a vast number of products in the inventory.

02.

To monitor the movement of the products, they need to be tagged and numbered in a solid, fool-proof manner including RFID tags.

03.

The success of the product's sales depends heavily on the region and the social & economic capabilities of the people in that region.

04.

If the data system is too complex, employees wouldn't be motivated to use the system.

img img
Methodologies

Our approach

We collected data from various dimensions for the following factors. These data are then analyzed for efficient resource handling.

img
Our Team

Team Structure

We handpicked the team members that are best suited for the project. Also, their ability to understand different contexts and problem-solving complemented their proficiency in tools and technologies that were necessary for the project.

img2

Data Analyst

img1

Cloud Architect

img1

Quality Analyst

img2

Backend Developer

img1

Projects Manager

img1

Front End Developer

img
Tech Stack

Tools and Technologies

img
Communication Tools:
  • Slack for internal communication.
  • Google meetings/Zoom for client communication.
img
Technologies
  • Power BI
  • MS SQL Server
  • ETL
  • Azure Synapse
  • Azure Cloud
img
Project Management Tools
  • JIRA- Task tracking and sprint plans.
  • Github- version control.
  • Confluence- Documents management.
img
img
Outcome

Solutions Offered

Result

Business Impact

Increase

img

Increased the overall sales

The sales across the weakly-performing branches shot up by 300% and registered positive customer experience.

Identify

img

Identify key performing employees.

Our analytics system helped the client identify the star performers in individual branches and across all their outlets. Incentivizing the employees also motivated them and increased their productivity by 60%.

Adeeper

img

A deeper understanding of the supply chain

The master data allows the client to monitor the overall product flow. Seasonal sales, annual sales, demand spike, etc., could be easily tackled as the system allowed for a better understanding of the supply chain.

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