Excel Charts and Graphs

Excel’s ubiquity for data analysis is undeniable. But creating charts and graphs in Excel can be slow, frustrating and limited. Tableau equips you to:

  • Use a drag & drop approach for visual analysis that is easy and fast
  • Explore data iteratively to ask and answer questions as you go
  • Create interactive charts and reports that let you drill-down in real-time for answers
  • See trends & outliers you can’t identify in spreadsheets or basic charts
  • Analyze as much data as your project requires
  • Never create charts and graphs in Excel with a wizard again!
Charts & Maps
Add maps to your arsenal to answer the question “where”

In your daily life it’s almost impossible NOT to know your location. Maps are common when we pick up our phones, check a website or get in our car, and more data now includes location information.

With Tableau, Excel charts and maps are quick and easy to create, so asking “where” gets much easier. Tableau automatically recognizes geolocation data and from there detailed maps are a click away.

This visualization features a U.S. information about obesity trends. Open it up and click on a state that interests you. Note how selecting "Florida" from the drop-down box acts as a filter for the other charts in the dashboard. Without Tableau, time and data constraints would have otherwise relegated this data to a spreadsheet.

Excel Dashboards
Create Excel dashboards quickly for any audience

Dashboards should not be relegated to the executive suite. Any time you have two or more pieces of related analysis, you’ve got cause for a dashboard. But creating dashboards in Excel is a long and painful process. And if you’ve ever tried to update one with new data, you know that Excel dashboards can be fragile and finicky.

Not anymore. Creating dashboards in Tableau is a snap. Using the same intuitive, drag & drop ease of creating individual charts, dashboards are created quickly so that you can see your related analysis in one place.

This video shows how you can create an entire dashboard –compelling charts, global filters and intuitive legends – in minutes. So whether you’re working in a team of one or communicating with a group of one hundred, Tableau let’s you easily create dashboards to better understand your business.

Ad-hoc Analysis
Quickly and easily get more from your data

You typically know what you need your data to show. This month’s financial performance. Next quarter’s forecast. A new product’s pricing model. But when you have a hunch there’s more in your numbers than what a pivot table shows, you need a way to investigate your data to discover what else it can tell you about your opportunities.

Tableau lets you dig into Excel data quickly and intuitively to create insightful visualizations. With an easy-to-use interface and built-in visual analysis best practices, you can drill into your information and reveal possibilities you never considered.

Explore this visualization of a monthly sales report and experience how quickly you understand which industries account for pipeline opportunities and the sales reps driving them home.

Data Blending
Combine data sources easily for comprehensive analysis

Picture this. You’ve been using Tableau to analyze sales data. The map and sales performance charts hinted at something significant: low profitability of a product category that is especially bad in two regions. Could shipping costs be responsible? The shipping data is available, but resides in a flat file. Without considering these two data sets together, it is difficult and time intensive to know for sure.

Tableau makes it easy to add new data sets –from another Excel workbook, a database, or flat files– and automatically blends them using common fields. Check out this four-minute data blending video that demonstrates the speed and ease with which you can blend data from different sources.

Combine PowerPivot calculation power with visual best practices

PowerPivot is great for business users who want robust calculations on large amounts of data without relying on IT. But while the analytical muscle of PowerPivot is great, its visual impact is limited. Unleash the wow factor that can be created by combining Power Pivot data analysis with Tableau visual analysis.

Tableau’s deep integration with PowerPivot means you can work with PowerPivot files from Excel or from SharePoint. Tableau easily consumes DAX expressions created in PowerPivot and puts you in the driver’s seat to create robust, meaningful visualizations of the data to extend your analysis. With no limits on the amount of data it can consider, Tableau can let you investigate your PowerPivot analysis in a fundamentally different way with visualizations.

This visualization shows millions of rows of tick-by-tick data for the DJIA that’s easy to understand, using big data and represents complex analysis on millions of data points at once. Select an industry, mouse over the graphs and see the results.

non-humans click here