||The user interface is easy and intuitive with a ‘Show Me’ feature which proposes to the user the ideal visualizations available for the data being analyzed. It offers great control in formatting the charts for readability. The user interface also includes ways to roll up charts into Dashboards and what are called Stories. This helps tell the data story by presenting dashboards and charts alongside telling captions.
||Power BI offers a click-button method of adding visualizations to your canvas with drag and drop capabilities for adding dimensions, measures, and filters to the chart. It also includes the ability to define your own chart using R. Power BI originated from the Power Query, Power Pivot, Power View, and Power Map Excel add-ins.
||Tableau offers desktop and on premises as well as Tableau Online versions of the software.
||Power BI integrates seamlessly with the Microsoft stack with Power BI Desktop and Online. Hosting can be done on premise or in Microsoft Azure cloud.
||Tableau Specifications supports many hundreds of data connectors including relational, online analytical processing (OLAP), and big data options like Hadoop, NoSQL, as well as cloud options. The data blending of these different sources is actively supported as of version 10.0. For a more detailed list of data sources, view Tableau Specifications.
||Power BI is catching up to Tableau in the data connectivity area by expanding the number of sources to which the user can connect. It allows users to connect to files, databases, Microsoft Azure databases, and online services like Google Analytics and Salesforce. For a more detailed list of data sources, view Data Sources in Power BI.
||Tableau allows users to create 24 different types of baseline visualizations, including bar and line charts, heat maps, tree maps, scatter plots, geospatial plots, and more. Tableau boasts an interface that does not require the user to know how to code in order to be able to create complex and sophisticated visualizations. It also offers:
- No limits when it comes to the number of datapoints in the analysis
- One-click filtering, sorting, and grouping
- Detailed tooltips
- Stories which are akin to presentations that incorporate dashboards
- The ability to ask “What if” questions of the data
- On-the-fly data cluster analysis
|Power BI also allows users to create circa 27 different types of baseline visualizations with just the click of a button. It covers the bases of allowing for bar and line charts, heat maps, tree maps, scatter plots, and geospatial plots. It also offers:
- The ability to build visualizations by asking queries using natural language (via Cortana personal digital assistant) with Power BI Online
- Includes Azure Machine Learning in the suite which can allow users to develop predictive models
- Can create custom visuals using R.
- Can use DAX to create custom measures/formulas
- Exceptional custom visualizations are available onlineSome limitations of Power BI are:- No ability to forecast. Forecasting must be done using Microsoft Excel.
- There is a 3,500 datapoint limit which can lead to automatic filtering of outliers.
||Tableau workbooks can be shared with all users that have a license within the organization.
||Dashboards and reports can be published to Power BI Online. Power BI also offers the capability of creating a Content Pack, which is a set of Reports, Dashboards, and Databases that can be distributed to others in the organization and locked for editing. Users can save the Content Pack locally and work on analysis without impacting the original version. For groups working together, there is an ability to work from a custom workspace.
||Tableau is the 3rd largest average deployment size of the vendors at 1,927 users and, as such, boasts quite a large community as well as a plethora of learning resources. There are online tutorials and courses as well as classroom-based training. Tableau’s user conference was attended by over 10,000 people in 2015.
||There is a very active community around Power BI and many learning resources as well, including online tutorials, an active Youtube channel, community support, conferences, and documentation. Microsoft often relies on user feedback to drive the Power BI roadmap, and often releases features based on the community demand. The community can be accessed at community.powerbi.com. There is also a custom visual development community at app.powerbi.com/visuals/info
Tableau Desktop Professional: $1,999 per user
Tableau Server: Contact Tableau for pricing
Tableau Online (Hosted version of Tableau Server): $500 per user, per year
Power BI Home is free.
Power BI Pro costs $9.99 per user, per month
Power BI Pro comes free for organizations with Office 365 (E5) and Cortana Analytics Suite