2021-2022 Pierce College Catalog 
    Apr 25, 2024  
2021-2022 Pierce College Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

CIS 275 Business Analytics/Intelligence (5 credits)

Prerequisite CIS 136  and CIS 262 , both with a 2.0 or higher; or instructor permission.

Course Description
Development of practical business intelligence (BI) solutions using currently available toolsets. Topics include data cleansing, Extract Transform Load (ETL), and Data Warehouse implementation. BI tools will be used for reporting, integration , and analysis. Cubes and marts will be created to feed presentation layers for dashboards and Key Performance Indicators (KPIs), providing needed user analytics.

Student Outcomes
1. Create Bisemantic Models (BISM) – Stars, Snowflakes, and other models using Design Patterns as appropriate.
2. Discuss performance options such as BISM storage options, caching, and partitioning.
3. Query and manipulate multi-dimensional data using the MultiDimensional eXpressions (MDX) language.
4. Discuss solving business problems and end user experience using Business Analytics and Business Intelligence.
5. Analyze end user requirements and develop presentation layer with dashboards and KPIs using PowerPivot, and third party tools such as QlikView.
6. Develop reports including the use of filters and parameters.
7. Develop and deploy packages for ETL and data transformation.
8. Develop and deploy dimension/facts tables, cubes, marts for data mining.

Add to Portfolio (opens a new window)