Business Analytics | Lambton College

In order to keep pace with the requirements of each and every course in your program, it is mandatory to own a reliable laptop to complete tests and assignments.

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.

This Lambton College program is licensed to and delivered by Queen’s College (PDF) , a licensed private career college in Mississauga, Ontario. Students that are registered at Lambton in Mississauga are students of a public college and as such, will receive full credit from Lambton College for all Lambton College courses completed at the Queen’s College campus in Mississauga. Students who meet program graduation requirements will graduate with a credential from Lambton College. Students may be scheduled to have classes on Saturdays.

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.

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

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.

BAM-1024: Introduction 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.

BAM-1013: 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.

BAM-1053: Managing Requirements and 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.

BAM-1043: 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.

BAM-1063: 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.

BAM-1073: 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.

BAM-1101: Canadian Careers in Business Analysis

In this course, students explain the hierarchical structure within the business analyst industry while connecting the dots with the roles and teams as a Business Analyst. This course will also provide students with employment preparatory skills specifically related to Co-operative Education. This will include understanding the Co-operative Education & Internship Policy, understanding the support system available through the Co-op and Career Services department.

BAM-2004: SQL and 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.

BAM-2014: Canadian Business Process Modelling and 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.

BAM-2024: 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.

BAM-3023: 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.

BAM-2053: 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.

JSS-1001: Job Search and Success

This course is designed to give the student an understanding of how to conduct a job search and how to succeed in the work place. This includes self-reflection, effectively designing a cover letter and resume, online job searches utilizing social media, behavioural based interviewing as well as marketing oneself effectively in a job interview. Job safety, successful work strategies and harassment and discrimination plan of action is also discussed.

Academic Break

BAM-3004: 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.

BAM-3014: 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.

BAM-3034: Sentiment Analysis and 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.

BAM-3062: Privacy and 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.

BAM-3135: 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.

CPL-1049: 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-op_and_career/

-or-

CPL-5559: 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.

*In order to be eligible to participate in a full-time Co-op Work Term (CPL-1049) students must have a GPA of 2.8 or greater.

Failing to do so will require the students to enroll in CPL-5559 WIL Project at an additional cost to the student.

See the Costs tab for current fees.

Program Maps

Current Students

Current students can view program maps from previous years on the mylambton website. 

You will need to login with your C# and password in order to access your program map.

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