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.
Course Content
1. Data Analytics and Intelligence
2. Key Performance Indicators (KPI)
3. Dashboards
4. User requirements
5. Data validation
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.
Degree Outcomes
Responsibility: Graduates will be able to critically examine the relationship between self, community, and/or environments, and to evaluate and articulate potential impacts and consequences of choices, actions, and contributions for the creation of sustainable systems.
Program Outcomes: Administer and secure the data and information resources that support the mission of a business
Lecture Contact Hours 20
Lab Contact Hours 0
Clinical Contact Hours 0
Total Contact Hours 20
Add to Portfolio (opens a new window)
|
