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