Success Story-2

Data Analysis and Visualization

We helped a Consulting Co. to analyze their client’s inventory data to unlock working capital and maximize sales.

Client Background

Our client is a US-based Consulting firm dealing with a Retail client trying to assess the future supply chain that meets the needs of the growing and changing business scenario

Business Need

With inventory data from over 100 warehouses for 5,000+ SKUs, the client required a team to manage data analysis so that the consultants can save time. They can directly analyze trends and generate insights. This would help them to increase their clients’ inventory productivity and reduce out-of-stock occurrences

What We Did

Committed Services Delivered To The Client

Defined scope and data request template for cleaning and aggregation
Verified and filled gaps in the data shared by client/ vendor
Cleaned inventory data leveraging Alteryx and Python and analyzed and aggregated client’s inventory management metrics including:
- Inventory turns: Sector/ Category
- Distribution/ warehousing costs
- Availability in % of active articles: Warehouse vs. Store
Developed a Power BI dashboard to represent these KPIs using various graphs, charts and filters

Value-Added Services Delivered To The Client

Collaborated with the consultant to provide preliminary findings from the analysis

Benefits/ Outcomes:

For GoIGNIS Circle

Scaled up team by 3x through high-quality output delivery

For clients

60% cost reduction; extended to 6-member team in low-cost region with high analytical capabilities
Reduced 50% project turnaround
Supported execution of parallel workstreams