eprintid: 1365
rev_number: 8
eprint_status: archive
userid: 24
dir: disk0/00/00/13/65
datestamp: 2016-06-08 18:15:06
lastmod: 2016-06-08 18:15:06
status_changed: 2016-06-08 18:15:06
type: conference_item
metadata_visibility: show
creators_name: Rogers, Mike
title: Tips & Tricks for Alma Analytics
ispublished: pub
subjects: Alma
divisions: eluna_conf
abstract: In this presentation I will share practical tips I’ve learned over the past year of working with Alma Analytics.  We will look at a number of helpful functions such as SUBSTRING, COUNT, TRIM, REPLACE, LOCATE, LENGTH, IFNULL, CAST, CASE, and FILTER, and learn how these can be used to create simple yet powerful formulas for extracting data.  We’ll review several formatting tips for tweaking the data output and also learn how to create a UNION query that combines two or more subject areas in one report.  Finally, I’ll demo some reports that have proven handy at our site.  I’ll strive to present material on a level that is useful to both beginners and advanced users.
date: 2016-05-05
date_type: published
full_text_status: restricted
pres_type: paper
event_title: ELUNA 2016 Annual Meeting
event_location: Oklahoma City, OK USA
event_dates: May 1-6, 2016
event_type: conference
refereed: FALSE
citation: Rogers, Mike (2016) Tips & Tricks for Alma Analytics. In: ELUNA 2016 Annual Meeting, May 1-6, 2016, Oklahoma City, OK USA.
document_url: https://beta-documents.el-una.org/id/eprint/1365/1/Rogers%20Tips%20and%20Tricks%20for%20Alma%20Analytics.pdf