Tableau vs Power BI in 2024: A Comprehensive Comparison

Tableau vs Power BI in 2024: A Comprehensive Comparison Today, we’re diving into a hot topic: Tableau vs Power BI in 2024. As someone who holds the prestigious titles of Tableau Ambassador and Power BI Super User, I’m uniquely positioned to provide insights on this subject. Let’s explore these tools from a neutral perspective, using the latest Gartner Magic Quadrant report as our guide. The Gartner Magic Quadrant 2024 The Gartner Magic Quadrant provides a graphical representation of the positioning of various tools in the market. According to the 2024 report, Power BI is ahead of Tableau and other competitors. This shift is significant and worth exploring further. My Journey with Tableau and Power BI In 2024, we see more tools entering the leaders’ quadrant, which used to be dominated by Microsoft Power BI, Tableau, and Qlik. This increased competition is a challenge for Tableau. When it comes to job opportunities, a quick search reveals that there are 7,638 jobs for Microsoft Power BI in India, compared to 4,632 for Tableau. While not foolproof, this indicates a higher demand for Power BI skills in the current job market. https://youtu.be/ECyqr2WGLRY Choosing the Right Tool If you’re deciding between Tableau and Power BI, it’s essential to adopt a neutral perspective. Start by working with each tool for a week and see which one you enjoy more. Your preference will play a crucial role in your decision. However, if your company already uses a specific tool, your choice is made for you. Ease of Use For me, Tableau was easier to use, primarily due to concepts like addressing and partitioning, and the order of operations. These features allow you to perform complex calculations without writing extensive code. For example, calculating the percentage of total sales for different regions is straightforward in Tableau, thanks to its addressing and partitioning capabilities. In contrast, Power BI requires writing DAX for similar tasks. Innovation and Visualization Tableau offers more flexibility and innovation in visualizations. With its rows and columns shelves, you can create a wide range of visualizations, from area charts to Sankey diagrams. This flexibility is unmatched by Power BI, which tends to be more rigid in its visualization options. However, Power BI does offer unique visualizations like gauge charts, which require lengthy calculations in Tableau. Conclusion Both Tableau and Power BI have their strengths and weaknesses. Tableau excels in ease of use and flexibility, while Power BI offers unique visualizations and a higher demand in the job market. Ultimately, the best tool for you depends on your specific needs and preferences. Whether you choose Tableau or Power BI, mastering either tool will open up numerous job opportunities. Thank you for joining me on “Dancing with Data.” Stay tuned for more insights and comparisons in the world of data analytics! Ritesh Bisht Founder of Dance & Sing with Data “Ritesh is 2 times Tableau Ambassador & 1 time Power BI Super User from India and has been featured in the Top 15 Tableau & Power BI World Communities” Found me on: Linkedin Twitter Youtube Whatsapp

Reset Button – Tableau Vs Power BI

Bookmarks as a Reset Button -Power BI A bookmark records the current state of a report page. It includes the settings you’ve made to the filters, slicers, and visuals on that page. Once you customize the report page to your liking, give it a friendly name. You can now easily return to that state of the report page. When you click a bookmark, Power BI returns you to that view. Please click on the below pic to explore the full blog. Custom Reset button with Tableau While working with numerous filters, a reset button comes in helpful to rapidly return to the initial position or set of filters. With Tableau, you have to create a separate sheet over there itself and then use action. Please click the link below to download the reset button, and you can follow along with me while I also give you the test workbook. Please click on the below pic to explore the full blog. Ritesh Bisht Founder of Dance & Sing with Data “Ritesh is 2 times Tableau Ambassador & 1 time Power BI Super User from India and has been featured in the Top 15 Tableau & Power BI World Communities” Found me on: Linkedin Twitter Youtube Whatsapp

Tableau Vs Power BI – Rank within Partition

Due to its many uses, rank (or index in Tableau) is one of the most frequently used functions in both Tableau and Power BI. Once you are familiar with the fundamentals of either tool, you might come across the Rank() function. This video blog will demonstrate how to use Tableau and Power BI to rank data by category or division. To follow along with me, you can grab the data source from this page. Additionally, you are welcome to download the full solution workbooks from this page. Please be aware that my blogs are video-oriented, so watch the video attentively and make sure the written or typed information complements it. Here is a snapshot of the data source showing that each category has multiple subcategories, and we are only interested in displaying the top 3 categories in terms of sales. Below is the expected output for Power BI, Top 3 Sub-Categories under each category Below is the expected output for Tableau, Top 3 Sub-Categories under each category These rates apply to both Tableau Server and Tableau Cloud. For those seeking more advanced features, such as AI-powered analytics, Tableau’s premium package, Tableau+, might be a worthwhile investment. Starting with Tableau, please. To follow along with me, please watch the step-by-step solution video on the RHS. RANK(sum([Sales])) is the function that is being utilized here.  RANK(expression, [‘asc’ | ‘desc’]) Returns the standard competition rank for the current row in the partition. Identical values are assigned an identical rank. Use the optional ‘asc’ | ‘desc’ argument to specify ascending or descending order. The default is descending. For information on different ranking options, see Rank calculation. The idea of addressing and partitioning is one of the main distinctions between Tableau and Power BI; if you want to learn more about this idea, go on this link. https://youtu.be/s4U3rgaMCU0 Now let’s turn to Power BI video for step-by-step analysis.  RANKX serves a similar purpose for us. Rank = RANKX(                             all(Orders[Product Sub-Category]),                              CALCULATE( sum(Orders[Sales])),,DESC                           )  RANKX(<table>, <expression>[, <value>[, <order>[, <ties>]]]) https://youtu.be/ckR46zdNexk table Any DAX expression that returns a table of data over which the expression is evaluated. expressionAny DAX expression that returns a single scalar value. The expression is evaluated for each row of table, to generate all possible values for ranking. value(Optional) Any DAX expression that returns a single scalar value whose rank is to be found. When the value parameter is omitted, the value of expression at the current row is used instead. order(Optional) A value that specifies how to rank value, low to high or high to low: Skip The next rank, after a ties, the rank value of the tie plus the count of tied values. For example, if five (5) are tied with rank of 11 then the next value will receive a rank of 16(11+5) Dense The next rank value, after a tie, is the next value. For example, if five values are tied with rank of 11 then the next value will receive a rank of 12 Source I hope you were able to grasp how to rank within a partition as well as how Tableau and Power BI tackled the same issue in various ways from this video blog. As said above, I would advise you to familiarize yourself with the Tableau Addressing and Partitioning concept here, which is the key distinction between Tableau and Power BI in terms of this use case. For instance, with Tableau, there is a dedicated function for dense ranking (RANK_DENSE), whereas Power BI’s RANKX function can handle this, you can notice the last parameter of RANKX above. Since we wanted to first emphasize the fundamental concept, we have not explored the many versions of RANK in Tableau and Power BI. However, please expect another blog article on the same topic. Share Share Course Page Link Share on social media  Facebook  Twitter  Linkedin Ritesh Bisht Founder of Dance & Sing with Data “Ritesh is 2 times Tableau Ambassador & 1 time Power BI Super User from India and has been featured in the Top 15 Tableau & Power BI World Communities” Found me on: Linkedin Twitter Youtube Whatsapp

Tableau Vs Power BI – Grand Total Bar

It was difficult for me to go to Power BI and start again in that community as a previous Tableau Ambassador. Even though I now have the title of Power BI Super User, I had to start over there from scratch, putting my “Tableau Ambassador” ego to the side. I’d like to talk about one Tableau feature that Power BI should include today, and in the blog post after that, I’ll talk about how we can get Power BI to reflect the same functionality by using DAX functions When I first started using Power BI, I was perplexed by the lack of a Grand Total indicator, which seemed like a pretty basic requirement. https://youtu.be/2l7YOMxvDT0 Additionally, when you switch the table visual to a bar chart, the grand total simply disappears. We must construct a new table and execute calculations, oh, I mean DAX, to resolve this issue. For detailed instructions on how to create the same grand total bar with Power BI, please refer to the abovementioned video.  Please download the file from this location and follow along with me Step 1 In order to store all the areas together with a new row marked “Total,” we must basically establish a manual table called “Total Table.” Total Table =  UNION ( DISTINCT ( Orders[Region] ), { “Total” } ) Step 2 Once the table is established, make sure the Region column is used to establish the relationship between it and the Orders table.This is an important step which should not be overlooked Step 3 Total Sales Measure = VAR amount =     SUM ( Orders[Sales] ) RETURN IF (         ISBLANK ( amount ),         CALCULATE ( SUM ( Orders[Sales]), ALL(Orders) ),         amount  ) With the exception of Total, which is not a region and thus throws blank or null, the goal of step 3 is to essentially get the output as the original sum (Sales) wherever it finds a region. To handle this, use the CALCULATE (SUM (Orders[Sales]), ALL(Orders)) function, which modifies the filter context with ALL to throw the total sales across all regions.You can check my video on the ALL function here In order to maintain the equilibrium between the two titans, I’ll shortly begin my series on the transition from Power BI to Tableau. Share Share Course Page Link Share on social media  Facebook  Twitter  Linkedin Ritesh Bisht Founder of Dance & Sing with Data “Ritesh is 2 times Tableau Ambassador & 1 time Power BI Super User from India and has been featured in the Top 15 Tableau & Power BI World Communities” Found me on: Linkedin Twitter Youtube Whatsapp

Tableau Vs Power BI Cost

Without a question, the top two business intelligence and data analytics platforms now in use are Tableau and Power BI. The two are frequently contrasted, much like Federer and Nadal. Tableau stands out for its unique VizQL engine, which enables the no-code drag-and-drop interface, according to Gartner’s Magic Quadrant for Analytics and Business Intelligence Platforms 2022, while Power BI is well-liked for its features at an affordable price. The video on your RHS is just a lighthearted justification for Power BI winning out over Tableau as far as price is concerned The details shown below were directly derived from the Magic Quadrant study for 2022. https://www.tableau.com/reports/gartner https://youtu.be/aJk9ibdqVaQ Salesforce (Tableau) The Salesforce (Tableau) is a Leader in this Magic Quadrant. It offers a visual-based exploration that enables business users to access, prepare, analyze and present findings in their data. Tableau CRM, formerly Einstein Analytics, provides augmented analytics capabilities for analysts and citizen data scientists. In 2021, Tableau unveiled new Slack integrations and improved its NLQ experience, Ask Data, which is now included with all license types along with Explain Data. Ask Data can be added to a dashboard as an integrated object, and new Lenses allow analysts to curate existing datasets. Tableau improved enterprise capabilities by adding centralized row-level security and virtual data connections that enable users to extract and manage data tables. Strengths  Business user-centric: Tableau provides an intuitive experience for business users to visually explore their data. The patented VizQL engine powers the no-code drag-and-drop interface. The acquisition of Narrative Science, the data storytelling vendor, will improve Tableau’s NLG and data storytelling capabilities in the future. Analytics economy: Users demonstrate a fanlike attitude toward Tableau. The analytics ecosystem Tableau has built, the Tableau Economy, brings an expansive community of customers, partners and people with analytics skills. One hundred new accelerators were rolled out in the Tableau Exchange, and a “Hire Me” function was added to Tableau Public to help hire talent with Tableau skills. Salesforce ecosystem opportunity: A new revenue category, “Data,” will incorporate MuleSoft, Tableau, and Tableau CRM, all of which were previously included in “Platform and Other,” demonstrating Salesforce’s dedicated investment to data and analytics business as part of its ecosystem. Cautions  Premium pricing: Compared with cloud vendors in this market, Tableau’s license cost is expensive, an issue raised by clients durings inquiries with Gartner. Tableau Prep Builder is bundled with the Creator license. Additional fees are required for Data Management, Server Management and Einstein Discovery; however, a new enterprise subscription plan bundles Data Management and Server Management to help customers scale. Service and support: Gartner Peer Insights reviewers report Tableau slightly below the average when it comes to overall service and support, particularly related to the timeliness of the vendor’s response. Some Tableau customers are unclear about the process for finding the Tableau-specific support they expect. Additionally, although the support organization is not impacted, Tableau no longer has operations directly located in Mainland China, leaving regional customers concerned. Evolving Einstein Discovery experience: The process for building and deploying Einstein Discovery’s no-code machine learning models is disconnected from the Tableau user experience. Users are redirected to Tableau CRM Studio in Salesforce, where they must reconnect to their desired dataset to train a model and then manually map the fields used when training back to the fields used in Tableau. Plans to address this user experience are on Tableau’s 2022 roadmap. Microsoft Microsoft is a Leader in this Magic Quadrant. It has massive market reach and momentum through Office 365 and a comprehensive, visionary product roadmap. Microsoft Power BI offers data preparation, visual-based data discovery, interactive dashboards and augmented analytics. The new “goals” capability enables data-driven and collaborative tracking of key business metric scorecards. Power BI is primarily deployed as a SaaS option running in Azure, but offers a less-functional on-premises option in Power BI Report Server. Microsoft continues to align Power BI closely with Office 365, Microsoft Teams, Excel and SharePoint. In 2022, Microsoft’s vision is to make Power BI the hub for data and analytics in an organization. Strengths  Alignment with Office 365, Teams and Azure Synapse: The inclusion of Power BI in the Office 365 E5 SKU has provided an enormous channel for the platform’s spread. As many customers turn to Teams for remote work collaboration, the ability to access Power BI and now “goals” within the same Teams interface is a compelling integration for business users. Power BI and Azure Synapse alignment addresses multiple data and analytics personas and use cases. Price/value combination: Power BI does not sacrifice quality in order to achieve its disruptively low pricing model. The Power BI cloud service is rich in its capabilities, which include an enlarged set of augmented analytics and automated ML (autoML) capabilities. Power portfolio and product ambition: Microsoft has a clear vision for cross-utilization of Power BI, Power Apps and Power Automate to drive business value. Power Apps can be embedded in Power BI dashboards or access Power BI datasets, and Power Automate flows can be constructed to take various actions based on the data. AI-powered services, such as text, sentiment and image analytics, are available within Power BI Premium. Cautions  Gaps in on-premises capabilities: Compared with the Power BI cloud service, Microsoft’s on-premises offering lacks significant functional capabilities, including dashboards, streaming analytics, prebuilt content, natural language question and answer, automated insights, and alerting. Azure as the only deployment option: Microsoft does not give customers the flexibility to choose a cloud IaaS offering. While data connectivity enables multicloud and hybrid cloud scenarios, its Power BI service runs only in Azure. However, customers that utilize Azure can take advantage of the global reach and multigeography capabilities offered by Microsoft’s cloud platform. Content publication process and governance: Creating a process for promotion and publication of Power BI content can lead to a significant administrative overhead for customers. With a one-to-one relationship between published Power BI apps and Workspaces, organizations may be manually managing many hundreds of Workspaces — an issue Microsoft plans to address in its roadmap. How to govern self-service usage is one of the most common questions asked about Power BI by users of Gartner’s inquiry service.