Sisense > Case Studies > Footwear Importer Saves 20 Hours Per Month on Report Generation

Footwear Importer Saves 20 Hours Per Month on Report Generation

Customer Company Size

Large Corporate

Region

America

Country

United States

Product

Sisense

Tech Stack

ERP System
Excel

Implementation Scale

Enterprise-wide Deployment

Impact Metrics

Productivity Improvements
Customer Satisfaction
Employee Satisfaction

Technology Category

Application Infrastructure & Middleware - Data Visualization
Analytics & Modeling - Predictive Analytics
Application Infrastructure & Middleware - Data Exchange & Integration

Applicable Industries

Retail
Consumer Goods

Applicable Functions

Business Operation
Sales & Marketing
Warehouse & Inventory Management

Use Cases

Inventory Management

Services

System Integration
Training

About The Customer

Founded in 1954, ES Originals is one of the longest surviving footwear importers in the US, pioneering imports from Asia. The company has a long history and has evolved its systems over time to meet various requirements. ES Originals operates a homegrown ERP system and deals with a large volume of reports, which has become a logistical challenge. The company brought in Software Analyst Ahuva Shabtai to address these issues and improve their reporting processes. ES Originals is a large organization with over 1,000 employees, and it operates in the retail and consumer goods industries.

The Challenge

ES Originals faced significant issues with disparate and disconnected data, with nearly 1000 reports running against their ERP system. This led to logistical challenges, as reports were static and required new reports for any additional fields or selection criteria. The company needed a unified and standardized reporting system to streamline the process and reduce the number of reports. Additionally, salespeople had to bring hard copies of reports to client sites due to unreliable internet connections, and data from partners came in different formats, complicating the reporting process.

The Solution

Ahuva Shabtai leveraged Sisense, a BI tool that ES Originals already owned but had not deployed, to address the reporting challenges. She conducted an audit of the existing reports, identifying nearly 1000 reports and analyzing how many could be combined with filtering options. She also addressed the issue of data ingestion from partners by standardizing the data formats. Ahuva worked closely with internal IT staff and utilized Sisense support and training materials to implement the solution. She focused on creating graphic representations of data and ensuring that everyone was reading from a single source of truth. This involved addressing discrepancies in reports and identifying unused or outdated reports. The implementation also included adding timing to inventory reports, allowing users to see current and future availability based on procurement information.

Operational Impact

The implementation of Sisense resulted in a significant reduction in the number of reports, streamlining the reporting process.
Salespeople no longer need to bring hard copies of reports to client sites, as they can now access standardized reports with reliable data.
The addition of graphic representations and drill-down tables has improved data visualization and made it easier for users to understand the information.
The standardization of data ingestion from partners has improved the accuracy and consistency of the reports.
The overall stress on employees has been reduced, as they no longer need to manually collect and manipulate data for reports.

Quantitative Benefit

Admins that run one of six core business reports have saved 20 hours per month in report generation.
Prior to Sisense, ES had 1600 reports from each division that had to be filtered and examined as text.