Tableau vs. Power BI: My Two Cents

Azharuddin · ‎10-12-2017

Tableau picked a fight with Microsoft, posting a slideshow titled “10 Ways Power BI Falls Short”. Their ten criticisms were:

Power BI limits visualizations to 3,500 data points, which can lead to missing outliers.
Relatively simple calculations require learning Microsoft’s DAX scripting language.
Power BI has limited ability to do trending and forecasting.
Users are unable to “slice and dice” their visualization by more than two categories.
Power BI’s filtering capabilities are limited as there is no “keep only” option.
Users are unable to customize popup content by adding different dimensions and measures or changing formatting. With Power BI, you get what you get.
Power BI cannot group data together on the fly, forcing you to do your grouping ahead of time in data prep.
Users cannot use another person’s visualization as a starting point for making their own changes.
No story-telling capability.
Power BI does not allow the input of data on-screen, limiting users’ ability to perform what-if analyses.

Of course, Microsoft did not take this sitting down, almost immediately responding with their own top 10 list of features available in Power BI which are missing from Tableau (http://mspoweruser.com/microsoft-responds-to-tableaus-criticism-on-power-bi😞

Out-of-the-box content packs for dozens of data providers, making it easy for business users to connect to data
Dashboards that collect important visualizations from reports into what Netz called a “higher-level view.”
Natural-language queries to explore data and create new visualizations.
Enterprise-class SaaS BI, including connecting to on-premise data.
A data engine Microsoft says is 10 to 100 times faster than Tableau’s.
Community-created custom visualizations that use an open visualization platform (Tableau’s platform, Netz pointed out, is closed and proprietary).
Native integration with Cortana, Excel and real-time data feeds.
Automated quick insights.
Integrated ETL (extract, transform and load) tool.
A data model that supports large numbers of tables and more complex relationships between tables. “Tableau does not support more than trivial data models,” according to Microsoft’s emailed response.

My Evaluation

Clearly, Tableau Training is the market leader, but the fact that they are directly calling out Microsoft shows that there is some concern about Power BI. So, how close is Power BI to matching the capabilities of Tableau? How many of the above points are accurate and how many are simply overblown? I’ve seen a few comparisons of the products, but I figured the only way for me to really understand the pros and cons of each package is to analyze the situation myself.

I’ve written a number of blog posts over the past few months and many of the visualizations included in those posts were created using Tableau Public. So what better way to analyze the capabilities of Power BI than to attempt to replicate those visualizations with the Power BI. I should note here that my experience with Power BI is limited; I’ve played with the tool a bit and created some basic visualizations, but I’m definitely nowhere close to being an expert, so much of this analysis will be initial impressions and it’s likely I’ll miss something here or there. If so, feel free to let me know.

Maps

I decided to start with my “Nate Silver Challenge” election map. Tableau’s implementation of maps is far better than any other product I’ve worked with, so I was really curious to see how well Power BI handled them. The results were not bad. Take a look (note: I did not take the time to bring Alaska and Hawaii into the map):

So what did I find in this analysis? Here are a few observations:

Tableau uses the state name as a geographic identifier, but Power BI uses the state code. In my data set, this field was named “Code”, but I could not get Power BI to recognize it as a geographic entity until I physically named the field “State”. Strange, but an easy change, so no big deal.
In Tableau, you have lots of options to change the look and feel of a map. Power BI does not appear to have many such options. For instance, the maps show highways, which can be really distracting and often unnecessary. I could find no way to turn these off (though I should note that they do go away if you zoom out).
As noted in Tableau point # 6, I could not customize popups. For instance, I would have liked to put the state name on the popup instead of the code and would have liked to remove the “Count of Prediction” value from the popup, but the lack of customization capability prevented this.
Perhaps the most annoying issue was that the visualization automatically zooms to the level it feels appropriate. In my case, it ended up cutting off parts of the northwest, Texas, and Florida.
Finally, the maps take a bit of time to load whereas Tableau is almost instantaneous.

I then decided to get a little deeper with maps and attempt to recreate my county-level drug overdose map. This was a complete failure because of Tableau point # 1. The data set has information for 3,000+ counties for each year from 1999 to 2014, a total of over 50,000 data points. Because Power BI is limited to 3,500 data points, it only mapped some of the counties (seemingly in random fashion) and presented me with a small—so small, it’s easy to miss—warning in the top left corner. When I click on this warning, I get the following message:

Essentially, I am forced to filter my data in order to get it to properly display. I attempted to filter down to just one year, which should have resulted in less than 3,500 data points, but could not get it to work. This is very disappointing, but more importantly, could be very problematic to a visualization because it could, as Tableau noted, cause an analyst to miss outliers in the data set. It’s easily noticeable in my situation because of all the uncolored counties, but could be missed in a data set with say 4,000 data points.

Hierarchical Data

Next, I decided to recreate some of the visualizations in my post on visualizing hierarchies. In that post, I used religion data to create a treemap, a sunburst, and packed bubbles in Tableau. So, I attempted to recreate those in Power BI. Here are some observations:

The treemap was easy to create, just like Tableau, but Tableau point # 4 came into play as the treemap is unable to display any more than two levels at one time. Instead, Power BI forces you to “drill down” to see the next level.

The Sunburst (or radial treemap) I created in Tableau is not an out-of-the-box visualization. Instead, I used a template created by another developer, formatted my data in the right way, then created the visualization. This was a somewhat difficult process. But, with Power BI’s community-driven visualization gallery (Microsoft point # 6), I was able to download a sunburst visualization and use it just like standard visualizations. This definitely made it much easier to create a sunburst.

The results are not bad. It does seem to have some trouble understanding that the levels of the hierarchy are not consistent across the board (some have two levels, while others have three), but I think there is likely a fix for this that I am just yet to discover.

Packed Bubbles requires a community visualization as well, so I downloaded “Super Bubbles”.

I attempted to display all three levels in the hierarchy but it didn’t show anything. I then tried to display only the lowest level and was able to get bubbles, but no text and no popup information. Eventually, I chose just the first level and was able to get bubbles, text, and popup info. Granted, this is a community visualization, so it’s difficult to point at Microsoft for this issue.

I did see one interesting take on the bubble chart though, which is worth sharing. A community visualization called “Aquarium” creates animated fish, the size of which is based on some metric. So I used it with the religion data. Take a look at the video below to see it in action.

dkay84_PowerBI · ‎11-11-2017

Did you try using the Esri map vs the native Power BI map? That has way more customization options

v-ljerr-msft · ‎10-15-2017

Hi @Azharuddin,

Thanks for the sharing!

Regards