Skagit Valley College

Catalog Course Search Details

New Course: this course was added after the last catalog

 Course Title:   Business Intelligence and Predictive Analytics

 Title Abbreviation:   BUS INTEL & ANALYTICS

 Department:    IMDS

 Course #:    225

 Credits:    5

 Variable:     No

 IUs:    5

 CIP:    30.7101

 EPC:    573

 REV:    2021


 Course Description  

Introduction to preparing data for PivotTables, creating Data Analysis Expressions (DAX) for calculated columns and measures, building a model from a single flat table, exploring the cloud benefits of business intelligence (BI) tools and features in modern information management technologies for making informed business decisions.

 Prerequisite  

Prerequisites: IMDS 101 and IMDS 120 and IMDS 230 all with a grade of C or higher.

Additional Course Details

Contact Hours (based on 11 week quarter)

Lecture: 55

Lab: 0

Other: 0

Systems: 0

Clinical: 0


Intent: Distribution Requirement(s) Status:  

Vocational Preparatory Required for ATA degree  

Equivalencies At Other Institutions

Other Institution Equivalencies Table
Institution Course # Remarks
N/A

Learning Outcomes

After completing this course, the student will be able to:

  1. Apply data analysis using information management technologies.
  2. Describe basic DAX and Text Queries.
  3. Recognize data models from multiple tables and advanced DAX and Text Queries.
  4. Apply information management and business intelligence tools for data visualization.

General Education Learning Values & Outcomes

Revised August 2008 and affects outlines for 2008 year 1 and later.

Course Contents

  1. Data models and visualizations using BI tools, services and mobile apps.
  2. Data imports from SQL databases, CSV files, and other sources.
  3. Measures using advanced DAX functions.
  4. Data mash-up with multiple queries.
  5. Data analysis using dashboards, pivot tables, and pivot charts.
  6. Data models and BI cloud computing services.