Course

Course Summary
Credit Type:
Course
ACE ID:
BISK-0127
Organization's ID:
VIL86
Organization:
Bisk Education
Location:
Classroom-based
Length:
12 weeks (48 -- 72 hours)
Dates Offered:
Credit Recommendation & Competencies
Level Credits (SH) Subject
Upper-Division Baccalaureate 3 Computer Science, Information Technology, or Information Systems
Description

Objective:

The course objective is to strengthen the strategic, tactical, and operational decision-making skills of students by exploring data structures as they relate to business intelligence.

Learning Outcomes:

  • Describe the common attributes of KPIs that are useful for dashboards
  • Describe the design process of balanced scorecards and common implementation pitfalls
  • Discuss the significance of analytic tools
  • Provide examples of subqueries
  • Discuss the applications of GROUP BY and HAVING clauses
  • Explain the process of extraction, transformation, and loading (ETL) and describe its benefits
  • Describe the uses and benefits of various visual charts and graphs
  • Analyze and document requirements
  • Describe the need for prototyping and iteration
  • Discuss the tools used to design and manage iterations
  • Compare predictive, descriptive, and decision models
  • Discuss the capabilities and syntax of SQL
  • Contrast CASE and DECODE
  • Explain the process of translating needs into growth for data, hardware, and licenses

General Topics:

  • Visualization and design best practices, report design, dashboard design, performance management, predictive analytics, SQL and MDX for BI, ETL best practices, and production support
Instruction & Assessment

Instructional Strategies:

  • Audio Visual Materials
  • Case Studies
  • Discussion
  • Lectures

Methods of Assessment:

  • Examinations

Minimum Passing Score:

70%
Supplemental Materials