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