Organizing your Data

SuperQuery main screen consists of one row of eight tabs. You can edit the tab title and change the tab color. You can explore these features from the tab property menu. To display the property menu, click the right mouse button on the tab you want to edit.

From the property menu of the first tab, select the "Title" menu item and write down " Sales Data" in the "Edit Title" edit box, then press OK. Repeat for the second tab, and write down the title "Product Summary".

Now we need to copy the main data view and put it in a separate tab before performing more analysis. Press the Duplicate button. SuperQuery creates a new copy of the same view. To move this view to the third tab, press the button. The button state will change to indicating that the view is now floating. Click on the third tab, in order to activate it. The current active tab becomes the third tab and the view still floats on this tab. Press the button again. The view is now fixed in this tab and the button state changes to . Write down the title "Raw Data" on the third tab in the same way you did for the two previous tabs.

SuperQuery's data view consists of four panes; the main pane is the Data Table that controls the scrolling of other panes. The other three panes are: Total Page, Reps Graph and the Data Page. Each pane has a re-sizable frame, to allow you to change pane size according to your preferences and the type of the analysis you are performing.

As you move the mouse on the pane frames, the cursor changes to in order to re-size vertical splitters and to re-size horizontal splitters separating the panes. As you move the cursor towards the splitter ends, the cursor changes to one of the following shapes in order to maximize or minimize the pane in the arrow's direction.

To change the pane type simply, select the "Change Type" menu item from the pane property menu. To display the property menu, click on the right mouse button when placed on the pane you want to edit. Select the new pane type from the list of the available types. Each pane has its own unique property menu that is tailored to its own functionality.

It is recommended that you spend some time to familiarize yourself with the different pane types and their properties in order to explore the strengths and capabilities of the system

• 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