July 23, 2019
CUSTOMER OVERVIEW
Metro Diary was set up as India’s first joint sector dairy project with the Government of West Bengal and NDBB under Operation Flood Phase III in 1996. It is presently a 100% owned subsidiary of Keventer Agro Ltd.
“Metro” brand of milk is one of the top 3 Pasteurized Milk Brands in Kolkata market.
Constraints Faced by them:
- Metro Dairy Limited used to make reports manually which was a long time taking process
- Manual reporting is prone to human errors and proper data availability is the need of the hour
- Accumulation of data from different sources is a time consuming process and requires more than one person to consolidate the data for reporting purpose
- The data source at Metro Dairy is maintained at different ends, and had to reorganize the data source by storing all the historical data into a centralized database
- The requirements of Metro Dairy Limited have been listed below;
- Sales Reports
- Tracking of Yearly, Quarterly, Monthly, Weekly and Daily Sales Performance
- Route Wise Sales Performance
- Analysis of Achievers and Laggards
- Automated delivery of scheduled reports
- Dashboards providing visibility of reports
- Tracking of Salesperson’s Performance
- Tracking of Performance in terms of Route
Solutions by EasyReports:
EasyReports helped Metro Dairy to reorganize their Sales data by providing an application for Data Upload which transferred their sales data in SQL Server which can later be viewed and monitored from EasyReports BI application. Using a mix of SQL Server Database Engine and SQL Server Analysis Services, we generate the reports faster than before along with complete accuracy.
Reports Delivered:
We delivered the following key reports;
- Gross Sales Volume (SKU wise) (Today vs MTD vs AOP (MTH))
- Route – Wise Volume (Today vs MTD vs AOP (MTH))
- Route – Wise SKU Breakup of Sales (MTD vs AOP)
- Routh Health (%age of Distributors) Sales >=AOP TGT – MTD Basis
- Route Wise Achiever List
- Route Wise Laggards List
- Date Wise Monthly Sales
- Route and Zone Wise Weekly Sales Analysis
- Date Wise Sales Analysis
- Sales Register
- Sales Register 3 years Analysis
Dashboards Delivered:
We delivered the following key dashboards;
- Daily Sales Performance Dashboard
- Monthly Wise Yearly Sales
- Route Wise SKU
Benefits of using EasyReports BI:
Following are the benefits of using EasyReports BI;
- Reduces Manual Error
- Reduces Manpower
- Accurate Insight
- Reports availability on time
- Automates the process of report making
- Faster execution of reports
- Holistic Dashboards
- Centralize Data
- Report Scheduler to automate your Report Delivery