Try our new research platform with insights from 80,000+ expert users

Tableau vs Teradata comparison

Sponsored
 

Comparison Buyer's Guide

Executive SummaryUpdated on Oct 6, 2024
 

Categories and Ranking

IBM Cognos
Sponsored
Ranking in BI (Business Intelligence) Tools
7th
Average Rating
8.0
Number of Reviews
134
Ranking in other categories
Reporting (4th)
Tableau
Ranking in BI (Business Intelligence) Tools
2nd
Average Rating
8.4
Number of Reviews
294
Ranking in other categories
Reporting (2nd), Data Visualization (1st), Embedded BI (1st)
Teradata
Ranking in BI (Business Intelligence) Tools
10th
Average Rating
8.2
Number of Reviews
74
Ranking in other categories
Customer Experience Management (3rd), Backup and Recovery (20th), Data Integration (17th), Relational Databases Tools (7th), Data Warehouse (3rd), Marketing Management (6th), Cloud Data Warehouse (6th)
 

Q&A Highlights

Tomasz Rabong - PeerSpot reviewer
 

Featured Reviews

Carlos Larrad Salgado - PeerSpot reviewer
Jul 27, 2022
Improved the quality of our KPIs, while reducing calls to the IT department
I don't like that when we use Colab packages, we get less functionality. For example, you can make groups of data with Excel or with the data sets from the packages, but when you use the Colab packages directly, you can only group the data when you analyze it with Analysis Studio. I think Cognos needs to improve more on this functionality. The user experience is also very important. Cognos is not very easy to understand sometimes, especially when they change the layout but keep the functionality the same. The help is not very graphic and they have no examples. Cognos has to make a big effort to help with understanding the functionality by improving the documentation. There is a lot of documentation, but the examples are hard to find and they should make their help section easier to understand for non-technical users.
ROMIL SHAH - PeerSpot reviewer
Mar 22, 2022
Provides fast data access with in-memory extracts, makes it easy to create visualizations, and saves time
When it comes to visualizations, Tableau has a limitation as compared to Power BI. It has a limited set of visualizations. Power BI has the entire marketplace, so you can connect and import many visualizations and use them, whereas Tableau has only 10 or 15 visualizations. There should be more visualizations, and there should also be data integration with more cloud providers. Tableau has recently launched a paid version for the documentation. So, documentation has become a little bit challenging when it comes to Tableau development because we do not have any tool to export the data out of it. It is a license-based feature that you need to purchase to prepare documentation. So, on the documentation front, for preparing clear documentation for any dashboard, it would help if we get an embedded option, rather than buying a license for each user for the documentation. To document anything, if I have to connect to each workbook and see what has been written as a formula and then document in the Word document, it is pretty time-consuming. We have the Microsoft stack, and we are currently evaluating Power BI because Tableau has a limitation of 50 columns for a drill-down report. If we want more than 50 columns, we have found a hack, but there is no ready-made option for doing it. So, we have to use another tool in case we need a drilled report with more than 50 columns. There are many instances where users need 80 or 90 columns for their analysis, and switching between two technologies becomes a challenge. It is not a cost-effective approach for us. Their support should be improved. We are not happy with their support. Whenever we raised queries, we were pointed to a few blogs, and we didn't get a proper solution from them. Their licensing should also be improved. They want us to purchase a Tableau Creator license for business users, whereas Power BI Desktop is free for business users. They should come up with a basic license with one or two connectors that our business users can use for preparing their visualizations. Tableau also charges us per user for users who want the data only through email.
SurjitChoudhury - PeerSpot reviewer
Feb 20, 2024
Offers seamless integration capabilities and performance optimization features, including extensive indexing and advanced tuning capabilities
We created and constructed the warehouse. We used multiple loading processes like MultiLoad, FastLoad, and Teradata Pump. But those are loading processes, and Teradata is a powerful tool because if we consider older technologies, its architecture with nodes, virtual processes, and nodes is a unique concept. Later, other technologies like Informatica also adopted the concept of nodes from Informatica PowerCenter version 7.x. Previously, it was a client-server architecture, but later, it changed to the nodes concept. Like, we can have the database available 24/7, 365 days. If one node fails, other nodes can take care of it. Informatica adopted all those concepts when it changed its architecture. Even Oracle databases have since adapted their architecture to them. However, this particular Teradata company initially started with its own different type of architecture, which major companies later adopted. It has grown now, but initially, whatever query we sent it would be mapped into a particular component. After that, it goes to the virtual processor and down to the disk, where the actual physical data is loaded. So, in between, there's a map, which acts like a data dictionary. It also holds information about each piece of data, where it's loaded, and on which particular virtual processor or node the data resides. Because Teradata comes with a four-node architecture, or however many nodes we choose, the cost is determined by that initially. So, what type of data does each and every node hold? It's a shared-no architecture. So, whatever task is given to a virtual processor it will be processed. If there's a failure, then it will be taken care of by another virtual processor. Moreover, this solution has impacted the query time and data performance. In Teradata, there's a lot of joining, partitioning, and indexing of records. There are primary and secondary indexes, hash indexing, and other indexing processes. To improve query performance, we first analyze the query and tune it. If a join needs a secondary index, which plays a major role in filtering records, we might reconstruct that particular table with the secondary index. This tuning involves partitioning and indexing. We use these tools and technologies to fine-tune performance. When it comes to integration, tools like Informatica seamlessly connect with Teradata. We ensure the Teradata database is configured correctly in Informatica, including the proper hostname and properties for the load process. We didn't find any major complexity or issues with integration. But, these technologies are quite old now. With newer big data technologies, we've worked with a four-layer architecture, pulling data from Hadoop Lake to Teradata. We configure Teradata with the appropriate hostname and credentials, and use BTEQ queries to load data. Previously, we converted the data warehouse to a CLD model as per Teradata's standardized procedures, moving from an ETL to an EMT process. This allowed us to perform gap analysis on missing entities based on the model and retrieve them from the source system again. We found Teradata integration straightforward and compatible with other tools.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The dashboarding offered by this solution is very valuable to us."
"The three IBM Cognos features I find the most valuable are Dynamic Cubes, PowerPlay, and Watson."
"The solution's initial setup process is easy."
"The initial setup is quite straightforward."
"The most valuable features are Report Development (Functionality) and Information Distribution (Flexibility)."
"It is a stable product."
"The initial setup is very straightforward."
"One of the strong suits of Cognos is its robust corporate reporting capability."
"I have found the solution easy to use and the interface is very good."
"This solution has transformed us from an Excel reporting environment to one of visual exploration."
"Tableau's initial setup was straightforward."
"Tableau's most valuable features are its ability to summarize data, provide dynamic controls for navigating different charts, and showcase historical data trends. I appreciate the option to colour-code different charts for improved customer experience."
"The solution allows for the possibility for end-users to do their own reporting."
"The number one thing was just the ease of getting something up quickly. The other thing that was good about it was that it was fairly fast for decent-sized data sets in terms of performance and run time."
"All features are valuable. It is very user-friendly, and it is mostly drag-and-drop. If we have the dataset available, then we can develop any dashboard very quickly."
"It's a very good, flexible product, and it's easy to learn."
"I like this solution's ease of design and the fact that its performance is quite good. It is stable as well."
"It's a pre-configured appliance that requires very little in terms of setting-up."
"The performance is great, we are able to query our data in one operation."
"The cloud is ten times better than physical hardware; it is more cost-effective and the upgrade process is ten times easier."
"The two types of partitioning have been very significant for us - row and columnar partitioning."
"Their extensive experience in data warehousing, the platform's performance, and their strong reputation in the market are the most valuable."
"The solution's banking model, called FSLDM (Financial Services Logical Data Model), is sophisticated and good."
"The data processing, clustering, and distributed computing are impressive."
 

Cons

"I don't like that when we use Colab packages, we get less functionality. For example, you can make groups of data with Excel or with the data sets from the packages, but when you use the Colab packages directly, you can only group the data when you analyze it with Analysis Studio. I think Cognos needs to improve more on this functionality."
"I would like to see the introduction of mapbooks for supporting some geographical information."
"The AI-based features could be further enhanced by the solution."
"They should provide improved visual reporting."
"The solution seems to slow down the servers."
"IBM Support can be slow at times, but they can usually deliver in a timely manner."
"Tableau and Power BI are faster than Cognos."
"I would like to have predictive and forecasting capabilities in Cognos. It's one thing to do reporting, and another thing to easily predict or forecast certain data points, which is very important for all the clients."
"I would like Tableau to handle geospatial data better in terms of multiple layers and shapefiles."
"When I've done presentations in the past, I've had issues with uploading the cartography."
"There should be more GIS features, such as location analysis, which is quite limited. There are very few location-based functionalities."
"Reports should be downloadable as PDF files."
"The tool's OpenAI integration was announced last year. However, it is late. Tableau is a good solution for end customers. However, there are some concerns regarding the stability and performance of its server architecture, including SaaS services. The server side appears unstable, and performance issues are noticeable, often accompanied by unclear error messages."
"The Hyper Extract functionality is not as strong as that provided by Microsoft SQL."
"The data entered into Tableau must be clean. Otherwise, it won't work properly."
"It's already using 32 gigabytes of memory, but the performance is not so good. It's very heavy."
"There is some improvement required on OLTP level and some analytical function is missing."
"​I think the UI is not there yet. It could be improved by being more user-friendly.​"
"The reporting side wasn't very good in the past, but with the latest versions, it's getting better. Still, the friendliness of the PDC reporting and functionality needs to be improved."
"I would like more security and speed."
"Teradata is a bit late for the cloud."
"It needs a teaching web site with more training on third-party tools used for BI."
"Limited interest and success in some areas make us hesitate about upgrading."
"Teradata's pricing is quite high compared to Redshift, Synapse, or GCP alternatives."
 

Pricing and Cost Advice

"It is my understanding that the cost is very low. It's not very expensive."
"Pricing should be improved."
"I rate the product price as four or five on a scale from one to ten, where one is a low price, and ten is a high price."
"There is a standard license required to use this solution. There are some additional tools but I am not sure if they are an extra cost."
"There is need to assess the purchase license accordingly so as to avoid audit penalties."
"The cost of IBM Cognos it's more or less the same as most of the other solutions on the market. They're very competitive with the rest of the market and it is not the most expensive product."
"It is quite pricy. I think Microsoft BI is cheaper. Tableau might also be cheaper, but it also depends on the usage. If you have very many users, Cognos can be a problem. It could be cheaper than Tableau but not for so many users. If you have a few thousand users, Tableau, which is generally quite expensive, can be cheaper than Cognos."
"There is some additional licensing that we needed to purchase because we were touching data outside of our core data platform. The cost was approximately $25,000 for the additional licenses, which were approximate 45 licenses. For the application itself, updates, and the core platform it was approximately $50,000. Giving a total cost of $75,000 annually for our usage of IBM Cognos."
"The pricing of Tableau should be better to remain competitive in the market, especially when compared to alternatives."
"The cost is high."
"Tableau is an expensive solution, though it comes with its advantages."
"The solution is expensive but it depends on the customer's needs which will determine the cost of the licensing."
"We pay for the enterprise license for Tableau. The licensing could be cheaper and more flexible."
"The solution's licensing is based on user-basis. It depends on the business ROI it offers. It's not on the higher side or too cheap; it falls in the medium-cost range. The price is determined by user usage, so the cost will also increase as the number of users increases."
"The pricing for Tableau is the same as the other products in the market."
"I like the payment model. For the people who need to create, they buy their licenses. Everyone else can use the free Tableau Viewer. This is much better than some of the competitor products, which require full licences for everything."
"Teradata is expensive but gives value for money, especially if you don't want to move your data to the cloud."
"The tool costs about 30,000 euros a month, while Azure Synapse SQL only costs 10,000."
"The price of Teradata is expensive. However, what they deliver they are outstanding. If you're looking for an inexpensive solution to run a database, this isn't your tool. It's the Ferrari of databases for data warehousing."
"The price needs to be more competitive as Hadoop, Redshift, Snowflake, etc are constantly making way into EDW space."
"The cost is substantial, totaling around $1.2 million, solely dedicated to upgrading the hardware."
"Teradata is not cheap, but you get what you pay for."
"Teradata is a very expensive solution."
"Teradata is expensive, so it's typically marketed to big customers. However, there have been some changes, and Teradata is now offering more flexible pricing models and equipment leasing. They've added pay-as-you-go and cloud models, so it's changing, but Teradata is generally known as an expensive high-end product."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
813,418 professionals have used our research since 2012.
 

Comparison Review

it_user6330 - PeerSpot reviewer
May 2, 2013
MicroStrategy vs. Tableau
After a recent presentation, several attendees asked me about the applications of Visual Insights and Tableau. Many companies are investing in both tools and are trying to figure out the right tool for specific applications Tableau has found its sweet-spot as an agile discovery tool that analysts…
 

Answers from the Community

Tomasz Rabong - PeerSpot reviewer
Apr 20, 2022
Apr 20, 2022
Dear Community, Many thanks for yor support and help!
2 out of 6 answers
EB
Apr 18, 2022
Hi @Delmar Assis, @Angel Pineda, @reviewer1318779, @George McGeachie, @Carel Van Der Merwe and @Moorthy Natarajan, Can you please assist @Tomasz Rabong ​with their question?​​ ​ ​ ​ ​
Leandro Sodré - PeerSpot reviewer
Apr 18, 2022
Hi Tomasz Rabong,  I believe that if you have a developer team in Amundsen it would be possible.  Alternatively, you can look at Informatica EDC or at Data Virtualization Data Catalog (from Denodo).
 

Top Industries

By visitors reading reviews
Educational Organization
58%
Financial Services Firm
7%
Computer Software Company
5%
Government
4%
Educational Organization
40%
Financial Services Firm
11%
Computer Software Company
7%
Manufacturing Company
6%
Financial Services Firm
25%
Computer Software Company
11%
Manufacturing Company
8%
Healthcare Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Seeking lightweight open source BI software
It depends on the Data architecture and the complexity of your requirement. Some great tools in the market are Qlik ...
What do you like most about IBM Cognos?
The solution's most valuable feature is its ease of use, which makes it easily compatible with other tools.
What needs improvement with IBM Cognos?
I need improvements, particularly with the Framework Manager, which has an outdated user interface from older version...
Tableau vs. Business Objects - Which is a better solution for visualization and analysis?
Both tools have their positives and negatives. First, I should mention that I am relatively new to Tableau. I have be...
Which would you choose - Tableau or SAP Analytics Cloud?
Tableau is easy to set up and maintain. In about a day it is possible for the entire platform to be deployed for use....
What do you like most about Tableau?
Tableau is a fantastic tool that provides impressive dashboards and customized reports.
Comparing Teradata and Oracle Database, which product do you think is better and why?
I have spoken to my colleagues about this comparison and in our collective opinion, the reason why some people may d...
Which companies use Teradata and who is it most suitable for?
Before my organization implemented this solution, we researched which big brands were using Teradata, so we knew if ...
Is Teradata a difficult solution to work with?
Teradata is not a difficult product to work with, especially since they offer you technical support at all levels if ...
 

Comparisons

 

Also Known As

Cognos, Cognos Analytics, IBM Cognos Analytics
Tableau Desktop, Tableau Server, Tableau Online
IntelliFlex, Aster Data Map Reduce, , QueryGrid, Customer Interaction Manager, Digital Marketing Center, Data Mover, Data Stream Architecture
 

Overview

 

Sample Customers

More than 23,000 leading organizations across multiple industries use Cognos. Some examples of Cognos customers include BMW Financial Services, Quinte Health Care, Troy Corporation, Michigan State University, and GKN Land System.
Accenture, Adobe, Amazon.com, Bank of America, Charles Schwab Corp, Citigroup, Coca-Cola Company, Cornell University, Dell, Deloitte, Duke University, eBay, Exxon Mobil, Fannie Mae, Ferrari, French Red Cross, Goldman Sachs, Google, Government of Canada, HP, Intel, Johns Hopkins Hospital, Macy's, Merck, The New York Times, PayPal, Pfizer, US Army, US Air Force, Skype, and Walmart.
Netflix
Find out what your peers are saying about Microsoft, Salesforce, Amazon Web Services (AWS) and others in BI (Business Intelligence) Tools. Updated: October 2024.
813,418 professionals have used our research since 2012.