10/28/2021

Tableau interview questions and answers for experienced professionals

 

Tableau Interview Questions and Answers for experienced professional

1. What is TABLEAU?

Tableau is the powerful and fastest visualizing tool that is used in the Business Intelligence(BI) Industry. It simplifies the raw data into an understandable format. Analysis of the data becomes faster with Tableau. The visualizations can be created in the form of dashboards. The visualizations or diagrammatic representation of data can easily be understood by the employees of the organizations who are at different levels.

2. List out Tableau File Extensions.

The below ones are few extensions in Tableau:

  1. Tableau Workbook (.twb)
  2. Tableau Data extract (.tde)
  3. Tableau Datasource (.tds)
  4. Tableau Packaged Datasource (.tdsx)
  5. Tableau Bookmark (.tbm)
  6. Tableau Map Source (.tms)
  7. Tableau Packaged Workbook (.twbx) – zip file containing .twb and external files.
  8. Tableau Preferences (.tps)

Define different connection types in Tableau?

There are 2 connection types available in Tableau.

Extract: Extract is a snapshot of data that will be extracted from the data source and put into the Tableau repository. This snapshot can be refreshed periodically fully or incrementally. This can be scheduled in Tableau Server

Live: It creates a direct connection to the data source and data will be fetched directly from tables. So, data will be up to date and consistent. But, this also affects access speed.

Define fact and dimensions?

Facts are numeric measures of data. They are stored in fact tables. Fact tables store that type of data that will be analyzed by dimension tables. Fact tables have foreign keys associated with dimension tables.

Dimensions are descriptive attributes of data. Those will be stored in the dimensions table. For example, customers’ information like name, number, and email will be stored in the dimension table.

What are the different Joins in Tableau?

Tableau works the same as SQL. So, it supports all Joins possible in SQL

  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Inner Join

What is Tableau Reader?

Tableau Reader is a free desktop application, where you can read and interact with the Tableau packaged workbooks. It can only open the files but cannot create new connections to the workbook.

Define Page Shelf in Tableau?

Page shelf breaks the views into a series of pages. It displays an alternate view on each page. Due to this feature, you can analyze the effect of each field on the rest of the data in the view.

What is published data and embedded data sources?

The published data source contains connection information that is independent of workbooks and can be used by multiple workbooks.

The embedded data source contains connection information but it is associated with the workbooks.

Differentiate parameters and filters in Tableau

Filters are the simpler and straightforward feature in Tableau. It applies to dimensions or measures directly. For example, to only show Gujarat or Karnataka in a State dimension, we can apply the filter on that. In Tableau, there are multiple UI options available for filters like radio buttons, drop-down lists, checkboxes, sliders, and more. Filters on sheets are also available in Tableau.

Parameters are like variables. They are complex and more powerful. Like a variable, a parameter can be used in calculations. So, that means, it only allows a single value. Parameters have the same UI options except for checkboxes because checkboxes don’t have a single value. For example, we can create a parameter for interest rate and period, and then we can use these parameters to calculate interest and principal payments.

Different types of filters are available in Tableau?

Filters are used to provide the correct information to viewers after removing unnecessary data. There are various types of filters available in Tableau.

Extract Filters – Extract filters are used to apply filters on extracted data from the data source. For this filter, data is extracted from the data source and placed into the Tableau data repository.

Datasource Filters – Datasource filters are the same as extract filters. They also work on the extracted dataset. But, the only difference is it works with both live and extract connections.

Context Filters – Context Filters are applied on the data rows before any other filters. They are limited to views, but they can be applied on selected sheets. They define Aggregation and Disaggregation of data in Tableau

Dimension Filters – Dimension filters are used to apply filters on dimensions in worksheets. Dimension filters are applied through the top or bottom conditions, formula, and wildcard match.

Measure Filters – Measure filters are applied to the values present in the measures.

Differentiate between Tiled and Floating in dashboards?

In a tiled layout, items don’t overlap. The layout will be adjusted according to dashboard size. In the floating layout, items can be placed on some other layers. Floating items can have fixed positions and sizes.

What is Data Modelling?

Data modeling is the analysis of data objects that are used in a business or other context and also used as identification of the relationships among these data objects. It is the first step of doing object-oriented programming.

Differentiate discrete and continuous data roles in Tableau

Discrete data roles consist of values that are separate and distinct. Discrete data roles can take individual values within a range. For Example – cancer patients in the hospital, no. of threads in a sheet, state. Discrete values are displayed as blue icons in the data window and blue pills on shelves. Discrete fields can be sorted.

Continuous data roles consist of any value within the finite or infinite intervals. For Example – age, unit price, order quantity. Continuous values displayed as green icons in the data window and green pills on shelves. Continuous fields cannot be sorted.

Extract or Live connection, which one is better?

Extract connection is better than live connection because extract connection can be used from anywhere, anytime without connecting to the database. We can construct our own visualizations on it irrespective of the database connection.

What are Calculated Fields?

A Calculated Field is a user-created field that can include operations on other fields that are present in the data. A calculated field does not impact the original data but rather creates a new field that contains the results of the operations conducted on the data.

What is the difference between a TWB and a TWBX file?

A TBW file is the basic Tableau file, which contains instructions regarding how Tableau interacts with a particular source of data. However, the data source needs to be attached separately and placed at an appropriate location for Tableau to interact with it. A TWBX file is a Tableau package, which contains the entirety of the data to be analyzed as well as the analysis.

What is a blended axis?

Very often, in Tableau, you may need to present multiple graphs in the same Cartesian plane. These graphs may have to be derived from different measures. You can do so with a blended y-axis. The caveat to incorporating a blended axis is that the unit and scale of the two measures must be the same.

What are Groups in Tableau?

A Group in Tableau is a collection of categories that can be used to create a single overarching subcategory. An example can be considered from the Superstore data set, in which several different product subcategories are present. You can create a group of any number of these subcategories and create a single category for analysis.

What is the difference between a Heat map and Treemap?

TreeMap Heat MapIt represents the data hierarchically and shows them as a set of nested rectangles. It represents the data graphically which uses multiple colors to represent different values. It is used for comparing the categories with colors, size, and it can also be used for illustrating the hierarchical data and part to whole relationships. It is used for comparing the categories based on color and size. And also it is great in spotting the patterns based on the density of the information. The colors and size of rectangles are respective to the values of the data points When their values are higher or density of records, the data will represent in dark color.

Define some ways to improve the performance of Tableau

  • Use an Extract to make workbooks run faster
  • Reduce the scope of data to decrease the volume of data
  • Reduce the number of marks on the view to avoid information overload
  • Try to use integers or Booleans in calculations as they are much faster than strings
  • Hide unused fields
  • Use Context filters
  • Reduce filter usage and use some alternative way to achieve the same result
  • Use indexing in tables and use the same fields for filtering
  • Remove unnecessary calculations and sheets

Define Dual-axis?

Dual-axis is used to show 2 measures in a single graph. It allows you to compare 2 measures at once. 

What is context filters in Tableau?

Whenever we set a context filter, Tableau generates a temp table that needs to refresh each and every time, whenever the view is triggered. So, if the context filter is changed in the database, it needs to recompute the temp table, so the performance will be decreased.

Define LOD Expression?

LOD Expression stands for Level of Detail Expression, and it is used to run complex queries involving many dimensions at the data sourcing level.

 

Tableau - Create Custom Color Palettes

Tableau provides several color options to visualize the data into different chart forms where a lot of color options are available already and if we need to add more colors then we can customize the color palettes where Tableau Desktop comes with color palettes that have been carefully designed to work well together and effectively apply color to data in many situations, such as on maps, heat maps, bar charts, etc. You can also create and use your own custom color palettes by modifying the Preferences.tps file that comes with Tableau Desktop.

The Preferences.tps file is located in your My Tableau Repository. The file is a basic XML file that you can open in a text editor to modify. An unedited preferences file looks like this:

we can add as many custom palettes as you like to your Preferences.tps file, each with as many colors as you want. When we modify Preferences.tps to add colors, use the standard HTML format for the new colors (hexadecimal value #RRGGBB or Red Green Blue format). When you save the workbook and restart Tableau Desktop, the color palette names you added to Preferences.tps appear in the Select Color Palette drop-down list (Edit Color dialog). You can use a new palette like you would any other.

Tableau doesn't test or support custom color palettes, so be sure to back up your workbooks before you continue. Also, there is no guarantee that custom color palettes you create will work with future Tableau Desktop upgrades.

When you edit your Preferences.tps file, be sure to use straight quotation marks (' ' or " ") to delimit the palette name and type, not curly quotation marks (“ ” or ‘ ’).

To edit your preferences file:

  1. Go to the My Tableau Repository folder in your Documents directory, and open the Preferences.tps file.

  2. Between the opening and closing workbook tags, insert opening and closing preferences tags.

For more options to modify the preferences file:

https://help.tableau.com/current/pro/desktop/en-us/formatting_create_custom_colors.htm


Query to find all the Stored Procedures (SP) which are related to one or more specific tables.

In some scenarios, we need to identify the dependency of particular tables for stored procedures.

The below query will help to find all the Stored Procedures (SP) which are related to one or more specific tables.

----Option 1

SELECT DISTINCT so.name

FROM syscomments sc

INNER JOIN sysobjects so ON sc.id=so.id

WHERE sc.TEXT LIKE '%TableName%'


----Option 2

SELECT DISTINCT o.name, o.xtype

FROM syscomments c

INNER JOIN sysobjects o ON c.id=o.id

WHERE c.TEXT LIKE '%TableName%'

9/27/2021

Mostly asked Tableau Interview questions for Beginner and experienced professionals


Below are mostly asked Tableau questions for the interview which will help you to stand out in your Tableau interview and to get the best jobs as a Tableau Developer, Tableau Solution Architect, Tableau Analyst, etc.

What are different Tableau products?

What is Tableau Data extract in Tableau?

Data Joining techniques in Tableau?

What is the Difference Between Joining and Blending?

What are measures and dimensions?

What are continuous and discrete field types?

What are the different types of joins in Tableau?

What are data connections in Tableau?

What is a blended axis?

How to create a donut chart in a tableau?

What is the difference between a tree and a heat map?

What are extracts and Schedules in the Tableau server?

What is a TDE file in Tableau?

How Can You Display the Top Five and Bottom Five Sales in the Same View?

What is the difference between a TWB and a TWBX file?

Approach to increase Performance in Tableau?

What is Hierarchy?

Table Calculation – Running Total, Percentile?

What is a User filter?

How to Implement Row-level security?

What are Groups and how do they differ from sets?

What type of filters is in the tableau? Table, Context, Extract, Data Source, Dimension, and Measure

How to set alternate row background color in tableau?

What is the Use of Dual-axis?

Have u developed calculated fields in tableau? what will be the expression to get the month name from the order date which is 9/2/2020?

What are the differences between Dashboard and Story in tableau?

What is the LOD function? Any example where u have applied LOD function?

How Can You Embed a Web Page in a Dashboard?

What is the Datetrunc function in Tableau?

how to customize the color palette in tableau?

 -----------------------------------------------------------------------------------------

Stay tuned for more real-time interview questions!

Thanks!

 

 

 

 

 

 

 

9/26/2021

Mostly Asked Interview Questions For Data Engineer, Data Analyst, BI Engineer and Data Science

 Most Asked Interview Questions For Data Engineer, Data Analyst, BI Engineer, and Data Science

In this post, I am sharing a list of the most asked questions in the interview for Data Engineer, Data Analyst, BI Engineer, and Data Science.

Must Read: SQL-server-day-today-mostly-used functions

- Data Types:

    Small Int

    Int

    Big Int

    Float

    Decimal

    Money

    Char

    Varchar

    Nvarchar

    Text

    Binary

    Image

    Date

    DateTime

    Timestamp

    Bit

Functions:

    Scalar Functions: Operate on a single value and then return a single value. Scalar functions can be used wherever an expression is valid.

        UCASE()

        LCASE()

        MID()

        LEN()

        ROUND()

        NOW()

        FORMAT()

    Aggregate Functions: Aggregate functions perform a calculation on a set of values and return a single value.

        Min

        Max

        Avg

        Count

        Sum

        Mod

        First

        Last

    Analytical Functions: Analytic functions compute an aggregate value based on a group of rows.

        First_Value

        Last_Value

        LAG

        Lead

        Percentile_Cont

        Percentile_Disc

        Percentile_Rank

    Ranking Function: Ranking functions return a ranking value for each row in a partition.

        Rank    

        Row_Number

        Dense_Rank

        NILE

    String Function: The string function return a value to perform some operations on the string value.

        Substr

        CharIndex

        PatIndex

        Replace

        Left

        Right

        LTrim

        RTrim

        Len

Date Functions: Date functions are used to perform some operations on the date value.

    DateAdd

    DateDiff

    DatePart

    DateName

    Year

    Month

    Getdate()

- What is @@Error?

- Difference between DDL, DML, and DCL.

- What type of clause in SQL?

    Ans: Where, Group BY, Order By

- What is Constraint in SQL?

- Difference between  Temp variable, Temp Table?

- Difference between Local Temporary Tables and Global Temporary Tables?

- How we can schedule a job in SQL Server?

    Ans: SQL Server Agent

- What is NOLock?

- What type of joins do we have in SQL?

- What are Logical Joins and Physical Joins?

- Difference between Inner Join and Left Join?

- What is Cross Join?

- What are Cross Apply and Outer Apply?

- Difference between Functions and Stored Procedure?

- Difference between the Delete table and the Truncate table?

- Difference between Varchar() and Nvarchar()?

- Difference between Cast and Convert?

- Difference between View and CTE?

- What is Indexed View?

- Can we Insert or update in views?

- What is Index in SQL and type of Indexes in SQL?

- Difference between Primary Key, Foreign Key, and Unique Key?

- What is Database Partitioning?

- What are Triggers in Database?

- What is Window Functions?

- Difference between Having and Group By?

- What is an Execution Plan?

- what are IN-memory Tables?

- What is Always on?

- What Is Data Encryption?

- What is the difference between ISNULL, NVL, and Coalesce?

Scenarios based Questions:

- How to improve the performance of slow-running queries?

OR

- Define approaches to tune the queries and improve the performance?

- How to calculate the running total?

- Find 3rd highest salary from the employee table?

- From the employee table, show the manager of each employee?

- Implementation of Joins for a given data

- How to remove duplicates from the table?

- How do get the latest order for each customer?

- Show highest-paid and Lowest paid employee from each Department

- Top five highest selling products from each product category in past one quarter?


Stay tuned for more details.

Thanks for your visit!







   



        

    

    



7/23/2021

SQL Server day-to-day mostly used functions - String, Aggregate, Window, Date Functions in SQL

 SQL Server day-to-day mostly used functions - String, Aggregate, Window, Date Functions in SQL

CAST() – This function is used to convert an expression of one data type to another. The CAST function is used to convert a data type without a specific format.

          Syntax – CAST(Coulmn_Name, Data_Type)

SELECT CAST(1234, INT)

CONVERT()This function is used to convert and formatting data types at the same time.

          Syntax – CONVERT(Data_Type ,Coulmn_Name, Format_TYPE)

SELECT CONVERT(Varchar,GateDate(), 111) FROM Table_Name

SUBSTR()This function extracts a substring from a string (starting at any position).

          Syntax SELECT SUBSTRING(‘ABCDEF'13)

STUFF()The STUFF function inserts a string into another string. It deletes a specified length of characters in the first string at the start position.

          Syntax – SELECT STUFF('ABCDEF', 2, 3, 'IJKL')

REPLACE() – This function is used to replace an existing specified string value with another string value of all occurrence.

          Syntax – SELECT REPLACE('ABCDEFGHI','EFG','LMN')

RTRIM()This function removes trailing spaces from a string from the right side.

          Syntax – SELECT RTRIM(' ABCDEF ')

LTRIM() - This function removes trailing spaces from a string from the left side.

          Syntax – SELECT LTRIM(' ABCDEF ')

LEFT() – This Function extracts a number of characters from a string (starting from left)

          Syntax – SELECT LTRIM('ABCDEF', 3)

RIGHT() – This Function extracts a number of characters from a string (starting from right).

          Syntax – SELECT RIGHT('ABCDEF',3)

CHARINDEX() – This Function is used to searches for a substring in a string and returns the position.

          Syntax – SELECT (CHARINDEX('CDEF', 'ABCDEFGH'))

PATINDEX() – This Function is used to get starting position of a pattern by using wild characters in the pattern.

          Syntax – SELECT (PATINDEX('%CDEF%', 'ABCDEFGH'))

ISNULL() – This function is used to specify how we want to treat NULL values.

Syntax – SELECT ISNULL(Column_Name, Specified_value) FROM Table_Name

COALESCE() – This function is used to handle null value from multiple arguments, and always returns first non-null value.  

          Syntax – SELECT COALESCE( NULL, ‘ABC’, ‘DEF’)

NVL() – This Function converts a null value to an actual value. Data types that can be used are date, character, and number.

          Syntax – SELECT NVL(ColumnValue, 0)

UCASE() – This function is used to convert the column value into upper case.

Syntax – SELECT UCASE(Column_Name) FROM Table_Name

LCASE() – This function is used to convert the column value into lower case.

Syntax – SELECT LCASE(Column_Name) FROM Table_Name

MID() – This Function extracts a substring from a string (starting at any position).

          Syntax SELECT MID(‘ABCDEFGH’43)

LEN() – This function calculates the number of characters of an input string.

          Syntax – SELECT LEN(‘ABCDEFGH’)

ROUND() – This Function rounds a number to a specified number of decimal places.

          Syntax – SELECT ROUND (12345.6789, 2)

AVG()This function returns the average value of a numeric column.

          Syntax – SELECT AVG(Column_Name) FROM Table_Name

COUNT()This function returns the number of rows.

          Syntax – SELECT COUNT(Column_Name) FROM Table_Name

FIRST()This function returns the first value of the selected column.

Syntax – SELECT FIRST(Column_Name) FROM Table_Name

LAST()This function returns the first value of the selected column.

Syntax – SELECT FIRST(Column_Name) FROM Table_Name

MAX() – This function returns the maximum value of the selected column.

Syntax – SELECT MAX(Column_Name) FROM Table_Name

MIN() – This function returns the minimum value of the selected column.

Syntax – SELECT MIN(Column_Name) FROM Table_Name

SUM() – This function returns aggregated sum value of the selected column.

Syntax – SELECT SUM(Column_Name) FROM Table_Name

LEG() – Lead and Leg are called WINDOW functions as well, are used to get preceding and succeeding value of any row within its partition. The LAG() function is used to get value from the row that precedes the current row.

          Syntax – Select LAG(sale_value) OVER(ORDER BY sale_value) as previous_sale_value From SalesTable

LEAD()The LEAD() function is used to get value from row that succedes the current row.

          Syntax Select LEAD(sale_value) OVER(ORDER BY sale_value) as Next_sale_value From SalesTable

RANK()Ranking functions return a ranking value for each row in a partition. 

Syntax – Select RANK() OVER(PARTITION BY Column_Name ORDER BY Column_Name DESC) Rank From Table_Name

ROW_NUMBER()This function to get a unique sequential number for each row in the specified data.

          Syntax – Select ROW_NUMBER() OVER(ORDER BY Column_Name) RowNumber From Table_Name

DENSE_RANK() – This function to specify a unique rank number within the partition as per the specified column value. 

Syntax – Select DENSE_RANK() OVER(ORDER BY Column_Name) DenseRank From Table_Name

DATEDIFF() – This function returns the difference between two dates based on argument value for Day, Month, and Year.

          Syntax – SELECT DATEDIFF(YEAR, ‘01/01/2011’, ‘01/01/2021, )

DATEADD() – This Function adds a time/date interval to date and then returns the date.

          Syntax SELECT DATEADD(year, 1'01/01/2021’)

DATEPART() – This function returns an integer representing the specified datepart of the specified date.

          Syntax SELECT DATEPART(year, '01/01/2021’)

DATENAME() – This function returns a character string representing the specified datepart of the specified date

          Syntax – SELECT DATENAME(Month, '01/01/2021’)

GETDATE() – This function returns the current date and time of the system/server, in a 'YYYY-MM-DD hh:mm:ss.mmm' format.

          Syntax – SELECT GETDATE()

CURRENT_TIMESTAMP() – This Function also returns the current date and time, in a 'YYYY-MM-DD hh:mm:ss.mmm' format.

          Syntax – Select CURRENT_TIMESTAMP

FORMAT() – This function returns a value formatted with the specified format and optional culture, mostly used for date format.

          Syntax – SELECT FORMAT(‘01/01/2021’, 'd', 'en-US' ) 'US English' 

SYSTEM_USER – This Function is used to return the current username.

          Syntax – Select SYSTEM_USER

 

 

 

 

Tableau interview questions and answers for experienced professionals

  Tableau Interview Questions and Answers for experienced professional 1. What is TABLEAU? Tableau  is the powerful and fastest visualizing ...