endorsedCompleted

Retail BI & Analytics: Forecasting, Inventory Optimization & Power BI

Services Covered:

Big Data Analytics and Business Intelligence • Data Engineering • Cloud Consulting and Services

Industry

E-commerce & Retail

Duration

5 months

Budget

50K - 199K

Start Date

1 August 2019

Team Size

Confidential

Engagement Model

Nearshore

Project Capability Score (PCS)

70/100

Good

Project Capability Score (PCS) estimates how capable NeenOpal Inc. is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS

Client

Confidential

Colombo, Sri Lanka

Project Summary

NeenOpal provided BI and analytics services for a consumer-durables retail company in Sri Lanka, delivering forecasting, inventory optimization, route optimization, marketing-mix modeling and Power BI reporting. They implemented sales forecasting for top categories, inventory and transport optimization, and set up cloud infrastructure and dashboards. The engagement resulted in optimized inventory and increased sales, and the client praised the team's professionalism, knowledge and collaboration.

Key Challenges

Forecasting for top product categories
Inventory optimization across stores and warehouses
Route and transport optimization
Marketing-mix modeling to understand marketing contribution and optimize spend
Delivering Power BI reporting and a scalable cloud-based analytics infrastructure
Implementing analytics solutions and providing learning/support to improve sales & distribution and an advanced analytics roadmap

Project Deliverables

Formulation of sales forecasting for top twenty categories
Inventory optimization for store locations and warehouses
Transport optimization algorithms for warehouses and stores
Marketing mix modeling (MMM)
Power BI dashboards
Robust cloud infrastructure for sales, inventory, service, finance, logistics, supply chain and customer loyalty

Project Solution

The vendor formulated sales-forecasting models for the top twenty categories, built inventory-optimization models for stores and warehouses, and developed transport-optimization algorithms. They performed marketing-mix modeling to quantify marketing contributions and optimize spend. NeenOpal developed Power BI dashboards and set up a robust cloud infrastructure covering sales, inventory, service, finance, logistics, supply chain and customer loyalty; the delivery team included a project manager, data scientists, a data-warehouse architect, Power BI expert and ETL developer.

Project Outcome

Increase of sales due to inventory optimization at store locations
Very good understanding and workflow between client and vendor teams
High client satisfaction and partner involvement contributed to project success

Platforms

SaaS
Cloud

Tech Stack

Power BI

Client Endorsement

Overall Review Rating

4.5

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“The engagement resulted in an optimized inventory and increased sales, meeting the expectations of the internal team. NeenOpal Intelligent Solutions is understanding and invests heavily in the project at hand. The team is hard-working, professional, and skilled.”
Kapila Perera
IT Director
Date: 03/07/2020