Company Name:
Adhesive manufacturing company
ERP: Navision
Industry: Chemical
The organization is an ultra-modern plant in manufacturing comprehensive range of laminating adhesives which includes comprehensive range of high performance and innovative products.
They value the importance of timely delivery and have stock points all over India as well as in Vietnam, Singapore, Dubai, Kenya for customized solutions to meet individual customer needs.
The supply and logistics system is tailored to ensure seamless service.
- Preparing timely daily / monthly / quarterly / yearly MIS & Reporting across different departments was a major challenge. Eg. Key reports like Vehicle Tracking status, Stock Report (monthly), Sales, Finance and GST Inward, GST outward file format.
- Excess Effort, time and cost involved, manual intervention and data redundancy were a few other challenges leading to delayed and incorrect decision making.
- Management was thus looking for reliable, simple and on-time report developing tool, they could trust.
- Report included operational excellence which was worked upon in Excel, along with dashboard and KPI reports. And required solution to cater to both the needs.
- They runs on Microsoft Navision ERP. Additionally, there are other data sources in flat files. MyReport helped in data extraction from all these sources, along with massaging and data consolidation.
- A SQL Data warehouse was configured considering the reporting requirement across different departments like Inventory, Sales, Finance, etc. This data warehouse serves as a common data lake for preparing Excel and Web dashboard Reports.
- The data warehouse is auto updated using inbuilt ETL (Extract – Transform – Load) functionality of the tool on a periodic time and frequency.
- Operational MIS, Tabular reports were built through MyReport’s Excel Add In and management dashboard which gave a snapshot of the departmental and overall organization performance were created on Web dashboard accessible anytime-anywhere on mobiles or tablets.
- Achieved end to end report automation. A lot of time & effort was saved, resulting into a better and productive MIS.
- All the data redundancies, duplication, manual errors were eliminated, thus enhancing the report accuracy, correctness, in turn into improved decision making.
- The organization utilizing the tool to its fullest, across different departments, leading to a faster ROI.
- All in all now it has become a Data Driven organization taking smarter decisions using this efficient analytics and reporting platform.