Surfguard reporting produces mainly what is called ‘raw data’, that is, the data that has been collected directly from a primary source of data (Surfguard) that is not processed or filtered by anyone.
The first step is to collect the data from the primary source of data, Surfguard General Reports or Custom Reports. When the data is gathered/downloaded, it can be filtered and summarised in various forms.
A useful tool in Excel to turn raw data into meaningful data is the Pivot Table Function.
What is a PivotTable used for?
A PivotTable is an interactive way to quickly summarize large amounts of data. You can use a PivotTable to analyze numerical data in detail, and answer unanticipated questions about your data.
A PivotTable is especially designed for: Querying large amounts of data in many user-friendly ways.
Training Resources
- Create a PivotTable to analyze worksheet data
- Pivot Tables Easy Excel
- Excel Pivot Tables Explained
- Excel Pivot Table Quick Tutorial
Feedback
Post your comment on this topic.