Because of the lack of support of easy-to-use tools, the offline analysis of data analysts is always performed first by a written complex query or data exported from a temporary table after multi-step processing, and then by using vlookup() and filters in Excel. When the data is updated or the scope is expanded, it is necessary to retrieve the data again and operate in Excel again. If there is a desktop tool that can read single table data in real-time, it can not only complete the above complex query and the calculation from multi-step processing to a temporary table, but also replace the calculation action in Excel, and avoid repeated labor, it will be good news for many data analysts.
If you can write SQL or VBA, you are very concerned about the flexibility of multiple calculations after obtaining data, rather than using a graphical interface tool to complete limited calculations, and you don’t want to spend a lot of time to learn python, esProc may be a good choice.
from DZone.com Feed https://ift.tt/2XEusU2
No comments:
Post a Comment