Source system: multiple installation of Tally ERP 9.1.
Problem : The end client desired to have a custom installation of Turbo data based on the unique requirements of its business. The product shall be used for designing a custom web interface for customer interaction.
The key tenets of the solution that differed from the standard deployment of turbo data were as follows:
- Standard price list instead of weighted average or FIFO pricelist.
- Closing stock value was to be calculated at a godown and item level.
- The solution was to work across multiple locations seamlessly with maximum RAM usage been 1 GB for both initial and incremental data loads.
- Custom masters extraction for item, stock group, category .
- GST classification to be extracted for the end client.
Time duration of the project: 2 weeks.
Approach of the ETL team:
- Choosing the appropriate set of attributes to be loaded based on the modular approach. That is the required fields to be loaded for ledger and inventory were chosen.
- Custom extraction for the tables: The process of normalization helped in the same since the attribute is to be loaded only once.
- Testing of initial and incremental data loads in terms of time and load on the system. The incremental data load process helped at reducing the time of data load.
- Data cleansing: special characters were removed from the item names. Also separation of the numeric values from the character fields
- Data consolidation: multiple types of voucher types were loaded onto the data warehouse.
Project has been done successfully. Hereafter the end client shall go for a MVC interface over the data warehouse for reporting and customer interaction purposes.
For any queries/help in Data Analytics, consulting, Data consolidation kindly refer our service partner- www.mnnbi.com