Microsoft data analysis made easy
Pros
- Easy to set up on a windows system and integrate to network drives for data integration.
- Allows easy authenticated user access to the tool to send jobs (one less user/pw on a domain).
- Easy to integrate to other windows applications that are installed beside the software on the same system and on other windows remote systems.
- Relatively low issues in the configuration phase to enable data processing.
Cons
- It is not fully featured vs linux open source versions out there.
- It is not as easy to find (or as much) online documentation when having issues with the software.
- Use of this tool alongside WSL applications is still too early. Once WSL gets more general use then this will be a better tool.
Return on Investment
- We took the learnings of this product and used it towards our replaced platform so no real lost investment. Just time was lost during the project when trying to integrate and use this along side our other ETL tools.
- This did allow us to identify other improvements (not realized before the project) to data analysis during the way that we have continued to leverage post project migration.

