Presentations and Documents - Analytics
The New Analytics User Interface in Alma
Advanced Material - Dashboards
Advanced Material - Linking from Analytics Reports
Advanced Material - Miscellaneous
Network Zone Consortia and Alma Analytics
Using Google charts with Alma Analytics
Introductory Material
General Overviews
- An Introduction to Esploro Analytics and Data Visualization.pptx
- How to make an analytics report pre-filter by library per staff user.pptx
- Alma Analytics - Update on New and Upcoming Features Igelu 2020 (Movie)
- Alma Analytics - Update on New and Upcoming Features Igelu 2020 (Presentation)
- Overlap analysis and physical item usage for weeding (deselection) in Alma Analytics (Part of ELUNA "Knowledge Days" 2021)
- Analytics - Infrastructure Improvements in 2020.pptx
- Analytics - Overview of Alma Link Resolver Usage Subject Area.pptx (Igelu 2015)
- Analytics - Overview of the addition of the fund information into the Physical Items subject area.pptx (June 2016)
- Analytics - Benchmark Analytics.pptx
- Understanding in house use and Alma Analytics reports for In House use.pptx
Network Zone Consortia and Alma Analytics
- Member institutions accessing reports created in the network zone institution.pptx
- Member institutions accessing electronic resource data from the network zone institution.pptx
- Consortia reporting in Alma Analytics for overlap analysis.pptx
- How to identify records not linked to the Network Zone.docx
- How to obtain the number of physical items held by institutions within the consortium by LC classification.docx
General Material
- How to create a report of all active electronic collections in the institution.pptx
- Library Independence - How to make an analytics report pre-filter by library per staff user.pptx
- How to manipulate the sorting of characters with diacritics in Analytics.pptx
- Bibliographic IDs in the Titles subject area of Alma Analytics.docx
- Understanding the fields Link ID Linked to CZ and Linked to NZ in the Bibliographic Details folder.docx
- How to save and recreate an analytics report using the xml of the analysis.docx
- Peer Reviewed and Open Access in Alma and Alma Analytics.pptx
- Alma Analytics and Evidence Based Decision Making.pptx
- User statistical categories and Alma Analytics.docx
- Analytics - Physical Item Usage for Weeding ELUNA 2019.pptx
- Analytics - Bibliographic records with no inventory and holdings records with no items.pptx (Igelu 2018)
- Analytics - Including local parameter fields (local fields) in Alma Analytics.pptx
- Analytics - Understanding why the number of items per fund is often 0 when using the fund information in the physical items subject area for continuous orders.docx
- Analytics - Recent developments in Alma Analytics with a focus on those developments originating from the community – September 2019.pptx
- Analytics - Ex Libris collaboration with the community in developing Alma Analytics ELUNA 2019.pptx
- How to change display default in Analytics Edit mode from Results Tab to Criteria Tab.docx
- Analytics - How to control if a sum is rounded up in an Analytics report.docx
- Analytics - How to separate the date time field to date time and hour.docx
- Analytics - Relative Date Filters in Alma Analytics.pptx
- Analytics - Bibliographic field Title (complete) with additional subfields.pptx
- Analytics - Four fields in bibliographic details based on 019 and 035.pptx
- Analytics - Balance and remaining funds measures in the Funds Expenditures subject area.pptx
- Analytics - Bibliographic field Author (contributor) from 7XX fields.pptx
- Acquisitions and Analytics - Purchase Requests in Alma Analytics.pptx
- Acquisitions and Analytics - POLs with no transactions in the Funds Expenditure subject area.pptx
Data Visualization (DV)
- An Introduction to Alma Analytics Data Visualization (DV).pptx
- An Introduction to Primo Analytics Data Visualization (DV).pptx
- New features in OAS 6.4 for Alma and Primo Data Visualization.pptx
- Developer Network Blogs about Data Visualization
- YouTube videos about Data Visualization
- An Introduction to Alma Analytics Data Visualization (DV).pptx
- Alma 資料視覺化 Data Visualization (DV).mp4 (session with simultaneous Chinese translation delivered 08 June 2021)
- YouTube videos about OAS (Oracle Analytics Server) and DV (Data Visualization)
- Oracle分析服务器（OAS）和数据可视化（DV）相关视频
- Blogs about OAS (Oracle Analytics Server) and DV (Data Visualization)
- Primo Data Visualization in Hebrew (one of two) הדמיית נתונים בפרימו אנליטיקס (חלק ראשון משתיים)
- Primo Data Visualization in Hebrew (two of two) הדמיית נתונים בפרימו אנליטיקס (חלק שתיים משתיים)
Anonymization
How to - Procedures
- How to create a report of number of items held by publication decade.docx
- How to create an Alma Analytics report of Primary IDs of users with an overdue loan and no active fines and fees.docx
- Analytics - How to set up Alma so that the Originating System in Analytics will be properly populated.docx
- Analytics - How to filter a report by the Unicode value of a character or string.docx
- Analytics - How to add the title to a bar graph and make the value appear on the top of each bar on an Alma Analytics graph.docx
- Analytics - How to combine two subject areas in an Alma Analytics report.pptx
- Analytics - How to duplicate (merge) cells per column in an Alma Analytics report.pptx
- How to make the alternate rows of a table be shaded in an Alma Analytics table.docx
- Analytics - How to remove COUNTER report data loaded in Alma.docx
- Analytics - How to separate a large Alma Analytics report into separate smaller reports.docx
- Analytics - How to create a measure from textual alpha numeric values.docx
- Analytics - How to filter a report by current and previous academic years.docx
- Analytics - How to retrieve duplicate barcodes via Alma Analytics.docx
- Analytics - How to identify mismatches between bibliographic material type and physical item material type via Alma Analytics.docx
- Analytics - How to create a report of all items which have been declared Missing longer than 6 months ago.docx
How to - Reports
- How to create an Alma Analytics report of portfolios activated for the electronic collection Ebook Central Perpetual DDA and Subscription Titles.docx
- How to create an analytics report of all POLs (orders) which have been received or activated but still not paid.pptx
- How to create an Alma Analytics report of all ordered items that have been received in the last 30 days.docx
- How to create a report of all loans with due dates within a certain date range.docx
- Analytics - How to make an Alma Analytics report of all bibliographic records which have no inventory.docx
- How to create an Alma Analytics report of duplicate users by specific parameters
- How to create a report of the number of courses created per year.docx
- How to create a report of the number of reading lists created per year.docx
- How to create a report of the number of citations created per year.docx
- How to get a numerical breakdown of all types of inventory in the repository.docx
- How to create a report of the number of items requested per week.docx
- Analytics - How to make a serial claim report by shelving location using Alma Analytics.docx
- Analytics - How to create an Alma Analytics report of all courses which do not have a reading list.docx
- Analytics - How to create an Alma Analytics report of all items returned 30 days or more after the due date.docx
- How to create an Alma Analytics report of all loans which are overdue by 30 or more days.docx
- How to create an Alma Analytics report of all ordered items that have not yet been received.docx
- Analytics - How to create an Alma Analytics report of all patrons with expiration date within one week and have active loans.docx
- Analytics - How to create an Alma Analytics report of all requests which have a different pickup location than the library of the item.pptx
- Analytics - How to create an Alma Analytics report of fund expenditures by fiscal period format and subject.pptx
- Analytics - How to create an Alma Analytics report of successful and unsuccessful logins to Alma for a specific time period.docx
- Analytics - How to make an Alma Analytics report of all items which transferred between two specific locations.docx
- Analytics - How to create an Alma Analytics report of users with a patron role and a role expiry date which will expire in the next 30 days.docx
Chinese Classifications for Taiwan
Chinese Classifications
Using Google charts with Alma Analytics
Example of a table (the html of the web page and the xml of the corresponding report)
Pies and Charts:
- Analytics - Google charts - How to use Alma Analytics with Google Charts and APIs to display Analytics reports in web pages.docx
- Analytics - Google charts - Pie Chart Link Resolver usage by method of access for current year.html
- Analytics - Google charts - Pie Chart Users.html
- Analytics - Google charts - Table Total Number of Titles.html
- Analytics - Google charts - One Table and Two Pies in one html page.html
- Analytics - Google charts - Total Number of Volumes.xml
- Analytics - Google charts - Count of Unexpired Users by group.xml
- Analytics - Google charts - Link Resolver usage by method of access for current year.xml
New Book List:
- Analytics - Google charts new book list - Instructions.docx
- Analytics - Google charts new book list -Records created in the library in the last week as a table.html
- Analytics - Google charts new book list -Records created in the library in the last week.xml
Tableau Web Data Connector
- Analytics - Using Alma Analytics with the Tableau Web Data Connector.pptx
- Tableau Web Data Connector Ex Libris Developers Network Blog
- Alma Analytics and Tableau Web Data Connector Integration - Youtube video for Igelu SIWG
- Alma Analytics - Using an API to integrate Alma Analytics with the Tableau Web Data Connector.mp4
Analytics SIWG Meetings
- Alma Analytics Q3 2020 Quarterly Update.pptx
- Alma Analytics Quarterly Update For the Analytics SIWG July 2020.pptx
- Primo Analytics Quarterly Update For the Analytics SIWG July 2020.pptx
- Alma Analytics Quarterly Update For the Analytics SIWG January 06 2020.pptx
- Alma Analytics Quarterly Update For the Analytics SIWG April 06 2020.pptx
- Meeting with Leganto Users Regarding analytics reports for Reading List repository citations July 14 2020 .pptx
Analytics SIWG Meeting January 11 2021
Advanced Material
Advanced - Prompts
- How to use SQL to specify which values should be listed in the prompt for locations.docx
- How to create a prompt in an Alma Analytics report
- How to make the report Analytics report prompt input be case insensitive.docx
- How to make the report prompt date be a specific date using SQL.docx
- How to make the report prompt date begin by default three months ago using SQL.docx
- How to make the report prompt year date begin at 2020.docx
- How to make the report prompt date be the current year using SQL.docx
- How to create a prompt by NULL and NOT NULL in an Alma Analytics report
- How to include the values chosen in prompts as part of the header in the analytics report results
- How to create a link to rerun a prompted Alma Analytics report.pptx
Advanced - Dashboards
- How to edit and change a default Alma Analytics dashboard using the archive method.pptx
- How to edit and change a default Alma Analytics dashboard using the copy folder method.pptx
- How to create a new Analytics Dashboard
- How to create Dashboard Prompt
- How to change the list of possible values in a dashboard prompt.docx
Advanced - Filters
- How to retrieve the Year To Date Loans in Alma Analytics.pptx
- How to filter by contents of a specific position of a control field in Alma Analytics.pptx
- How to filter by a string for both uppercase and lowercase with one filter
- How to use regular expressions to retrieve analytics fields by alpha and numeric characters and combinations
- Analytics - Alma Analytics Regular Expression Examples
- How to use multiple filters per column in an Alma analytics report
- How to filter in an Analytics report for fields which contain a semicolon.docx
Advanced - Functions
- How to concatenate multiple rows of the same field to one row.pptx
- How to change a date field which contains date and time to only contain date.docx
- How to use RCOUNT to add a running number to each row of a report in Alma Analytics
- How to use RCOUNT to display the total number of rows in an Analytics report
- How to use the CASE condition to change text in an Alma Analytics report.pptx
- How to use the SUBSTRING function to separate out part of a column in an Alma analytics report
- How to use COUNT BY to create an Alma Analytics report of users who have at least two barcodes
- How to use COUNT DISTINCT BY to create an Alma Analytics report of all portfolios which exist in multiple collections
- How to use the TIMESTAMPDIFF parameter to perform a mathematical operation on two columns in an Alma Analytics report
- How to use the TIMESTAMPADD parameter to retrieve by today - X time in an Alma Analytics report
- Alma Analytics SQL Filter Examples
Advanced - Linking from Analytics Reports
Analytics Objects
- Analytics Menu Entries in Alma - Introduction.pptx
- The Analytics Objects List.pptx
- How to create a scheduled report from an Alma Analytics report for Alma and non-Alma users.pptx
- How to create a widget from an Alma Analytics report and add it to the Alma homepage.pptx
- How to use a Data Visualization Workbook as an Alma Homepage.pptx
- The Pinned Objects and the Report URL.pptx
- How to automate the process of sending an Alma Analytics report to an FTP server
Advanced - Miscellaneous
- How to save a customized Alma Analytics column to be used in future reports.docx
- How to find and view a specific COUNTER report which was loaded to Alma and is reflected in Alma Analytics
- How to add a logo to the top of an Alma Analytics report
- How to use the output of one Alma Analytics report as the input for a subsequent Alma Analytics report
- How to identify which reading list citations are from a specific electronic collection
- Creating sets in Alma from Alma Analytics Reports
- How to create a set of users with items on loan and expiration date in specific range using Alma Analytics
- How to change the no results message to a specific message in an Analytics report
- How to separate the semicolon delimited network number into separate fields
- How to separate semicolon delimited values to separate columns
- How to concatenate two or more fields in an Alma Analytics report
- How to conditionally change the text format in an Alma Analytics report
Back to main "Presentations and Documents" page