Coming October 25: PeerSpot Awards will be announced! Learn more
Ariel Lindenfeld - PeerSpot reviewer
Director of Content at PeerSpot (formerly IT Central Station)
  • 161
  • 550

When evaluating Business Intelligence Tools, what aspect do you think is the most important to look for?

Let the community know what you think. Share your opinions now!

PeerSpot user
167 Answers
PeerSpot user
Executive Vice President at a tech vendor with 51-200 employees
10 December 15

Total cost of ownership is often overlooked during BI product selection. Cheap products do not equal cheap ownership experiences, whether it is missing functionality which must be provided by additional products, poor integration of modules which causes duplication of effort, weak support from the vendor, high cost of maintenance or constant changes to the product portfolio.

The key factors to consider are:

Is this product right for the intended user-base? It should not be necessary to purchase one product for IT, one for business analysts and one for 'end-users'. There are considerable cost savings associated with using a single platform (not a single vendor with many products they have built or bought).

Does the product have the depth of functionality needed, and foreseeably anticipated?
Is that functionality accessible? Can an expert easily access complex, deep functionality, without the occasional or new user being overwhelmed by the interface?

Can it reach all the necessary data sources? Both inside and outside the corporation.

How fast is the user experience, both in developing reports and dashboards and in retrieving the data? Speed of both allows iterative learning and development by new and occasional users, while ensuring high productivity for expert users.

Does it work with our real world data? Too often evaluation of products still relies on superficial test on restricted volumes of data, or the lower complexity data as "it would take too long to build a fully representative testing environment" - big mistake. Identify the product(s) you believe are suitable and then bear the cost of proving they can deliver in your own use case. Too often a poor acquisition is followed by increasing spend to "make it work", when money spent earlier on selecting and proving the right tool would lead to much lower overall cost of ownership and more importantly early success and hence ROI.

Does the company have a history of good backward compatibility? You will build a vast amount of intellectual property with a BI tool. You will become dependent on the insight it provides your organization. So investigate how well you chosen product has allowed users to migrate that IP forward through new revisions of their products. Rewriting IP is a good opportunity to clean it up and start over, but it's a massive unnecessary expense if you have built what you need and it is the vendor forcing you to rewrite your work.

it_user738690 - PeerSpot reviewer
Gestor de Capacidad at a logistics company with 10,001+ employees
Real User
04 January 18

It is really difficult to choose the right one, in my experience, the most important thing is not the tool that we choose. The most important thing is to design the correct scope, what we need to give us the tool based on two factors, the data we want to obtain and for whom that data will be. If a good approach is made, the chosen one will be the correct one.

Mark Selinger - PeerSpot reviewer
SVP Operations at Exago Inc.
27 July 17

Use case! What and or for whom are you trying to provide reporting capabilities to and from what applications and data sources. What are the skill levels of these users - basic business users or analysts. Ease of use should be top of the list as well as a quality customer support experience.

There are many choices today around BI solutions (embedded, self-service, etc.) and finding the right one depends upon answering these questions.

PeerSpot user
Info Sec Consultant at Size 41 Digital
Real User
Top 5
29 June 16

Easy to use, performs well, cost, and not going to send me insane integrating it with other systems. Everything else is gravy.

PeerSpot user
Director of BI / Solution Architect at a tech vendor with 51-200 employees
Real User
07 August 14

Key Evaluation Points for BI Tools:
1) Ease of use – Self-service analytics and data exploration, End-user report consumption and Time to develop new reports
2) User Interface and Visualization effectiveness – If it does not look good business will not use it
3) Styles of BI Supported – Scorecards Dashboards, Operational Reports, OLAP Reporting, Predictive Analysis, Notification and Alerting
4) License/TCO – Open Source vs Enterprise Software – support and maintenance structure – development and administration costs, environment deployment constraints, admin tools
5) Performance and data scalability – Depends on the business requirements and data volume
6) Data source connectivity – Depends on the source systems that need to be integrated and backend data integration
7) Security – Authentication, Authorization, Application, Object and Data level security
8) Extensibility and API/SDK – If integration with external applications is required
9) Feature Set/Product Roadmap – scope of product features, speed of platform innovation

08 June 14

Most folks tend to think of UI and the flashy, sexy stuff. However, experience has proven that adopting a platform approach is key to success - a Platform that can access any data source and provide capabilities for internal and external users from the same platform, and not merely serve as a data visualization tool. The ability to do disconnected analytics cannot be discounted; Further having a platform that does NOT mandate creating a data warehouse as a prerequisite; i.e. It shoild have the ability to access operational data sources with minimal impact to the back-end systems.

Find out what your peers are saying about Microsoft, Tableau, SAP and others in BI (Business Intelligence) Tools. Updated: September 2022.
634,775 professionals have used our research since 2012.
it_user17526 - PeerSpot reviewer
Manager, Business Intelligence at a consumer goods company with 1,001-5,000 employees
Real User
23 May 14

I believe you have to match product capabilities to company BI strategy first and then consider infrastructure standards and internal competencies. if you do these things you should get value. The type of BI solution is important but don't be fooled by the "it's all about data visualization or big data". it is not in most organizations...

Alberto Guisande - PeerSpot reviewer
Director at Decision Science
Real User
Top 5Leaderboard
06 March 18

"Time to insight" is very important for me. Since the business questions arise non stop and need fast responses, going from raw data to answer a business question in the lesser time possible, with the easiest way of doing that, could be a huge differential in selecting a tool (set of tools).

PeerSpot user
Business Intelligence Data Analyst at a financial services firm with 201-500 employees
28 September 17

User Friendly, Customization, Pricing

VishalGuthula - PeerSpot reviewer
Sr. Software Engineer at a tech company with 501-1,000 employees
10 April 16

1. Meet business needs
2.Total cost of ownership
3. Performance
4. Stability
5. Scalability
6. Easy to use/build reports/administration
7. Functionality/Visualization
8. Mobility
Along with
9. User friendly
10. Security
11. Method of implementation

PeerSpot user
Director of Enterprise Sales at Tableau Software
22 February 16

1) Organic Adoption
2) IT involvement in only data prep/mgt. not having to build anything
3) true Self Reliance not endless self service report runs

PeerSpot user
OBIEE Technical Consultant at a manufacturing company with 1,001-5,000 employees
12 August 15

In the following order :

Licensing Cost
Ease of Use for End User
Functional Capabilities

PeerSpot user
MSBI Technical Lead at Mindtree
11 August 15

1. First and foremost. Gather the detailed BI requirement from Organization needs. Answer the below questions,
a. How much GB (memory size) is required to hold / maintain organization data?
b. How much the data is going to increase by months and years?
c. How many BI users (Analyst) are going to use BI system?
d. How Critical would the BI system would be for End users?
e. What are the reporting requirements from End users? do they need simple report, visualized reports, Self service BI requirements
f. What is the Budget to build BI?
g. Is management ok to have Cloud BI?
........... like this much more information
Based on this above needs selection of BI would vary.

Typical BI tools features

1. Core BI features
DB Engine, Master Data Management, Data Quality Management, Scaleability, Performance, Hardware and Software Maintenance, Replication requirements
2. Additional features such as reporting, sharing, collaboration, visualization, etc
3. Ease of use (installation, operations, learning, etc)
4. User friendly design environment and run time environment
5. Customized Security features
6. Product Stability and Consistency
7. Good Product Support available
8. Ability to merge / mingle with Social Media.
9. Cost not significantly high/low with competitor products
10. High Productivity to develop and deploy
11. Forum / open support guidance availability

I see these are the basic BI selection criteria.

PeerSpot user
Data Group Developer at a pharma/biotech company with 501-1,000 employees
23 July 15

Security integration. My existing application already has a list of users and what products they have access to. Allow me to push this assignment to the BI tool or have the BI tool call out for access to a dimension. Don't make me duplicate permissions.
Ease of setting up the metadata layer (I would like to be able to manipulate it programmatically / via scripts)
Make it appear to be part of the existing application. No separate logon, run headless or allow significant LnF changes.
Licensing to match my usage not my hardware.

PeerSpot user
Solution Advisor | Business Analytics at SAP
Real User
07 July 15

Most important it is to support all End-User needs; Analyst, Management, Operational

PeerSpot user
04 July 14

The success or failure of any BI project depends on collecting and prioritizing Business requirements and must include the following:

1. A targeted business process

2. How BI can improve the process

3. When BI will be used

4. What kind of BI is needed

5. Who will use it

6. How improvements will be measured

In most cases, BI investments need to address:

Better alignment of BI with business strategy
Improved data quality
Better integration of BI systems with other systems, such as CRM or ERP
Better understanding of user needs and requirements
Improved user training
Brainstorm ideas - on how BI can be used
Identifying business questions - gaining more detail on requirements and information needed

PeerSpot user
Head of Management IS at a non-tech company
31 May 14

The most important criteria for me would be it's ease of use for non-technical users. If you have to use data analysts to develop all the reports then keep looking.

PeerSpot user
Senior Project Manager at a tech services company
15 April 14

Performance and Scalability. Ease of use goes without saying.

Alejandro Moscoso - PeerSpot reviewer
General Surgeon at a healthcare company with 51-200 employees
Real User
Top 5Leaderboard
21 February 20

Afordable for the company. Capacity of training. Solutions for needs

Justin Trollip - PeerSpot reviewer
Founder at a tech services company with 1-10 employees
Real User
19 September 18

For us it normally comes down to a combination of the following:
1. Cost of implementation
2. Ease of use
3 Vendor lock in or does it use shared technology

Kah WengLim - PeerSpot reviewer
Presales at a tech vendor with 1,001-5,000 employees
Real User
09 April 18

1. Cost of implementation & Licensing Price
2. Ease of use and drill down function
3. Ease to change the source of data, as data information is keep increasing
4. Can link to multiple datasource like mssql, MySQL, excel, csv.....
5. Speed of data present BI & Drill down
6. User access rights, since not all information should be publish to all level of people

Issa Ibrahim Taiwo - PeerSpot reviewer
Avaya Support Engineer at Simba Group
Real User
04 January 18

will the solution solve my present,past,and future problem. how about support should incase of downtime. performance and scalability

Chandra Bhanu Nayak - PeerSpot reviewer
Manager SAP at a non-tech company with 10,001+ employees
Real User
03 January 18

01> Fulfill the business requirements
02> Cost of the Implementation.
03> User friendly, ease to use
04> Real time Dashboard
05> Performance & Scalability
06> Troubleshooting and Support

Anwar Hossain - PeerSpot reviewer
Network Engineer at a tech services company with 51-200 employees
Real User
14 December 17

“It’s better to have fewer things you trust than have a whole lot of things that are suspect,”

Issa Ibrahim Taiwo - PeerSpot reviewer
Avaya Support Engineer at Simba Group
Real User
11 December 17

Support is the number one thing you think of before any other thing

PeerSpot user
Security Professional with 501-1,000 employees
Top 10
01 December 17

Customization, Scalability, OnPrem or Cloud, Licence price v Functions you get and the resources the BI system demand in staffing.

it_user779502 - PeerSpot reviewer
User at a tech company with 51-200 employees
27 November 17

Scalability, Performance, Security

PeerSpot user
Master Principle Sales Consultant at Oracle
Real User
11 September 17

User experience, metadata support, Performance

PeerSpot user
NA Lead Business Intelligence Systems at TechnipFMC
16 August 17

Speed to market, User interface, scalability, performance, and many other depending on how bad your current BI situation actually is.

PeerSpot user
VP Human Resources at Independent Bank
02 May 17

Definitely, ease of use, the real-time dashboards, performance, and stability. The fact that a relative novice to Cognos is able to utilize the tool on day 1 is impactful.

PeerSpot user
Senior BI Analyst at a tech services company with 10,001+ employees
Real User
28 March 17


PeerSpot user
CEO at a tech vendor with 51-200 employees
Real User
17 March 17

Easy to use/build reports/administration

PeerSpot user
dept manager at a tech vendor with 501-1,000 employees
15 February 17

1) Integration capabilities to make complex solution (to bi built in the core systems / co-exist with core system)
2) Ability to get data from RDBMSs (from core system) easily

PeerSpot user
Sr. Manager Business Development at NEC Corporation
Real User
04 January 17

1. Scalability
2. Self Service
3. Visualization
4. Mobility
5. Performance

PeerSpot user
Sr.Engineer-High Touch Technical Services at Cisco
Real User
01 October 16

2: Mobility Along with User friendly
3:. Security

PeerSpot user
Customer Success Manager at PeerSpot
28 September 16

When it comes to integration capabilities, which system-integrations are crucial to the solution performance, to the extent that users must be continuously informed/updated about their availability?

PeerSpot user
Managing Member at Christina M. Durta, CPA, LLC
21 March 16

A package that can be used by Main Street. Too many of the BI Vendors only focus on enterprise. Organizations of all sizes have tons of data that important information can be gleaned from. Frankly, the smaller your organization, the more you need it because your risk threshold is lower.

it_user391644 - PeerSpot reviewer
User at Capgemini
Real User
19 February 16

1) Functional capabilities
2) Scalability
3) Licensing /TOC

PeerSpot user
Data Analysis and Visualisation Consultant at a consultancy with 51-200 employees
26 January 16

Adaptability of the tool
Constant Development & investment
Ease of use for end consumers

PeerSpot user
SAS BI Consultant at a tech vendor with 51-200 employees
20 January 16

Data Analysis (Understanding of Data) after analysis you can discover pattern of data or you can extract fruitful data for the business process or business management automatically.

08 January 16

Clear experience for end users and have efficient integration wiht other systems and technologies

PeerSpot user
Sales manager at a construction company
06 January 16

TCO and a set of features that you need for your work.

it_user359049 - PeerSpot reviewer
User with 10,001+ employees
Real User
21 December 15

Ease of use

PeerSpot user
Developer at a tech services company
15 December 15

Ease of Use
Easy integration capabilities

it_user342831 - PeerSpot reviewer
User at a tech company with 51-200 employees
18 November 15

Scalability from dept level to corporate wide.

PeerSpot user
Information Architecture Manager at a retailer with 1,001-5,000 employees
10 November 15

1. Meet business needs
2.Total cost of ownership
3. Performance
4. Stability
5. Scalability
6. Easy to use/build reports/administration
7. Functionality/Visualisation
8. Mobility

PeerSpot user
Manager, Business Intelligence at a healthcare company with 5,001-10,000 employees
Real User
Top 10
07 November 15

1. Unified Access & Connectivity
2. Discover & Explore
3. Collaborate
4. Administration

PeerSpot user
Information Technology Bureau Deputy Director at a government with 1,001-5,000 employees
Real User
16 October 15

BI tools are not easy to implement unless:

1. you have done a business need analysis.
2. you develop an strategy that provide continue support to the end users.
3. you got executive management approval.
4. you have a product maintenance plan that allows to continue to update the products.
5. you have a daily backup/restore strategy in place.
6. you have a technical team trained.

PeerSpot user
BI Consultant at Quick Report Software Pvt. Ltd.
14 October 15

-Is BI Tool User Friendly for data modeling?
-Is Licensing Cost affordable?
-Is BI tool have ETL option?
-Is Web based?
-Can it produce charts on graphs? If yes then can we use it another application by just coping & pasting?
-Is it have auto ETL & auto report scheduling option?
-Is it have user management option?
-Is it have Export facility?
-Can we integrate different database in one table?
-can we connect flat files?

PeerSpot user
Operations Support Manager at a logistics company with 1,001-5,000 employees
08 October 15

Implementation time/complexity
Ease of use (from implementation to user in a short amount of time)
Training and support availability
Shared knowledge boards (is there a community of users who share ideas and suggestions?)
Visualization tools - with ability to produce visually appealing, value added dashboards, charts, and standard reports
Can the tool produce interactive files (e.g. Xcelsius output) that are shared externally via .pdf, Excel, etc.?
Multiple file output options
Publication options

it_user322836 - PeerSpot reviewer
User at a tech company with 51-200 employees
05 October 15

I think the most important criteria would consist the ease of use (user friendly), implementation and licensing.

29 September 15

- Architecture / Infrastructure
- Compatibility across platforms and devices
- Predictive Capability
- Data Mining - breadth / depth / reach
- Security Considerations
- Customization - Search
- Customization - Visualization
- Automated Updates to Information

25 September 15

-How little training is required to get end users (Non-IT) going.
- Scalability
-Ability to access multiple types of data sources
- Ability to integrate with OLTP databases with minimal footprint. (Im assuming OLAP integration is defacto)
-Data blending capabilities.

PeerSpot user
Manager HRO Application Development at Xerox
Top 5
18 September 15

- Ease of use for IT and non-IT end users
- OLAP functions
- Performance: Creation and consumption of In-memory MOLAP cubes
- Accepting integration with other OLAP engines thru MDX queries
- Easy mapping of Logical views from physical datawarehouse tables/views.
- Creation of Dynamic Dashboards and Transparent way to expose them to Mobile applications
- Scalable solutions.
- Authorization Model at very low granularity level (attribute data) to allow multi-tenant solutions.
- License model and cost

PeerSpot user
IT CONSULTANT at a tech consulting company
14 September 15

User Friendly, Feature richness, Scalability, Infrastructure requirement, Ease of Troubleshooting and Support.

14 September 15

User Friendly, Feature richness, Scalability, Infrastructure requirement, Ease of Troubleshooting and Support

PeerSpot user
IT CONSULTANT at a tech consulting company
09 September 15

1. Licensing cost.
2. Infrastructure requirement.
3. Scalability.
4. Complexity/ Ease of Development effort as well as Customization.
5. Metadata support.
6. Mobility and Cloud based customizations.
7. Ease of Troubleshooting and Support

PeerSpot user
System Engineer at a tech services company with 51-200 employees
04 September 15

Integration Capabilities and User friendly

PeerSpot user
Director of Projects at a consultancy
03 September 15

Licensing Cost
User Friendly
Low Maintenance Cost
Integration Capabilites

PeerSpot user
Head of BI & Analytics, Retail, UK at Tata Consultancy Services
Real User
01 September 15

Product roadmap, ease of use, performance and cost.

PeerSpot user
System Engineer at a tech services company with 51-200 employees
28 August 15

Usability, Speed to market, Manageability and scalability
Mainly Reports are Integrate with Web UI applications

PeerSpot user
Founder, CEO of Tech Startup at a tech services company
28 August 15

Easy to use and build the reports, scalability

PeerSpot user
Tech Lead and Architect BI DW at a financial services firm
16 August 15

Feature richness, Flexibility and Cost ( License and Support)

06 August 15

Time to market, agility
Ease of user (end users), user empowerment
Hierarchies easy to build, maintain and navigate

22 July 15

Principalmente: Integración, facilidad de uso, visualización de información en tiempo real y costos de licenciamiento. Entre otras con menos peso como soporte, movilidad, documentación, etc.

21 July 15

Ease of use,
Integration with current analytics tool I am using: google analytics,

20 July 15

Integration, Licensing

PeerSpot user
Analyst at a consultancy
Real User
16 July 15

Functional Capabilities

it_user273981 - PeerSpot reviewer
Owner with 51-200 employees
16 July 15

1) The most important is that the functionality meets the company requirements.
2) That the new functions required in the future can be easily implemented
3) Security
4) Stability
5) Performance
6) user - friendliness
7) TCO

13 July 15

Self Service capabilities; ease of use; documentation and developer community

PeerSpot user
Snr BI Developer / Team Lead at a tech services company with 10,001+ employees
02 July 15

Open API interface which allow you extend functionality not covered by default. If you take one of the TOP 10 BI tools every product has cons and pros. In my practice from many projects I haven't product which 100% satisfied customer requirements

01 July 15

Not in order of importance:
1. Licensing cost
2. Scalability
3. User friendly (I mean also for non technical user)
4. Good support (remote and on site)
5. Use of well known components (DB, OS, etc.)

it_user263847 - PeerSpot reviewer
Senior Software Engineer with 1,001-5,000 employees
01 July 15

1. Data Handling
2. Ease of use/implementation
3. License Cost
4. Latest technique & innovations
5. Connector - Facebook, Twitter, Google Analytics

PeerSpot user
BI Pre-Sales Consultant with 51-200 employees
27 June 15

- Turnaround time, the ability to meet the shrinking decision window
- Vizual / interactive BI structure, strong data vizualization with analitic dashboards
- Ease of use
- Cost of licensing and ownership
With respect to these criterias I prefer E-Kalite Software

PeerSpot user
Datawarehouse Consultant - Freelance at a comms service provider
26 June 15

@ChaelChristopher i think still it means the singular. If he wanted to mean plural, the question would be "what are your most important criteria.. ".
Off course there are a lot of criteria to when you are researhing a BI tool. But every role can have different priorities. Power users or developers may want it to be easy to use, sponsor may want it not to cost too much.

PeerSpot user
Senior Principal at a consultancy with 51-200 employees
26 June 15

@Mehmet Üskes -- Criteria is a plural concept, criterion is singular. I think the bulk of these answers are adequate...the reality being that no one selects a BI tool for just ONE reason. There are always strengths and weaknesses in a class of BI tools but if all you have is a hammer, then everything looks like a nail. Selection should be based on the basic needs of a project or an organization, and the needs of a single business user will be different than the needs of an organization that needs to OEM a vendor's solution into their own offering.

PeerSpot user
Datawarehouse Consultant - Freelance at a comms service provider
26 June 15

I wonder why most of people answered with writing more than one criteria and some of them have shared long lists. Is not it clear : "What is your most important criteria" ? It means you should say your MOST important criteria which has to be only one, Otherwise the question would be like "What are your important criterias.. " :)

PeerSpot user
Assistant Vice President at a tech services company
26 June 15

Ease of use (UI/UX implementation & learning curve)
Ease of implementation
Performance & Scalibility
Other tools included in the package (reporting, ETL, analytics, db etc.)
Interoperability with other tools

it_user260289 - PeerSpot reviewer
User at a tech company with 51-200 employees
23 June 15

1. Performance
2. Usability & UI
3. Maintenance and code
5. Connectivity to Databases

PeerSpot user
Datawarehouse Consultant - Freelance at a comms service provider
23 June 15


PeerSpot user
Project Manager at a tech services company with 51-200 employees
22 June 15

At présent time INTEROPERABILITY ....

it_user254994 - PeerSpot reviewer
Business Analyst at a tech consulting company with 1,001-5,000 employees
15 June 15

Simplicity then scalability. Everything else is negotiable in BI

PeerSpot user
Application and Business Intelligence Developer at a financial services firm with 51-200 employees
11 June 15

3.Ease of access
4.Visually Friendly

it_user251190 - PeerSpot reviewer
User at SAS
08 June 15

Ease of use (Time from data to Insight) and the enterprise capabilities (single version of the truth within the company)

it_user249393 - PeerSpot reviewer
User at Vertek Corporation
03 June 15

Ease of use, speed of implementation, ad hoc capabilities.

PeerSpot user
Architect (Datawarehouse / BI) at a financial services firm with 1,001-5,000 employees
22 May 15

1) Cloud strategy of the product.
2) Ease of use when cloud based.

21 May 15

(1) Visualization capabilities

PeerSpot user
Pré-Vendas at a tech vendor
18 May 15

Easy use, fast implementation and search performance

PeerSpot user
Director- NES Applications High Performance Management Competency Center at a tech services company with 10,001+ employees
18 May 15

Ease of user and data connectivity

it_user240387 - PeerSpot reviewer
General Manager & Head - OSS Architecture & Delivery with 5,001-10,000 employees
Real User
18 May 15

1. Scalability 2. Simplicity and the power to end-users to analyse data 3. TCO

it_user236448 - PeerSpot reviewer
IT Admin at a tech company with 501-1,000 employees
11 May 15

capacity to develop
user friendly
Does the tool integrate with many data sources

it_user236817 - PeerSpot reviewer
CTO at Endava
11 May 15

A lot depends on context but important factors I've seen influence people are:

- End-user ease of use (meaning self-service and integration into the desktop today)
- Enterprise features such as integration into enterprise security
- Ease of data acquisition and ingress into the platform
- Cost
- Existing vendor relationships
- Long term support costs (when people think of it ...)

07 May 15

The cost is important but having a tool that is simple enough for user to use and build on but also strong enough to support complex processing and provide strong performance is equally important.
Connectors are very important, being able to use various data sources.

PeerSpot user
Senior Principal at a consultancy with 51-200 employees
05 May 15

Integration - applicable on many fronts...
Is the platform integrated as a whole (i.e., a report created for web renders correctly on a mobile device)
Does the tool integrate with many data sources, including RDBMSs, cubes, spreadsheets, APIs...
Importing SAS, R, or PMML packages?
Integration with Office?
Does the BI vendor provide well-documented and flexible APIs?
Can the the platform be integrated with SSO and portals?

PeerSpot user
Data Management Expert at a tech services company with 51-200 employees
30 April 15

And, in order:
1. Easy for non-technical users & UI
1. Ease of Troubleshooting and Support, and Security.
1. Reporting / Visualization - dashboard, cubes
4. Licensing cost / Infrastructure requirement /Scalability.
5. Complexity/ Ease of Development effort as well as Customization.
6. Metadata support.
7. Mobility and Cloud based accessibility.

The top three are '1' as the order would change depending on the budget and size of the organization.

PeerSpot user
Manager, Business Advisory with 51-200 employees
30 April 15

Ease of tapping into DB, ease of use, and available industry benchmark.

PeerSpot user
Analyst at a consultancy
14 April 15

I am a user, but I compare Bi tools. In my understanding,
1. Cost
2. Complexity and time in installation
3. Security
4. Compatibility
5. ETL - Issues around it
6. Support
7. Responsiveness (Device compatibility for end users)
I guess, there will be more, but these are on top of my mind.

PeerSpot user
IT Consultant at a non-profit with 1,001-5,000 employees
14 April 15

Easy for Development
Provide all Information to all levels of management.
Easy for publishing

13 April 15

- User Friendly
- Ease of adaptation
- Security
- Cost

10 April 15

1. Interoperability
2. Ease of Use
3. Security
4. Cost

02 April 15

1 - user friendly & high performance
2- cost
3-perfect database to access Tables
4 - ((((( TRUST )))))

it_user217017 - PeerSpot reviewer
User at a tech company with 51-200 employees
01 April 15

1. Total Cost of ownership.
2. Infrastructure requirement.
3. Scalability.
4. Complexity/ Ease of Development effort as well as Customization.
5. Mobility and Cloud based customizations.
6. Ease of Troubleshooting and Support.
7. Resource (employee/contractor) availability to execute and maintain

PeerSpot user
Owner with 201-500 employees
Real User
30 March 15

Ease of implementing and user friendly visuals.

it_user212286 - PeerSpot reviewer
User at a tech company with 51-200 employees
23 March 15

Ease of use, scalable

PeerSpot user
Senior BI & Master Data Analyst at a consumer goods company
Real User
20 March 15

Flexibilty and suitability to requirements

PeerSpot user
MicroStrategy Expert with 15 years exp. at Strategy BI Consulting
02 March 15

After more then 15 years experience in BI Consulting,
I see as most important is:

1. Completeness of the solution (is it possible to cover all business requirements with a single BI platform )
2. Centralized administration and unified semantic layer
3. Ability to integrate with a variety of data sources
4. Scalability
5. Support and maintainable upgrades

PeerSpot user
Voorzitter Mooi Rembrandtpark at a consultancy
01 March 15

License model fitting our startup requirements; dashboarding incl collaboration functionality; cloud based, sass capability and multi tenant; integrated lite dwh plus mdm functionality

PeerSpot user
Marketing ⎥⎥ Business Development Predictive Analytics
26 February 15

Flexibility it gives to the end user to discover and explore without being constrained by (by IT) pre-defined 'search trajectories' / access paths

PeerSpot user
Director Of Business Development at a tech services company
25 February 15

Licensing cost
User Interface
User experience

it_user199443 - PeerSpot reviewer
User at a tech company with 10,001+ employees
25 February 15

competitive differentiators

PeerSpot user
Jr. Business Analyst (IT Department) at a wholesaler/distributor with 1,001-5,000 employees
24 February 15

Integration with current systems

19 February 15

Visualisations of data to make sense of them

PeerSpot user
Technology Leadership at a consultancy
17 February 15

(1) Ease of use
(2) Ability to integrate with a variety of data sources
(3) Company reputation

PeerSpot user
Cognos BI Consultant at a tech services company
05 February 15

The answers already provided cover much of what I would recommend, so let me add a few items that are not mentioned:

1) Company track record. Have they delivered in the past on new features and new functions?
2) Is there a product roadmap for future development?
3) Is there native driver support for your data source(s)? Relying on ODBC for your BI tools is going to guarantee slow performance.
4) Are the major modules/functions web-based or PC-based? If you have to install software on every PC it will cost more to maintain and be more difficult to upgrade.

I hope those are helpful.

04 February 15

How quickly it can crunch millions of records.

30 January 15

Cost Effective

23 January 15

1. Data visualizing capability
2. Tools for ETL and Reporting
3. Ease of use
4. Implementation cost
5. Development cost

PeerSpot user
Database Manager at a tech services company
21 January 15

Functionality and cost. Cost to include license, infrastructure, training and ongoing support.

it_user182949 - PeerSpot reviewer
technopreneur with 11-50 employees
19 January 15

Ease of use, Visualization options, Interactive, accuracy when combining data from multiple data sources, alerts

PeerSpot user
BI Expert at a financial services firm
16 January 15

You need:
type of storage: MOLAP; ROLAP HOLAP
Architecture: Stage, Landing, Reports
Integration, Analysis and Reports Tools

14 January 15

TCO / Functionality trade offs for the current environment with an eye on the longer term.

Dan Ring - PeerSpot reviewer
Writer at TechTarget
03 January 15

I am a news writer at and am interested in interviewing users of BI solutions. If you are willing to be interviewed, I can assure you that I will fact check before publishing. If you found BI software that performs well or not so well, and your company will allow an on-the-record interview for a story, or if you know someone I can contact at your company for a story, I would be pleased to speak with you. Please email at

31 December 14

Apart from sufficient functionality: readiness and ease to deploy and upgrade.

PeerSpot user
Architect at a tech services company
29 December 14

Whether the adequately meet the needs of the business.

PeerSpot user
Business & Community Development at a tech company with 51-200 employees
29 December 14

1. Find good use cases
2. Ease of integration
3. Have mobile versions
4. Security aspect when used with mobile devices.

PeerSpot user
Marketing at Ricoh India Ltd
24 December 14

1. Easy to Use
2. Scalable
3. Free Support
4. cost effective
5. Business Requirement

PeerSpot user
23 December 14

Flexible intergrating with existing systems, ease of use, maintenance and good technical support

PeerSpot user
Database And BI Developer at a tech consulting company
18 December 14

1-Business ( Answer from the Business Users)
2-Development Effort.
3-Cost of the product
5-Technical Support.

PeerSpot user
Business Development Manager
11 December 14

1 - Self-Service : Empower everyone with reports that are easy to build and share customize reports
2 - Unify disparate data sources : use data from multiple sources in a single report, (Excel, text/CSV files, any database, Web, etc.)
3 - Real-time business intelligence : makes data available on demand rather than on regularly scheduled annual, quarterly or monthly
4 - Maintenance issues and easy to implement. : centralized data management and implementing a generic solution to meet specific challenges often becomes difficult and costly
4 - TCO : have the lowest ownership costs (pricing Licensing + installation & maintenance costs + Infrastructure requirement)

10 December 14

1. Self Service / Ease of Use
2. Performance and Scalability to handle Big Data
3. Database agnostic
4. Good Product support and TCO

PeerSpot user
02 December 14

Knowing what you want to achieve with that tool

PeerSpot user
Information Management Manager at a insurance company with 5,001-10,000 employees
Real User
28 November 14

for BI platforms;
1. ease of use from end user point of view, and ability to manage flexibility for different user groups
2. ease of maintenance
3. visual capabilities
4. performance

PeerSpot user
CEO with 51-200 employees
23 November 14

I think the most Important criteria Is not specific feature, it's actually the matching between the customer's needs and the features of the tool. So you can write ease of use for example but if the solution is a dashboard that hangs in the CEO / CTO / CFO office then it's not relevant.
If the need is to analyze the data by only the economic department then you need a tool that is great at analyzing like Sisense or Tableau.
On the other hand if the requirements is a full-scale large-company business intelligence solution for thousands of users that maybe you Can go with more general solutions like Yellowfin.
The requirement could be embedded business intelligence then you can consider tools that made for that (yellowfin / pentaho) and don't forget Big-data That can change the picture altogether.

So, in other words, first know what your customers need then you can pick the right set of tools:
data integration, data warehouse, business intelligence GUI tool.
And you also can combine several of them for example:
1. Pentaho data integration, exasol , yellowfin
2. MySQL and Sisense (that has an internal in memory database)

Our website:
Also I am the author of the course: Pentaho kettle tutorial at

PeerSpot user
Senior Developer
17 November 14

Ease of Use - ability to train a 'power' user. Flexible and performance options.

PeerSpot user
Director of Engineering with 1,001-5,000 employees
05 November 14

#1 - Ease of use without the need to know how to code as a business user. Should simply be able to search for answers or drag and drop fields to get insights.

PeerSpot user
Database Expert at a tech services company
04 November 14

Following this order:
1. Comprehensive, Easy & Intuitive User Interface (Scorecards Dashboards, Reports, OLAP, ...)
2. Licencing->Installation->Maintenance Costs + Infrastructure requirement (TCO)
3. Performance, scalability & Connectivity (data sources)

30 October 14

Business user friendly

it_user158118 - PeerSpot reviewer
Director of IT Operations at a wholesaler/distributor with 501-1,000 employees
22 October 14

1. Flexibility
2. Cost
3. Ease of Use
4. Mobile

10 October 14

Ease of use is key.

PeerSpot user
Director at a energy/utilities company
29 September 14

Usability, Integration, Performance & Scalability

PeerSpot user
Skip Tracer | 10+Years Specializing in Unclaimed Money | Find Unclaimed Money | Finding Heirs at AURFS Pty Ltd trading as Money Catch
28 September 14

1. Ease of use
2. Help/Support

PeerSpot user
Director at a tech services company
25 September 14

1) Simplicity / Ease Of Use
2) Integration / Ease Of Integrating
3) Supportability / Maintainability Over Time
4) Performance & Scalability

PeerSpot user
Business Analyst at CGI
23 September 14

All above and flexibility of integration with existing corporate systems

it_user153165 - PeerSpot reviewer
User at a tech company with 51-200 employees
18 September 14

Cost, Performance, Ease of Use, Visualizations

PeerSpot user
Consultant at Virtusa
12 September 14

Performance, Licensing Cost and User Friendly

PeerSpot user
Chief Strategy Officer at a manufacturing company with 1,001-5,000 employees
08 September 14

We have found that a easy-to-use UI, Integration with our ERP/DW, and speedy performance are favored by our business users. Otherwise, the BI tool will end up being a burden of our IT team with less-than-stellar gains by the users.

PeerSpot user
User at Telefónica
Real User
03 September 14

It depends on the environment where you are implementing the BI solution. If you are implementing a solution in a 100% commercial company you want something very easy to use. If you are facing an organization full of geeks you want something that can be twisted in every single way... And so on.

02 September 14

I would start by saying that there is not a single criteria that will magically make you decide on which BI tool to use. First things first, requirements should be analyzed in the perspective of scalability(that will lead to performance as well), licensing/maintenance/training cost, target audience and tools available. In regards to the last point, analysis on the data source connectivity provided, ETL processes made available, semantic layer and reporting/analysis tools provided should be considered. It can be that not only tools from one vendor will do the job for you so integration with other tools should also be considered.

it_user145521 - PeerSpot reviewer
User at a tech company with 51-200 employees
26 August 14

Good Feedback.

SO based on feedback, all I can add is evaluate
1) Your need : How much Data
2) usage: just for a few months or Long term example : 15 years
3) IS the data model going to change over the years or period.
4) will their be new feeds over time.
3) How many reports : this is where ease of use,dash boards come in picture
1) extract , transform load functionality . This is important , if your ETL guy or girl leaves the company , you are screwed , unless tool is able to simplify the ETL process , that you can do reverse engineering.

1) based on your answers above you can choose the appropriate BI tools out there.

PERFORMANCE : Non related to tool
1) this depends upon your HARDWARE, Data model and architecture , and fine tuning of addition maybe populating the Data marts or views and / or Reporting universe.

12 August 14

Check support for Analytics, Data Insights, Visualization and data as service

it_user146187 - PeerSpot reviewer
User at a tech company with 51-200 employees
12 August 14

1. Easy of Use
2. Licensing cost

PeerSpot user
Consultant at a financial services firm with 5,001-10,000 employees
Real User
08 August 14

At risk of repeating others, ease of use, scalability, security (user and row level for example) and TCO are probably top of my shopping list. Compatibility with other tools also quite important (for example R or hosting visulisations on intranet/internet)

15 July 14

Scalability and Performance
Maintenance Requirements
Product Roadmap

it_user140223 - PeerSpot reviewer
Marketing Intelligence Analyst at a financial services firm with 501-1,000 employees
14 July 14

Feature Set, Ease of use, mass deployment capabilities, and licensing costs..

PeerSpot user
Engineer at a energy/utilities company
03 July 14

Performance, understandability and user-friendly

27 June 14

The scale at which you are going to implement the BI tool. Everything else has a solution But you can't go using in memory tools for a Global enterprise.

PeerSpot user
Student at a tech services company
20 June 14

It is important that a Business Intelligence solution supports the principle of ‘create a report once; run on every device’. People today use tablets, smartphones very very often.
Second, performance? a good response time is also important.

Dung Dinh Tien - PeerSpot reviewer
Database Expert & BI Developer at a outsourcing company
Real User
20 June 14

Following this order:
1-Licence cost
2-Visualization data (dashboard, reporting,..)
3-Performance (Load/process data)
5-Easy for non-technical users

19 June 14

Integration with existing portfolio

PeerSpot user
Sub-Manager of Development at a healthcare company with 1,001-5,000 employees
Real User
19 June 14

User friendly and very good dashboards

PeerSpot user
Sales at Information Builders
Real User
19 June 14

Flexibility, ease of use, scalabilty

19 June 14

User friendliness is at the top of my criteria list!

PeerSpot user
CIO at a pharma/biotech company with 501-1,000 employees
16 May 14

Simplicity ~ Scaleablity ~ Sensiblity

it_user115203 - PeerSpot reviewer
Solution Architect at a tech company with 51-200 employees
15 May 14

The following is the order I follow when I research BI tools:
1. Scalability and Performance
2. Usability & UI
3. Mobile and Cloud Based integration and accessibility
4. Maintenance and code
5. Connectivity to Databases and Big Data

13 May 14

User Friendly
IT Maintenance Friendly

PeerSpot user
Manager of Data Analytics at Tata Consultancy Services
Real User
24 April 14

The following are important when researching BI Tools:

1. Licensing cost.
2. Infrastructure requirement.
3. Scalability.
4. Complexity/ Ease of Development effort as well as Customization.
5. Metadata support.
6. Mobility and Cloud based customizations.
7. Ease of Troubleshooting and Support.

PeerSpot user
BI Expert
08 April 14

Ease of use, implementation, adaptability licensing.

Related Questions
reviewer1772406 - PeerSpot reviewer
User at Unionbank Philippines
Feb 02, 2022
Hi experts, I work at a large financial organization. I have been wondering what types of problems (=use cases) can be solved/optimized using the Edge AI technology in industries such as Banking and  Finance, Power and Land and Agriculture?  I appreciate your thoughts and suggestions.
See 1 answer
Djalma Gomes, Pmp, Mba - PeerSpot reviewer
Managing Partner at Data Pine
02 February 22
AI has already been used for decades in banking, finance and agriculture.  Credit and loan analysis use a lot of logistic regression to know who to loan money to. Finance uses AI for regression analysis of forecasts and optimum stock portfolios, agriculture to predict production and supplies needs based on the amount of rain forecasted. What we have is the evolution of tools, methods and techniques. We no longer need cubes. Although Hadoop is meant for safe storage at low cost and not for AI purposes, tools have evolved and new tools arose providing the speed required for AI analysis. We have evolved in terms of data governance with the use of DMBoK (Data Management Body of Knowledge), visual planning frameworks like the Machine Learning Canvas, Self Service BI approaches stimulating collaboration amongst users.  We now have tools, practices, frameworks and enough manpower that makes the job more challenging. We have been using AI in those sectors for quite a while, but now we have the momentum to reach a different level of data thinking organizations.
Frank Bianchi - PeerSpot reviewer
Chief Sales and Marketing Officer at AdminaHealth
Jan 27, 2022
Hi peers, Aside from dashboards, there are some use cases that require a fair amount of detailed data, with customizable sort and display fields which can vary by account.  This is in the insurance, healthcare, benefits space in particular.   While advanced visualization features help on the dashboard side of the equation, I would like to get the opinion on the best tools for this detailed, ...
2 out of 5 answers
Alan Sutton - PeerSpot reviewer
Senior Manager at a tech services company with 1-10 employees
25 January 22
XLCubed (now owned by Fluence Technologies Inc) is the market-leading Reporting and Dashboard tool for any Excel-connected data.  With entry-level pricing and straightforward feature explanations via online training materials, XLCubed can be implemented as either a standalone cloud-based BI tool or as part of today's world-beating Financial Consolidation and Reporting solution.
Jose Barbosa - PeerSpot reviewer
CEO at Finanblue
25 January 22
Hi Mr. @Frank Bianchi, Yes, you can do that but only on Professional or Enterprise Plan.  Also, you can link to Power BI and generate some different views.
Related Articles
Evgeny Belenky - PeerSpot reviewer
Director of Community at PeerSpot (formerly IT Central Station)
May 02, 2022
Hi peers, We're happy to share our new bi-weekly Community Spotlight with you. Here you'll find recent contributions by PeerSpot community members: questions, articles and trending discussions. Trending See what your peers are discussing at the moment! What to choose: an endpoint antivirus, an EDR solution, or both? What is your recommended IT Service Management (ITSM) tool in 2022? W...
Evgeny Belenky - PeerSpot reviewer
Director of Community at PeerSpot (formerly IT Central Station)
Apr 04, 2022
Hi peers, This is our new Community Spotlight that includes recent contributions (questions, articles and discussions) by the PeerSpot community members. Trending Is RPA beneficial for a healthcare organization? With the increasing risk of cyber attacks in the west, due to the war in Ukraine, how safe is your data in the cloud? Articles 8 Business Automation Ideas to Save Time and...
Evgeny Belenky - PeerSpot reviewer
Director of Community at PeerSpot (formerly IT Central Station)
Mar 18, 2022
Hi community members, Here we go with a new Community Spotlight. We publish it to help YOU catch up on recent contributions by community members. Trending What open-source HCI solution do you recommend? How much time does SSO save? What are the main technical differences between Microsoft Power Automate and Blue Prism? Articles Top HCI in 2022 What is Web Design? The Ultima...
Evgeny Belenky - PeerSpot reviewer
Director of Community at PeerSpot (formerly IT Central Station)
Mar 04, 2022
Hi community members, Here is our new Community Spotlight for YOU. We publish it to help you catch up on recent contributions by community members. Do you find it useful? Please comment below! Trending Top HCI in 2022 What are the main differences between XDR and SIEM? Articles Top 5 Ethernet Switches in 2022 SASE: what is it and what are the main benefits? Questions Che...
Shibu Babuchandran - PeerSpot reviewer
Regional Manager/ Service Delivery Manager at ASPL INFO Services
Oct 16, 2021
What Is Intelligent Process Automation? Intelligent process automation (IPA) refers to tasks that are automated or optimized in part by artificial intelligence and machine learning algorithms. IPA tools can reduce human intervention in a variety of business processes. IPA solutions go beyond simple, rule-based tasks. For example, IPA tools can apply artificial intelligence to process unst...
Related Articles
Evgeny Belenky - PeerSpot reviewer
Director of Community at PeerSpot (formerly IT Central Station)
May 02, 2022
Community Spotlight #13: Top Products and Solutions
Hi peers, We're happy to share our new bi-weekly Community Spotlight with you. Here you'll find ...
Evgeny Belenky - PeerSpot reviewer
Director of Community at PeerSpot (formerly IT Central Station)
Apr 04, 2022
Community Spotlight #11
Hi peers, This is our new Community Spotlight that includes recent contributions (questions, a...
Download Free Report
Download our free BI (Business Intelligence) Tools Report and find out what your peers are saying about Microsoft, Tableau, SAP, and more! Updated: September 2022.
634,775 professionals have used our research since 2012.