1 names and their relevant data in Excel

1         
Visualizing
Data through Tableau:-

 

Ø 
Make
data set in Excel file. For example column names and their relevant data in
Excel File.

We Will Write a Custom Essay Specifically
For You For Only $13.90/page!


order now

Ø 
Open
the Tableau and go to the file Menu.

Ø 
Go
to the “Open” option in file menu and select the desired excel file with
specified path.

 

 

 

Ø 
 The tableau will open the data set from excel
file and will display it.

 

 

Ø 
Go
to worksheet and design the visualization. Design a question and drag the
dimension in Columns (Tableau) and
measures in the Rows (Tableau). And
the tableau will highlight the available graphs that can be made by the given
question. For example,

QUESTION: – How many honor code certificates a particular course title have?

The
graphs within the yellow boundary can be made for the above question. So the
users can select the suitable graph for their questions.

 

 

2         
Types
of Graphs:-

1)     
Text
Table (Crosstab)                                           

2)     
Heat
Map

3)     
Highlight
Table

4)     
Symbol
Map

5)     
Filled
Map

6)     
Pie
Chart

7)     
Horizontal
Bar Chart

8)     
Stacked
Bar Chart

9)     
Side-by-Side
Bar Chart

10)  Treemap

11)  Circle
View

12)  Side-by-Side
Circle View

13)  Line
Charts (Continuous & Discrete)

14)  Dual-Line
Chart (Non-Synchronized)

15)  Area
Charts (Continuous & Discrete)

16)  Scatter
Plot

17)  Histogram

18)  Box-and-Whisker
Plot

19)  Gantt
Chart

20)  Bullet
Graph

21)  Packed
Bubbles

3         
Creating
Bertin Variables and Perceptual Coding Elements Using Tableau:-

 

3.1        
Visualizing
Graph

Ø  First
Design a question. For example:-

QUESTION:
– How many honor code certificates
are received by the instructors for a specific course title in HardwardX?

Ø  When
we 1st make a graph from the given data.

The graph seems so much confusing
because of  huge amount of data. Which
will create clutters and confusion for the users. So to make it easy for the
users to easily view data and quickly draw conclusions. Tableau gives us the
option to sample our data to make it displayable according to the available window
and remove the slider which will distract the user.

 

3.2        
Filtering
Graph

Ø  So
perform sampling on the given data.

1)     

First move the to the column names in the “Columns” tableau.
For example go to Institution.

2)      Right
click in “Institution”. And it will open a new window with available options.
Then Click on Filter.

 

 

3)      Then
after clicking on “Filter”. It will open a new window.

 

Then unchecked some options and
checked the required option to get the desired graph. For example, I want to
see the data related to institution (HarwardX), so I checked on this option and
unchecked the other option.

4)      Then
Click “Ok” or “Apply Button” to perform filtering. Similarly we can do
filtering for other columns and rows too.

 

Ø  So
after sampling the above data, the graph will seem like:-

 

3.3        
Coloring
Graph

Ø  Now
to make the graph more attractive for the viewers, we can use bertin variables
to do it. For example, showing the circles in different colors.

1)      Go
to the “Color” option at the left side of the graph. Drag the required column
or row in the “Marks” Option. Then click on the “Color” option and then Click
on “Edit Color”. For example, I drag the “Course Title”.

 

2)      Then
After clicking on the “Edit Color” button. Tableau open a new window for
changing the color of “Course Titles”. After selecting the desired color for
the “Course Title”. Click “Ok” button or “Apply’ button.

Ø  Then
after applying coloring, the graph seems more attractive and easily
understandable. The pink color show the course title “Computer Science” and the
green color shows the course title “Science, Technology”.

3.4        
Labeling
Graph

Ø  We
can also label the circle to make data easily and accurately readable for the
users. To do it drag the “instructor” from the columns and drop it to the
“Label” option in the marks. So after labeling the graph will seem like:-

 

 

3.5        
Conclusion
of Filtering, Coloring, Labeling

Ø  So
after doing filtering, labeling and coloring, we get the following bertin
variables and perceptual coding :-

§ 
Position

§ 
Size

§ 
Value

§ 
Color

§ 
Semantic
Zoom

§ 
Details
on Demand

§ 
Output
to Input

§  Immediate Feedback

 

Ø  We
can also change the shape and size of the circle using the tableau when
required to make our visualization more precise and accurately displayable.

4         
Tableau
Features:-

Ø  Sorting
(In Ascending order Or Descending Order)

 

Ø  Displaying
Column Date (Either in Sum, Or Maximum, or Minimum etc)

5         
Story
Boarding

 

In
Tableau, a story is a sequence of visualizations that work together to
convey information. We can create stories to tell a data narrative, provide
context, demonstrate how decisions relate to outcomes, or to simply make a
compelling case.

 

5.1        
Creating
Story

Ø  Click
on the “Story” option from the top menu bar. It will open a new window.

Ø  It
will display all the Sheets at the left of the new window. Drag the desired
sheet in the middle of the window. Add caption.

 

 

6         
Dashboard

 

A
dashboard is a consolidated display of many worksheets and related information
in a single place. It is used to compare and monitor a variety of data
simultaneously. The different data views are displayed all at once.

 

6.1        
Creating
Dashboard

Ø  Click
on the “Dashboard” option from the top menu bar. It will open a new window.

Ø  It
will display all the Sheets at the left of the new window. Drag the desired
sheets in the middle of the window. Adjust all the sheets according to the
window.

 

 

 

 

 

1         
Visualizing
Data through Tableau:-

 

Ø 
Make
data set in Excel file. For example column names and their relevant data in
Excel File.

Ø 
Open
the Tableau and go to the file Menu.

Ø 
Go
to the “Open” option in file menu and select the desired excel file with
specified path.

 

 

 

Ø 
 The tableau will open the data set from excel
file and will display it.

 

 

Ø 
Go
to worksheet and design the visualization. Design a question and drag the
dimension in Columns (Tableau) and
measures in the Rows (Tableau). And
the tableau will highlight the available graphs that can be made by the given
question. For example,

QUESTION: – How many honor code certificates a particular course title have?

The
graphs within the yellow boundary can be made for the above question. So the
users can select the suitable graph for their questions.

 

 

2         
Types
of Graphs:-

1)     
Text
Table (Crosstab)                                           

2)     
Heat
Map

3)     
Highlight
Table

4)     
Symbol
Map

5)     
Filled
Map

6)     
Pie
Chart

7)     
Horizontal
Bar Chart

8)     
Stacked
Bar Chart

9)     
Side-by-Side
Bar Chart

10)  Treemap

11)  Circle
View

12)  Side-by-Side
Circle View

13)  Line
Charts (Continuous & Discrete)

14)  Dual-Line
Chart (Non-Synchronized)

15)  Area
Charts (Continuous & Discrete)

16)  Scatter
Plot

17)  Histogram

18)  Box-and-Whisker
Plot

19)  Gantt
Chart

20)  Bullet
Graph

21)  Packed
Bubbles

3         
Creating
Bertin Variables and Perceptual Coding Elements Using Tableau:-

 

3.1        
Visualizing
Graph

Ø  First
Design a question. For example:-

QUESTION:
– How many honor code certificates
are received by the instructors for a specific course title in HardwardX?

Ø  When
we 1st make a graph from the given data.

The graph seems so much confusing
because of  huge amount of data. Which
will create clutters and confusion for the users. So to make it easy for the
users to easily view data and quickly draw conclusions. Tableau gives us the
option to sample our data to make it displayable according to the available window
and remove the slider which will distract the user.

 

3.2        
Filtering
Graph

Ø  So
perform sampling on the given data.

1)     

First move the to the column names in the “Columns” tableau.
For example go to Institution.

2)      Right
click in “Institution”. And it will open a new window with available options.
Then Click on Filter.

 

 

3)      Then
after clicking on “Filter”. It will open a new window.

 

Then unchecked some options and
checked the required option to get the desired graph. For example, I want to
see the data related to institution (HarwardX), so I checked on this option and
unchecked the other option.

4)      Then
Click “Ok” or “Apply Button” to perform filtering. Similarly we can do
filtering for other columns and rows too.

 

Ø  So
after sampling the above data, the graph will seem like:-

 

3.3        
Coloring
Graph

Ø  Now
to make the graph more attractive for the viewers, we can use bertin variables
to do it. For example, showing the circles in different colors.

1)      Go
to the “Color” option at the left side of the graph. Drag the required column
or row in the “Marks” Option. Then click on the “Color” option and then Click
on “Edit Color”. For example, I drag the “Course Title”.

 

2)      Then
After clicking on the “Edit Color” button. Tableau open a new window for
changing the color of “Course Titles”. After selecting the desired color for
the “Course Title”. Click “Ok” button or “Apply’ button.

Ø  Then
after applying coloring, the graph seems more attractive and easily
understandable. The pink color show the course title “Computer Science” and the
green color shows the course title “Science, Technology”.

3.4        
Labeling
Graph

Ø  We
can also label the circle to make data easily and accurately readable for the
users. To do it drag the “instructor” from the columns and drop it to the
“Label” option in the marks. So after labeling the graph will seem like:-

 

 

3.5        
Conclusion
of Filtering, Coloring, Labeling

Ø  So
after doing filtering, labeling and coloring, we get the following bertin
variables and perceptual coding :-

§ 
Position

§ 
Size

§ 
Value

§ 
Color

§ 
Semantic
Zoom

§ 
Details
on Demand

§ 
Output
to Input

§  Immediate Feedback

 

Ø  We
can also change the shape and size of the circle using the tableau when
required to make our visualization more precise and accurately displayable.

4         
Tableau
Features:-

Ø  Sorting
(In Ascending order Or Descending Order)

 

Ø  Displaying
Column Date (Either in Sum, Or Maximum, or Minimum etc)

5         
Story
Boarding

 

In
Tableau, a story is a sequence of visualizations that work together to
convey information. We can create stories to tell a data narrative, provide
context, demonstrate how decisions relate to outcomes, or to simply make a
compelling case.

 

5.1        
Creating
Story

Ø  Click
on the “Story” option from the top menu bar. It will open a new window.

Ø  It
will display all the Sheets at the left of the new window. Drag the desired
sheet in the middle of the window. Add caption.

 

 

6         
Dashboard

 

A
dashboard is a consolidated display of many worksheets and related information
in a single place. It is used to compare and monitor a variety of data
simultaneously. The different data views are displayed all at once.

 

6.1        
Creating
Dashboard

Ø  Click
on the “Dashboard” option from the top menu bar. It will open a new window.

Ø  It
will display all the Sheets at the left of the new window. Drag the desired
sheets in the middle of the window. Adjust all the sheets according to the
window.

 

 

 

 

 

1         
Visualizing
Data through Tableau:-

 

Ø 
Make
data set in Excel file. For example column names and their relevant data in
Excel File.

Ø 
Open
the Tableau and go to the file Menu.

Ø 
Go
to the “Open” option in file menu and select the desired excel file with
specified path.

 

 

 

Ø 
 The tableau will open the data set from excel
file and will display it.

 

 

Ø 
Go
to worksheet and design the visualization. Design a question and drag the
dimension in Columns (Tableau) and
measures in the Rows (Tableau). And
the tableau will highlight the available graphs that can be made by the given
question. For example,

QUESTION: – How many honor code certificates a particular course title have?

The
graphs within the yellow boundary can be made for the above question. So the
users can select the suitable graph for their questions.

 

 

2         
Types
of Graphs:-

1)     
Text
Table (Crosstab)                                           

2)     
Heat
Map

3)     
Highlight
Table

4)     
Symbol
Map

5)     
Filled
Map

6)     
Pie
Chart

7)     
Horizontal
Bar Chart

8)     
Stacked
Bar Chart

9)     
Side-by-Side
Bar Chart

10)  Treemap

11)  Circle
View

12)  Side-by-Side
Circle View

13)  Line
Charts (Continuous & Discrete)

14)  Dual-Line
Chart (Non-Synchronized)

15)  Area
Charts (Continuous & Discrete)

16)  Scatter
Plot

17)  Histogram

18)  Box-and-Whisker
Plot

19)  Gantt
Chart

20)  Bullet
Graph

21)  Packed
Bubbles

3         
Creating
Bertin Variables and Perceptual Coding Elements Using Tableau:-

 

3.1        
Visualizing
Graph

Ø  First
Design a question. For example:-

QUESTION:
– How many honor code certificates
are received by the instructors for a specific course title in HardwardX?

Ø  When
we 1st make a graph from the given data.

The graph seems so much confusing
because of  huge amount of data. Which
will create clutters and confusion for the users. So to make it easy for the
users to easily view data and quickly draw conclusions. Tableau gives us the
option to sample our data to make it displayable according to the available window
and remove the slider which will distract the user.

 

3.2        
Filtering
Graph

Ø  So
perform sampling on the given data.

1)     

First move the to the column names in the “Columns” tableau.
For example go to Institution.

2)      Right
click in “Institution”. And it will open a new window with available options.
Then Click on Filter.

 

 

3)      Then
after clicking on “Filter”. It will open a new window.

 

Then unchecked some options and
checked the required option to get the desired graph. For example, I want to
see the data related to institution (HarwardX), so I checked on this option and
unchecked the other option.

4)      Then
Click “Ok” or “Apply Button” to perform filtering. Similarly we can do
filtering for other columns and rows too.

 

Ø  So
after sampling the above data, the graph will seem like:-

 

3.3        
Coloring
Graph

Ø  Now
to make the graph more attractive for the viewers, we can use bertin variables
to do it. For example, showing the circles in different colors.

1)      Go
to the “Color” option at the left side of the graph. Drag the required column
or row in the “Marks” Option. Then click on the “Color” option and then Click
on “Edit Color”. For example, I drag the “Course Title”.

 

2)      Then
After clicking on the “Edit Color” button. Tableau open a new window for
changing the color of “Course Titles”. After selecting the desired color for
the “Course Title”. Click “Ok” button or “Apply’ button.

Ø  Then
after applying coloring, the graph seems more attractive and easily
understandable. The pink color show the course title “Computer Science” and the
green color shows the course title “Science, Technology”.

3.4        
Labeling
Graph

Ø  We
can also label the circle to make data easily and accurately readable for the
users. To do it drag the “instructor” from the columns and drop it to the
“Label” option in the marks. So after labeling the graph will seem like:-

 

 

3.5        
Conclusion
of Filtering, Coloring, Labeling

Ø  So
after doing filtering, labeling and coloring, we get the following bertin
variables and perceptual coding :-

§ 
Position

§ 
Size

§ 
Value

§ 
Color

§ 
Semantic
Zoom

§ 
Details
on Demand

§ 
Output
to Input

§  Immediate Feedback

 

Ø  We
can also change the shape and size of the circle using the tableau when
required to make our visualization more precise and accurately displayable.

4         
Tableau
Features:-

Ø  Sorting
(In Ascending order Or Descending Order)

 

Ø  Displaying
Column Date (Either in Sum, Or Maximum, or Minimum etc)

5         
Story
Boarding

 

In
Tableau, a story is a sequence of visualizations that work together to
convey information. We can create stories to tell a data narrative, provide
context, demonstrate how decisions relate to outcomes, or to simply make a
compelling case.

 

5.1        
Creating
Story

Ø  Click
on the “Story” option from the top menu bar. It will open a new window.

Ø  It
will display all the Sheets at the left of the new window. Drag the desired
sheet in the middle of the window. Add caption.

 

 

6         
Dashboard

 

A
dashboard is a consolidated display of many worksheets and related information
in a single place. It is used to compare and monitor a variety of data
simultaneously. The different data views are displayed all at once.

 

6.1        
Creating
Dashboard

Ø  Click
on the “Dashboard” option from the top menu bar. It will open a new window.

Ø  It
will display all the Sheets at the left of the new window. Drag the desired
sheets in the middle of the window. Adjust all the sheets according to the
window.

 

 

 

 

 

x

Hi!
I'm Mack!

Would you like to get a custom essay? How about receiving a customized one?

Check it out