Tableau Tutorial For Beginners introduction

TABLEAU

1. Data Visualization

2. What is Data Visualization? edureka!

DATA
VISUALIZATION
Q Visualization allows us visual access to huge amounts
of data in easily digestible visuals.

Q Well designed data graphics are usually the

simplest and at the same time, the most powerful.

3. Power of Data Visualization edureka!

i) "
0 w
REN KEY x KEY. =
o an = E] . «= »
. «sl . au 3 . s% se
» za nam 2 . a .
sm s an , sm i
u m ns a su
ass “u a M . 7
.m . en ‘ . 3 »
4 4a) s 1 4 » m m tw
2 ma 2 sn 2 . ss « 7 =
7 4m 7 12% ? sm
z : - r »
ws [ame mst Re « 2.
10 | 900 70] 730 . .
un 208 20 . ‘
Anscombe's Quartet Dataset

When viewed in tabular format, all the four quartets look
similar Graphical Data Visualization

4. Scope of Visual Analytics edurekal

Scope of Visual

Analytics

5. Data Visualization edurekal

Integrate Different Data Sets Analyze Visualize

6. Why Tableau?

7. Why Tableau? edurekal

8. What is Tableau?

9. What is Tableau? edureka!

Q Tableau is a Software company which produces interactive data visualization products focused
on business intelligence.

Q Tableau helps the world's largest organizations unleash the power of their most valuable assets:
their data and their people.

Q Allows the customers to spend more time on data analysis and less on "data wrangling”.

10. Tableau Architecture

OHO

11. Tableau Architecture edureka!

eb & Mobile Users

|

12. Installing Tableau

&

13. Installing Tableau

edureka!

ar a

14. Understanding Tableau

En

15. Tableau UI - Connections edureka!

We can connect to multiple file
formats and servers in Tableau

[ee Coe

La

16. Tableau UI - Connections edurekai

ee tae tte Hy

We have connected to an Excel
m Sheet “Sample - Superstore”

This is the Dashboard once we
load data into Tableau Desktop

A preview of the data

17. Tableau Datatypes edurekal

December 31.2016 |
Icon | Data type 01:00:00 AM !
Text (string) values el ARA .
Date values

Date & Time values

Numerical valves

Boolean values
Geographic values

#OD E

h
| New York, France, |
| India, Beijing |

® =

18. Tableau Desktop UI edurekal

Tableau Dashboard

19. Tableau UI - Dimensions & Measures edureka!

Once we connect to a data source in
Tableau, the columns get divided into
Dimensions and Measures.

A Dimension is a field that is an
independent variable.

A Measure is a field that is a Dependent
Variable and its value is a function of one
or more Dimensions.

20. Tableau UI - Show Me edureka!

Show Me in Tableau shows all the possible
visualizations available for our data source.

The visualizations that are highlighted are
the ones that are currently available for the
current selection of dimensions and
measures.

21. Visualizations in Tableau

22. Tableau - Visualizations

12 J I" "1
1 a . & il a
Pit gry pereyy = "iii

Bar Graph

Line Graph Dual Axis Graph

23. Tableau - Visualizations edureka!

Get ical Area Gi with Dual Axes
og!

24. Tableau - Visualizations edureka!

25. Tableau - Visualizations edurekal

Tree Map

26. Tableau - Applying Visualizations

Let us discuss which visualizations are the best for various applications

Visi
Bar Graph
Line Graph
Dual Axis Graph

lization

Geographical Graph
Area Graph — Dual Axes
Heat Map

Tree Map

Application
Used when Dimension is discontinuous
Preferred for continuous Dimensions
Used to represent two Measures together
Used to plot Measures on geographical map
Provides better comparison amongst Measures

Used to visualize variations across categories

Used to represent quantity in nested rectangles

27. Functions in Tableau

28. Tableau - Join & Union edureka!

Join and Union functions are used to perform operations to combine data

Join — Combine Columns Union — Combine Rows

Table A Table B

El: 50-000) BI+IM-
- + =

Sn SR SES

29. Tableau - Sort

edurekai

Sort function can be used to sort categories and sub categories based on their measure

Connery

1

m
I

su cto

y

30. Tableau - Set edureka!

Set is a type of filter where we can set a condition for displaying values, e.g. Discount > 10% ]

= = 2 be Eesssstenssstussestenseninsnnstnnittiseten
I Ünenssesstensesnstsnsessessnsensegontsnnsen
in E susvateetenzecsoanensenzestenzez: h Ñ

7 PPPOE Ep Pp

31. Tableau - Forecasting edureka!

Forecasting is used to predict the future trend based on the current values of graphs

el

Maren Date 2L] Maret re Dat 2] Ma nD [204] Mae ner Date (2015)

32. Tableau - Data Granularity

Marks
D squire +
# © @
Cour | Sue Late
2 Q
Detst Tootte

Sales

SUMAProfit)

[64,083

258,568

edurekai

We have connected to an Excel Sheet |
"Sample - Superstore”

This is the Dashboard once we load
data into Tableau Desktop

33. Tableau - Highlighting

edureka!

Highlighting is used to highlight specific sub categories among all others

Accessories
Appliances
Ar
Binders
Bookcases
Chairs
Copiers

34. Tableau - Device Designer

Device Designer is used to make best visualizations for specific devices

Stow exo we

35. Practical Demo

36. IMDb Movie Data - Flow Diagram

(==)

Huge amount of

Input Data into
Tabieau

Insight 1

Insight 3 insight 4

Predict Movie | How doos Facebook’
based on Actors,
¡ense and Directors

Campaign aftect
Movie Sales?

_edureka!

A tableau

Compare Gross &

Creating
Visualizations:

(Matching Predict
with Actual Box
Office Numbers

y —

37. Tableau Success

38. Companies using Tableau edurekal

Google

50,000+ Tf] D OU LE
citibank au

Customers

Gre WORLD BANK & © XBOX $ Ferrari

Deloitte. IM Y, Ehe New York Times
= Stanford
A Adobe | University I pepsi

BankofAmerica 7 (duo Skype]

39. Tableau - Success Stories

edureka!

Deloitte.

“Tableau is changing the game for us. It's reduced the time
that they have to spend on lower-value-add activities.”

— Ryan Renner, Deloitte

A

ONE KINGS LANE

“It increases our sales; it decreases our costs. There's a direct
impact. It just gets you insight faster,”

- Geraldine Niemczyk, One Kings Lone

NE AR

“You have crafted a powerful analytical tool for us. Thank
you“

~ Alan Benjamin, Cinemark

“The impact was dramatic. That's why we feel good about
completely redoing the way we do analytics. This is going to
help EOS and analytics to the next level.”

— Maile Hadley, Equal Opportunity Schools