Nov 21, 2024  
PUBLISHED 2020-2021 Credit Catalog 
    
Catalog Navigation
  Catalogue Home
  Programs/Categories
  Programs/Categories by School
  Courses by School
  Programs/Categories in Business
  Courses in Business
  Programs/Categories in CALS
  Courses in CALS
  Programs/Categories in Construction
  Courses in Construction
  Programs/Categories in HPS
  Courses in HPS
  Programs/Categories in H&T
  Courses in H&T
  Programs/Categories in ICT
  Courses in ICT
  Programs/Categories in M&A
  Courses in M&A
  Programs/Categories in MSE
  Courses in MSE
  Programs/Categories in Transportation
  Courses in Transportation
  Campus Recreation
HELP
PUBLISHED 2020-2021 Credit Catalog [ARCHIVED CATALOG]

CPSY 209 - OLAP (Online Analytical Processing)

Course Description:
In this course, students will plan, design, implement and optimize the infrastructure for an OLAP solution. Students will create the logical design and physical storage for multidimensional solutions. Students will implement KPIs (Key Performance Indicators) and associated actions, stored procedures and data sets. As students deploy, manage and maintain an Analysis Services Solution, they will implement data mining solutions. Students will work with SQL Analysis Services to create Multidimensional Analysis Solutions, work with Measures and Measure Groups and execute queries against Multidimensional Analysis Solutions. By customizing cube functionality as they deploy and secure an Analysis Services Database, students will look at Data Mining activities.

1.5 Credits

© 2015 - 2020, Southern Alberta Institute of Technology (SAIT). All Rights Reserved.