Tableau home page- 3 sections
Connect- to connect to data sources
Open- see prev files
Learn
Dimension- all text, geo, dates- all categorical data
Dimensions are discrete data- field with a list of values in it. It is blue pill
This creates row or columns wherever you put it and can select one entity
Measure- numbers, figures, float – all quantitative values (eg: cost price,
profit, discount). All measure are continuous by default
Continuous data- range of values (eg max and min and in between many
values)
It is green pill
This forms entire axis with range of values- you cannot select one
entity/value
# numerical
Abc- string
Globe- geographical
Calendar- date
T|F- Boolean
Clock- date and time
1st import the excel in data source- ut will list all worksheets
[Link] on one worksheet to make a connection
for color- drag and drop column to color
then edit color
Data binding:
1st data source – sample store 1
2nd data cource- super store
Import category, sub and sales from first
Only sales from second
Aggregate values- min, max etc
---------
Continuous values
Import category wise sales- click on sales and select convert to discrete
Again [Link] on sales (the color changes)
Splitting of columns in data source
Joins to combine columns
unions to combine rows
sort function
Rname the column, hide the column
Dimension- all text, geo, dates
Measure- numbers, figures, float
Tablaue automatically divides
ONE OF the most popular graphs is heat chart
Tree map
Functions:
1) Sets
2) Highlight – highlight one line in graph
3) Sorts
4) Device designer- design graph for particular phone tablet
Visualization:
1) Attentive- very much detailed required
2) Pre-attentive- easy to understand
Bar Graph:
It is used for comparative analysis/categorical-relative analsys
Pie chart: for composition analysys- what is your data composed of
To show shares, proportion , part to whole
Discrete Line graph- for summary graph
Here we have 2 sets of year, quarter, month etc
1st set Is discrete
2nd set is continuous
Continuous Line Graph- select 2nd set of options for detailed
analysis