Course Course Summary Section 1 Content Section 1 Content Left Section 1 Content Right 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: 6/1/2018 - 5/31/2021 4/1/2014 - 5/31/2018 Credit Recommendation & Competencies Section 2 Content Section 2 Content Left Section 2 Content Right Level Credits (SH) Subject Upper-Division Baccalaureate 3 Computer Science, Information Technology, or Information Systems Description Section 3 Content Section 3 Content Left Section 3 Content Right 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 Section 4 Content Section 4 Content Left Section 4 Content Right Instructional Strategies: Audio Visual Materials Case Studies Discussion Lectures Methods of Assessment: Examinations Minimum Passing Score: 70% Supplemental Materials Section 5 Content Section 5 Content Left Section 5 Content Right Section 6 Content Section 6 Content Left Section 6 Content Right Button Content Rail Content 1 Page Content