Analytics for Business Decision Making - 386

Ontario College Graduate Certificate
Mix of classroom and online
Effective business decisions today come as a result of interpreting large amounts of data. Data Analytics provides the specialized knowledge necessary for you to become a skilled professional essential to an employer’s business decision making process.
Picture of a person's hand holding a pen while analyzing data on a piece of paper
Overview
Program Length ~ 2 years 
Cost ~$425 per course + textbooks
Intakes Fall, Winter, Spring
Application Process Students must apply and be accepted prior to registering

Executive style delivery

  • Analyze and interpret digital information
  • Case studies, problem solving and analysis
  • Understand key analytical, modeling, statistical and programming tools
  • The use of business analytics systems with a focus on data identification, consolidation, communication, reporting, manipulation and trending, which are critical for decisions on strategic direction and improving operational efficiencies.

osap checkmark icon OSAP Eligible. Learn about the Ontario Student Assistance Program (OSAP).

Program Contact
Continuing Education Technology
  • Prior approval for this certificate is necessary.
  • University degree or college diploma (two year or longer) including most Business programs, Computer Science, or Humanities and Social Sciences OR an acceptable combination of related work experience and postsecondary education (as determined by the college).
  • Please complete the application page and include either a copy of online course marks or a digital transcript to receive a conditional offer.
  • Original, official transcripts (in a sealed envelope from the issuing institution) must be submitted in order to receive an official, and final, offer for the program.
  • If Applicable:

    • Applicants declaring permanent resident or Convention Refugee status in Canada, must submit a copy of their Permanent Resident Card (PR card) along with their application.
    • All applicants submitting international transcripts must also provide an official and sealed credential evaluation report. This can be coordinated through any of the following:
    • An official English Language Proficiency score report outlining a minimum grade of 7 in all components.
    • Other information or documents may be requested to determine your eligibility.

Apply Now!

The program of studies displayed below applies to students starting the program in the 2019/20 academic year. Students who began in other academic years may require different courses to be eligible to graduate. If you have questions regarding a strategy for completion contact Continuing Education - Business Please note this same program is offered through both Full Time Studies and Continuing Education at Mohawk College.

Click on the Course number for more information on each course. 

Visit the Mohawk College Bookstore Textbook Search (opens in new window) for information on textbooks.

Registration for core courses in this program cannot be completed online. You must register in person, by mail, or by fax once your application for acceptance has been approved. Visit How to Register for more information.
 

Mandatory Courses

Course Number Course Name Course Description
BUSN10196 Data Modelling Model operational and dimensional representations of data appropriate for addressing business requirements. Design, import, manage and publish meta data models for use with business analytics software. 56 hours.
COMP10192 Applied IBM Business Intelligence Introducing Applied IBM Business Intelligence, a new course designed to enhance your analytics skills. Explore the latest IBM Cognos Analytics (11.0.5) suite of products and underlying architecture. Build drill-through reports, animated infographics, geospatial visualizations, and executive style dashboards through hands-on demos and labs and gain the knowledge to become a report designer. Network with guest speakers, IBM partners, BI developers and administrators. 42 hours.
COMP10214 Programming Fundamentals for Business Review different types of programming languages and develop computer programming skills necessary for using applications in business settings. Examine programming logic and control structures (decisions, looping). Using JavaScript, practice coding and debugging through the application of programming techniques using mathematical operators, arrays, classes, objects, methods, and object relationships. Write and trace algorithms. Practice fundamental skills including use of HTML and the operation of web pages manipulated by JavaScript. 42 hours.
INFO10257 Database Analytics Develop an understanding of software and computer models using object-relational database management system software, relational database design including normalization and design implementation using database management systems and SQL queries. 56 hours.
INFO10258 Excel for Business Analytics Use advanced spreadsheet techniques to analyse and present business data. Spreadsheet activities that will be examined include; nested functions, linking (or connecting) data, and pivot tables. 42 hours.
STAT10001 Statistics for Business Analytics Employ foundational statistical concepts to categorize data and solve business problems. Topics will include; data organization and display, measures of variability, probability, linear regression, sampling distributions, hypothesis testing for means and proportion and confidence intervals. Use statistical software in the application of theory. 42 hours.
BUSN10140 Strategy Analysis and Planning The foundations of Business Analysis are planning, stakeholder analysis, and structure and cultural awareness of an enterprise or business entity. Prepare for projects through needs analysis and business plan development using industry standard strategies such as project charter, interview and focus group techniques. 42 hours.
BUSN10197 Project Management for Business Analytics Apply the fundamentals of project management to the field of information technology. Utilize Project Management methodologies according to the Project Management Institutes PMBOK, (Project Management Body of Knowledge). Demonstrate an understanding and application of scheduling, scope, budgeting, risk assessment, critical path and resources through case studies. 70 hours.
BUSN10198 Predictive Modelling Use data from a variety of sources to develop and validate predictive models that will aid business planning with an emphasis on marketing trends. Combine and clean data from sources such as social media, customer segmentation, customer relationship management systems and market research. Prepare a model that responds to corporate needs within a specified confidence interval that can be easily used and maintained by non-technical users. 56 hours.
BUSN10225 Analytics Capstone Under faculty guidance and support, students choose a topic of interest, develop a project plan, execute the project, and deliver a presentation on the project. Students will apply the skills, tools, and techniques learned in the program as they identify a problem, source and acquire data sets, prepare data, analyze data, and generate visualizations for presentation. 42 hours.
COMP10187 Business Analytics for Managers Understand the types and use of business data collected and identify the how and why of using it. Identify and examine legal, ethical and strategic uses of Business Practice handling of important and significant data and appropriate data analysis using case studies and individual and group assignments through in-class and virtual delivery. 42 hours.
COMP10233 Analytics Programming Learn programming languages and apply programming techniques for use in data analytics applications. Load and manipulate data sets using the computer languages Python and R. Explore and utilize different development environments and libraries that support data preparation and data analysis activities for different types of data. 42 hours.
CRED10128 Career Discovery for Analytics Professionals

Explore the Certified Analytics Professional designation and what it means to be an analytics professional. Develop connections with industry to help formulate job search strategies and investigate ongoing professional development opportunities in the field of business analytics. Identify and develop a network of online resources and communities to maintain and explore current practices in the industry. 42 hours.

COMP10214 must be taken first. BUSN10197, BUSN10225, COMP10187, and CRED10128 should be taken last.

OntarioLearn Equivalent: MGMT10121 (Business Analysis Introduction) is equivalent to BUSN10140 (Strategy Analysis and Planning).

The list of scheduled course offerings for this program is below. Please note that all offerings are subject to change. Not every course is offered every semester, so please consider this schedule when planning your academic path.

Course Code Course Name Winter 2020
(Jan to Apr)
Fall 2020
(Sep to Dec)
Winter 2021
(Jan to Apr)
Fall 2021
(Sep to Dec)
BUSN10196 Data Modelling

 

    X
COMP10192

Applied IBM Business Intelligence

      X
COMP10214 Programming Fundamentals for Business

 

X    
INFO10257 Database Analytics

 

    X
INFO10258 Excel for Business Analytics

 

X    
STAT10001 Statistics for Business Analytics

 

X    
BUSN10140 Strategy Analysis and Planning

 

  X  
BUSN10197 Project Management for Business Analytics

 

  X  
BUSN10198 Predictive Modelling

X

     
BUSN10225 Analytics Capstone X   X  
COMP10187 Business Analytics for Managers

X

     
COMP10233 Analytics Programming

X

     
CRED10128 Career Discovery for Analytics Professionals

 

  X  
Getting Started

Login to MyMohawk
MyMohawk is the college portal used to access your student account information, email, grades and more. Your username and password can be found on the Continuing Education Acknowledgement of Registration & Student Account form that was sent to you after you registered for your course. Visit the Getting Started - MyMohawk Guide for step-by-step instructions.

Access Mohawk Email
On the MyMohawk Home screen you will see a link to Mohawk email. Visit the Getting Started – Mohawk Email Guide to learn how to set up your account on your devices.

Access eLearn
On the MyMohawk Home screen you will see a link to eLearn. Visit the Getting Started - eLearn Guide for step-by-step instructions. Please note your course will not appear in eLearn until the scheduled start date.

Find your Classroom
Room assignments for Continuing Education are available on the WhereEnCampus Portal. Visit Room Listings for more information.

Find your Textbook
Use the Mohawk College Textbook Search to find your course materials.

Explore Student Services available

Learning Outcomes

Program Learning Outcomes, often referred to as ‘Program Standards', set out the essential learning that a student must achieve before being deemed ready to graduate.

In many cases these program learning outcomes were developed by the Ministry of Colleges and Universities (MCU) in consultation with employers and educators who are experts in the program field. To ensure the outcomes remain current and in line with industry needs, we invite our employers, graduates working in the field and current students to re-examine and update them during regular, ongoing program review focus groups.

Career Opportunities

  • Data Scientist
  • Advanced Analytics Professional
  • Data Analyst
  • Business Analyst
  • Business Intelligence Professional

Industries of Employment

  • Tech Industry
  • Marketing
  • Finance
  • Insurance
  • Media
  • Healthcare
  • Sports and Entertainment

Opportunities for Graduates

  • Certified Analytics Professional credential

Computer Requirements:

Windows 7 with a minimum of 4 Gig Ram and Microsoft Office 16 (supplied free through the Office 365 student account)

Microsoft Project 2016 (Purchase through the College Webstore – student pricing applies)