"Just creating a picture, anybody can do that. For us the picture is the means of communicating the data and a way of asking questions of the data," Ajenstat said.
The Power BI motto, meanwhile, also emphasizes ease-of-use and speed: "Five minutes to wow."
So what are the differences? Tableau criticizes Power BI because:
- Outliers can be lost in large data sets due to the 3,500-data-points limit
- It's difficult to do even simple calculations within Power BI, such as creating a percent-of-total variable, without learning the DAX language
- There's limited built-in trends and no forecasting (using R within Power BI might address some of this concern, but users would need to learn/know R and it's no longer a point-and-click platform)
- Users can't "slice and dice" data by more than two categories
- Pop-up menus can't be fully customized
- Data can't be grouped on the fly
- Someone else's dashboard can't be used as a starting point for additional analysis
- It's difficult to add narratives to dashboards in order to "tell a story"
- And it's difficult to explore what-if scenarios due to inability to input/change data directly into a Power BI dashboard
Microsoft responded with what it sees as its advantages, including:
- 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.
Ultimately, though, Ajenstat doesn't believe the friction between Tableau and Power BI will affect Tableau's larger partnerships with Microsoft outside of the Power BI platform. Tableau "integrates deeply with Azure," Ajenstat noted, and was part of the SQL Server 2016 launch. And, of course, data in Excel can be pulled into Tableau.
The "list of places where we're working together is dramatically bigger than places where we overlap," he said. "We live in this world of 'co-opition.' ...For a customer, that just means choice. "
As platforms race to out-perform their competitors, those choices should continue to get more robust.
Sign up for CIO Asia eNewsletters.