Table of contents

Needle in a Haystack

Last modified
Table of contents


For Internet Explorer Users and Those Wanting Full Screen Display Use: Web Player Get Spotfire for iPad App

Error: Embedded data could not be displayed. Use Google Chrome



EPA Statistics Users Group Meeting, Business Intelligence for the Statistician (building a with interactive dashboards), April 28, 2010. Interpretation of Environmental DataData on the Web.

Go to:

Go to: Spotfire 3.1 launches

Go to: Demos, Demo Gallery, and explore (Note: These demos use the Web Player to render almost all of the desktop functionality to the Web!)

Click on See it:

Especially see: World Energy Survey and PART Analysis 2008.

Click on Try It: Complete the form and you will receive a free 30-day trial version. Install it and enter the username and password you receive in the return email and click the option to save the login information.

See mine.

From the TIBCO Spotfire Menu you can see an Introduction to Spotfire.

Download Needle in a Haystack.dxp to a new directory that you create.

From the Main Menu: Click File, Open, and Select Needle in a Haystack, to open this Spotfire file that someone else has already created. Note: You can also explore the sample files that come with your evaluation copy.

The top Text Box says: Below is a fun data table that represents a hay stack that contains close to 70,000 pieces of straw and one needle. Each row in the data table is straw with the exception of the one row which contains the needle. Each straw (and the needle) have properties such as the XYZ position in the stack, shape, color etc.

In the Table Box: Click on the Material column (once and then again) to see how it sorts the data and reveals that one row has a "metal" object. Click on that row so it is highlighted (marked) in green.

Next: click on the Haystack tab at the top to see four panels as follows:

1. Text panel which says:

To find the needle, use the Filter Panel on the right to to adjust the categories based on the following conditions:

The needle is 35 mm long
The needle is 2 mm wide
The needle is round
The needle is brown
The needle weighs 20 ounces

2. 3D Scatter Plot

3. Details on Demand - shows row highlighted (marked) in the Data Table tab

4. Filter Panel

Note: More funtionality is available to add more panels using the same or additional data by selecting icons or menu items at the top and by right mouse clicking within each panel and selecting from the new menu revealed by that. This gives you a hint of the power available!

For example, right mouse clicking within the 3D Scatter Plot panel and selecting Properties shows you you the caution that this is not available on the Web Player (one of the very few features not yet supported on the Web).

Next: Adjust all of the Filter Panel slides or select all of the Filter Panel options to the specified conditions:

The needle is 35 mm long
The needle is 2 mm wide
The needle is round
The needle is brown
The needle weighs 20 ounces

and we see some thinning on the haystack data, but not enough yet to reveal the needle at least at this resolution.

Note that some "Filters are hidden" and Show all is highlighted in blue. Click it and make the bottom panel smaller to show all of the filters available (one for every column of data!).

First, uncheck the Material: Hay box and the Needle is revealed! Put your mouse cursor over the green needle and you will see the data characteristics that match those in the Filter Panel for the selected (marked) row.

You can export your application to PowerPoint and the Web by doing File Export and selecting the option you want. See selected screen capture slides attached.

Note: You can do additional statistical analyses and visualizations with this Spotfire application by selecting from the Main Menu, Insert, New Page, and on the new page, selecting a graph icon in the Main Menu (e.g. Scatter Plot, Summary Table, etc.) and adjusting the axes to what you want to show. You can choose to save you exploratory data analysis or not when you exit Spotfire. Spotfire will import your S+, SAS, etc. files from previous analyses and other applications. Have fun!

Page statistics
1135 view(s) and 7 edit(s)
Social share
Share this page?


This page has no custom tags.
This page has no classifications.