Comparing multiple datasets using the Cross Dataset Analysis tool
What is a cross dataset analysis?
The Cross Dataset Analysis tool allows you to compare up to 4 variables from one or more datasets. This can provide some really useful insight for seeing trends across services or resources over time. For example, you might want to compare:
- Book circulation vs. the number of items borrowed via ILL
- Book acquisitions vs. the number of items borrowed via ILL
- Book circulation vs. e-book usage
- Questions asked at the reference desk vs. the circulation desk
- Usage of LibGuides, your library website (via Google Analytics), and your research databases
- E-journal usage vs. the number of articles borrowed via ILL
That just scratches the surface, but hopefully it gives you some ideas as to how you can put the Cross Dataset Analysis tool to good use!
Running a cross dataset analysis
- Click on Cross Dataset in the command bar.
- Select the Date Range you want to analyze in your report.
- Choose whether you want to Aggregate the data monthly or annually. For example, if you're looking at a date range of one year or less, monthly would be the best choice to view data over time. But if you're looking across multiple years, then you may want to view your data annually instead.
- Select the variables that you want to compare.
- For each variable, first select the dataset. You can select from any dataset you've been given permission to analyze. (Don't see one you're looking for? Contact your admin and ask to be given that permission.)
- Select one of the available fields to use in your analysis (not all field types are able to be used in a cross-dataset analysis).
- Select the individual variable from the field.
- Choose the chart type for this particular variable.
- If desired, you can reorder the variables by dragging and dropping each one into a new position.
- Click the Run This Report button.
- The variables will display in an interactive chart using the chart types you selected.
- Under Complete Trends Data, you'll find a data table containing the monthly or annual totals. Click on the Toggle Trend Details link to display a year-over-year (y-o-y) comparison and a comparison to the first year of data (vs. 1st).