2021-2022 Pierce College Catalog 
    Nov 28, 2023  
2021-2022 Pierce College Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

CIS 274 Applied Business Management Analytics (2 credits)

Prerequisite CIS 138  with a 2.0 or higher.

Course Description
This course supports business management decision-making by developing practical application business intelligence (BI) solutions using advanced spreadsheet functionality. Dashboards and KPIs will be designed and created to meet end user requirements. Connecting spreadsheets to third-party BI tools will also be discussed.

Student Outcomes
1. Discuss solving business problems and end user experience using Business Analytics and Business Intelligence.
2. Identify, import, integrate, cleanse, and validate data for use in decision making.
3. Analyze end user requirements and model with appropriate test data
4. Develop presentation layer with dashboards and KPIs using advanced Excel functionality such as PivotTables, Pivot Charts, PowerPivot, Slicers Develop analytical reports including the use of filters and parameters.
5. Analyze appropriate data connection to various third-party tools such as QlikView, Tableau, or PowerBI.

Add to Portfolio (opens a new window)