Adobe Commerce Intelligence (formerly Magento BI) is an ecommerce analytics solution that provides data pipeline, warehouse and visualization capabilities. It was acquired by Magento, and is now owned and supported by Adobe.
N/A
Altair Monarch
Score 8.0 out of 10
N/A
Altair Monarch (formerly Datawatch Monarch, acquired by Altair in December, 2018) works with both relational and multi-structured data including support for a wide range of formats including PDF, XML, HTML, text, spool and ASCII files. The product can access data from invoices, sales reports, balance sheets, customer lists, inventory, logs and more. According to the vendor, the system is easy to use, allowing users to quickly select any data source and automatically convert it into…
N/A
Toad Data Point
Score 8.0 out of 10
N/A
Toad Data Point is a cross-platform, self-service, data-integration tool that simplifies data access, preparation and provisioning. It provides data connectivity and desktop data integration, and with the Workbook interface for business users, it provides simple-to-use visual query building and workflow automation.
A company or organization that is in contact with the customer and wants to examine customer behavior in the purchase and selection of products and services should use this platform. It does not matter how many advertising tools and referral links or social media campaigns you use to attract customers. In any case, Magento BI integrates all the information and DB as a single platform and provides you with the best reports. Potential customers can be positioned according to location, city, country. Now we know exactly which product is most popular and where to put our advertising costs on which site or social network has the most audience.
The product is especially useful when you have real-time and/or time series data to analyze. If you have more mundane, simpler requirements, other products might do the job you need for less money (there are even some decent open source visualization tools you can find.) I know the product is very widely used in capital markets applications to monitor and analyze risk and price and volume changes; if you're working in that area, I don't think there's a better tool to use.
Appropriate for general querying and some DBA work. It's the universal least-offensive solution for most environments - not best of breed, but not subject to unusual/extensive requirements. It just works. On the other hand, some functionality (e.g. data import/export, snippets) are perfunctory and minimal and seem to be either difficult or impossible to automate. If you need to streamline those operations, you'll be forced to rely on third-party solutions that mostly work on top of (instead of with) TOAD.
It is relatively easy to manipulate the time period in which you want to see your report. This is important for our business because we are constantly analyzing sales month over month, quarter over quarter, and year over year. RJ makes it easy to toggle between these time ranges on the same report.
The visualizers available for reports are what you would expect out of a product like this. You have the ability to view your results in tables and a multitude of charts.
The ability to customize dashboards and rearrange reports quickly is great and intuitive!
Creating a basic model to extract data from a report is very easy.
Advanced features like Calculated Fields and External Lookups allow you to augment the raw data.
You can create a "project" to automate the data extraction. Combined with Datapump (a separate DW app), you can fully automate the process once the raw report is generated.
Educational videos and tutorials must be more simpler and more understandable language with subtitles
There should be the ability to select graphic diagrams with different shapes and graphs
The basic features of the Essential Paln can be increased with the current price so that startup companies can better use the features of this platform.
Recently, we had some major sticker-shock when we wanted to upgrade Data Pump. It is an exceptional product, but when the price jumped from $6,000 to over $60,000, it was impossible to get the funds approved internally for the upgrade.
We also paid for yearly maintenance contracts which included Professional Services, but rarely found those services beneficial. However, we did receive all software upgrades for Datapump as part of the contract which we found to be very beneficial. However, with the new pricing, that is not longer the case.
The workflow is a relatively new feature. Quest is adding additional functionality and the workflows are useful now.
Would be nice if the 'Automate' feature was a bit easier to use.
Would be nice if some of the SQL Editor features in the traditional interface worked better in the new workflow interface (although, these are being fixed with each release).
In addition to its features, it has made the Magento Commerce platform much better, more functional, and smarter, and through Magento BI dashboard they know very well what reports have been sent and all our business tools are summarized in one business platform. The ability to share report results is very popular and useful, and you can share content with anyone anywhere in the world.
I find Toad Data Point easy to use for both the novice and the experienced business analyst. If all you desire is to access data and create spreadsheets...this is a snap. Toad Data Point actually has cool data analysis features built into it. The newer workflow interface makes automating steps a snap
The very strong and knowledgeable support team and great help forums and documents, any questions and cases will be answered immediately or checked through tickets and resolved quickly. It is also possible to send comments and changes. Or our team , fast response and after-sales cooperation of the service company is always more than the product itself and its quality, and we want the service and support to support our interests.
The advantage of Magento BI is easier compatibility and adaptation with Adobe platforms and easier installation, configuration and customization with Mojto Store Builder and its various caskets, and I am very satisfied with it now and in every way I think it is a very good platform for integration in reporting.
Datawatch is very good value of money compared to QlikView; QlikView is really more of a BI tool and has a lot of functions that I didn't need. Datawatch is very strong in the real-time area where Tableau, Panorama, and Qlik don't do very well. If you need to set up a visual monitoring dashboard, Datawatch is the best product I've seen for that. if you want to do a lot of in depth statistical analysis of large databases, Tableau is probably a good option.
It is the least common denominator - not particularly optimized for our environment or workflows.
Hangs or slowdowns add anywhere from 5% - 7% for projects utilizing large/complicated data setts. (This could be due to other IT-imposed constraints and not entirely due to TOAD.)
Trying to perform some operations requires reading documentation and experimenting in order to figure out the TOAD-specific approaches and commands.
It just works (when we understand it). Updates don't break things and things don't suddenly start behaving differently. Best of all, we don't mysteriously lose functionality.
