Excel Analytics

Bring Your Analytics to a Completely New Level with Tableau Desktop and Microsoft Excel

Tableau customers regularly state that tasks that take hours in Excel are completed in minutes with Tableau – typically a 10x productivity improvement.

Taylor Hawes, Microsoft's Controller for Global Platforms said it well, "At Microsoft, we use Excel spreadsheets and Pivot Tables to perform detailed analysis. However, Tableau has enabled us to bring analytics to a completely new level."

Award-winning graphing and charting software for faster reporting and dashboards. No deployment. No waiting. Just incredible ROI.

Download Free Trial

Tableau Features You'll Love

instant access & no limitations

Tableau can access and display unlimited amounts of data. We have customers that analyze 10’s of billions of rows of data. Create pivot tables with unlimited number of rows, columns, members, and cells. Excel has many limitations in all these areas that confound even simple analysis. Just connect and go!

safety

How much confidence do you have that everything is correct with your data in excel? Did someone delete something or change a value by accident? Do the formulas account for all the data? With Tableau there is complete safety. The underlying data is not changed, the formulas are universal – they are always correct, if you make a mistake, simply use the unlimited undo feature. Explore with freedom.

beauty

The default charts and graphs created by Tableau adhere to best practices in visualization. This means that the formatting, colors, axes and other aspects of the views are already beautiful – there is no need for mass manipulation of the defaults to get a stunning result. Even better, if you decide that ‘Cust._Sta_Loc’ should be called ‘Customer State’, Tableau will update it everywhere it is used, on every label, axis, legend, and possible place it is presented.

visual analysis

Excel allows you to plot the results of your analysis but Tableau actually helps perform better analysis. The entire process is visual so you get the benefits of the clean, simple presentation of a chart at every step along the way. This encourages data exploration and allows people to understand the data instead of just presenting a report.

dates

Take a simple date: ‘12/25/2008’ and Tableau automatically will roll it up to years, quarters, months, day of the week, etc. No need to have multiple fields or complex calculations. Fiscal months? No problem, adjust with a click.

table calculations

A hidden gem within Tableau. How do you calculate Year over Year growth? It’s a simple click with Tableau. What about Quarterly growth? Click to drill down on dates. Done. What about growth rates for every state/ Product/ Customer? Simple, drag it into the view. As a bonus, simply filter to show just the items with positive growth. It’s that easy. Total elapsed time: 5 seconds.

grouping that really works

Simply click on the items that belong together and ‘Group’. Groups can fix data errors (‘Cali’ and ‘CA’ and ‘California’ should all be the same thing), create new roll-ups (Products into Product bundles, States into Regions), or segment the data. The best news is that groups are easy to create, modify and completely reusable – even in different workbooks connected to different data!

drill through

Want to see what the original data is behind a bar, line or cell in a table? Tableau automatically enables drill through to the raw data with a right click. This filtered, sortable detail data is instantly available to allow you to find data anomalies, additional details or other micro trends in the data.

maps

Maps are very common for analysis and presentation. Where are your best customers? How are regional sales? Tableau makes them simple beyond compare. Double click on a State field and a map appears with your data displayed. Zoom in, add pie charts on the map, drill to zip codes etc. No programming, hunting for maps, linking to other data. It just works.

guided analysis

Tableau allows you to package an entire set of analysis – including the process of analysis – into a single file that can be opened with free Tableau Reader. Arrange the results in a dashboard and provide interactive controls that allow users to sort, filter, drill down or even provide a path for users to navigate through the data to find the cause of interesting points, outliers or other anomalies. All this without programming, macros, writing SQL or anything more than drag and drop, and some occasional typing to provide names for things.

dashboards & templates

Dashboards in Tableau are easy. Just drag and drop the views you've built into an interactive workspace. Combine views from different data sources, filter, highlight, and link across multiple views in one dashboard. You can also embed dashboards in a browser or portal like Microsoft SharePoint. The best part is you can take all your analyses, views, and dashboards and reuse them with new data. Simply edit the connection information and point Tableau at the new data and all the analysis is automatically re-run using that new data.

collaboration & web-based analytics

Sharing analyses and dashboards is simple with Tableau. From copy/paste to exporting to PowerPoint, PDF and other applications, you'll immediately impress your colleagues. Save as a packaged workbook for users of our free Reader application. Publish to Tableau Server to deliver web-based analytics. All with beautiful formatting and annotations.

Download Free Trial