Click on the first tab "Sales Data" in order to work with the Sales data view. Make sure that no filters are set on the view. To release all filters, press on the filter button, so that the green light is turned off. Press the Facts button to display the "Fact Discovery Engine" dialog.

1. From the "Search for facts about:" drop-down list, select the "Profit" column.

2. Move the "Discover" slider to the right so that it shows 80% at the right side. This means that we are tuning the engine to discover more facts. Press "Run" button.

Once the "Run" button is pressed, SuperQuery starts the Fact Discovery Engine and displays the "Fact Progress" dialog showing facts as the engine discovers them. The dialog gives some useful information about the engine performance as it discovers the facts.

When the engine finishes scanning the data , it displays the facts found in the "Fact Engine Save Results"dialog . The dialog will allow you to browse through the facts found and write them in one of the following format: "If … then", "Fact - exception" or "Tab delimited"

"If PRODUCT = Jacket and Color = Black à then Profit = High. Confidence 63% Supported by 7 rows"

means that "Most black jacket Sales have high profits." The rule has a certainty factor of 63% and there are 7 rows supporting this rule.

The same rule is represented in the other two formats as follows:

"Fact - Exception" format:

Most SALES$ where PRODUCT = Jacket and COLOR = Black à have Profit = High. Percentage 63% Supported by 7 rows.

"Tab delimited" format : ( useful for importing into Excel )

• Chapter 1 -- Getting Started in SuperQuery
• Chapter 2 -- Organizing your Data
• Chapter 3 -- Querying the Database (Filter Column) (Classification Column)
• Chapter 4 -- Discover Facts and Rules (Office edition) (Discovery edition)
• Chapter 5 -- Summarize your data