Tableau 1

Question 1

Tableau architectural compnents

Answer 1

Tableau desktop ‘ authoring and publishing tool ‘ also used to connect to various data sources

Tableau server users to save collaborate share their work
Tableau Online similar to Tableau server cloud based version of scene
Tableau mobile uses to access Tableau dash board and reports from mobile devices
Data connectors: users to connect to various data sources like data base spreadsheets

Question 2

Interfaces of tableau

Answer 2

Workspace = where you create and design visualisations. These are tools to interact with data
Data pane: located on left side of the interface displays data source you have connected to
Canvas: main areas where you build your visualisation. Drag and drop from Data pane
Toolbar;contains tools to interact with your visualisation
Worksheet individual visualisation of charts. Dashboards allow you to combine multiple visualisation into a single canvas.

Question 3

Top charts in tableau

Answer 3

Depends on your specific requirements
I. Bar chart: effective for comparing categorical data- useful for visualizing ranking trends and comparison
2 line chart-ideal for visualising trends and patterns over time ag: stock trends
3. Scatter plot: to visualise relationship between 2 continuous variables. Identity correlation, clusters
4 pie chart: suitable for displaying proportion of diffecategories within single dataset ag: market share
5. Histogram: display the distribution of continuous variable by dividing it into bins and counting frequency within each bin

Question 4

Tableau

Answer 4

Powerful data visualisation and business intelligence software that allows users to connect, share and visualise data in a way that helps understanding and decision making

Question 5

Key features of Tableau

Answer 5

Data connectivity,
Data visualisation
Drag and drop interface
Real time analysis
Data preparation
Collaboration and sharing

Question 6

Various file types

Answer 6

1. Tableau Data source (TDS) = XML based file containing connection information to data source like database Excel
   2, packaged TDS (itdsx) = similar to TDS but contains the data itself so it can be sent to people without access to original data
2. Tableau extract c-hyper, -IDE) = local copy of data from data source stared in tableau format 4’ Tableau data connection (tdc) is an XML based file that contains custom connection settings for a data source,
3. Tableau book mark (tbm) contains a single worksheet or dashboard saved from Tableau workbook.

Question 7

Parameters

Answer 7

Dynamic controls that allow users to interactively change values,

Question 8

Key points about parameters in Tableau

Answer 8

1. Creation= Data pane» parameters set type and value
   . 2 use cases = various purposes: a) filtering data b. Changing dimension c setting reference d) controlling threshold
   3 default values
2. Integrated with calculations
3. Parameter control types= drop down list, sliders
4. Limitations = cannot be directly used in SQL and large datasets

Question 9

Grouping

Answer 9

Combine multiple values within a field into a single group
Useful for simplifying analysis, Create categories, aggregating data

Question 10

How grouping works in tableau

Answer 10

1. Create group: data pane » create → group
   Include specific values dick ok
2. Edit group: data panes → eat group
   Add/remove value and dick ok
3. Grouping by DataRange: Data Janes → create → bins
   4’ using grouped fields: will be shown as new dimension in Data pane* they can be dragged G dropped
4. Performance consideration: size and complexity is affected on performance

Question 11

How you can work with sets ‘in tableau

Answer 11

1, creating sets: create → set and define conditions
2- edit sets- Data panes → edit and modify condition
3. Dynamic sets VS fixed set
4 visualise set
5. Set in calculation
6. Combine sets = union, intersection