You can use the Excel-exports for further data analysis using the built-in functionality of Excel. In this article we show you how to use the filter-feature for data exploration.
TABLE OF CONTENTS
- Export information from dashboard
- Use the Data worksheet for analysis
- Set filters
- Select information element of interest
- Narrow results by answer
Export information from dashboard
You can export all objects of a category (e.g. all software & service tools) through the export functionality on the ZOA dashboard.
Use the Data worksheet for analysis
The Data worksheet in the Excel-file should be used for further data analysis. The sheet contains all information elements that are also available within the ZOA platform.
In order to explore your data, we recommend to set some filters. You select the first row that contains the column headers and select "Data" in the menubar and then "Filter".
Select information element of interest
Then you can click in the cell "Question" and select the information element of interest. In the example below, we are interested which tools are related to a data processor. Hence, we select "Is this application or service controlled by an outside data processor?" from the list. You can also select multiple questions if needed. This will filter the rows accordingly.
Now we see which tools are controlled by a data process.
Narrow results by answer
You can narrow the list by the answer (e.g. only show software tools & service providers that are not controlled by a data processor).