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!

 

 

 

 

 

 

 

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!