Tableau Tip: Quickest way to get a table into Tableau from Excel

by Hashu Shenkar

In this post I will be explaining how we can quickly copy a table from Excel into Tableau to perform ad-hoc analysis.

1) To begin, we need a table in Excel.

tablefromexcel

2) Copy the table then navigate to Tableau and simply press Ctrl+V to paste the table into your view. We now have the same table in Tableau to start some ad-hoc analysis.

tablefromexcel1

3) Create a new worksheet. Double click on Country, drag and drop Sales onto Color and change the color palette to Red-Blue Diverging, Reversed. MAGIC! Why view your sales by country in a table when you can see it on a map!

tablefromexcel2

 

Tableau: Filtering using the custom value list

2 mins read

Fri 21 Aug 2015

Tableau Tip: Formatting across worksheets

1 mins read

Thu 20 Aug 2015

Tableau Tip: Switch between views dynamically on a dashboard

4 mins read

Wed 19 Aug 2015

How to use the color picker to personalise/brand your visualisations

2 mins read

Tue 18 Aug 2015