Tableau Quiz2

1- ZN(expression) is

   a.  Return (expression) if it is not null, otherwise return zero
   b.  Return (expression) only if zero
   c.  Return (expression) if null
   d.  None

Ans - a

2- Javascript API is used in Tableau
    a.  To integrate tableau visualizations into your web applications
    b.  To schedule the data extract
    c.  To automate the data integration
   d.  None
Ans- a

3- Single axis show multiple measures and all the marks are shown in a single pane. This concept is known as....  ?
   a.  Dual Axis
   b.  Blended Axis
   c.  Multiple axis
   d.  None
Ans- b

4- Parameters can be used as-
   a.  Filters
   b.  Calculated field
   c.  Actions
   d.  Measure swap
   e.  Auto update
   f.   Dimensions
Ans-  a,b,d,f


5- In tableau sorting can be done via below methods.
   a.  Alphabetic
   b.  Data source order
   c.  Manual
   d.  Field
   e.  Index
Ans- a,d,e

6- URL action is
    a.  A hyperlink that points to another sheet
    b.  A link that points to another dashboard
    c.  A hyperlink that points to a web page, file,  or another web-based resource outside of Tableau.
Ans- c

Tableau Quiz

1-   Tableau allows -
      a. both live connection and data extraction
      b. only live connection
      c. only data extraction
      d. None
Ans- a

2-  Tableau allows direct connection to the database for fetching data
     a. True
     b. False
Ans- a

3-  The data elements of a data source are divided into the following within Tableau Desktop-
     a. Dimensions
     b. Measures
     c. A and B
     d. None
Ans- c

4- Data from excel files can be directly accessed via Tableau?
     a. True
     b. False
Ans- a

5- For a 64 -bit Tableau Server what is required
   a. 2 core, 4GB RAM
   b. 4 core, 8GB RAM
   c. 8 core, 16GB RAM
   d. 16 core, 64GB RAM
Ans- d

6- How many Max tables can we join in tableau?

   a. 256
   b. 64
   c. 32
   d. 16

Ans- c

7- How many types of annotations used in tableau?
   a. 5
   b. 7
   c. 3
   d. 2
Ans- c

8- Multiple values can be selected in filters?
  a. True
  b. False
Ans- True

Tableau Quiz2

Data Blending

Data blending is used when we use data from more than one data source in a single workbook. Data blending is based on the common dimension used to join both databases. Two data sources used in data blending are referred to as a primary data source and secondary data source. A small chain image appears next to the common dimension between both data sources. Data blending is used to combine data from one data source with column data from another data source in a single table.

Why data blending is useful over join-

1- Data is at different granularity.
2- Data is not supported by cross-database join

Tableau Data Extract

Tableau data extract (.dte) Stores tableau data as a filtered and aggregated extract. TDE files are data extracted from external sources such as MS Access or Excel. It is used for external data.  This data can be text,  numerical, or statistical data. 

TDE extracts are Tableau's method of caching data logically to reduce database hits for frequent access reports. TDE extract can be refreshed manually through the Tableau desktop or can be scheduled for periodic refresh through the enterprise edition.

Tableau Packaged Workbook

Tableau packaged workbook contains the Tableau package and extracted local data. The packaged workbook also includes background picture and customized settings in a workbook.
The main purpose of a packaged workbook is to share it with other Tableau Desktop users, who do not have data access. These users can modify the workbook also.
Tableau Reader user can also use packaged workbook but they can't modify it.

The workbook is not connected to original data source and images. It is saved with a .twbx file extension.