Working with output | 27.10.2016
Excel table is the basic output of Marketing Miner that is available to a user after completing a report. It always contains an initial list (Report) that summarizes info about collected data, then a general list Data that contains data that were accessible at output for individual lines, and then other lists according to miners that cannot be paired straight into a line.
After downloading and opening the file, a user gets to the initial list (Report). Some Excel versions ask for permission before manipulating, because it is a file that is downloaded from the internet, comparably to the image below:
To be able to manipulate the file, a user first has to give permission to do so. Excel also often displays output file without wrapping the text, which could look chaotic to a user. To make it more clear for a user, the wrap text function should be removed:
Using wrap text:
After wrap text removal:
Filter function is used to adjust data display. This function will create a filter range from the top columns, which will allow user to search for rows in columns or to otherwise filter dataset content:
Examples of content filtering
Basic filtering is text filtering. A user types in a part of the text that corresponds with the cells of selected column and after clicking OK, a user gets to the dataset only corresponding with the assignment.
Excel has two basic and most commonly used types of filters:
In case there is a text content in the column cells, Excel uses text filters to filter it. These filters work similarly to searching and their functionality is intuitive to its name.:
In case there is a numeral content in the column cells, Excel uses number filters to filter it. Those allow user to select a part of the dataset that corresponds with more complex conditions of the range or with the minimum or maximum value of the column cells.
Conditional formatting is used to change a color of the cell, based on its value compared to the whole column. An example of the application and the output can be found in the video below:
Using output data, a user can then make charts:
Other tutorials for Microsoft Excel:
Instructions on how to make charts in Excel can be found at: