Important Notice: COVID-19 Institute response

Part-time Certificate 5512cert

Learn To Be A Data Analyst

Fall 2020 Delivery Mode: ONLINE
  • This program will be delivered online for the fall semester.
  • Your education is our priority and we will continue to deliver the applied instruction, collaborative experience, and industry connections that you expect from BCIT.

The Applied Data Analytics Certificate, ADAC from BCIT Computing provides the technical foundations for data analytics systems.

Students build systems that model data, and learn to use IT tools to mine data for business intelligence and data-driven decision making.

The focus of ADAC is to build and data analytics systems and use popular visual analytics tools like Tableau and PowerBI.

Starting with relational database foundation students use Excel, SQL Python and statistics to develop data analytics systems.

ADAC elective courses include: UX/UI, database development, business intelligence tools for performance management and evidence-based decision making.

Some students may wish to complete the Applied Database Administration and Design Associate Certificate, ADAD first.
Course credit will apply for both credentials if ADAD is completed first.

Upon program completion, students will be able to develop secure business intelligence database solutions for data analytics.

ADAC graduates will be able to create, manage and use data analytics systems to help organizations make informed and actionable decisions.
 

Keep up to date with current data analytics technologies and business intelligence tools.


Program Entry

Important Notice: BCIT suspended declaration into the Applied Data Analytics Certificate program for all international students on May 30, 2019. This short-term program declaration suspension will provide better course availability for current declared students.

    COMP 1002 or equivalent knowledge of file management on a Windows based PC.

    Plus COMP 2010 or COMP 1362 or equivalent knowledge of MS Excel Spreadsheet Fundamentals.

    BC High School Grade 12 English and Grade 12 Math, or equivalent knowledge are recommended for success.

    Students in this program are required to have solid English comprehension, reading, writing and speaking skills.

    Specific prerequisites or equivalent knowledge are required for each course. Please complete courses via the tier sequences as indicated.

    The Applied Data Analytics Certificate (ADAC) program is aimed at mature students with other post-secondary education looking to acquire an additional set of skills that are needed in the marketplace.

    ADAC is not designed for those students just out of high school with no other education or work experience; those students should consider completing a Diploma or Degree in order to be well positioned in the job market.

    Depending on electives, students may be able to complete this BCIT credential with as few as sixteen courses, part-time in the evenings and on weekends.

    Students who have completed or who are in process of completing the Associate Certificate in Applied Database Administration and Design (ADAD) will have advanced standing in ADAC.

    It is recommended that ADAC students complete COMP 1630 prior to taking MATH 1060.
    Those students who have been away from higher math or need a refresher should consider completing the new online MATH 0060 prior to MATH 1060.
    There may be additional MATH prerequisites depending on your prior education as MATH 1060 assumes an understanding of high school MATH 12 precalculus.

    Part-time Studies program delivery:

    This program is designed for course by course delivery in part-time studies and it was not designed for students on limited timelines.

    Not all required higher-level and elective courses may be offered each term and some PTS courses are only offered once per year.

    It is not possible to complete the Applied Data Analytics Certificate, ADAC in a full-time delivery and in no less than 5 terms.

    Attempting 3x COMP courses per term can equate to a 40+ hour workload per week and take 2 years to complete ADAC.

    Finishing 2x COMP courses per term equates to a 25+ hour workload per week and 3 years to complete the program.

    Students have a maximum of 5 years to complete ADAC. Courses have specific prerequisites, and must be completed first..

    Complete Tier 1 before starting Tier 2. Please COMP 2854 and MATH 3060 before starting Tier 3.

    Please contact the department after completing COMP 1630 and MATH 1060 if you require additional course planning advice, email: cstpts@bcit.ca

Complete COMP 1630 Relational Database Design and SQL prior to declaring the Applied Data Analytics Certificate (ADAC).

Program declaration

Declaring your Part-time Studies program ensures that BCIT is aware of your intent to complete a program as it is currently outlined and provides you the opportunity to apply for transfer credit.
Learn more about program declaration

To submit your declaration:

  • Answer all questions completely.
  • If required, convert transcripts and documents to PDF files.
  • Have a credit card ready to pay the application fee.
Declare Now

Upon approval, a program plan letter will be sent to you confirming your program of study. Please allow approximately eight weeks for processing.

Scheduled intakes

Ongoing Part-time Studies intakes: January, April and September
Some summer sections may also be available.

Prior Learning Assessment & Recognition (PLAR)

Phone 604-432-8465 or email cstpts@bcit.ca to find out if PLAR is available for the course you wish to receive credit.

Costs & Supplies

All Computing Part-time Studies programs are course by course registration.

Students should have a personal computer with internet access capable of running MS Windows 10.

There are typically 16 courses required to complete the CSC.

Canadian and PR students should budget $10,000 for tuition and books.

The average cost for each PTS course for Canadian citizens and permanent residents is around $500-$600 per course plus books.


Typical part-time students may complete the ADAC over 3 years with 2 courses per term. This would equate to an average workload of 25+ hours per week.

Some students may complete ADAC over 2 years (5-6x PTS terms) with 3 specific courses per term which equates to an average workload of 40+ hours per week between class time, reading and homework.

Attendance and participation are mandatory, students who skip classes or who do not participate may be dropped from a COMP course.

NOTE:
Please register early to avoid disappointment, our database courses are very popular and fill weeks or months in advance.

Important Notice: BCIT suspended declaration into the Applied Data Analytics Certificate program for all international students on May 30, 2019. This short-term program declaration suspension will provide better course availability for current declared students.

Tuition fees

Please see the Part-time Studies Tuition & Fees page for information on part-time tuition fees.

Courses

Class hours

Part-time studies delivery on evenings and weekends.COMP courses typically run weeknights at the Burnaby Campus from 6:30-9:30 p.m. and at the Downtown Campus from 6:00-9:00 p.m.

Program delivery

Courses are primarily delivered in Windows based PC computer labs in a lecture/lab format. Please review COMP 1002 Applied Computer Concepts for required expectations. Students must be computer literate and able to manage file systems on a network.

Program matrix

Check current availability of courses for this program.

Tier 1 Required Courses (11.0 credits) Credits
Complete Tier 1 before declaring the program and taking Tier 2 or 3 courses.
  COMP 1630 Relational Database Design and SQL 5.0
  COMP 2362 Microsoft Excel Advanced 1.5
  COMP 2454 Python Fundamentals for Data Analysis* 1.5
  MATH 1060 Statistics for Data Analysis 3.0
*COMP 2454 may be used as an elective for students with prior program approval. Students who have not completed MATH 1060 should complete COMP 2454 first.
 
Tier 2 Required Courses (16.5 credits) Credits
Courses within the tiers can be taken in any order as long as the course prerequisites are met. To be successful, it is recommended that you complete Tier 2 courses before Tier 3.
  COMP 2156 Introduction to Microsoft Power BI 1.5
  COMP 2256 Introduction to Visual Analytics with Tableau 3.0
  COMP 2831 Business Analysis and Systems Design 4.0
  COMP 2854 Data Analytics Fundamentals** 3.0
  COMP 3838 Data Warehouse Foundations for Business Intelligence 1.0
  MATH 3060 Advanced Statistical Techniques for Data Analytics 4.0

**All Tier 1 courses required as prerequisites.

 
Tier 3 Required Courses (11.5 credits) Credits
  BLAW 3205 Internet and IT Law 3.0
  COMP 3704 Applied IT Security Fundamentals 3.0
  COMP 3839 Data Quality Improvement 1.5
  COMP 3840 Introduction to Big Data and Hadoop 1.0
  COMP 4254 Advanced Topics in Data Analytics 3.0
 
Elective Courses (6.0 credits) Credits
Complete 6.0 credits from the following list of electives:
  COMM 7840 Technical Presentations 1.5
  COMP 1011 UX/UI Fundamentals 3.0
  COMP 1288 IT Project Management 1.5
  COMP 2252 Crystal Reports 3.0
  COMP 4678 Microsoft SQL Server 2016 Development 4.0
  COMP 4679 Business Intelligence with SSRS, SQL Server Reporting Services 4.0
  COMP 4680 Business Intelligence with SSIS, SQL Server Integration Services 4.0
  COMP 4681 Business Intelligence with SSAS, SQL Server Analysis Services 4.0
  HLED 7250 Leading Performance Measurement and Management 3.0
  HLED 7260 Leadership Issues in Evidence-based Decision Making 3.0
 
Total Credits: 45.0

Check current availability of courses for this program.

Transfer credit

Do you have credits from another BC/Yukon post-secondary school? Do you want to know if they transfer to courses here at BCIT? Check out BCIT's Transfer Equivalency Database to find out.

Program Details

Computer hardware and Internet requirements
COMP courses are now conducted entirely online until further notice. Students must provide a current model PC desktop or laptop with a web cam, microphone and have high speed internet access. Courses will be delivered in real time and may use two way audio and video as well as group work.

Students must be computer literate and be able to log in during regular scheduled class hours in order to participate and complete each COMP course. Please contact the department via email: cstpts@bcit.ca if you have any questions.

Program specific details:

ADAC includes group work, written communications of technical system specifications and oral presentations in a team environment.

After completing the core courses in Relational Database Design with SQL, Business Analysis and Systems Design and Data Warehouse Foundations for Business Intelligence, students then have a variety of Business Intelligence elective choices from SAP and Microsoft.

Electives also include: Technical Presentations, UX/UI Development, IT Project Management, Performance Management and Evidence-based Decision Making.

This program must be completed within 5 years. Students who only complete one course per term will take 5 years to finish this certificate. Those students who complete two courses per term may typically complete the ADAC program over 3 years.

Some students may complete ADAC over 2 years (5-6x PTS terms) with 3 specific courses per term. This will equate to an average workload of 40+ hours per week between class time, reading and homework.

Please contact the department for course planning: cstpts@bcit.ca



Not all courses are offered every term and each course has specific prerequisites.

Some COMP courses prepare students for Industry exams which are independent from BCIT credentials. These exams may be purchased for additional costs, from various third parties. Students will also require additional preparation and studying in order to pass these industry certification exams.

NOTE: This part-time certificate program is not designed for fast-track delivery and it will take a minimum of 5-6 PTS terms or 2 years to complete.


Students who hold a bachelor's degree or higher, and are looking for an applied business analytics program to learn how to harness data and make data-driven business decisions, might consider the Graduate Certificate in Business Analytics available from BCIT's School of Business.


Important Notice: Computing Part-time Studies is course by course registration and was not designed for students on limited timelines. International students and those on funding timelines should instead apply to Full-time programs. Please read the details on the program entry page.

Program length

This program must be completed within 5 years. Students who only complete one course per term will take 5 years to finish this certificate. Those students who complete two courses per term may complete the program in less than 3 years.

NOTE: Not all courses are offered every term and each course has specific prerequisites.

Grading

Each COMP course in this program has a passing grade of 60%

Accreditation

Several of the Microsoft SQL-related electives in this program provide preparation for Microsoft Certification exams.

Students will also require additional preparation and studying in order to pass these industry certification exams.

Note: Industry exams are independent from BCIT credentials. These exams may be purchased for additional costs, from various third parties.

Program location

Courses are offered either at the Burnaby Campus or at the Downtown Campus

Program abandonment

  • Students approved for a part-time studies program are expected to register and complete courses on a continuous basis.

  • A student that has not completed a course from their approved program of study over a period of three consecutive academic terms will be considered to have abandoned the program.

  • Throughout the duration of the program, a student is permitted a maximum of five academic terms where they are not required to register and complete a course from their approved program of study. Students who exceed the five term maximum will be considered to have abandoned the program.

  • Students who have abandoned their approved program of study and wish to be reinstated will be required to apply for program approval for a current credential. BCIT cannot guarantee that courses taken prior to this reapplication will be credited towards the current credential.

BCIT Policy 5103 - Student Evaluation [PDF] permits a maximum of three attempts to successfully complete each course within a credential.

Graduating & Jobs

Graduate employment outcomes

The BCIT student outcomes reports present summary findings from the annual survey of former students administered by BC Stats one to two years after graduation. These reports combine the last three years of available results for the 2017-2019 BCIT Outcomes Surveys of 2016-2018 graduates and for Degree 2015-2017 graduates. The reports are organized into three-page summaries containing information on graduates' labour market experiences and opinions regarding their education. More detailed information can be accessed at the BC Student Outcomes website.

To view these results, you may need to have the Adobe Acrobat Reader installed in your Web browser.

Apply for graduation

Upon successful completion of all program requirements, complete an Application for BCIT Credential [PDF] and submit it to Student Information and Enrolment Services.

Allow approximately six to eight weeks for processing.

All financial obligations to the Institute must be met prior to issuance of any credential.

Students on Limited Timelines

Important Notice: BCIT suspended declaration into the Applied Data Analytics Certificate program for all international students on May 30, 2019. This short-term program declaration suspension will provide better course availability for current declared students.


IMPORTANT NOTICE:

Students who require a minimum course load to retain eligibility for financial aid or international student status have no guarantees that all or any Part-time Studies (PTS) courses will be available in any given term.

Please understand that there is also no guarantee that the minimum required course credits can be sustained from term to term in PTS.

Most PTS courses fill quickly so space is not guaranteed and courses may be cancelled before term start if there is insufficient interest.

This may impact both the number of courses a student is able to take in any term, and the time it takes to complete a PTS credential.

As a result, students may not be able to obtain the minimum credits they need or want in each term to continue in the program.

Computing Part-time Studies

ADAC was not designed for those attempting to complete this certificate program in a full-time delivery model of less than 2 years or 6x PTS terms.

Most Computing Part-time Studies credentials cannot be fast-tracked in less than 2 years due to prerequisites and scheduling.

Please make allowances for this 2 year minimum time requirement in your funding or student visa applications.

Faculty, Advisors & Staff

BCIT Computing Part-time Studies COMP courses are delivered by subject matter in Computing and Information Technology, Math, Business Systems, Law, Business Intelligence and Analytics.

The Applied Data Analytics Certificate, ADAC program was developed in conjunction with subject matter experts.

Program surveys and proposals were coordinated by Cynthia van Ginkel, Business Development Manager for SoCAS.

Both ADAD and ADAC were created and developed by Kevin Cudihee, Program Head for BCIT Computing PTS and Industry Training.

BCIT Computing Part-time Studies courses are delivered by subject matter experts who work in the field.

Courses were developed and delivered by: Diana Gerrard, Joanne Atha, Andrew McConnell, Takashi Nakamura, Benjamin Yu, Frank Wegener, Glen Elliott, Alex Volkov, Pat MacGee, Hessam Teimouri, Dean Palmer, Donabel Santos, Roland Santos, Gordon Hamilton, Steve Overland, and Farshad Abasi.

Elective courses were developed by Arron Ferguson, Andre Coetzee, Cathy Michitsch, Marin Kostadinovic, Kirk Mitchel and Shan Satoglu.

Administrative support is provided by Joanne Atha.


Advisory committee

This credential was approved by the Computer Systems Technology, CST Curriculum Committee and School of Computing an Academic Studies Quality Committee, SQC.

Contact Us

Please email BCIT Computing Part-time Studies:

Email: cstpts@bcit.ca

General Inquiries: 604-432-8465

Questions or comments?

Please ensure you have reviewed the detailed information on this site, using the navigation to the right, before submitting the form below.

As well, if you meet any of the following criteria, please follow the links for more information, instead of sending the form:

The personal information on this form is collected under the authority of the College and Institute Act (RSBC 1996, Ch.52). BCIT will use this information to communicate with you regarding relevant BCIT programs, courses and services. This information is only used by authorized BCIT staff. Email communication sent to and from BCIT is routed through the United States of America. If you have any questions about BCIT's collection and use of this information, please contact BCIT’s manager of Information Access and Privacy.

Subscribe

Sign up to receive updates, invitations to events, and information about BCIT and your program.

We promise not to spam you, we won’t share your personal information, and you can unsubscribe at any time.

The personal information on this form is collected under the authority of the College and Institute Act (RSBC 1996, Ch.52). BCIT will use this information to communicate with you regarding relevant BCIT programs, courses and services. This information is only used by authorized BCIT staff. Email communication sent to and from BCIT is routed through the United States of America. If you have any questions about BCIT's collection and use of this information, please contact BCIT’s manager of Information Access and Privacy.

How To Apply

Subscribe

Contact Us

Information Sessions

Attend an upcoming information session for this program:

Explore all upcoming BCIT info sessions.

Payment Changes At BCIT

We've changed the way we accept payments.

Find out more

Search Programs

Testimonial

“Every organization that I know – big or small, from social non-profits to manufacturing - runs on data, and studies have shown that 20-35% of the average organization’s operating revenue is lost every year due to poor data quality. The cleaner the data, the better your modeling will be, and the better your bottom line.”
Gordon Hamilton, Instructor and Senior Data Quality Specialist, EA

Testimonial

“The need to analyze and mine data will only grow; the amount of data we have is only limited by input. I returned to BCIT to study part time and earn a certificate in Applied Data Analytics. Through BCIT’s hands-on exercises and unique applied learning I find my retention is exceptional.”

Stuart Budd, Intermediate Business Analyst, Agreement Express CST grad and ADAC student

Start With Just One Course