Contents
Exercise 1. Download and setup Tableau......................................................................................................... 2
Exercise 2. Data visualization of election result. ............................................................................................... 3
Exercise 3. Data visualization for airline revenue. ............................................................................................ 7
Exercise 4. Data visualization for the online purchase. .................................................................................. 11
Exercise 5. Data visualization for Finance entities .......................................................................................... 14
Exercise 6. Data visualization for PC Sales. ................................................................................................... 18
Exercise 7. Data visualization of US cities population .................................................................................... 20
Exercise 8. Data visualization on the HHC facilities. ...................................................................................... 23
Exercise 9. Data visualization for the purchase of office supplies. ................................................................. 27
Exercise 1. Download and setup Tableau
What this exercise is about:
This exercise covers the following
1. Tableau Installation
What you should be able to do
At the end of this exercise, you should be able to:
• Download and install the Tableau from below link
https://www.tableau.com/products/desktop/download
Introduction
In this exercise will learn how to download the Tableau Desktop and install it in your local machine.
Requirements
Windows
Microsoft® Windows® 10, 8, 7, Vista, or XP sp3; or Server 2012, 2008, or 2003 (on x86 or x64
chipsets)
32-bit or 64-bit versions of Windows
Minimum of an Intel Pentium 4 or AMD Opteron processor 250 megabytes minimum free disk space
32-bit color depth recommended
Note: Internet Explorer 6 is not supported.
Mac
iMac (Mid 2007 or newer)
MacBook (Late 2008 Aluminum, or Early 2009 or newer)
MacBook Pro (Mid/Late 2007 or newer)
MacBook Air (Late 2008 or newer)
Mac mini (Early 2009 or newer)
OS X 10.8.1 or later (10.8.6 or later recommended)
2 GB memory
500 MB available disk space
Read more at https://www.tableau.com/products/desktop/download#KMp2QjLqSwQJL5Wr.99
At last check, Tableau is running successfully.
End of Exercise.
Exercise 2. Data visualization of election result.
The dataset provided gives information on the election results of Fairfax county.
Step 1. Open Tableau, and import the dataset.
Step 2. Insert the excel sheet 2012_RHFS_National_Tables_v3.0.xls
Open new sheet and visualize the data for different conditions.
Build the dashboard and insert the sheets.
End of exercise.
Exercise 3. Data visualization for airline revenue.
The dataset provided gives information on two different airlines. Bring out the data visualization for the
same.
Step 1. Import the dataset to tableau.
Step 2. Create a stacked column
End of exercise
Exercise 4. Data visualization for the online purchase.
The dataset provides information on the type of orders received and shipped. Bring out a data visualization
on the same.
Step 1. Import the dataset to tableau.
Step2. Spatial representation.
End of exercise.
Exercise 5. Data visualization for Finance entities
The dataset provides the information on various finance entities across US. Bring out the data visualization
for the same.
Step 1. Import the dataset.
Step 2. Perform the various visualizations.
End of exercise.
Exercise 6. Data visualization for PC Sales.
The dataset given, provides information on the Personal Vehicle globally. Bring out the data visualization of
the same.
End of exercise.
Exercise 7. Data visualization of US cities population
The dataset gives the information on the population of various cities across US. The census for the year
2010 and the estimate for the year 2015 is given. Bring out suitable visualizations.
Step 1. Import the dataset.
Step 2. Give the spatial visual representation
End of exercise.
Exercise 8. Data visualization on the HHC facilities.
The dataset gives the information on various health and hospitals corporation. Analyse an visualize the
data for the same.
Step 1. Import the excel dataset from Health_and_Hospitals_Corporation__HHC__Facilities
Dataset
\Facility type and Facility names with census track
Pstcode with Council and Community board
Borough with number of records
Facility type and Borough with number of records.
End of exercise.
Exercise 9. Data visualization for the purchase of office
supplies.
The dataset consists of the purchase of office supplies. Analyse the data and visualize the data suitably.
Step 1. Import the dataset from the excel file – OfficeSupplies
Datasets
Items ordered in the year 2014 & 2015 and its units
Items with units and unit price
Region and items with number of records
Region, Item and order with unit price
Dashboard
Story
End of Exercise.
