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
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
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
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
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.
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
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.