School of Business and Technology Diploma
Oracle SQL, Microsoft Azure Fundamentals

Data Analyst

Turn raw data into decisions employers act on, and become a data analyst within about a year.

A

A direct path to employment, Robertson graduates finish ready for the workforce with practicum placement and hiring support from Robertson Workforce.

Prefer to learn in person? Please contact us.

Learn more about Workforce

Find the story your organization’s data is telling

Exam Preparation Microsoft Certification

Students are eligible to request industry certification vouchers toward AZ-900 (Microsoft Azure) and 1Z0-071 (Oracle Database SQL).

Credential Diploma · 12 Months
Practicum 3 weeks

Robertson’s Data Analyst Diploma program will prepare you for an in-demand, rewarding role that you can find in a variety of industries. While you’re a student, you’ll learn how to ethically collect data, articulate that data, and present findings to coworkers.

A Data Analyst is responsible for designing databases and developing and administering data management solutions across a broad range of private and public sectors. Data Analysts are responsible for compiling and merging data, cleaning data and using a variety of tools and software to extract information from datasets. They are also responsible for reporting data findings through data visualizations, reports, dashboards, scorecards, and a variety of other methods.

Data Analysis is used to support Business Intelligence and ensure that private and public sectors can make informed decisions from data.

Thirteen courses from collection to compelling reports

  1. 1.

    Data foundations

    • Introduction to the Data Analyst Profession – 20h
    • Business Intelligence – 100h
    • Statistical Methods – 80h
  2. 2.

    Collection and management

    • Data Collection – 100h
    • Database Design – 100h
    • Data Manipulation – 100h
  3. 3.

    Visualization and reporting

    • Data Visualization – 80h
    • Dashboards – 80h
  4. 4.

    Tools and delivery

    • Microsoft Office Applications – 80h
    • Project Management – 80h
  5. 5.

    Communication and career

    • Business Communication – 60h
    • Presentation Skills – 40h
    • Career Preparation – 40h

Where data analysts put their skills to work

Job titles graduates land

Business Analyst Data Analyst Database Clerk Innovation Specialist

Recent graduate placements

Analytics Teams Public Sector Agencies Technology Firms

Potential Earnings

$52,000–$126,942

in a year or less, after graduation

jobbank.gc.ca

12 months, broken into 13 courses

Business Intelligence

100h

This course introduces students to the concept of Business Intelligence (BI) and how this serves as a foundation for the data analysis profession. Students will develop an understanding of BI approaches across disciplines such as banking, healthcare, government, and education. They will be introduced to key technologies used within these disciplines to support BI. Students will develop the skills to support effective BI through the use of data.

Business Communication

60h

This course provides students with the knowledge and tools to communicate effectively and professionally in the workplace. Students will be introduced to essential skills in writing, speaking, formal presentations and the use of technology to enhance workplace communication.

Dashboards

80h

In this course, students will be introduced to the design and development of dashboards. Students will develop the capacity to develop effective data dashboards, use dashboard technology effectively, and design dashboard to best fit organizational and reporting needs. Students will develop the skills to support data analytics through effective dashboards visualizations.

Database Design

100h

In this course students will develop the capacity to develop and design databases. Students will develop the skills to design databases using common models and structures. They will be introduced to the elements of different databases and how to develop schema for each. Students will develop the skills to develop databases tailored to a variety of BI and data needs.

Data Collection

100h

This course introduces students to the process of data collection and storage. Students will be introduced to the processes of data collection, integration, storage, cleaning, and data security. Students will also explore the concept of ethical collection, storage and use of data. Students will develop the skills to effectively collect and manage data.

Data Manipulation

100h

In this course students will be introduced to the process of data manipulation. Students will develop the skills to manipulate data in Excel and will learn scripting languages such as Python and SQL. Students will develop a broad understanding of data manipulation techniques and technologies.

Data Visualization

80h

This course will introduce students to data visualization techniques and strategies. Students will develop the capacity to develop effective data visualizations, use data visualization technology effectively, and design visualizations to best fit organizational and reporting needs. Students will develop the skills to support data analytics through effective visualizations and storytelling.

Introduction to the Data Analyst Profession

20h

This course introduces students to the Data Analyst profession. Students will develop an understanding of the roles and responsibilities of Data Analysts, along with the professional competencies expected within the discipline. They will explore the concept of professionalism and how ethical practice frames the work of Data Analyst professionals. Students will develop a comprehensive understanding of the profession.

Microsoft Office Applications

80h

This course will prepare students to perform functions common to all Microsoft Windows applications. Elements include the ability to create and manipulate Word, Excel, or PowerPoint applications, modify the display of toolbars and other on-screen elements, use online help, and perform file management, editing, formatting and printing functions common to most Windows applications.

Presentation Skills

40h

This course introduces students to the skills needed to develop effective written and oral presentations. Students will explore the key components of crafting effective reports and presentations. They will be introduced to a variety of technologies that can be used to support these activities. Students will develop the foundational skills to communicate data findings with key audiences and stakeholders.

Project Management

80h

This course will provide students with the skills, knowledge and tools to manage and execute projects efficiently and successfully.

Statistical Methods

80h

This course provides students with a concrete foundation in probability and statistics as it relates to data analytics. Students will develop their understanding of statistical thinking, sampling and probability, inferential and descriptive statistics. Students will develop the skills to apply statistical reasoning and inference to sets of data and make comparisons between the differences in machine learning and statistical models.

Career Preparation

40h

This course introduces students to the idea of professionalism and preparation for employment. Students will be introduced to the professional standards and skills required within their industry. Specific skills related to employability such as developing a resume, networking, career paths, and professional learning will be covered. This course develops a student’s capacity to become a skilled and insightful professional.

One flat tuition, no surprises

Program Tuition

Includes all applicable fees, ebooks and courseware

Fees, ebooks, courseware included

$17,995

Tuition total

$17,995

Enrolling now for upcoming cohorts

Applying to Robertson College is simple, with no fee to apply and no commitment. If you'd rather talk it through first, book a 15-minute call with an advisor: they'll walk you through admission, financing, and which way to learn is best for you.