Skip to main content Skip to site utility navigation Skip to main site navigation Skip to site search Skip to footer
NSCC's response to COVID-19: view updates
Menu

Business Intelligence and Analytics

Manage, mine and filter big data and apply analytical techniques in support of critical business decision-making.

A close-up photo of a hand drawing graphs and charts on a tablet screen and another hand holding a smartphone.
Start Date:
September
Typical Length:
1 Year
Credential:
Graduate Certificate

Apply Now

Overview

With the increased use of smart devices, sensors, intelligent systems and other tools, the volume of data is increasing exponentially, making it more challenging to manage and use in meaningful ways.

 This graduate certificate program teaches you to:
  • Manage, research, gather and filter large volumes of data to make more precise, reliable business decisions.
  • Work with platforms and applications to create and present visual representations of descriptive and predictive analytics.
  • Work with business analysts or on your own to interpret, analyze and optimize data for timely, accurate and efficient business decisions.
  • Use data analysis to seize business opportunities and motivate your team to improve performance.

Work experience

  • Work placement is a mandatory credit course, providing the opportunity to apply your knowledge and skills outside of the classroom.
    • Opportunities are typically unpaid and last approximately 5 weeks.
    • Transportation, accommodations and other costs related to work placements are your responsibility.
  • For more information visit Work Experience Opportunities.

Choose NSCC

  • Many companies in Nova Scotia understand the need to use business intelligence and data analytics in their decision-making processes, meaning graduates of this program are in high demand.
  • You gain valuable work experience during a work term, where you apply your skills and knowledge in a real-world setting, on real industry projects.

2023-24 programs

Program delivery may be subject to change based on Public Health guidelines.

September 2023

Campus Location Full time/part time Delivery Availability
Institute of Technology Campus/Online Halifax Full time Blended Delivered through a combination of in-person and scheduled online classes. Waitlist

September 2024

Campus Location Full time/part time Delivery Availability
Pictou Campus/Online Stellarton Full time Blended Delivered through a combination of in-person and scheduled online classes. Seats available

Admission requirements

  • Diploma, advanced diploma or undergraduate degree in one of the following areas: information technology; business administration; geomatics; engineering technology; geospatial data analytics, geographic sciences, health information management, engineering (electrical, electronic, environmental, mechanical, industrial); natural sciences or related fields.

Program requirements

  • Portfolio development – As part of your studies at NSCC, you develop a portfolio of your work; the portfolio captures your achievements and profiles your skills to employers.

    Tuition

    Tuition amounts are for the 2022-23 academic year. Program costs and fees (textbooks, supplies, etc.) are additional. 2023-24 tuition will be announced in the late Spring.

    Tuition (Domestic):
    $5,540
    Tuition (International):
    $11,690

    Tuition, fees and program costs

    In addition to annual tuition, there are program costs (books, tools, etc.) and student fees for college services, health and dental plans, your student association and parking.

    View detailed program fees page(s). Please note that amounts on these pages are meant for planning purposes only. They don't represent final amounts owing.

    Career options

    Graduates of this program are in high demand and find employment in any of the following positions:

    • Business Intelligence Specialists
    • Data Analysts
    • Report Authors
    • Business Analysts
    • Database Analysts
    • Integrated Analytics Specialists
    • Data Analytics Analysts
    • Data Stewards
    • Business Intelligence Analysts
    • Data and Reporting Analysts

    Future study options

    • Continue your studies at university – This program includes courses that count towards a university degree. Find out more

    Courses may include

    These are some of the courses offered in this program. It is not a complete list and courses are subject to change in advance of the academic year.

    Recognizing prior learning / transfer credits
    If you have previous learning (course, employment, etc...) that's relevant to your program, you may be able to apply to earn credit. Not all programs are eligible. Learn about our recognizing prior learning (RPL) process.

    DBAS 2010 - Database Design II
    This course extends the learners involvement with database design. The need for database design to be complete and to be able to capture all of the data will be emphasized. Design considerations affecting performance from hardware, networking, security, platform and architectural points of view will be discussed and addressed hands-on. The learner's exposure to a series of both initial design and re-engineering case studies will ensure that they are made aware of the importance of fast, reliable access to data in all organizational areas.

    DBAS 2101 - Data Reporting
    The course is designed to provide learners with the necessary skill background and understanding to be able to realistically assess data reporting requirements, migrate data from its sources to the reporting utility, and to author, manage and deliver traditional and interactive reports and visualizations. All applied work will be performed using current local industry standard platforms.

    DBAS 2103 - Data Provisioning with ETL
    The course is designed to familiarize learners with the process and methodologies used to provide data from data sources to a processing environment. Progression of skill is done in the end-to-end context of the ETL process. Learners will identify data sources based on analyzed client requirements, extract those data, perform cleansing, perform any necessary transformations, integrate and load the data to its end platform. Due to the fact that in production programmers may be applying all or any component of the ETL process, a variety of platforms will be used ranging from command line ANSI standard SQL to comprehensive ETL suites such as Informatica. Every platform choice will reflect current local industry standards.

    DBAS 2104 - Business Analysis Essentials
    This course teaches the fundamental business processes that govern the operation of any business. The focus is on the tools and methodologies used by business analysts to gather information regarding those operational processes and how the gathered information is used to support strategic and tactical decision-making in the business. This fundamental understanding of the business and analysis is then used by the learners to accurately interpret the detailed business requirements that drive design and implementation of supporting IT products and services. Extensive use is made of real world case studies from the local area, including guest lectures from local business analysts. Tools and software used in the course will be chosen according to current local industry standards.

    DBAS 4075 - Introduction to Business Intelligence
    This course explains how to create, implement, and manage an enterprise BI solution. Topics covered include modelling, monitoring, and analytics capability. Learners build reports that foster informed business decisions. Solutions implement security and collaboration with communications utilities and mobile devices. Learners will cover preparation of reports using relational and dimensional data, and will use BI tools to perform statistical analysis.

    DBAS 5010 - Structured Query Language for Analysts
    This course will focus on DML (Data Manipulation Language) where students will build queries to satisfy aggregations, segments, and align to business strategies. Students also cover reporting data structure design, optimization, and maintenance using DDL (Data Definition Language).

    DBAS 5015 - Introduction to Data Science
    This introductory course will explore the practical methods and techniques of Data Science employed by analysts. Students will use industry standard tools to apply the most common machine learning algorithms used for predictive analytics (operational planning and forecasting).

    DBAS 5020 - Applied Data Science
    The primary focus of this course is on planning and forecasting, commonly referred to as predictive analytics. Students will apply Data Science methodologies to data sets and identify trends, patterns and abends in the analysis that can be used for better business decisions.

    INFT 3000 - Capstone
    Learners acquire hands-on experience on a group project applying much of the material learned throughout their program. Throughout this course, learners will apply their skills to prepare and deliver technical documentation and presentations using various media platforms.

    INFT 4001 - Special Topics II
    This course introduces one or more technology or research topics for discussion and exploration. Topic selection may vary from year to year, driven by the outside influences such as industry input, new technology trends, or learner interests.

    INFT 5500 - Work Experience
    This course is either a campus-based or external applied learning experience which may consist of work experience, directed studies, industry projects or applied research.

    SAFE 1000 - Introduction to WHMIS (Workplace Hazardous Materials Information Systems)
    This course offers learners basic overview of WHMIS principles and establishes a solid foundation to support workplace-specific training on the safe storage and handling of controlled/hazardous products. Upon successful completion of the course, students receive basic WHMIS certification.

    SAFE 1001 - Introduction to NS OH&S Act
    This course offers students an introduction to the Occupational Health & Safety (OH&S) Act of Nova Scotia, which is required by any person employed in a Nova Scotia workplace. This is a generic, introductory course that provides basic knowledge of the Act for students and is considered to be the basis from which more specific training can be given.

    Apply Now

    Learn more about this program.

    Share your details with us and we'll send you a program overview.

    Required fields are marked with a red symbol (*)

    Thank you for contacting us.
    Your program overview is on the way. While you wait, feel free to browse our list of Programs & Courses or visit our Admissions information section.

    Explore similar programs

    To find other programs and career options that might be a good fit for you check out these areas of interest:

    Back to top