Course

Credit Type:
Course
ACE ID:
IBM-0031
Version:
1
Organization:
IBM
Location:
Online
Length:
10 weeks (141 hours)
Minimum Passing Score:
80
ACE Credit Recommendation Period:
Credit Recommendation & Competencies
Level Credits (SH) Subject
Lower-Division Baccalaureate 3 Data Analysis and Visualization
Upper-Division Baccalaureate 3 Relational Databases and SQL Fundamentals
Upper-Division Baccalaureate 3 Data Warehousing and Analytics
Lower-Division Baccalaureate 3 Business Intelligence Fundamentals
Description

Objective:

This course is offered through Coursera, which is an ACE Authorized Instructional Platform.

The course objective is to teach data collection, analysis, visualization, and reporting - honing skills in developing data models and deriving invaluable insights for making informed decisions. Students will analyze data from a variety of data sources such as relational databases and data warehouses.

Learning Outcomes:

  • Apply statistical analysis methods to identify trends, create visualizations, and build dashboards using Tableau, Excel, Cognos, and Looker
  • Utilize BI analytics to consult with stakeholders, define goals, implement strategies, and develop effective projects for a rewarding career in BI
  • Generate valuable insights through data warehousing, profiling, and evaluation, leading to informed decision-making and process improvement
  • Build skills in SQL queries, relational databases, data gathering and cleaning, data warehousing, data analysis and reporting techniques

General Topics:

  • Comprehensive introduction to business intelligence (BI), its key concepts, components, and the benefits and challenges of implementing BI solutions
  • Career opportunities and roles available in the BI arena and the skills and qualifications required
  • Experience working with data sets and spreadsheets
  • Use business intelligence (BI) tools like Cognos Analytics to create interactive dashboards
  • Introduction to relational database concepts, as well as several industry standard relational databases, including IBM DB2, MySQL, and PostgreSQL
  • Utilize RDBMS tools used by professionals such as phpMyAdmin and pgAdmin for creating and maintaining relational databases
  • Use the command line and SQL statements to create and manage tables
  • Master techniques for populating data warehouses through ETL and ELT processes, and hone skills in verifying and querying data, and utilizing concepts like cubes, rollups, and materialized views/tables
  • Work with sophisticated modeling approaches, execute computations, and optimize data models for performance
Instruction & Assessment

Instructional Strategies:

  • Audio Visual Materials
  • Computer Based Training
  • Discussion
  • Lectures
  • Practical Exercises

Methods of Assessment:

  • Other
  • Quizzes
  • Peer-reviewed Assignments
Supplemental Materials
Equivalencies