Analytics Training

A practical guide to Analytics brought to you by the Central Analytics Standing Group, based on questions and feedback from Alliance members like you.

Help & FAQs

Self-Paced Training and Documentation

In addition to live training sessions throughout the year, CASG offers training resources specific to Alliance needs that you can use to supplement Ex Libris documentation and resources (see External Resources, below) in your Analytics learning journey. We cover some of the major uses of Analytics, as well as use cases, where you can find examples from Alliance institutions. You may also want to check the FAQ if you have a very specific question. A new Analytics user could use this as a training outline, while occasional or intermediate users may want to use the area for their current needs. 

While older resources may have different Alma, Primo and Analytics screens than the current system, they are generally similar enough for the instructions to still apply. We occasionally review and delete older content. If you happen across something that no longer works, let us know through our request form.

If you have a question not answered here or in the FAQs, don’t forget that you can always submit a request for CASG’s help!

Introduction, Navigation and Creating Your First Report

Analytics 101 (March 1, 2024)

This Analytics 101 training introduces the Analytics interface, creating reports, working with filters, adding totals and subtotals, and copying existing reports from shared folders.

Additional Resources

Display, Styling, Chart Types

  • Display and Styling (January 2017; Video, 12:15)
    • Editing properties for analysis, tables, and columns
    • Including null values in a report
    • Hierarchy of columns
    • Enabling user interactions across multiple tables
    • Styling and setting sizes for tables and columns
    • Setting column and data formatting,
    • Customizing column headings
    • Conditional formatting for rows and columns
  • Modifying the Look of an Analysis (July 2016; PDF)
    • Changing column heading display
    • Adding totals to the end of columns
    • Coloring every other row.
  • Chart Types
    • Pivot Tables in a Nutshell (July 2020; Video, 4:55): Turn your Analytics report into a pivot table.
    • Visualizing Analytics (May 2020; PDF): How to turn your reports into graphs and charts within Analytics. (This is different from Data Visualization, which is a separate interface. See the Data Visualization section for more info.)

Dashboards

Building and Using Dashboards (March 9, 2022)

An in-depth overview of dashboards, including when you might want to use one, how to build one, how to add prompts, and how to use action links within your dashboards to drill down.

Recording (58 mins)

Supplementary materials:

Dashboard Prompts

  • Dashboard Prompts (April 2017; Video, 11:52): If you already know dashboards but need help with prompts, this shorter demo video will show you how to create a prompt and add it to your dashboard. 
  • Copying and Modifying a Report to Build a Dashboard with a Prompt (Summer Meeting 2019; PPTX): Most of the material in these slides is covered in the recordings linked above, but slides 16 and 17 show a prompt being applied to two reports on a dashboard page. It also shows starting with an existing report and modifying it for your needs.

Using Analytics with Other Tools

From our annual training interest surveys, we know many people eventually move Analytics-generated data to other tools, like Excel, Tableau, and other similar tools. If you’re interested in this topic, we suggest these recorded trainings (extended descriptions of contents, slides and supplementary materials are available in the Training Archives section below):

Data Visualizations in Analytics and Excel (June 8, 2022)

Recording (55:53)

Using Analytics Data in Other Tools (May 18, 2023)

Recording (55:42)

Supplementary materials:

Making Usable Reports Out of Imperfect Data (May 11, 2022)

Using SQL

You can use SQL in Analytics for advanced filters and functions. If you don’t know SQL or don’t know SQL well, you can use these resources to learn enough to apply it in Analytics.

Enhancing Analytics Reports with SQL (April 13, 2022)

Covers what SQL is and how to use it in filters and column formulas.

Recording (58 mins)

Supplementary materials:

Additional Resources

SQL resources from the Alliance and external sites are listed below. Many of the links include copy-and-paste code examples you can use.

Data Visualization

Data Visualization is a tool accessed from the same menu in Alma as Analytics, but it’s a different interface. You can also create basic charts and graphs within Analytics. See the “Display, Styling and Chart Types” section above for information on that functionality.

Combining & Visualizing Data with Alma (June 14, 2021)

An introduction to the OAS (Oracle Analytics Server) and DV (Data Visualization).

Recording (55:51)

Supplementary materials:

Use Cases

Acquisitions

ACRL & IPEDS Data

Shared reports are reviewed and updated annually by CASG. 

  • ACRL/IPEDS Analytics Review (January 2021; Video, 35:33): Demo of how to access and copy shared reports to your institution’s Analytics space. 
  • ACRL/IPEDS Canned Reports (Updated September 2021; PDF): Instructions on how to access and copy shared reports to your institution’s Analytics space. 
  • Shared reports available in Alma Analytics -> Shared Folders/Community/Reports/Consortia/Orbis Cascade Alliance/Analytics Group/[Reporting Year] ACRL and IPEDS

Collections

Fines and Charges

Fulfillment

Resource Sharing

Shared Reports

Over the years, CASG has created a library of Shared Reports in the Analytics catalog. These shared reports were usually created in conjunction with training sessions, Alliance projects, or request form questions, and one or more of them may fit needs you currently have.

Access these reports in the Analytics catalog under Shared Folders/Community/Reports/Consortia/Orbis Cascade Alliance/Analytics Group. 

Copy a shared report to your institution or personal Analytics folder before modifying them. 

User Records

External Resources

Training Archives

Access recordings and supplementary materials from past sessions. 

  • Trainings are occasionally removed from the archive if the functionality or topics become outdated. 
  • Past sessions may include recordings or screenshots showing older versions of Alma and Analytics but are otherwise still applicable. 
  • Most topics have been duplicated over the years. We include duplicates in the archive unless they are otherwise outdated. 

Archives content last reviewed: January 2023

Analytics Subject Area Examples Shown Keywords Title Date Recording and supplementary materials Description
Usage Data (COUNTER), E-inventoryUsage Data, SUSHI, COUNTER, Out-of-the-box ReportsUsage Data Reports with COUNTER and SUSHIJune 1, 2023Recording (45:20)
Slides (PPTX)
This training explained how to set up SUSHI harvesting of COUNTER reports from database vendors, and how to construct usage analyses from the stored data.
Physical Inventory, Fulfillment, RequestsExcel, OpenRefine, API, XLOOKUP, Data Clean-up, Looker Data Studio, Google SheetsUsing Analytics in Other ToolsMay 18, 2023Recording (55:42)
Using the Analytics API as an Excel Data Source & Looker Studio (Google Slides)
Using XLOOKUP to Join Reports (PPTX)
Demo Shared Report (Google Sheets)
This training provided examples of using the Analytics API as a data source for Excel, using OpenRefine to clean up messy data, and using Excel’s XLOOKUP function to combine data from multiple Analytics reports into one.
E-inventory, Requests, Physical Items Analytics Objects, SQL, Data Clean-up, Local Parameters, Usage Data, SUSHI, COUNTERSpring Cleaning: Data Clean-Up Projects with AnalyticsApril 20, 2023Recording (47:41)
Slides:
Clean Up Items in Limbo
Local Resources Clean-Up
Electronic Portfolio Clean-Up
SUSHI Clean-Up
This training provided three examples of clean-up projects: cleaning up local resource types, requests or work orders too long in process and SUSHI accounts on vendor records. 
Fulfillment, Fines, UsersEquity, Inclusion, Diversity, Fines, UsersFrom ILS to DEIMarch 16, 2023 Slides This discussion-style session was not recorded, but the slides cover some ways you can use Analytics to make equity-related changes at your institution.
Fulfillment, RequestsNavigating, Out-of-the-box Reports, DashboardsAnalytics for Resource Sharing & Fulfillment (RSF)February 9, 2023Recording (39:38)This Analytics training was held in conjunction with an RSF open call. There are demos of reporting on old request notes, modifying an out-of-the-box report, out-of-the-box dashboards, and some Q&A with the audience. 
Physical Items, FulfillmentSubject Areas, Documentation,Widgets, Exporting, Advanced Searching, Filters, Out-of-the-box ReportsAnalytics 101January 19, 2023Recording (52:54)
Transcript (TXT)
Handout (PDF)
Slides – Part 1
Slides – Part 2
Slides – Part 3
This Analytics 101 features an introduction to Analytics, including accessing it, navigating it and choosing when to use it (versus advanced search features in Alma itself). It includes two examples that walk you through how to create a basic report from an existing out-of-the-box report, filter and export it to external tools. 
Fulfillment, Physical Items, Primo Action UsageData Visualization, Excel, Charts, GraphsData Visualizations in Analytics and ExcelJune 8, 2022Recording (56 mins)
Advanced Data Visualizations (PDF)
Sparklines in Excel (PDF)
Bubble Charts in Excel (PPTX)
Complex Data in DV (PDF)
This training begins with an introduction to data visualization generally, followed by step-by-step instructions of creating your own data visualizations for a variety of use cases. Examples are shown in Analytics’ Data Visualization tool of tree maps, high-volume time series, heat maps, tree diagrams, and tag clouds. Sparklines and bubble charts are shown in Excel. 
Physical Items, FulfillmentSQL, Regular Expressions, Data clean-up, MARC dataMaking Usable Reports Out of Imperfect Data May 11, 2022Recording (53 mins)
Call Number Sorting and Data Type Conversions (PPTX)
Cleaning Up the Published Field with Regular Expressions and Evaluate Functions (PPTX)
Using SQL Substring to Find Mismatched Data (PDF)
This training demonstrates several ways to clean up Analytics data before exporting to an external source (e.g., Excel), including the age-old frustration of call number sorting. Some SQL functions are shown for doing “find and replace” type functions, as well as grouping similar data together using bins. 
Physical Items, Fulfillment, Usage DataSQLEnhancing Analytics Reports with SQLApril 13, 2022Recording (58 mins)
Slides, Part 1 (Google Slides)
Slides, Part 2 (PPTX)
Part 1 provides an overview of what SQL is and how to use it in Analytics. A basic SQL query is deconstructed and explained in detail. Part 2 demonstrates specific examples of useful SQL in Analytics, including doing date and time calculations, tops and bottoms and ranking. 
Physical ItemsAnalytics Objects, Prompts, Dashboards, Action LinksBuilding and Using Dashboards March 9, 2022Recording (58 mins)
Slides (PDF)
This training explains the uses of a dashboard and options for creating one in Analytics. Common problems with library data are addressed. Finally, the training walks you through creating a simple dashboard, adding a prompt and creating an Analytics Object for your users to share your dashboard with users. 
Physical items, E-inventoryMARC data, Data clean-up, Overlap Analysis, WeedingAlliance Case Studies in AnalyticsFebruary 9, 2022Recording (50 mins)
Alma Analytics for Weeding (PPTX)
Sample spreadsheet to construct a query to compare vendor titles with Alma records (XSLX)
Using Analytics for bibliographic record cleanup (PPTX)
Short demos of real-life Analytics projects at Alliance institutions, including creating a weeding list, cleaning up bibliographic data and identifying overlap in existing e-inventory and a vendor list. 
Funds Expenditure, E-inventorySubject Areas, Documentation, Filters, ExportingAlma Analytics 101January 12, 2022Recording (1 hour)
Slides (PDF)
An introduction to Analytics, including accessing Analytics, navigating the interface, creating your first analysis, filtering, exporting and getting help. 
E-inventory, Funds ExpenditureData Visualization, Charts, GraphsCombining & Visualizing Data with Alma June 2021Recording (55:51)An introduction to the OAS (Oracle Analytics Server) and DV (Data Visualization), including how to pull in outside data and combine it with Alma Analytics data.
Physical items, E-inventory, UsersSQL, Exporting, Excel, XML, Filters, Time & Date Arithmetic, Call Numbers, Local Parameters Analytics Trips and Tricks May 2021Recording (54:15)14 short demos of useful Analytics tips, including the Lifecycle filter, call number sorting, conditional formatting, SQL tricks, mapping local parameters, and separating a large report into smaller ones.