Tools & Applications
Resources for users of prompt-based premade reports, such as HR Reporting and University Financial Reporting (Box login required)
Cognos Video Library
Work smarter in Cognos with report scheduling, shared folders and more. Each video is less than two minutes long.
Query Studio classes*
Query Studio Basics is available as a self-service e-learning module for beginning report writers. To advance your skills, take a classroom session of Query Studio Intermediate. Query Studio will run in the new Cognos Analytics as a companion application for a limited time after the upgrade.
Workspace Advanced classes*
Learners needing report writing capabilities beyond Query Studio can learn Workspace Advanced. While Workspace Advanced will NOT be part of the Cognos Analytics upgrade, this training will familiarize report-writers with more advanced skills that will translate to the new Report Author tool.
* = Training will be available until the Cognos upgrade in Spring 2018. For information about training for the upgrade and after, click here to visit the project page.
Package and Datamart descriptions, diagrams, and other useful information(Box login required)
Data Dictionaries (Box login required)
If you are interested in customized group training for four or more users in your department, please complete this form to request a consultation with our training specialist.
Advancing Data Science & Analysis
Learning Data Analytics (Lynda)
Every person that works with analytics, from data mining to business intelligence, has to start with the raw data. The goal of this training course is to teach analysts and nonanalysts alike the basics of using data for analysis and reporting. 35 min.
The Essential Elements of Predictive Analysis and Data Mining (Lynda)
A proper predictive analytics and data-mining project can involve many people and many weeks. There are also many potential errors to avoid. A “big picture” perspective is necessary to keep the project on track. 88 min.
Data Visualization: Best Practices (Lynda)
Learn how to put data into visual and textual context to ensure it is accurate . This course, developed and led by Killer Infographics CEO, Amy Balliett, walks you through the ins and outs of creating accurate and compelling data visualizations. 75 min.
Excel 2016: Managing and Analyzing Data (Lynda)
Large amounts of data can become unmanageable fast. But with the data management and analysis features in Excel 2016, you can keep the largest spreadsheets under control. Extract the most important information from your data, in the shortest amount of time. 3 hrs.
Microsoft Excel: Data Analysis with Pivot Tables (Udemy)
Pivots allow you to quickly explore and analyze raw data, revealing powerful insights and trends otherwise buried in the noise. Learn to use PivotTables and PivotCharts to streamline and absolutely revolutionize your workflow in Excel. 6 hrs.
We will be expanding this section as our team reviews more course offerings, and invite you to share what resources you have found useful as well. If you have taken a data-related class with Lynda, Udemy, or another provider and would like to recommend it to other users, please email our training specialist to have it added to this website.
Lynda and Udemy are third-party providers and not affiliated with Washington University in St. Louis. Some departments (including but not limited to CFU, Olin School of Business, Sam Fox School of Design, Arts & Sciences) at WashU extend Lynda.com memberships to faculty and staff free of charge. To learn more or to request a temporary Lynda.com license, contact WashU IT Software Licensing. WashU IT makes no guarantee of reimbursement for any personal expenses incurred for third-party training.