Data Analysis and Databases

Course code ACCT 2004

Credit 3.0

Length 45.0 hours

Course outline View

In the business world, it is important to turn ever-increasing amounts of data into useful information that can been easily seen and understood. In this course students learn the fundamental principles and practices of data analysis and how to communicate business intelligence in visual formats. Working with a variety of data sources and software, students learn to make sense of quantitative business data by discerning meaningful patterns, trends, relationships and exceptions that reveal business performance, potential problems and opportunities.  Students will also learn to manage relational databases, using queries, and create, edit, and delete tables using SQL or other query languages.

Prerequisites

MGMT 1001, MGMT 1021, MGMT 1020.

Missing prerequisites?

Learn more about VCC's academic upgrading or English as a Second Language (ESL) courses, or discover which university transfer options are right for you.

What you will learn

  • Introduction to Data Analytics and Business Intelligence
  • Creating Visualizations and Dashboards
  • Foundational to Advanced Analytics
  • Row-Level and Aggregate Calculations
  • Table Calculations
  • Formatting Visualizations
  • Telling a Data Story with Dashboards
  • Adding Value to Analysis - Trends, Distributions and Forecasting
  • Advanced Techniques
  • Presenting Data Stories
  • Data analysis and financial modeling

How to register

This course is offered as part of a VCC program only.

Course schedules

Select your program to see the available course schedules.

Contact us

If you have any question, please email at advising@vcc.ca.

† This information is intended as a guideline only. Program and course details are subject to change with the approval of VCC's Board of Governors.

Indigenous Territory Acknowledgment

VCC is located on the traditional territories of the xʷməθkʷəy̓əm (Musqueam), Sḵwx̱wú7mesh (Squamish), and səlilwətaɬ (Tsleil-Waututh) peoples, and we acknowledge our privilege to be here.