Business Analytics
Overview
Business Analysts have become an integral part of every organization and have the responsibility to adopt modern technologies, methodologies, and historical data to develop insight and improve on future business processes across the organization.
With improved globalization and constant innovation across different industries, there has been an increased demand for employees with unique skill sets in identifying, describing, and interpreting various forms of business generated data that help inform corporate decisions in order for companies to stay relevant and competitive. In line with these employer demands, the Lambton College Business Analytics, Ontario College Graduate Certificate helps train students to explore, understand, and ultimately influence business planning within organizations where necessary.
In the program, students are equipped with the requisite industry knowledge needed to drive innovation and change in any organization. More so, the curriculum delves into core Business Analyst expertise required such as project and task planning, statistical analysis, report writing, resource management, eliciting, documenting, and communicating requirements, process modelling and improvements, project management and business communication among others.
In addition, students study topics such as business analysis core concept models, requirement documents. and software testing development life cycles and methodologies. The program also covers many industry applications and techniques such as SQL, Salesforce, JIRA, Confluence, Microsoft Visio, Microsoft Power BI Waterfall and Agile Methodologies and Requirements Elicitation among others.
Admission Requirements
- University degree in business, commerce, mathematics, statistics, or another related discipline
The admissions process is competitive and meeting the minimum academic requirements does not guarantee admission.
Lambton College reserves the right to alter information including admission requirements and to cancel a program or course at any time; to change the program curriculum as necessary to meet current competencies or changes in the job market; to change the pathways to third-party certification bodies; or to withdraw an offer of admission both prior to and after its acceptance by an applicant or student because of insufficient applications or registrations or over-acceptance of offers of admission. In the event Lambton College exercises such a right, Lambton College's sole liability will be the return of monies paid by the applicant or student to Lambton College.English Language Requirements
- IELTS of 6.5
-or-
IELTS of 6.0 + Completion of EAP-3106 (English for Academic Purposes) during the first term of study
- or -
- TOEFL iBT 79
-or-
ITOEFL 70 + Completion of EAP-3106 (English for Academic Purposes) during the first term of study
- or -
- Passed Lambton Institute of English placement test
Please Note: IELTS is the only proficiency score accepted by the Study Direct Stream (SDS) program. Additional country-specific requirements may also be applicable.
Meeting the minimum English requirements does not guarantee admission. Students with higher English proficiency scores will receive priority in the admission assessment process. Not all students will qualify for EAP-3106 in place of the required IELTS or TOEFL test scores.
Costs
- Term 1 $9,629.14
- Term 2 $8,690.62
- Term 3 $9,315.19
- Term 4 $0.00
Total Cost of Program
Tuition fees are estimates and are subject to change each academic year. Fees do not include books (unless specifically noted), supplies or living costs.
Lambton College reserves the right to alter information including admission requirements and to cancel at any time a program or course; to change the location and/or term in which a program or course is offered; to change the program curriculum as necessary to meet current competencies or changes in the job market; to change the pathways third-party certification bodies; or to withdraw an offer of admission both prior to and after its acceptance by an applicant or student because of insufficient applications or registrations or over-acceptance of offers of admission. In the event Lambton College exercises such a right, Lambton College’s sole liability will be the return of monies paid by the applicant or student to Lambton College.
Additional Fees
WIL Project Fees
Students who are not successful in securing a co-op or fail to meet the co-op requirements will need to register in CPL-5559 WIL Project.
There is an additional fee of $2,100 for each student enrolled in the WIL Project course.
Important Dates, Deadline & Late Fees
For additional information on registration dates, deadlines and late fees please refer to Registration Dates and Deadlines.
Student Fees
A student services fee is included in your tuition.
Health Insurance Coverage
Emergency medical insurance is mandatory for all international students at Lambton College. This includes students who are full-time and part-time and who are on a co-op. This insurance is provided by guard.me - a third party insurance provider.
See Insurance Costs & DetailsTechnology Requirements
In order to keep pace with the requirements of each and every course in your program, Lambton College requires that each student have access to a laptop while studying at our college.
Courses
Intrduction to Statistical Analytics
Students (1) propose solutions using exploratory and descriptive approaches; (2) apply probability distributions (3) compute point and interval estimation for various population parameters, (4) infer properties using hypothesis testing and (5) Produce business insights based on data analysis techniques. As a term project, students complete a capstone project involving a business problem where real data is used. Plausible solutions to such problem are expected to involve techniques and tools presented throughout the course.
Project Management Fundamentals for Canadian Business
This course introduces students to the essential logical flow of project management concepts, tools and techniques that can be immediately applied in the Canadian workplace. Students will review different project management case studies and generate a summary report of all the key skills required to be an effective project manager. Students will gain more experience with indemand skills that employers seek in MS Office (Word, Excel), scheduling software, document management, and record keeping, management of meetings, budgeting, and communications.
Manageing Requirements & Engagement for the Canadian Workforce
This course requires students to adopt a holistic approach to business analysis engagement and requirements management for the Canadian work environment. Students learn how to approach, plan, execute, and close a business analysis engagement using software such Jira, Confluence, Workforce and Trello. Topics include stakeholder analysis, traceability, writing, elicitation, verification, validation, approval, and change. Students explore these topics through discussions and written assignments completed as individuals and groups. A major case study simulates a complete business analysis engagement.
Big Data Fundamentals
Big Data Fundamentals introduces students to Big Data, the data-driven organization and how to leverage Big Data to gain insights to support, improve, and reinvent the enterprise to better service customers and better address data variety, velocity, and volume. Students explore Big Data best practices, corporate data governance, data practitioner roles, the data scientist and the data science workflow. Students further explore, mobile devices, sensors, artificial intelligence and robotics, security, privacy, ethics and society, and informatics. Students also explore how Big Data supports business processes, operational models, and business models in different industries from sales, to marketing, operations, supply chain, human resources, and finances. Industries reviewed range from healthcare, to financial, biology, manufacturing, and retail. Similarities and differences between Big Data solutions across different industries is explored. Students review information system history, the Big Data solution landscape and how to modernize organizations to better leverage Big Data.
Management Information Systems
This course will introduce students to the concepts of computer-based information systems in an organization. Students will examine the impact of information technology on an organization's decision-making as well as ethical issues facing managers. Information technology fundamentals are explored (networking and communications; database management systems, data warehousing, systems development) as well security, control frameworks and auditing computerbased systems. Students will gain practical experience by covering different topics which include: information systems, organizations and strategies, social, ethical and legal issues, information systems infrastructure, business process mapping and database design, e-commerce, systems security, systems development and emerging issues.
Introduction to Canadian Business Analytics
In today's highly connected world, organizations are privileged to gather and consume more and better data than ever before, allowing them to reflect on nature, trends, and insights within the business. Such information constitutes a powerful resource for deeply understanding business dynamics and, thus, leading decision-makers on their processes. This data is a valuable commodity that drives business In this course, 1) Comment the processes and techniques of business data collection, analysis, and visualization, 2) Program basic instructions when dealing with data, 3) Implement segmentation techniques, 4) Implement regression techniques, 5) Deliver solutions to business problems and 6) Realize the role of further models and deployments. Students will complete a capstone project involving a business problem where real data is used as a term project. Plausible solutions to such problems are expected to include techniques and tools presented in the course.
Job Search & Success
This course provides student with skills and knowledge to help support their career search and succeed in the workplace. Students align their personal skill set and goals to guide them on their career paths. They will learn how to effectively conduct a job search, build a professional and well-tailored resume and cover letter, and develop and practice interview techniques. Students will also develop their personal brand to help support effective career networking and aid in their job search. Teamwork and collaboration in the workplace are also discussed. Self-reflection is used to inspire insight and support their professional career journey.
SQL & Data Analysis
An introduction to relational database design and Structured Query Language (SQL). Students (1) analyze user requirements and construct data models using entity-relationship diagrams (ERD), normalization, and relational data models; (2) create database tables, add, delete, and modify data, and implement and test database constraints; (3) develop single-table and multiple-table queries using SQL functions, joins, and subqueries; and (4) implement views.
Canadian Business Process Modelling & Improvement
This course requires students to examine process management concepts, tools and techniques that will help to identify and improve processes in any Canadian organization. This course equips students with the skills to design process mapping and the modelling of business process improvements. The course is divided into two portions - mapping and modeling processes and improving processes. From a Canadian business process management perspective, students examine process analysis with techniques to map the current state, perform gap analysis, and define the future state with process improvement. Students also explore the use of the Unified Modelling Language (UML) for process modelling and to elicit requirements for technology-enabled process improvements. Modelling activities are performed, including application of selected Six Sigma quality principles and techniques while drawing on the Business Analysis Body of Knowledge (BABOK). By the end of this course, students will have demonstrated the ability to develop a business process model and improvement recommendation for a technology-enabled future state that is modeled with Unified Modeling Language techniques and tools.
Business Intelligence Tools
Business Intelligence (BI) refers to technologies, applications, and practices for the collection, integration, analysis, and presentation of business information. The purpose of business intelligence is to better support short and long-term business decisions. This course provides an overview of the technology of BI and the applications (tools) of BI to an organization's strategies and goals. This course gives an overview of how business intelligence technologies can support decision making across any number of business sectors. These technologies have had a profound impact on corporate strategy, performance, and competitiveness and broadly encompass decision support systems, business intelligence systems, and visual analytics. Modules are organized around the business intelligence concepts, tools, and applications, and the use of data warehouse for business reporting and online analytical processing, for creating visualizations and dashboards, and for business performance management and descriptive analytics. Students will gain skills in tools used for extracting data from sources of various formats, manipulating this data, combining with other data, and producing and saving meaningful output for management in various formats. A combination of different software products will be used to develop applications.
Project Management Analytics
Project management is the key for driving business in many organizations; ranging from construction, manufacturing, food processing and restaurant, and the software industries. With the advancement of technologies, projects are becoming more complicated, and the decision-making processes have equally become sophisticated. Modern projects are data-driven, and data is an asset for project managers since it can provide more insights in planning and controlling projects. However, to get the proper insight, project managers and analysts need to be skilled with tools or techniques to analyse project data during the project lifecycle, for accomplishing the business requirements. This course will require students to adopt best practices, approaches, and tools for managing and delivering analytics, predictive analyses and data projects. Students will assess approaches around collaboration, estimation, scoping, planning, data cleaning, data migration, data quality, and risk mitigation. Students will recommend how to best communicate their assessments to business stakeholders. This course and accompanying short case studies will facilitate both tactical and operational level complex decision-making processes in managing projects.
Data Visualization
This course requires students to learn the skills to present analytics results in a clear, concise, and visually appealing manner. Students will adopt hands-on practice tools and techniques of data visualization, visualization best practices, and common pitfalls. Students will be exposed to the application of Data Visualization tools such as Microsoft Power BI for the hands-on lab sessions. Students will also work on building targeted dashboards based on their audience's need. Other tools such as Google Charts will be introduced to reflect on the variety of data visualization tools available for a data analyst to visualize the results of analysis. Students will practice the skills and explore the knowledge that will help them establish or advance their career in this in-demand discipline. Plus, our unique student-cohort program model will allow students to gain a rich network of professional contacts through their peers.
Business Case Development in Canada
This course introduces students to the five-step model to Canadian Business Case Development. These steps can be adopted easily to develop compelling Business Proposals. Students will also learn how to adopt Program/Opportunity identification to specify the gap between the actual and ideal. In addition, students will learn how they can process ideas, measure success drivers and impediments to achieve measurable improvements and building a business case for Canadian organizations. This business-case writing course includes comprehensive financial evaluation and recommendations - a complete process to compare the pros and cons of each idea, including financial, corporate and environmental goals. Additionally, implementing a winning action plan - how to present and timeline your recommendations across four key functional in any organization.
Basics of Software Testing
This course introduces students to concepts and processes of software testing that are used to verify that developed solutions match documented specifications. Through practical applications, students perform static testing to identify defects and utilize different dynamic test design techniques to write test cases. Students learn to apply the fundamental methods, techniques, and processes of software testing to write a test plan and incident/defect reports for industry-specific business scenarios. Students explore a variety of test approaches and test tools that are suitable for different testing scopes. Upon completion of the course, students will have the ability to produce the key deliverable expected of a software tester, including test cases and test reports, while applying the fundamental concepts of software testing.
Sentiment Analysis & Text Mining
Sentiment analysis uses natural language processing (NLP), machine learning, and other data analysis techniques to analyze and derive quantitative results from raw text. Businesses often use the method to detect sentiment in social data, gauge brand reputation, and understand customers. Since customers express their thoughts and feelings more openly than ever, sentiment analysis is becoming an essential tool to monitor and understand that sentiment. This course introduces students to techniques used to collect data from different sources, i.e., social media sources. Students will apply statistical methods to process text data in any natural language with minimum human effort. Students will also apply algorithms in text mining involving correlation, regression, pattern recognition, and knowledge extraction to derive insights about data sources and their potential applications. At the end of the course, the student will be able to address a specific problem in text mining and sentiment analysis. In particular, students will identify, apply and differentiate the main notions needed to understand, describe and design text processing, foundations of natural language processing, text classification, and topic modelling. Moreover, students will deal with sentiment analysis in the context of opinion mining, rule-based models, and machine learning models for text. In the lab, students will use toolkits such as NLTK, SpaCy, LDA models, kNN, SVM, TextBlob, Vader, etc.
Privacy & Ethics for Canadian Business Analytics
In the Canadian Business Analytics workspace, privacy and ethics plays an integral part the overall decision process. Generally, these ethical standards should be applicable not only in a Canadian context, but across the world - regardless of country, law, or cultural differences. To ensure business success, these ethical codes should be applied and communicated by leaders in business. This course speaks to the importance of business data privacy in terms of the collection and use of data. This course introduces students to the fundamentals of privacy and ethics laws in Canada and its applicability to the business analytics industry. This course aims to equip the student with the intellectual tools to make effective, reasoned and justifiable moral decisions relating to the Business Analytics domain within appropriate legal and social frameworks. With a strong requirement for reading, research, reflection and debate, it is structured around formal discussions within the subject area and makes extensive use of social technologies to enable sharing and interaction. More so the course is designed to explore the nature and principles of ethics-- including personal, professional, and corporate ethics -- in the Business Analytics context. The course equips students with the skills to explore specific ethical issues raised by the ubiquity of computer and information technology in today's society. Students will explore such topics including the role of the Office of the Privacy Commissioner of Canada, PIPEDA fair information principles, the Privacy Act legislation.
Capstone Project
The purpose of the Capstone Project is for the students to apply theoretical knowledge acquired during the program to a project involving actual data in a realistic setting. During the project, students engage in the entire process of solving a real-world Business Problem, from collecting and processing actual data to applying suitable and appropriate analytic method to the problem. Both the problem statements for the project assignments and the datasets originate from real-world domains similar to those that students might typically encounter within industry, government, non-governmental organizations (NGOs), or academic research. Depending on the project's complexity, students will work individually or in small teams. Skills acquired in the Capstone Project are highly applicable in today's job market. Employers are seeking candidates who are competent and have experienced teamwork in project environments. This course prepares students to work on concrete goals in a small team. They will address a Business Analysis problem based on pre-set requirements. Students apply the necessary project management skills to manage planning, deadlines, milestones, and deliverables with a stakeholder. Appropriate documentation will supplement the design to cover the motivation, methods, and test cases.
Work Term (Full-Time)
Co-operative education provides students with the opportunity to apply classroom learning to the workplace, undertake career sampling and gain valuable work experience that may assist students in leveraging employment after graduation. For further information regarding co-op, please refer to: https://www.lambtoncollege.ca/co-ops-placements
WIL Project
Work Integrated Learning (WIL) Project is aimed at enriching students by connecting different program areas of study, cutting across subject-matter lines, and emphasizing unifying concepts. The focus of the WIL Project is to make connections between study and industry by engaging students in relevant and meaningful activities that are connected to and practiced within the professional workplace. WIL Project allows students to enhance and strengthen their employability prospects post-graduation by fine tuning skills and knowledge and meeting the expectations of today's employers. Students are required to attend the scheduled shifts in the WIL office, reporting to the WIL Supervisor. Weekly real-world challenges are presented in the WIL office, designed by industry professionals. In addition to the weekly assigned deliverables, students are also offered professional development sessions, and exposed to industry guest speakers, enhancing their opportunity to develop their professional network.
Co-op Eligibility & WIL Project Fee
In order to be eligible to secure an approved full-time co-op work term (CPL-1049), students must have a GPA of 2.8 or greater and complete all the co-op eligibility requirements. Failing to do so will require students to enroll in CPL-5559 WIL Project at an additional cost.
Contact
Centre for Global Engagement
LAMBTON COLLEGE SARNIA
226-313-7777
1457 London Road
Sarnia ON, N7S 6K4
After Graduation
Employment Opportunities
Program graduates are currently in high demand in Canada. These graduates may find employment in roles such as Business Analyst, Data Analyst, Analytics Specialist, Business Management Consultant, Management Analyst, Project Managers and other related fields.
Career positions may include, but are not limited to:
- Business Methods Analyst
- Records Management Specialist
- Management Analyst
- Organizational Analyst
- Business Management Consultant
- Consultant, Organizational Analysis
- ISO Consultant
Post-Graduate Employment
International students who successfully complete their programs of study at Lambton College may be eligible to apply for a Post-Graduation Work Permit (PGWP) Program. This program allows students to gain valuable Canadian work experience.
A work permit under the PGWP may be issued for the length of the study program, up to a maximum of three years. A post-graduation work permit cannot be valid for longer than the student's study program, and the study program must be a minimum of eight months in length. The length and approval of the PGWP is determined solely by Immigration, Refugees and Citizenship Canada (IRCC).
Students must meet the eligibility requirements to apply for a post-graduation work permit.
Immigration Regulations & Changes
Immigration regulations are legislated by the Federal Government of Canada and are subject to change at any time without notice. Students are responsible for ensuring that they are in compliance with all Immigration, Refugees and Citizenship Canada regulations at all times during their studies and while in Canada. Lambton College staff are not authorized to provide advice or guidance on immigration-related matters. Prospective applicants and current students should consult the Immigration, Refugees and Citizenship Canada website or call the IRCC Call Centre at 1-888-242-2100 to answer or clarify any immigration-related questions or information.
Co-op
About Co-op
Students in this program have the opportunity to gain valuable work experience by applying classroom learning during co-op experiences.
Learn more about co-op terms and the roles and responsibilities of students and co-op advisors.
More Information
Student Responsibilities
- Course and program delivery schedules are proposed and subject to change for each intake.
- Students are required to bring their own laptop with wireless capability.
- Students are advised to bring an official copy of their most recent police clearance, driver's license, and vaccination record from their home country.
Technology Requirements
It is recommended that students purchase a laptop with a Windows operating system.
Internet Speed Requirements
For best performance for students learning remotely, an internet connection with a minimum of 40 Mbps download and 10 Mbps upload speed is recommended in order to effectively use video conferencing and remote lecture delivery software as well as, other online resources remotely. Due to the large area over which students may be dispersed, we are unable to recommend a specific provider, so you will need to inquire around your area to find one that best suits your needs.
Minimum Laptop Requirements
In order to access the internet and virtually-delivered software and courseware, student laptops should include the following at a minimum. By meeting the following specifications, students will be equipped to access software and courseware on their laptop through the internet:
- Intel i5 8th Gen Processor or equivalent
- 16 GB of RAM (with a minimum of 8 GB)
- 100 GB HDD or more
- HD Graphics
- Webcam with a microphone
- Wireless 802.11n/ac 5ghz capable
- Windows Operating System (Windows 11)
Software
To ensure students are getting the most our of their classroom experience, some software will be required.
Lambton College has made this software easily accessible online. Students can leverage our Microsoft Office 365 software packages and services. In addition, much of the software you require for your courses will be available on demand for use on any device - on or off campus.