Skip to content

Learning and Knowledge Sharing

Scheduled Training Classes

Monday, 3/20/2017

Introduction to UC-IRAP Star-Schemas and Data Marts

Venue: Franklin, Room 5318

Time: 2:00PM - 3:00PM

Overview of the UC Data Warehouse(UC-IRAP) architecture. Facts and dimensions. Conformed dimensions. UC-IRAP naming conventions. Walkthrough of database environments, schemas, tables and views.

Wednesday, 4/12/2017

UC-IRAP Star-Schemas and Data Marts - Live Demonstration

Venue: Franklin, Room 5318

Time: 1:30PM - 3:00PM

Demonstration of the UC Data Warehouse(UC-IRAP) using Db Visualizer CASE tool. Live walkthorugh of UC-IRAP Schemas. Facts and dimensions in UC-IRAP. Time dimension. Dimension and fact keys. Materialized query tables (MQTs) and regular views.

Friday, 4/21/2017

Using Db Visualizer

Venue: Franklin, Room 11326

Time: 3:00PM - 4:30PM

Benefits of Db Visualizer. Getting started with the tool - installation and configuration. Db Visualizer basics - connecting to a database, the object view, using the SQL Commander.

Tuesday, 4/25/2017

Using UCOP Box

Venue:Franklin, Room 12129

Time: 2:30PM - 4:00PM

Introduction to UCOP Box. When to use Box. Creating a Box account. Getting started with Box. Box user guide. Box university. Box applications - Box Edit, Box Synch and Box Mobile.

Tuesday, 5/9/2017

Using Atlassian JIRA for Requirements Management

Venue: Franklin, Room 5318

Time: 3:00PM - 4:00PM

Overview of Atlassian JIRA for requirements management. Projects and project categories. Validating requirements. Comments and watchers.

Friday, 5/19/2017

Db Visualizer - Tips & Tricks

Venue: Franklin, Room 11326

Time: 3:00PM - 4:30PM

Deeper dive into the Db Visualizer CASE tool. Exploring more functionality, short-cuts and tool use maximization.

Tuesday, 6/27/2017

Introduction to SQL

Venue: Franklin, Room 11326

Time: 9:30AM - 11:00AM

Introduction to the basics of Structured Query Language (SQL) - Simple select statements, simple and compound conditions, comparison and logical operators.

Simple SQL Queries

Monday, 8/7/2017

Contracts and Grants SPX System Reporting

Venue: Franklin, Room 10325

Time: 10:00AM - 11:00AM

Introduction to the new Contracts and Grants SPX system and its reporting environments.

Monday, 8/7/2017

Using the IRAP Code Library

Venue: Franklin, Room 11326

Time: 2:30PM - 3:30PM

Introduction to the IRAP Code Library in JIRA - Accessing the library, eligible assets, registering your asset and the asset certification process.

Wednesday, 9/13/2017

UC-IRAP Student Ethnicity Infrastructure

Venue: Franklin 12322

Time: 10:00AM - 12:00PM

Overview of the UC-IRAP Ethnicity Infrastructure - How ethnicity data is collected, reported and stored, ethnicity hierarchies, multiple ethnicities and primary ethnicity, using UC and IPEDS ethnicity data accurately and oddities to be aware of.

Tuesday, 11/14/2017

Creating, Maintaining and Publishing Data Sources on Tableau Server

Venue: Franklin 11326

Time: 1:30PM - 3:00PM

Introduction to creating and using data sources on Tableau Server. Training covers data sources and extracts, maintaining and refreshing data sources and best practices.