Skip to content

Learning and Knowledge Sharing

Scheduled Training Classes

Monday, 3/20/2017

Introduction to UCDW Star-Schemas and Data Marts

Venue: Franklin, Room 5318

Time: 2:00PM - 3:00PM

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

Wednesday, 4/12/2017

UCDW Star-Schemas and Data Marts - Live Demonstration

Venue: Franklin, Room 5318

Time: 1:30PM - 3:00PM

Demonstration of the UC Data Warehouse using Db Visualizer CASE tool. Live walkthorugh of UCDW Schemas. Facts and dimensions in UCDW. 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

UCDW Student Ethnicity Infrastructure

Venue: Franklin 12322

Time: 10:00AM - 12:00PM

Overview of the UCDW 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.