See how analysts deal with offline analyses after retrieving data from databases.
Let’s be friends:
Comment (0)
Join the DZone community and get the full member experience.
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.
