Business Intelligence Tool to streamline inventory management collaboration in the retail industry
Cloud-based business intelligence tool, designed specifically for the retail industry to assist retailers and their suppliers to collaborate around point of sales scan data.
With a wealth of experience in analytics, and a commitment to openness in developing IT infrastructure and tools, along with strong global BI deployment capabilities, NTT DATA can help you unlock the business value from your Big Data.
- SERVICES
- Big Data, BI and Analytics
- COUNTRY
- Australia
Benefits
Better Utilisation
Benefits
Higher Sell-through
Benefits
Streamlined Processes
Abstract
The client’s product is a simple to use, cloud-based business intelligence tool, designed specifically for the retail industry to assist retailers and their suppliers to collaborate around point of sales scan data.
Challenges
- Develop a SaaS (Software as a Service) based BI and Analytics product for managing retail supply chain to help key stakeholders in making business decisions for establishing equilibrium between demand and supply of the articles.
- Architecture needed to support multi-tenancy, multiple file formats, data formats from different retailers
- Source system issues, pre-validations and post-validations on the data
- Application level security and performance tuning
Technology
- Microsoft SQL Server
- Microsoft SSIS
- Microsoft SSRS
- Microsoft Analysis Services
- MS .Net Framework
- Devexpress
Solution
- End-to-end product development for the solution (initiation to implementation), having regard to the features below
- SaaS based BI and Analytics application
- Generic, scalable, secure, configurable, high usability …..etc..
- Set of dashboards/minis to give the high level view to top management
- Canned reports for normal users
- Reports with drill-down and drill-through for advanced users
- Ad-hoc query and reporting for analyst and planners
- Statistical analytics and geo-analytics for planners and business analyst
- Providing ongoing post deployment support to client’s customers (80 customers) and also enhancing the product with the new features and functionalities
Results
- Higher sell through, reduced stock outs
- Visibility at the granular level (by store and SKU level) of business
- Helps in building transparency and trust in aligning supply chain objectives
- Better utilisation of internal resources
- Streamlined processes and operational efficiency gains
- Offshore support and development - high cost benefit
- 100+ tenants on the product