אניפיט - פתרונות מידע בהתאמה

                                                         
Question: How can data mining and analysis procedures be improved?

 Answer: Automation of manual repetative work 

Approach: Solution development in excel using extended built-in functionalities and customized features in VBA

Hundreds and thousands of hours of sisyphean work are invested by experienced analysts, financial experts, logistics and procurement professionals, engineers, researchers and many others. The purpose of the analysis is, eventually, to refine meaningful information from vast quantity and quality of data. Usually, analysis efforts require 10% of working time for "lite" users and can reach more than 50% for heavy users. Significant part of data mining procedures are carried out in excel.

However, many powerful functionalities of excel are not utilized. This fact causes to intensive manual work and is exposed to inaccurate results.

In that case, customized solution executed by experienced developer, can bridge the gaps to desirable process. The automation on-click solutions are agile, affordable and provide fast ROI (few days to few months).

                                                          
Example: Data analysis from ERP system

Time: 3 hours weekly of manual work

Automation: Import external data file and automatic analysis procedures

Result: 3 minutes per week

Savings: 12 hours per month, 144 hours per year

ROI: 1 month
                                                       

1) Filtering relevant ERP items according to warehouse and available quantity
2) Erasing irrelevant item lines according to exceptions lists
3) Adding 7 calculated columns to indicate inventory parameters
4) Updating periodical charts tables with new data
5) Adapting charts periods
6) Exporting charts to PowerPoint
7) Sending Outlook emails with attached presentation

Summary:
3 hours weekly, activating 3 different  office application

Automation: