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. In this blog we will discuss, the Metro Dairy’s Journey from Manual Reports to BI Automation.
“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 provided Metro Dairy with a Data Upload application that transferred their sales data to SQL Server, allowing them to view and monitor it through the 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
This is the transition of Metro Dairy’s Journey from Manual Reports to BI Automation. With EasyReports BI, Metro Dairy can now focus on growth and performance optimization rather than spending hours on data consolidation and report creation. This success story highlights how BI solutions can revolutionize reporting processes for businesses of all sizes.
For more visit our website www.easyreports.in