Devart Excel Add-ins vs. Phocas Business Intelligence

Devart Excel Add-ins is really good for data comparison of one database table against another database table. There are plenty of times where the business users need help understanding with their Power BI data models are not connecting correctly and I use this tool to break down the differences between the tables they are trying to connect.

Incentivized

If you would like your data in one place with easy access, this is the software for you. You can have data from multiple systems and bring it into one view so that you have a quick and easily visible dashboard for the data you wish to see.

Incentivized

• Devart Excel Add-in supports connectivity with various databases - which really helps to customize and massage data.
• Since data is available in cloud, it is easily accessible everywhere.
• It can also be integrated with SSIS components making it possible to resolve complex problems.

Incentivized

• Custom reports are simple to create.
• The ability to manage users and their dashboards is solid.
• Easy to navigate web interface makes the software accessible from anywhere.

Incentivized

• The data pump feature breaks sometimes
• The profile usage monitoring is slow
• The event profiler is delayed

Incentivized

• Phocas needs to make it easier to connect to different types of databases.
• The data in Phocas needs to be updated faster in some cases.
• It needs to provide functions to create better charts and graphs.

Incentivized

It is a very user-friendly product and is easy to understand. You can get your data from just a quick click and the dashboard loads. You can take the data and drill down easy to find what you are looking for.

Incentivized

Support is responsive. You log a call and they will respond quickly and resolve your issues. We have only had great experiences with the support team.

Incentivized

Devart Excel stacks up very well against its alternatives. It has significant advantages as it keeps getting an update. Features are very much suitable for smaller organizations. For larger organizations the features cannot be used directly because of the size of the company and more native requirements of IT software requirements.

Incentivized

Phocas is easy to use for end users and can be used on desktops, laptops, and phones.

Incentivized

• The data compare option saves our dev team a lot of time
• The documenter feature is nice to use for explaining table definitions
• The event profiler is great for usage metrics

Incentivized

• It has given our business a view on data
• We can access it from anywhere
• You can have multiple dashboards for different information

Incentivized