Data Analysis and Visualization

Demand for data analysis and visualization skills are rapidly increasing across all industries. Boost your career with our range of courses covering IBM SPSS, Excel and more. Don't see what you're looking for here? Contact us at training@ualberta.ca to learn about our custom training options.


Courses

Note: If no classes are visible when you click the "View Upcoming Classes" button, no sessions are scheduled at this time. Please contact training@ualberta.ca if you are interested in a particular course or require a specific date - we're happy to help!

Crystal Reports

Crystal Reports is a business intelligence tool that allows users to quickly create custom reports from various data sources, including Excel, Access MySQL, XML, Oracle and many more. Learn how to plan, create and modify simple reports in our one day hands-on class.

Course Details

Prerequisites:

  • Good understanding of Windows and Microsoft software
  • Basic Knowledge of Databases

Duration: 1 day

Multiple course sections are open to registration. Click the link below to view all available dates.

Registering at least one week before the deadline is recommended as this class may fill up or be cancelled due to low enrolment.

View Upcoming Classes

IBM SPSS Application

Use of statistical software continues to increase and therefore, an introductory level course will be offered if sufficient enrolment can be attained. The course is designed to introduce SPSS features to individuals who have not used the software before. It will start at a very basic level covering the menu, tool and status bars then moving onto the data editor, Output Window, Chart Window and inferential statistics. In the last area of inferential statistics the course will cover the Statistics menu and use examples of exploratory analysis, regression and analysis of variance.

Course Details

Prerequisites:

  • Basic computer skills and knowledge of Windows

Duration: 1 day

Multiple course sections are open to registration. Click the link below to view all available dates.

Registering at least one week before the deadline is recommended as this class may fill up or be cancelled due to low enrolment.

View Upcoming Classes
Statistical Analysis Using Excel

This course will introduce students to both descriptive and uni-variate inferential statistical procedures used commonly in social science research. The emphasis for this course, however, will be on the application of these procedures in the spreadsheet environment of Microsoft Excel. Three different aspects of statistical reasoning will be emphasized: (1.) computational formulas and assumptions, (2.) spreadsheet applications using Excel, and (3.) appropriate uses of these statistics. The topics we will cover include descriptive summary statistics, correlation, regression, t-tests, and analysis of variance (ANOVA).

Course Details

Prerequisites:

  • Excel Level 2 or equivalent knowledge/experience

Duration: 1 day

Multiple course sections are open to registration. Click the link below to view all available dates.

Registering at least one week before the deadline is recommended as this class may fill up or be cancelled due to low enrolment.

View Upcoming Classes
Statistical Analysis Using IBM SPSS

This course will introduce students to both descriptive and uni-variate inferential statistical procedures used commonly in social science research. Three different aspects of statistical reasoning will be emphasized: (1.) computational formulas and assumptions, (2.) computer applications using SPSS, and (3.) appropriate uses of uni-variate statistics. The topics we will cover include descriptive summary statistics, correlation, regression, t-tests, and analysis of variance (ANOVA). Very little time will be spent on data manipulation and data transformation (as these topics are covered in the SPSS Application)

Course Details

Prerequisites:

  • SPSS Application or equivalent knowledge experience

Duration: 1 day

Multiple course sections are open to registration. Click the link below to view all available dates.

Registering at least one week before the deadline is recommended as this class may fill up or be cancelled due to low enrolment.

View Upcoming Classes
Statistical Analysis and Visualizations Using JASP

Learn how to perform statistical analysis and create data-driven graphics using JASP, a free, open-source and user-friendly alternative to SPSS. This introductory course will combine a review of statistical concepts and theories with guided data analysis exercises using JASP. Procedures commonly used in the social sciences, public health and similar areas will be covered.

Course Details

Prerequisites:

  • Good understanding of Windows and Microsoft software
  • Basic understanding of descriptive and univariate statistics

Duration: 1 day

Multiple course sections are open to registration. Click the link below to view all available dates.

Registering at least one week before the deadline is recommended as this class may fill up or be cancelled due to low enrolment.

View Upcoming Classes

Statistical Analysis and Visualizations Using R

Learn how to describe, visualize and analyze data using R, a free, open-source statistical analysis program used by researchers around the world! In this class, we will explore the basic structure and functions of R and practical applications of the program, such as data management.

Course Details

Prerequisites:

  • Good understanding of Windows and Microsoft software
  • Basic understanding of descriptive and univariate statistics

Duration: 1 day

Multiple course sections are open to registration. Click the link below to view all available dates.

Registering at least one week before the deadline is recommended as this class may fill up or be cancelled due to low enrolment.

View Upcoming Classes

SQL Querying: Fundamentals

Many organizations use databases to store critical information used to manage day-to-day operations. Unfortunately, this data is useless unless you can retrieve it for further business analysis. In SQL Querying: Fundamentals, you'll learn how to use Structured Query Language (SQL) as a tool to retrieve the information you need from Microsoft SQL Server 2012, a common database management system.

Course Details

Prerequisites:

  • Basic end-user computer skills and some familiarity with database terminology

Duration: 2 days

Multiple course sections are open to registration. Click the link below to view all available dates.

Registering at least one week before the deadline is recommended as this class may fill up or be cancelled due to low enrolment.

View Upcoming Classes