tableau roles and responsibilities

 tableau roles and responsibilities

·  Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.

·  Published Workbooks by creating user filters so that only appropriate teams can view it.

·  Embedded Tableau views in to SharePoint

·  Analyzed the source data and handled efficiently by modifying the data types.

·  Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.

·  Generated context filters and used performance actions while handling huge volume of data.

·  Generated tableau dashboards for sales with forecast and reference lines.

·  User Java Script API to customize the views, selects, filters, date and time.

·  Generated tableau dashboards with combination charts for clear understanding.

roles and responsibilities in tableau

·  Interacted with business users for gathering requirements and look and feel of the applications to be developer.

·  Developed various dashboards, used context filters, sets while dealing with huge volume of data.

·  Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.

·  Prepared use cases and got reviewed with state of Nevada.

·  Designed dash boards for actionable, non-actionable complaints from Multidimensional database.

·  Generated dashboards to compare the expected weekly sales vs projected sales used dual axis for comparison.

·  Generated Dashboards by joining multiple complex tables.

·  Generated dashboard for Finance team, provided security by using user filters.

·  Interacted with business users for gathering requirements for BASV Projects Dashboards.

·  Prepared Use cases and look and feel documents and got reviewed with end users.

·  Generated Tableau dashboards for e-bills and paper bills comparison.

·  Generated tableau dashboards with quick filters and sets for connecting to Oracle Database.

·  Generated adhoc Tableau reports on demand for providers.

·  Generated Tableau reports with Trend lines.

·  Generated Tableau Dashboards with Oracle Essbase multidimensional database.

·  Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.

·  Performed incremental extracts for OLAP database.

·  Created actual sales and target sales view with Trend lines, table calculations to see the difference between each quarter.

·  Worked as Business Analyst and Analyzed specifications and identified source data needs to be moved to data warehouse, Participated in the Design Team and user requirement gathering meetings.

·  Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.

·  Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.

·  Involved in creating and visualizing dashboards using Tableau Desktop.

·  Generated Tableau combination charts using Tableau visualization software.

Read more...

tableau interview questions and answers

1.     Best features of tableau and limitations of tableau.

A.    Best visualizations with less it cost,can connect to any database,no plugin required and powerful in memory processing. Limitation : Only supports Windows and Mac.No support to Linux based systems.

2.     what are the file size limitations with tableau

A.    Offically no limit,but we have observed best peformance with 4GB of data and 278 columns.

3.     what is the max file size u used in tableau.

A.    4GB

4.     how many max columns we can use in tableau.

A.    If you source is Access then 255.

5.     what are the limitations of tableau based on size, number of caluclations,

A.    No Limitation ,but suggested to work with extracts with max 4 GB.

6.     have u ever used tableau to perform etl or any complex calculations

A.    Tableau is a Ajax based Java Scripting data Visualisation tool and it can not peform any ETL actions.Complex calculation : Using Parameter in calculations.

7.     have u faced any problems with file size and number of columns which we use in tableau

A.    So far no as i have been working with limited data.

8.     what is tableau achitecture.

A.    It is Client and Server based N-Tier Achitecture. We build Tableau reports in using Tableau Desktop and Deploy them to Tableau Server. Tableau Server runs on 3 diference services Visual Server: This sends the queries to database and then coverts it to the visuals/Images you see in tableau. Database/Repository Server: This manages the connectivity and maintains the data extracts. Application Server: This handles the Authentication and Authorization.

9.     what is tableau reader

A.    Tableau reader is used to open the .twbx(Tableau packaged Workbook) files and it can only open the files and it can not create new connections and workbooks.

10.  What are there any data limitations with tableau public?

A.    Tableau Public can connect to Microsoft Excel, Microsoft Access, and multiple text file formats. It has a limit of 1,000,000 rows of data that is allowed in any single file. Yes, your data on Tableau Public is now accessible on the world-wide web and is downloadable by anyone. We strongly suggest you only publish data you are willing to share with anyone.

11.  how can u set permissions or protect the data in tableau public?

A.    We don't have any options for applying permissions to user in Tableau public. World wide web users will be able to access all files present in tableau public. No Security in public,so don't share any company confidential data.

12.  if i delete a workbook from tableau public and there are links to other blogs and other web locations.. what happens to dem?

A.    Every thing will be lost. Public is like a repository if you delete any thing in public the links in blogs will show error " File does not exist".

13.  did u work on real time reporting on tableau or u worked on back processing?

A.    I think question is regarding executing the sql queries from back end or directly executing the queries in tableau desktop.My answer will be: worked on writing the sql queries in sql developer/todd and executing them in tableau desktop.

14.  what domain u worked on, when u worked for tableau.

 A. My answer will be Insurance domain and currently working on Month end Process.

Hope it helped you..

Read more...

tableau interview questions in real time

                             

Real time tableau interview questions

1.  What is the difference between filter and parameter?
2.  What are the different types of Actions?
3.  What is architecture of tableau?
4.  What are the different security levels?
5.  What is data modelling?
6.  How to display lable of a country in map when it selected?
7.  There are is map and quick filters if we select one country in map it should get selected in quick filter. how to do same?
8.  How to display top 5 and last 5 in same view?
9.  Can we use parameters in filters?
10. What kind of reports you prepare?
11. What are diffrent types of connecting data?
12. How to refresh data extracts?
13. what is rightback?
14. If we connect live will it refresh automatically or do we need to refresh manually?
15. What is difference between discrete and continuous?
16. What is crasstab?
17. What do you mean by interactive dashboards?
18. What is dashboard life cycle?
19. What are the limitations of tableau public?
20. What is difference between tableau public and desktop?
21. What are different products of tableau?
22. what is the use of tableau reader?
23. How to reduce complexity of calculated field?
24. What kind of functions you used?
25. What to do if we don't have latitude and longitude of a location?
26. What type of data connections you used?

Read more...

tableau interview questions

1.expain about DWH archetecture with a real life senario
2.what is a component of DWH
3.compare ETL with BI
4.compare OLTP with OLAP
5.compare database with DWH
6.what is staging area

Read more...

difference between oltp and olap

DIFFERENCE BETWEEN OLTP AND OLAP

              OLTP                                                                             OLAP




source of data                                                                source of data                                             

Any user interface is the                                               All the OLTP' s are source for OLAP    
source data for OLTP


purpose                                                                           purpose

The mainpurpose of OLTP                                           The main purpose of OLAP is to analysis the
is to run the business                                                     business


operations                                                                   operations 

OLTP is the area where the frequently                        OLAP is the area where frequently select
perform transactions which means                               operation to be performed
INSERT ,UPDATE ,DELETE


Amount of data                                                        Amount of data

All ways OLTP contains less                                   OLAP contains large amount of data as we
amount of data with comparing                               are dapping the complete data from OLTP's into
to OLAP                                                                   OLAP

size                                                                          size
the size of OLTP is upto 400 GB                           The size of the OLAP is rang from 600 GB to 2 TB

Read more...

tableau componets

Tableau has five importent compenets they are
1.OLTP
2.ETL
3.STAGING AREA
4.DWH
5.BI

Now we can discuss about the five components of tableau
1. OLTP : 
OLTP stands for ONLINE TRANSACTIONAL PROCESS which stores the day to day business transactions

2.ETL :
ETL stands for EXTRACTION TRANSFORMATION LOADING ,ETL is mechanism mainly used to extract the data from multiple sources and performing the required transformations and finally loading the data into DWH

3.STANGING AREA  :
It is a temporary area where all the required transformations takes place ,transformations means coverting the data inthe different format into one universal format

4.DWH :
DWH is a house where the information gets stores for analysis and reporting DWH is also known as 'OLAP' OLAP stands for online analytical processing system

5.BI  :
BI stands for business intelligence bi is the process of incorporating the intelligence to the information stored in the data where house

Read more...