Spotfire Interview Questions

Hi,

Today i wish to tell you about one of the leading data visualization tool - Tibco Spotfire
Here I am writing some of the queries i got from interviewer.

INTRODUCTIONSpotfire Analytics is an enterprise Analytics platform that helps business and technical users quickly to get an actionable insight.This allows customers to perform in-depth analysis of their data through the use of predictive and complex statistics. You can learn this very easily.
Spotfire Analytic ... Better than BI, smarter that spreadsheet. if you don't have the tool and wish to learn this, simply download the free trial from there website http://spotfire.tibco.com/,  its free for 30 days.



Journey through Spotfire before attending the interview
1. If i want to see the outlier which visualization i need to use?
A: Scatter plot.


2. Are you able to edit the marking, the name and color?
A: Yes, from the Document Property, we can change the marking properties based on your requirement.

3. Can we use different filters in different pages?
                       OR
    I need two pages with different filtering , how can you implement?
A: We can use filtering schema to apply different filter.


4. Tell me the way you created the dashboard using IL(information link).
A: First create the data source, then take the columns you wanted for dashboard and save in a folder in the library. If using multiple tables, create the joins . Finally create the IL. Add data from library to access the IL to the front end.

5. Which version of Spotfire you are working on? 
A: Say only the one you worked, because the next question will be the difference you find in both .


6. What are the various visualization used in the Spotfire?
A: You can tell the one you are able to recollect. If possible tell them the importance and the use of one or two.

7. Is there any difference between the terms Data on Demand & Details on Demand?
A: Data on Demand is one of method we used to adding data and Details on Demand is the way of displaying the detailed view of data.


8. Have you heard about personalized information link?
A: Yes, using this method we can filter the users to view the dashboard. 2 parameters are used for this. CURRENT_USERS AND GROUP_USERS, from version 6 on wards there is one more named CURRENT_USER_DOMAIN 

9. Have you ever created dashboard using procedures with input parameter?If your answer is yes , definitely the next question will be how?
A: You can create the procedures through IL, instead of table columns create procedures. While creating the procedures there is one option to select the query type. If it is with input parameters change that to post - query, write default values and save. Create IL using the procedure , and refresh the parameters to get the values. 

10.Is it possible to create drop down filter?A: Yes, using the text area you can create drop down filter.

11.What attracted you in Spotfire? 
A: Be ready to answer this with an example you have done.



Few More Questions ......

1. Is it possible to create a guage in spotfire?
2. How can we export the visualization?
3. Are you expert in map? Is it possible to add pie inside the map? ( possible upto 5, in 6, i dont think so)
4. What is comparison circle?
5. Do you know box plot and the use of it?
6. Do you have any work experience in Spotfire Admin area?
7. Explain data on demand with one example you have done .
8. Method used to navigate from one page to another?
9. Features of graphical design.
10. Different methods of filtering ?
11. What are the features you noticed in 6 compared to 5.5?
12. Databases that support Spotfire.
13. From where we can see the database list.
14. Spotfire cache?
15. Architecture of Spotfire
16. How to Pivot and Unpivot Data? Is it possible to pivot data from IL?
17. Differences Between In-Memory and In-Database Data
18. Is it possible to avoid duplicate data through Spotfire?How?
19. I would like to display trend over time, which viz u will prefer for this?
20. Have you worked in Composite tool for creating IL?
21. Different bin methods?
22. Is there any function like NVL ( oracle function for replacing null values) in spotfire?  (ANS: Yes, SN will substitutes null values in Arg1 with Arg2.)
23. How to display the axis values based on the column selections?

You can expect questions from the SQL, Business Intelligence and also few more depending on the role you are interviewed for ........

Thanks for visiting ..... Feel free to add your comments, suggestions, any queries & of course the questions that have tried to puzzle you  : -) ....

Best of luck for a bright future...