Sunday 23 February 2020

What are the different Tableau Products?




The products are
  • ·       Tableau Desktop
  • ·         Tableau Online
  • ·         Tableau Server
  • ·         Tableau Mobile
  • ·         Tableau Prep
  • ·         Tableau server management
  • ·         Tableau Data Mangement
  • ·         Embedded analytics
  • ·         Tableau Reader


What are common file extensions in tableau Desktop?



  •        .TWB -Tableau Workbook
  • ·         .TDS-Tableau Data Source
  • ·         .TDE-Tableau Data Extract
  • ·         .TMS-Tableau Map Source
  • ·         .TPS-Tableau Preferences
  • ·         .TWBX-Tableau Packaged Workbook
  • ·         .TDSX-Tableau Packaged Data Source
  • ·         .TBM-Tableau Bookmark


What are the Categorize dimensions in Tableau?


There are 9 different Categorize dimensions

Slowly ever-changing Dimension: Value of the dimension changes over an amount of time for slowly ever-changing dimensions.
e.g: tudent of worker
Chop-chop ever-changing Dimension: Value in the dimension is rapidly changing for chop-chop ever-changing dimensions.
e.g:Age (It changes every second)
Junk Dimension: Junk values or unrelated dimensions are termed as Junk Dimension.
Conformed Dimension: If any dimension is provided by various business areas, then such a dimension is termed as Conformed Dimension.
e.g: Time (9-5) for any company or hospital or college
Degenerated Dimension: Degenerated dimensions have primary keys only without any matter info.
Unchanged Dimension: Values are constant for unchanged dimension.
e.g: Traffic Signals
Shrunken Dimension: Set of 1 dimension is termed as Shrunken Dimension.
e.g: A week is Shrunken dimension for the month
Inferred Dimension: Empty dimensions are called inferred dimensions. They are usually used in ETL.
e.g: Customer email which he may not enter while submitting any form will be filled as null.
Role enjoying Dimension: If one dimension is employed in multiple roles, then they are termed as Role enjoying Dimensions.
e.g: Date for e-commerce site order (Date of Order, Date of Shipment, Date of delivery)

Saturday 19 January 2019

What is a Published data source?


Published data sources are not all that simple to utilize. Various item defects or design oversights could have frustrated the appropriation of server-based data sources.

Publishing data sources to the server enable us to
  1. Centralize information sources
  2. Share them with all the validated clients
  3. Increase workbook uploading/publishing speed
  4. Schedule information update with described frequency

What is the diffrence between Aggregation and Disaggregation in Tableau?


Aggregation and Disaggregation in Tableau are the approaches to build up a scatter plot to look at and measure data values.

Aggregation Data:When you put a measure on a shelf, Tableau consequently totals the information, generally by summing it. You can easily decide the collection applied to a field because the capacity dependably appears before the field’s name when it is put on a shelf.

Disaggregating Data :Disaggregating your information enables you to see each line of the information source, which can be helpful when you are breaking down measures that you might need to utilize both freely and conditionally in the view.

Whata re the important features of Tableau?


Tableau provides solutions for all kinds of industries, departments, and data environments. Following are some unique features which enable Tableau to handle diverse scenarios.

Speed of Analysis :As it does not require high level of programming expertise, any user with access to data can start using it to derive value from the data.

Self-Reliant :Tableau does not need a complex software setup. The desktop version which is used by most users is easily installed and contains all the features needed to start and complete data analysis.

Visual Discovery :The user explores and analyzes the data by using visual tools like colors, trend lines, charts, and graphs. There is very little script to be written as nearly everything is done by drag and drop.

Blend Diverse Data Sets :Tableau allows you to blend different relational, semistructured and raw data sources in real time, without expensive up-front integration costs. The users don’t need to know the details of how data is stored.

Architecture Agnostic :Tableau works in all kinds of devices where data flows. Hence, the user need not worry about specific hardware or software requirements to use Tableau.

Real-Time Collaboration :Tableau can filter, sort, and discuss data on the fly and embed a live dashboard in portals like SharePoint site or Salesforce. You can save your view of data and allow colleagues to subscribe to your interactive dashboards so they see the very latest data just by refreshing their web browser.

Centralized Data :Tableau server provides a centralized location to manage all of the organization’s published data sources. You can delete, change permissions, add tags, and manage schedules in one convenient location. It’s easy to schedule extract refreshes and manage them in the data server. Administrators can centrally define a schedule for extracts on the server for both incremental and full refreshes.

What are the some file extension in Tableau?


There are many file types and extensions in Tableau.
Some of the file extensions in Tableau are:

  • Tableau Workbook (.twb).
  • Tableau Packaged Workbook (.twbx).
  • Tableau Datasource (.tds).
  • Tableau Packaged Datasource (.tdsx).
  • Tableau Data extract (.tde).
  • Tableau Bookmark (.tdm).
  • Tableau Map Source (.tms).
  • Tableau Preferences (.tps)