Skip to content
NextLytics
Megamenü_2023_Über-uns

Shaping Business Intelligence

Whether clever add-on products for SAP BI, development of meaningful dashboards or implementation of AI-based applications - we shape the future of Business Intelligence together with you. 

Megamenü_2023_Über-uns_1

About us

As a partner with deep process know-how, knowledge of the latest SAP technologies as well as high social competence and many years of project experience, we shape the future of Business Intelligence in your company too.

Megamenü_2023_Methodik

Our Methodology

The mixture of classic waterfall model and agile methodology guarantees our projects a high level of efficiency and satisfaction on both sides. Learn more about our project approach.

Products
Megamenü_2023_NextTables

NextTables

Edit data in SAP BW out of the box: NextTables makes editing tables easier, faster and more intuitive, whether you use SAP BW on HANA, SAP S/4HANA or SAP BW 4/HANA.

Megamenü_2023_Connector

NextLytics Connectors

The increasing automation of processes requires the connectivity of IT systems. NextLytics Connectors allow you to connect your SAP ecosystem with various open-source technologies.

IT-Services
Megamenü_2023_Data-Science

Data Science & Engineering

Ready for the future? As a strong partner, we will support you in the design, implementation and optimization of your AI application.

Megamenü_2023_Planning

SAP Planning

We design new planning applications using SAP BPC Embedded, IP or SAC Planning which create added value for your company.

Megamenü_2023_Dashboarding

Dashboarding

We help you with our expertise to create meaningful dashboards based on Tableau, Power BI, SAP Analytics Cloud or SAP Lumira. 

Megamenü_2023_Data-Warehouse-1

SAP Data Warehouse

Are you planning a migration to SAP HANA? We show you the challenges and which advantages a migration provides.

Business Analytics
Megamenü_2023_Procurement

Procurement Analytics

Transparent and valid figures are important, especially in companies with a decentralized structure. SAP Procurement Analytics allows you to evaluate SAP ERP data in SAP BI.

Megamenü_2023_Reporting

SAP HR Reporting & Analytics

With our standard model for reporting from SAP HCM with SAP BW, you accelerate business activities and make data from various systems available centrally and validly.

Megamenü_2023_Dataquality

Data Quality Management

In times of Big Data and IoT, maintaining high data quality is of the utmost importance. With our Data Quality Management (DQM) solution, you always keep the overview.

Career
Megamenü_2023_Karriere-2b

Working at NextLytics

If you would like to work with pleasure and don't want to miss out on your professional and personal development, we are the right choice for you!

Megamenü_2023_Karriere-1

Senior

Time for a change? Take your next professional step and work with us to shape innovation and growth in an exciting business environment!

Megamenü_2023_Karriere-5

Junior

Enough of grey theory - time to get to know the colourful reality! Start your working life with us and enjoy your work with interesting projects.

Megamenü_2023_Karriere-4-1

Students

You don't just want to study theory, but also want to experience it in practice? Check out theory and practice with us and experience where the differences are made.

Megamenü_2023_Karriere-3

Jobs

You can find all open vacancies here. Look around and submit your application - we look forward to it! If there is no matching position, please send us your unsolicited application.

Blog
NextLytics Newsletter Teaser
Sign up now for our monthly newsletter!
Sign up for newsletter
 

The right Data Visualization Tool: A comparison of Power BI & Tableau

In the data-driven era, Tableau and Power BI have gained significant popularity as data visualization and analytics solutions. Both are known for their ability to transform raw data into meaningful insights and share many similar functionalities. In this article we will compare these two applications and uncover the similarities that underpin their success. Moreover, we highlight the differences that give each platform its unique identity.

A short introduction to Tableau

Tableau was founded in 2003 but the first release was in January 2005 making it one of the early players in the modern data visualization landscape. Tableau was acquired by Salesforce in 2019. Tableau offers flexible licensing options to cater to various user needs and organisation requirements. Tableau as a software is a data visualization and business intelligence tool that is built to provide the end users the ability to analyse and explore large or complex data. Also a Tableau user has the opportunity to create dashboards and a variety of visualizations, including bar charts, line charts, pie charts, maps, and many more, which help users to gain insights from data. Drag and drop functionalities in key areas, such as data preparation, visualization building, and customization, allow for an intuitive user experience. This user-friendly approach is particularly beneficial for users without programming skills, enabling them to create visualizations effortlessly.

Tableau can connect to various data sources, such as spreadsheets, databases, big data platforms and others. Once the data is loaded, many operations like data cleaning, transformation tasks and the creation of custom calculations are available, as well as the option to filter data and create hierarchies. Another feature is the real time data visualizations with the help of Tableau’s server component. Tableau GPT offers a suite of capabilities that bring trusted generative AI to accelerate the speed at which insights are generated while reducing repetitive tasks for data analysts through intelligent suggestions and in-app guidance.

A short introduction to Power BI

Power BI is a business analytics and data visualization platform by Microsoft that aims to fulfil the needs in business analytics and data visualization of the market. The user interface is structured in a simple way, which flattens the learning curve a lot. Also there is no need for programming skills in order to use it. Power BI offers multiple data shaping actions, including data transformation, data cleaning, and custom calculations. It provides a diverse range of visualization options, such as charts, pies, maps, and histograms, allowing users to present insights effectively. Power BI can effortlessly load data from other Microsoft programs as well as from all popular database management systems. It is known for its capabilities in data modelling and analytics.

Similarities

Tableau and Power BI are both popular data visualization tools used for business intelligence and data analytics. The applications offer a very user-friendly UI with the opportunity to use the drag and drop functionality and require no previous knowledge of any programming language in order to use them. If the user wants to perform advanced and specific custom calculations or conduct advanced analytics and predictive tasks, both Power BI and Tableau provide the opportunity for the user to do so via code. Additionally, code integration can assist users in working with the API provided by both tools, allowing them to programmatically interact with the tools and perform various tasks, such as data refresh and dashboard publishing. 

Since Tableau and Power BI are visualization platforms, both of them allow users to create interactive and visually appealing data visualizations like charts, graphs, dashboards etc and it is also possible to create custom formulas and measures in order to perform various calculations. Also, both of them support connectivity to multiple data sources and are able to handle a wide range of data formats, databases, cloud services, and spreadsheets. Since both programs have a big community support, it is quite easy to find tutorials, resources, forums and solutions for problems that may arise. Both of them allow users to analyse and monitor up to date data since they offer tools for real time data processing.

PowerBI_Tableau_1_Data Visualization Tool


Self-Service Analytics with Tableau -
Download the whitepaper here!

Neuer Call-to-Action


Differences

Both Tableau and Power BI offer an on prem version and both of them offer a cloud based solution too. The Licensing options for both are role based or server based and in some scenarios even a combination of both. Both employ distinct pricing models, which can significantly impact overall costs and you need to pay attention to the details (see box below). 

A big advantage of Power BI is that it is easily integrated with all the Microsoft solutions like Excel, SharePoint, Azure, and SQL Server. This means that Power BI seems to be a better solution for companies that have already invested in the Microsoft ecosystem. On the other hand, a big advantage of Tableau is that it is better in processing large volumes of data, or data that is characterised by complexity.

When it comes to data preparation, Power BI offers Power Query which is not a standalone tool as it is integrated with Excel and Power BI. This tool also allows users to clean, transform, and reshape data before visualising it. The same work can be done in Tableau with the usage of Tableau Prep but Power Query Editor is considered to be better. Both of them, Power Query Editor and Tableau Prep, enable users to perform various data preparation tasks, such as data cleaning, joining, pivoting, aggregating, and creating calculated fields. When comparing the learning curve of both applications, it seems to be a bit smoother for Power BI due to its integration with other Microsoft programs. Last but not least, the factor of OS compatibility is an issue for Power BI since it is designed and developed for Windows. This is not an issue for Tableau which is a program that can run on Windows and Mac OS as well. A web based version of Power BI called Power BI Service is also available and of course it’s running on any OS. Also, Power BI is closely integrated with Azure as part of the broader suite of Azure solutions.

 

Power BI 

Tableau

Cost for role based Licence

Power BI Desktop : Free

Power BI Free : Free to view reports (only available for Premium capacity or on prem server)

Power BI Pro : 10$ per user/month

Power BI Premium per user: 20$ per user/month 

Power BI Premium per capacity (dedicated Server): 4,995$ per capacity/month

Remark: If you don’t have a Premium Capacity or on Prem server all users need to have Pro license weven if they only should / want to view a report 

Tableau Creator: 70$ per user/month

Tableau Explorer: 42$ per user/month

Tableau Viewer : 15$ per user/month

On Prem Server

Similar cost involved than Power BI Premium per capacity 

Role Based licensing and per core licensing available


Remark: If you need to run an on prem server and only have a few users (role based) then tableau can be a lot cheaper option as no server licence is needed

Performance

It is fast when it comes to not that big amount of data. The performance on bulk data is slow. 

It is fast when handling large volumes of data, and also has a lot of features for visualising the data.

Programming Support

Power BI supports integration with R, Python and with Power Query M language, which is a functional case-sensitive language that allows you to perform data shaping tasks and create custom functions. The Language DAX is supported to define logic at runtime of report, e.g. Key figures and restrictions.

Tableau provides a very good integration of code with the following languages : Python, R, C, C++ and Java. 

Data sources 

Power BI supports various data sources like

  • File data sources (Excel Workbook, Text/CSV, XML,JSON,Folder,SharePoint folder)
  • Database data sources (IBM Netezza, MySQL database,PostgreSQL, SAP HANA, Snowflake)
  • Power Platform data sources (Power BI datasets, Datamarts, Lakehouses)
  • Azure data sources (Azure SQL database, Azure Synapse Analytics SQL, Azure BLOB storage)
  • Online Services data sources (SharePoint online list,, Dynamic 365)
  • Other data sources (Spark, Hadoop, R and Python scripts, Google sheets )
  • SAP BW for import and live (limited use)

Tableau supports numerous data sources such as 

  • File data sources (Excel, Text files, JSON, PDF, spatial files)
  • Database data sources (Spark SQL, MySQL database,PostgreSQL, SAP HANA, Amazon Redshift, Google MongoDB, Snowflake)
  • Business Applications(Salesforce, Google Analytics, Microsoft Dynamics 365)
  • Statistical Files (SAS files, SPSS files, R data files)
  • Data Warehouse Appliances ( IBM Netezza, Teradata, Exasol)

Machine learning 

Power BI allows you to build machine learning models and make predictions. The training of the models can be done in Power Query Editor. Also, in Power BI, the Automated Machine Learning feature can be used. Furthermore Power BI benefits from Microsoft's suite of business analytics solutions, which encompasses platforms like Azure.

Tableau doesn't have built-in native machine learning capabilities like Power BI's AutoML feature but supports the feature of Python machine learning and thus the users have the ability to perform any machine learning operation over the datasets.

Toolset 

Power BI offers a comprehensive set of tools and features, but achieving certain solutions within Power BI it is not as readily accessible
or straightforward to achieve them as it is in Tableau and often require more effort and customization.  

Tableau provides a wide range of tools and features that encompass various data analysis, visualization, and reporting needs. 

Community 

There is the relatively new Power BI
Community Forum, which, despite being in its early years of existence, serves as a valuable resource for users seeking help and insights. Also, there is the Power BI Documentation in order to help the customers with problems
that maybe comes up. Generally you will find quite likely a solution to your problem in one
or the other place as there has been quite intensive adaption in the community. However sometimes rather simple things, like reporting on a P&L statement with configurable
groupings can be quite challenging to achieve with PowerBI.

A documentation site is available where the users can find information and instructions about Tableau. Also, as a program that is in use for more years than Power BI ,it has an even larger community. Furthermore, Tableau has the Tableau User Groups that are groups of users where regular meetings happen with guest speakers and the goals of these groups are to share knowledge with webinars where members can network, learn from guest speakers, share best practices and use cases. 

 

PowerBI_Tableau_2_Data Visualization Tool

Data Visualization Tools - Our Conclusion

Both Power BI and Tableau are powerful data visualization and business intelligence applications. Power BI stands out as an excellent option for organisations using Microsoft technologies due to its seamless integration with the Microsoft ecosystem. Its user-friendly interface and extensive data transformation capabilities further solidify its position as a top choice in this category.

On the other hand, Tableau's strength lies in its robust data discovery and interactive visualizations, making it an excellent solution for data analysts and scientists seeking advanced analytics capabilities. Tableau is also known for being a more premium offering with better dashboarding tools and greater scalability, albeit at a premium price. Both tools have their unique characteristics and the choice of which one should be chosen to work with is dependenting on the requirements and the existing technology ecosystem. Also, there are a couple of more options in the data visualization and business intelligence field, like Apache Superset and SAP Analytics Cloud (SAC). A comparison of those will be published in a new article.

Do you have questions about the features adressed in this article or other topics? Contact us! As a Tableau partner, we are happy to advise you extensively on topics such as best practices for creating effective dashboards.

Learn more about Tableau

, ,

avatar

Georgios

Georgios joined NextLytics in 2021 and he is working as a data engineer. He is mostly focused in technologies like docker, apache airflow, REST APIs and python programming. As a former national swimming champion, in his free time he likes to be active doing sports or hiking as well as doing barbeque with his friends.

Got a question about this blog?
Ask Georgios

Blog - NextLytics AG 

Welcome to our blog. In this section we regularly report on news and background information on topics such as SAP Business Intelligence (BI), SAP Dashboarding with Lumira Designer or SAP Analytics Cloud, Machine Learning with SAP BW, Data Science and Planning with SAP Business Planning and Consolidation (BPC), SAP Integrated Planning (IP) and SAC Planning and much more.

Subscribe to our newsletter

Related Posts

Recent Posts