- International Fees
International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
Course Overview
In an information-based society, every enterprise requires business analytics and decision support systems to enable a competitive advantage. As a result, knowledge workers across all industries increasingly require an understanding of data modelling and advanced data management and analytical techniques. Building off the foundational skills learned in BSYS-1000, this course leverages the Microsoft ecosystem, including Access, Excel and Power Query, Microsoft's data transformation and data preparation engine, to perform complex data management tasks. Advanced formulae, concepts, and data modelling theory will enable students to connect to various types of data to enable the analysis and presentation of data to enable business insight.
Prerequisite(s)
- 50% in BSYS 1000
Credits
4.0
Domestic fees
$682.27 - $789.18 See individual course offerings below for actual costs.
Learning Outcomes
Upon successful completion of this course, the student will be able to:
- Solve financial/business problems using advanced formulae.
- Build a dynamic what-if business model that includes sensitivity analysis.
- Use correct data modelling terminology.
- Explain and illustrate the data modelling process using normalization.
- Analyze business data through single-source and multi-source queries.
- Employ built-in tools in Excel to analyze data using advanced criteria.
- Evaluate large datasets to extrapolate meaningful information to facilitate decision making.
- Present data analytics using pivot tables, charts, and other visualization techniques.
- Collaborate on the analysis and presentation of information using Microsoft 365.
Effective as of Winter 2023
Related Programs
Applied Data Analytics in Excel (BSYS 2000) is offered as a part of the following programs:
- Indicates programs accepting international students.
- Indicates programs eligible for students to apply for Post-graduation Work Permit (PGWP).
School of Business + Media
- Accounting
Diploma Full-time
- Accounting
Diploma Part-time
- Business Information Technology Management
Diploma Full-time
- Business Management
Diploma Full-time
- Business Operations Management
Diploma Full-time
- Computerized Accounting
Associate Certificate Part-time
- Finance
Diploma Full-time
- Finance
Diploma Part-time
- Financial Management (Finance Option)
Certificate Part-time
- Financial Management (Professional Accounting Option)
Certificate Part-time
- Financial Planning
Diploma Full-time
- Financial Planning
Diploma Part-time
- General Insurance and Risk Management
Diploma Full-time
- Global Trade and Transportation Management
Diploma Full-time
- Human Resource Management
Diploma Full-time
- Marketing Management
Diploma Full-time
- Operations Management (Facilities Management Option)
Certificate Part-time
- Operations Management (Industrial Engineering Option)
Certificate Part-time
- Operations Management (Management Engineering Option)
Certificate Part-time
- Operations Management (Materials Management Option)
Certificate Part-time
Course Offerings
Winter 2025
Below are four offerings of BSYS 2000 for the Winter 2025 term.
CRN 92749
Dates
Jan 03 - Mar 21 In Progress
- CRN 92749
- $682.27 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Jan 03 - Mar 21 | Fri | 17:30 - 21:30 | Burnaby NE01 Rm. 335 |
Duration
12 weeks
Instructor
Jeff Sawers
Course outline
Important information
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
Status
In Progress
This course offering is in progress. Please check this page for other currently available offerings or subscribe to receive email updates.
CRN 92549
Dates
Jan 06 - Mar 27 In Progress
- CRN 92549
- $696.56 Domestic fees
Class meeting times
Duration
12 weeks
Instructor
Denise Calvert
Course outline
Important information
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
- This course is asynchronous and does not require you to meet every week at a specific time, however, there will be specific timelines for assignments and exams. It is important you have a stable and consistent internet connection to access course content. Course content, type and quality of assignments, and general standards for this online course are the same as classroom courses. To be successful in this online course, plan to spend 7-10 hours per week on your studies, or more of it’s a condensed course, starting Week 1. Important course information will be sent to your myBCIT account prior to your course start date. ***Please note*** Exams only will be held in person on campus as follows: Midterm exam Thurs, Feb 13 at 1800 and Final Exam is on Thurs, March 27 at 1800
Status
In Progress
This course offering is in progress. Please check this page for other currently available offerings or subscribe to receive email updates.
CRN 92759
Dates
Jan 08 - Mar 26 In Progress
- CRN 92759
- $696.56 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Jan 08 - Mar 26 | Wed | 18:00 - 22:00 | Burnaby NE01 Rm. 338 |
Duration
12 weeks
Instructor
TJ Jones
Course outline
Important information
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
Status
In Progress
This course offering is in progress. Please check this page for other currently available offerings or subscribe to receive email updates.
CRN 92563
Dates
Jan 09 - Mar 27 In Progress and Full
- CRN 92563
- $682.27 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Jan 09 - Mar 27 | Thu | 17:30 - 21:30 | Downtown DTC Rm. 382 |
Duration
12 weeks
Instructor
Kaitlyn Minatozaki
Course outline
Important information
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
Status
In Progress and Full
This course offering is in progress and full. Please check this page for other currently available offerings or subscribe to receive email updates.
Spring/Summer 2025
Below are four offerings of BSYS 2000 for the Spring/Summer 2025 term.
CRN 70040
Dates
Apr 07 - Jun 26 Seats Available
- CRN 70040
- $789.18 Domestic fees
Class meeting times
Duration
12 weeks
Instructor
Denise Calvert
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Important information
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
- ***Please note that the midterm and final exams will be on campus. The midterm exam is on Thurs, May 15 at 1830 and the final exam will be on Thurs June 26 at 1830 This course is asynchronous and does not require you to meet every week at a specific time, however, there will be specific timelines for assignments and exams. It is important you have a stable and consistent internet connection to access course content. Course content, type and quality of assignments, and general standards for this online course are the same as classroom courses. To be successful in this online course, plan to spend 7-10 hours per week on your studies, or more of it’s a condensed course, starting Week 1. Important course information will be sent to your myBCIT account prior to your course start date. Please note that the midterm and final exams will be in person on campus. The midterm will be on Monday May 12th at 1800 and the final exam will be on Monday, June 23rd at 1800.
Status
Seats Available
This course offering has seats available.
CRN 69668
Dates
Jul 08 - Aug 01 Seats Available
- CRN 69668
- $789.18 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Jul 08 - Aug 01 | Tue, Wed, Thu | 18:00 - 22:00 | Burnaby NE01 Rm. 336 |
Duration
4 weeks
Instructor
Juan Azmitia
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Important information
- Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
- .
Status
Seats Available
4 seats remaining as of Sat March 15, 2025 at 2:46 pm (PDT). Availability may change at any time.
CRN 69360
Dates
Apr 07 - Jun 26 Full
- CRN 69360
- $789.18 Domestic fees
Class meeting times
Duration
12 weeks
Instructor
Denise Calvert
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Important information
- Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
- ***Please note that the midterm and final exams will be on campus. The midterm exam is on Thurs, May 15 at 1830 and the final exam will be on Thurs June 26 at 1830 This course is asynchronous and does not require you to meet every week at a specific time, however, there will be specific timelines for assignments and exams. It is important you have a stable and consistent internet connection to access course content. Course content, type and quality of assignments, and general standards for this online course are the same as classroom courses. To be successful in this online course, plan to spend 7-10 hours per week on your studies, or more of it’s a condensed course, starting Week 1. Important course information will be sent to your myBCIT account prior to your course start date. Please note that the midterm and final exams will be on campus. The midterm will be on Thursday, May 15th and the final exam will be on Thursday June 26.
Status
Full
This course offering is full. Please check this page for other currently available offerings or subscribe to receive email updates.
CRN 69364
Dates
Apr 10 - Jun 26 Full
- CRN 69364
- $789.18 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Apr 10 - Jun 26 | Thu | 17:30 - 21:30 | Burnaby SE12 Rm. 318 |
Duration
12 weeks
Instructor
Kaitlyn Minatozaki
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Important information
- Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
Status
Full
This course offering is full. Please check this page for other currently available offerings or subscribe to receive email updates.
Programs and courses are subject to change without notice.